[generic] episode_1-subtitles: Downloading webpage
WARNING: [generic] Falling back on generic information extractor
[generic] episode_1-subtitles: Extracting information
[generic] episode_1: Downloading m3u8 information
[info] episode_1: Downloading 1 format(s): 1123
[hlsnative] Downloading m3u8 manifest
[hlsnative] Total fragments: 654
[download] Destination: Эпизод 1 ⧸ Субтитры ⧸ Я хочу съесть твою поджелудочную ⧸ Kimi no Suizou wo Tabetai ⧸ SovetRomantica [episode_1].mp4
[download] 0.1% of ~ 3.49GiB at 141.74KiB/s ETA 07:10:15 (frag 0/654)
Source, Campaign, Ad
— это составной ключ (для source any — внешний).UNION ALL
по всем таблицам, а полученные результат группируете по Source, Campaign, Ad
.DECLARE @SA TABLE ( [Date] DATE, Campaign VARCHAR(100), Ad VARCHAR(100),
Impression INT, Click INT, Cost MONEY );
INSERT @SA VALUES
('2022-11-08', 'Vasya', 'C', 12, 1, 1),
('2022-11-08', 'Vasya', 'C', 12, 1, 1),
('2022-11-08', 'A', 'C', 12, 1, 1),
('2022-11-08', 'A', 'C', 12, 1, 1),
('2022-11-08', 'B', 'A', 12, 1, 1),
('2022-11-08', 'B', 'A', 12, 1, 1),
('2022-10-08', 'Vasya', 'C', 12, 1, 1);
DECLARE @SB TABLE ( [DateTime] DATETIME, Campaign VARCHAR(100), Ad VARCHAR(100),
Impression INT, Click INT, Cost MONEY );
INSERT @SB VALUES
('2022-11-06 12:10:00.000', 'Random', 'V', 12, 1, 1),
('2022-11-06 12:10:00.000', 'Random', 'V', 12, 1, 1),
('2022-11-07 12:10:00.000', 'H', 'A', 12, 1, 1),
('2022-11-07 12:10:00.000', 'H', 'A', 12, 1, 1),
('2022-11-08 12:10:00.000', 'K', 'C', 12, 1, 1),
('2022-11-08 12:10:00.000', 'K', 'C', 12, 1, 1),
('2022-11-06 12:10:00.000', 'Random', 'V', 12, 2, 2);
DECLARE @Sany TABLE ( [Date] DATE, [Source] VARCHAR(100), Campaign VARCHAR(100), Ad VARCHAR(100),
Install INT, Purchase MONEY );
INSERT @Sany VALUES
('2022-11-08', 'Source A', 'Vasya', 'C', 1, 1),
('2022-11-08', 'Source A', 'Vasya', 'C', 1, 1),
('2022-11-08', 'Source A', 'A', 'C', 1, 1),
('2022-11-08', 'Source A', 'A', 'C', 1, 1),
('2022-11-08', 'Source A', 'B', 'A', 1, 1),
('2022-11-08', 'Source A', 'B', 'A', 1, 1),
('2022-11-06', 'Source B', 'Random', 'V', 1, 1),
('2022-11-06', 'Source B', 'Random', 'V', 1, 1),
('2022-11-07', 'Source B', 'H', 'A', 1, 1),
('2022-11-08', 'Source A', 'Vasya', 'C', 3, 3),
('2022-11-08', 'Source A', 'Vasya', 'C', 1, 1),
('2022-11-08', 'Source A', 'Vasya', 'C', 1, 1),
('2022-11-11', 'Source A', 'Vasya', 'C', 2, 2),
('2022-11-13', 'Source C', 'AAAA', 'B', 2, 2);
SELECT [Source], Campaign, Ad,
SUM( Click ) AS SumClick, SUM( Cost ) AS SumCost,
SUM( Install ) AS SumInstall, SUM( Purchase) AS SumPurchase
FROM (
SELECT 'Source A' AS [Source], Campaign, Ad, Click, Cost,
CAST(NULL AS INT) AS [Install], CAST(NULL AS MONEY) AS Purchase
FROM @SA
UNION ALL
SELECT 'Source B' AS [Source], Campaign, Ad, Click, Cost,
CAST(NULL AS INT) AS [Install], CAST(NULL AS MONEY) AS Purchase
FROM @SB
UNION ALL
SELECT [Source], Campaign, Ad, NULL, NULL, [Install], Purchase
FROM @Sany
) AS Common
GROUP BY [Source], Campaign, Ad
DECLARE @Table TABLE ( [Column] NVARCHAR(50))
INSERT @Table VALUES
('46546546'),
('45.04545'),
('4545.5454'),
('5.0'),
('545.0'),
('0.0'),
('0.025'),
(NULL)
SELECT ISNULL(FORMAT( CAST( [Column] AS FLOAT ), '', 'en-US' ), 'sale')
FROM @Table
46546546
45.04545
4545.5454
5
545
0
0.025
sale
DECLARE @Table
TABLE ( [Column] NVARCHAR(50),
[ColumnNeed] AS ISNULL(FORMAT( CAST( [Column] AS FLOAT ), '', 'en-US' ), 'sale'));
INSERT @Table VALUES
('46546546'),
('45.04545'),
('4545.5454'),
('5.0'),
('545.0'),
('0.0'),
('0.025'),
(NULL)
SELECT ColumnNeed
FROM @Table
SELECT *
FROM @Words AS Wrd
JOIN ( SELECT LEFT( Word1, 4 ) AS Word4
FROM @Words
GROUP BY LEFT( Word1, 4 )
HAVING COUNT(*) > 1 ) AS Wrd4
ON Wrd4.Word4 = LEFT( Word1, 4 )
JOIN ( SELECT LEFT( Word2, 2 ) AS Word2
FROM @Words
GROUP BY LEFT( Word2, 2 )
HAVING COUNT(*) > 1 ) AS Wrd2
ON Wrd2.Word2 = LEFT( Wrd.Word2, 2 )
cheque_id
и ROUND(qty,2)
и соответствующим HAVING
, а потом соединяете его с основной таблицей.DECLARE @items_sales TABLE ( [Date] DATE, cheque_id INT, item INT, position INT, qty REAL )
INSERT @items_sales VALUES
('2022-09-12', 1, 1, 1, 0.237),
('2022-09-12', 1, 2, 2, 0.238),
('2022-09-12', 1, 3, 3, 0.322),
('2022-09-12', 1, 4, 4, 0.239),
('2022-09-12', 2, 1, 1, 0.210),
('2022-09-12', 2, 2, 2, 0.210),
('2022-09-12', 3, 5, 1, 0.240),
('2022-09-12', 4, 9, 1, 0.322),
('2022-09-12', 4, 8, 2, 0.322)
SELECT *
FROM @items_sales AS Iteams
JOIN ( SELECT cheque_id, ROUND( qty, 2) AS RoundQty
FROM @items_sales
GROUP BY cheque_id, ROUND( qty, 2)
HAVING COUNT(*) >= 3 ) AS IteamCount
ON IteamCount.cheque_id = Iteams.cheque_id
AND IteamCount.RoundQty = ROUND( qty, 2)
ORDER BY [Date], Iteams.cheque_id, item
https://praybook.info/sitemap.xml
-> https://praybook.info/uploads/static_pages.xml
работает;https://praybook.info/uploads/static_pages.xml
-> https://praybook.info/pro_sait.html
не работает, так как первое ниже второго.https://praybook.info/uploads/static_pages.xml
как https://praybook.info/static_pages.xml
и отдайте их все google без всяких промежуточных sitemap.