Actualize clickbench queries

2 files changed, 124 insertions, 101 deletions

diff --git a/ydb/public/lib/ydb_cli/commands/click_bench.cpp b/ydb/public/lib/ydb_cli/commands/click_bench.cpp
index b57f22c9d4f..5e0686c1c9c 100644
--- a/ydb/public/lib/ydb_cli/commands/click_bench.cpp
+++ b/ydb/public/lib/ydb_cli/commands/click_bench.cpp
@@ -80,6 +80,15 @@ static void ThrowOnError(const TStatus& status) {
     }
 }
 
+static bool HasCharsInString(const TString& str) {
+    for (auto c : str) {
+        if (std::isalpha(c)) {
+            return true;
+        }
+    }
+    return false;
+}
+
 static std::pair<TString, TString> ResultToYson(NTable::TScanQueryPartIterator& it) {
     TStringStream out;
     TStringStream err_out;
@@ -190,6 +199,9 @@ bool TClickBenchCommandRun::RunBench(TConfig& config)
             continue;
         }
 
+        if (!HasCharsInString(qtokens[queryN])) {
+            continue;
+        }
         const TString query = PatchQuery(qtokens[queryN]);
 
         std::vector<TDuration> timings;
diff --git a/ydb/public/lib/ydb_cli/commands/click_bench_queries.sql b/ydb/public/lib/ydb_cli/commands/click_bench_queries.sql
index 7e39beab5aa..9d46b18e443 100644
--- a/ydb/public/lib/ydb_cli/commands/click_bench_queries.sql
+++ b/ydb/public/lib/ydb_cli/commands/click_bench_queries.sql
@@ -1,154 +1,165 @@
+-- q00
 SELECT COUNT(*) FROM {table};
-SELECT COUNT(*) FROM {table} WHERE AdvEngineID != 0;
+-- q01
+SELECT COUNT(*) FROM {table} WHERE AdvEngineID <> 0;
+-- q02
 SELECT SUM(AdvEngineID), COUNT(*), AVG(ResolutionWidth) FROM {table};
-SELECT SUM(UserID) FROM {table};
+-- q03
+SELECT AVG(UserID) FROM {table};
+-- q04
 SELECT COUNT(DISTINCT UserID) FROM {table};
+-- q05
 SELECT COUNT(DISTINCT SearchPhrase) FROM {table};
+-- q06
 SELECT MIN(EventDate), MAX(EventDate) FROM {table};
-SELECT AdvEngineID, COUNT(*) as c FROM {table} WHERE AdvEngineID != 0 GROUP BY AdvEngineID ORDER BY c DESC;
+-- q07
+SELECT AdvEngineID, COUNT(*) as cnt FROM {table} WHERE AdvEngineID <> 0 GROUP BY AdvEngineID ORDER BY cnt DESC;
+-- q08
 SELECT RegionID, COUNT(DISTINCT UserID) AS u FROM {table} GROUP BY RegionID ORDER BY u DESC LIMIT 10;
-SELECT RegionID, SUM(AdvEngineID), COUNT(*) AS c, avg(ResolutionWidth), COUNT(DISTINCT UserID) FROM {table} GROUP BY RegionID ORDER BY c DESC LIMIT 10;
+-- q9
+SELECT RegionID, SUM(AdvEngineID), COUNT(*) AS c, AVG(ResolutionWidth), COUNT(DISTINCT UserID)
+FROM {table} GROUP BY RegionID ORDER BY c DESC LIMIT 10;
+-- q10
+SELECT MobilePhoneModel, COUNT(DISTINCT UserID) AS u
+FROM {table} WHERE MobilePhoneModel <> '' GROUP BY MobilePhoneModel ORDER BY u DESC LIMIT 10;
 -- q11
-SELECT MobilePhoneModel, CountDistinctEstimate(UserID) AS u
-FROM {table} WHERE MobilePhoneModel != '' GROUP BY MobilePhoneModel ORDER BY u DESC LIMIT 10;
+SELECT MobilePhone, MobilePhoneModel, COUNT(DISTINCT UserID) AS u
+FROM {table} WHERE MobilePhoneModel <> '' GROUP BY MobilePhone, MobilePhoneModel ORDER BY u DESC LIMIT 10;
 -- q12
-SELECT MobilePhone, MobilePhoneModel, CountDistinctEstimate(UserID) AS u
-FROM {table} WHERE MobilePhoneModel != '' GROUP BY MobilePhone, MobilePhoneModel ORDER BY u DESC LIMIT 10;
+SELECT SearchPhrase, COUNT(*) AS c
+FROM {table} WHERE SearchPhrase <> '' GROUP BY SearchPhrase ORDER BY c DESC LIMIT 10;
 -- q13
-SELECT SearchPhrase, count(*) AS c
-FROM {table} WHERE SearchPhrase != '' GROUP BY SearchPhrase ORDER BY c DESC LIMIT 10;
+SELECT SearchPhrase, COUNT(DISTINCT UserID) AS u
+FROM {table} WHERE SearchPhrase <> '' GROUP BY SearchPhrase ORDER BY u DESC LIMIT 10;
 -- q14
-SELECT SearchPhrase, CountDistinctEstimate(UserID) AS u
-FROM {table} WHERE SearchPhrase != '' GROUP BY SearchPhrase ORDER BY u DESC LIMIT 10;
+SELECT SearchEngineID, SearchPhrase, COUNT(*) AS c
+FROM {table} WHERE SearchPhrase <> '' GROUP BY SearchEngineID, SearchPhrase ORDER BY c DESC LIMIT 10;
 -- q15
-SELECT SearchEngineID, SearchPhrase, count(*) AS c
-FROM {table} WHERE SearchPhrase != '' GROUP BY SearchEngineID, SearchPhrase ORDER BY c DESC LIMIT 10;
+SELECT UserID, COUNT(*) as cnt FROM {table} GROUP BY UserID ORDER BY cnt DESC LIMIT 10;
 -- q16
-SELECT UserID, count(*) AS c FROM {table} GROUP BY UserID ORDER BY c DESC LIMIT 10;
+SELECT UserID, SearchPhrase, COUNT(*) as cnt FROM {table} GROUP BY UserID, SearchPhrase ORDER BY cnt DESC LIMIT 10;
 -- q17
-SELECT UserID, SearchPhrase, count(*) AS c FROM {table} GROUP BY UserID, SearchPhrase ORDER BY c DESC LIMIT 10;
+SELECT UserID, SearchPhrase, COUNT(*) FROM {table} GROUP BY UserID, SearchPhrase LIMIT 10;
 -- q18
-SELECT UserID, SearchPhrase, count(*) AS c FROM {table} GROUP BY UserID, SearchPhrase LIMIT 10;
+SELECT UserID, m, SearchPhrase, COUNT(*) as cnt
+FROM {table} GROUP BY UserID, DateTime::GetMinute(EventTime) AS m, SearchPhrase ORDER BY cnt DESC LIMIT 10;
 -- q19
-SELECT UserID, m, SearchPhrase, count(*) AS c
-FROM {table} GROUP BY UserID, DateTime::GetMinute(EventTime) AS m, SearchPhrase ORDER BY c DESC LIMIT 10;
--- q20
 SELECT UserID FROM {table} WHERE UserID = 435090932899640449;
+-- q20
+SELECT COUNT(*) FROM {table} WHERE URL LIKE '%google%';
 -- q21
-SELECT count(*) FROM {table} WHERE URL LIKE '%google%';
--- q22
 SELECT SearchPhrase, MIN(URL), COUNT(*) AS c
-FROM {table} WHERE URL LIKE '%google%' AND SearchPhrase != '' GROUP BY SearchPhrase ORDER BY c DESC LIMIT 10;
--- q23
-SELECT SearchPhrase, some(URL), some(Title), count(*) AS c, CountDistinctEstimate(UserID)
-FROM {table} WHERE Title LIKE '%Google%' AND URL NOT LIKE '%.google.%' AND SearchPhrase != ''
+FROM {table} WHERE URL LIKE '%google%' AND SearchPhrase <> '' GROUP BY SearchPhrase ORDER BY c DESC LIMIT 10;
+-- q22
+SELECT SearchPhrase, MIN(URL), MIN(Title), COUNT(*) AS c, COUNT(DISTINCT UserID)
+FROM {table} WHERE Title LIKE '%Google%' AND URL NOT LIKE '%.google.%' AND SearchPhrase <> ''
 GROUP BY SearchPhrase ORDER BY c DESC LIMIT 10;
--- q24
+-- q23
 SELECT * FROM {table} WHERE URL LIKE '%google%' ORDER BY EventTime LIMIT 10;
+-- q24
+SELECT SearchPhrase, EventTime FROM {table} WHERE SearchPhrase <> '' ORDER BY EventTime LIMIT 10;
 -- q25
-SELECT SearchPhrase, EventTime FROM {table} WHERE SearchPhrase != '' ORDER BY EventTime LIMIT 10;
+SELECT SearchPhrase FROM {table} WHERE SearchPhrase <> '' ORDER BY SearchPhrase LIMIT 10;
 -- q26
-SELECT SearchPhrase FROM {table} WHERE SearchPhrase != '' ORDER BY SearchPhrase LIMIT 10;
+SELECT SearchPhrase, EventTime FROM {table} WHERE SearchPhrase <> '' ORDER BY EventTime, SearchPhrase LIMIT 10;
 -- q27
-SELECT SearchPhrase, EventTime FROM {table} WHERE SearchPhrase != '' ORDER BY EventTime, SearchPhrase LIMIT 10;
+SELECT CounterID, AVG(length(URL)) AS l, COUNT(*) AS c
+FROM {table} WHERE URL <> '' GROUP BY CounterID HAVING COUNT(*) > 100000 ORDER BY l DESC LIMIT 25;
 -- q28
-SELECT CounterID, avg(length(URL)) AS l, count(*) AS c
-FROM {table} WHERE URL != '' GROUP BY CounterID HAVING count(*) > 100000 ORDER BY l DESC LIMIT 25;
+SELECT key, AVG(length(Referer)) AS l, COUNT(*) AS c, MIN(Referer)
+FROM {table} WHERE Referer <> '' GROUP BY Url::CutWWW(Url::GetHost(Referer)) as key
+HAVING COUNT(*) > 100000 ORDER BY l DESC LIMIT 25;
 -- q29
-SELECT key, avg(length(Referer)) AS l, count(*) AS c, some(Referer)
-FROM {table} WHERE Referer != '' GROUP BY Url::CutWWW(Url::GetHost(Referer)) AS key
-HAVING count(*) > 100000 ORDER BY l DESC LIMIT 25;
--- q30
 SELECT
-    sum(ResolutionWidth), sum(ResolutionWidth + 1), sum(ResolutionWidth + 2), sum(ResolutionWidth + 3),
-    sum(ResolutionWidth + 4), sum(ResolutionWidth + 5), sum(ResolutionWidth + 6), sum(ResolutionWidth + 7),
-    sum(ResolutionWidth + 8), sum(ResolutionWidth + 9), sum(ResolutionWidth + 10), sum(ResolutionWidth + 11),
-    sum(ResolutionWidth + 12), sum(ResolutionWidth + 13), sum(ResolutionWidth + 14), sum(ResolutionWidth + 15),
-    sum(ResolutionWidth + 16), sum(ResolutionWidth + 17), sum(ResolutionWidth + 18), sum(ResolutionWidth + 19),
-    sum(ResolutionWidth + 20), sum(ResolutionWidth + 21), sum(ResolutionWidth + 22), sum(ResolutionWidth + 23),
-    sum(ResolutionWidth + 24), sum(ResolutionWidth + 25), sum(ResolutionWidth + 26), sum(ResolutionWidth + 27),
-    sum(ResolutionWidth + 28), sum(ResolutionWidth + 29), sum(ResolutionWidth + 30), sum(ResolutionWidth + 31),
-    sum(ResolutionWidth + 32), sum(ResolutionWidth + 33), sum(ResolutionWidth + 34), sum(ResolutionWidth + 35),
-    sum(ResolutionWidth + 36), sum(ResolutionWidth + 37), sum(ResolutionWidth + 38), sum(ResolutionWidth + 39),
-    sum(ResolutionWidth + 40), sum(ResolutionWidth + 41), sum(ResolutionWidth + 42), sum(ResolutionWidth + 43),
-    sum(ResolutionWidth + 44), sum(ResolutionWidth + 45), sum(ResolutionWidth + 46), sum(ResolutionWidth + 47),
-    sum(ResolutionWidth + 48), sum(ResolutionWidth + 49), sum(ResolutionWidth + 50), sum(ResolutionWidth + 51),
-    sum(ResolutionWidth + 52), sum(ResolutionWidth + 53), sum(ResolutionWidth + 54), sum(ResolutionWidth + 55),
-    sum(ResolutionWidth + 56), sum(ResolutionWidth + 57), sum(ResolutionWidth + 58), sum(ResolutionWidth + 59),
-    sum(ResolutionWidth + 60), sum(ResolutionWidth + 61), sum(ResolutionWidth + 62), sum(ResolutionWidth + 63),
-    sum(ResolutionWidth + 64), sum(ResolutionWidth + 65), sum(ResolutionWidth + 66), sum(ResolutionWidth + 67),
-    sum(ResolutionWidth + 68), sum(ResolutionWidth + 69), sum(ResolutionWidth + 70), sum(ResolutionWidth + 71),
-    sum(ResolutionWidth + 72), sum(ResolutionWidth + 73), sum(ResolutionWidth + 74), sum(ResolutionWidth + 75),
-    sum(ResolutionWidth + 76), sum(ResolutionWidth + 77), sum(ResolutionWidth + 78), sum(ResolutionWidth + 79),
-    sum(ResolutionWidth + 80), sum(ResolutionWidth + 81), sum(ResolutionWidth + 82), sum(ResolutionWidth + 83),
-    sum(ResolutionWidth + 84), sum(ResolutionWidth + 85), sum(ResolutionWidth + 86), sum(ResolutionWidth + 87),
-    sum(ResolutionWidth + 88), sum(ResolutionWidth + 89)
+    SUM(ResolutionWidth), SUM(ResolutionWidth + 1), SUM(ResolutionWidth + 2), SUM(ResolutionWidth + 3),
+    SUM(ResolutionWidth + 4), SUM(ResolutionWidth + 5), SUM(ResolutionWidth + 6), SUM(ResolutionWidth + 7),
+    SUM(ResolutionWidth + 8), SUM(ResolutionWidth + 9), SUM(ResolutionWidth + 10), SUM(ResolutionWidth + 11),
+    SUM(ResolutionWidth + 12), SUM(ResolutionWidth + 13), SUM(ResolutionWidth + 14), SUM(ResolutionWidth + 15),
+    SUM(ResolutionWidth + 16), SUM(ResolutionWidth + 17), SUM(ResolutionWidth + 18), SUM(ResolutionWidth + 19),
+    SUM(ResolutionWidth + 20), SUM(ResolutionWidth + 21), SUM(ResolutionWidth + 22), SUM(ResolutionWidth + 23),
+    SUM(ResolutionWidth + 24), SUM(ResolutionWidth + 25), SUM(ResolutionWidth + 26), SUM(ResolutionWidth + 27),
+    SUM(ResolutionWidth + 28), SUM(ResolutionWidth + 29), SUM(ResolutionWidth + 30), SUM(ResolutionWidth + 31),
+    SUM(ResolutionWidth + 32), SUM(ResolutionWidth + 33), SUM(ResolutionWidth + 34), SUM(ResolutionWidth + 35),
+    SUM(ResolutionWidth + 36), SUM(ResolutionWidth + 37), SUM(ResolutionWidth + 38), SUM(ResolutionWidth + 39),
+    SUM(ResolutionWidth + 40), SUM(ResolutionWidth + 41), SUM(ResolutionWidth + 42), SUM(ResolutionWidth + 43),
+    SUM(ResolutionWidth + 44), SUM(ResolutionWidth + 45), SUM(ResolutionWidth + 46), SUM(ResolutionWidth + 47),
+    SUM(ResolutionWidth + 48), SUM(ResolutionWidth + 49), SUM(ResolutionWidth + 50), SUM(ResolutionWidth + 51),
+    SUM(ResolutionWidth + 52), SUM(ResolutionWidth + 53), SUM(ResolutionWidth + 54), SUM(ResolutionWidth + 55),
+    SUM(ResolutionWidth + 56), SUM(ResolutionWidth + 57), SUM(ResolutionWidth + 58), SUM(ResolutionWidth + 59),
+    SUM(ResolutionWidth + 60), SUM(ResolutionWidth + 61), SUM(ResolutionWidth + 62), SUM(ResolutionWidth + 63),
+    SUM(ResolutionWidth + 64), SUM(ResolutionWidth + 65), SUM(ResolutionWidth + 66), SUM(ResolutionWidth + 67),
+    SUM(ResolutionWidth + 68), SUM(ResolutionWidth + 69), SUM(ResolutionWidth + 70), SUM(ResolutionWidth + 71),
+    SUM(ResolutionWidth + 72), SUM(ResolutionWidth + 73), SUM(ResolutionWidth + 74), SUM(ResolutionWidth + 75),
+    SUM(ResolutionWidth + 76), SUM(ResolutionWidth + 77), SUM(ResolutionWidth + 78), SUM(ResolutionWidth + 79),
+    SUM(ResolutionWidth + 80), SUM(ResolutionWidth + 81), SUM(ResolutionWidth + 82), SUM(ResolutionWidth + 83),
+    SUM(ResolutionWidth + 84), SUM(ResolutionWidth + 85), SUM(ResolutionWidth + 86), SUM(ResolutionWidth + 87),
+    SUM(ResolutionWidth + 88), SUM(ResolutionWidth + 89)
 FROM {table};
+-- q30
+SELECT SearchEngineID, ClientIP, COUNT(*) AS c, SUM(IsRefresh), AVG(ResolutionWidth)
+FROM {table} WHERE SearchPhrase <> '' GROUP BY SearchEngineID, ClientIP ORDER BY c DESC LIMIT 10;
 -- q31
-SELECT SearchEngineID, ClientIP, count(*) AS c, sum(IsRefresh), avg(ResolutionWidth)
-FROM {table} WHERE SearchPhrase != '' GROUP BY SearchEngineID, ClientIP ORDER BY c DESC LIMIT 10;
+SELECT WatchID, ClientIP, COUNT(*) AS c, SUM(IsRefresh), AVG(ResolutionWidth)
+FROM {table} WHERE SearchPhrase <> '' GROUP BY WatchID, ClientIP ORDER BY c DESC LIMIT 10;
 -- q32
-SELECT WatchID, ClientIP, count(*) AS c, sum(IsRefresh), avg(ResolutionWidth)
-FROM {table} WHERE SearchPhrase != '' GROUP BY WatchID, ClientIP ORDER BY c DESC LIMIT 10;
--- q33
-SELECT WatchID, ClientIP, count(*) AS c, sum(IsRefresh), avg(ResolutionWidth)
+SELECT WatchID, ClientIP, COUNT(*) AS c, SUM(IsRefresh), AVG(ResolutionWidth)
 FROM {table} GROUP BY WatchID, ClientIP ORDER BY c DESC LIMIT 10;
+-- q33
+SELECT URL, COUNT(*) AS c FROM {table} GROUP BY URL ORDER BY c DESC LIMIT 10;
 -- q34
-SELECT URL, count(*) AS c FROM {table} GROUP BY URL ORDER BY c DESC LIMIT 10;
+SELECT UserID, URL, COUNT(*) AS c FROM {table} GROUP BY UserID, URL ORDER BY c DESC LIMIT 10;
 -- q35
-SELECT UserID, URL, count(*) AS c FROM {table} GROUP BY UserID, URL ORDER BY c DESC LIMIT 10;
+SELECT ClientIP, ClientIP - 1, ClientIP - 2, ClientIP - 3, COUNT(*) AS c
+FROM {table}
+GROUP BY ClientIP, ClientIP - 1, ClientIP - 2, ClientIP - 3 ORDER BY c DESC LIMIT 10;
 -- q36
-SELECT x0, x1, x2, x3, count(*) AS c
+SELECT URL, COUNT(*) AS PageViews
 FROM {table}
-GROUP BY ClientIP as x0, ClientIP - 1 as x1, ClientIP - 2 as x2, ClientIP - 3 as x3 ORDER BY c DESC LIMIT 10;
+WHERE
+    CounterID = 62 AND EventDate >= Date('2013-07-01') AND EventDate <= Date('2013-07-31') AND DontCountHits == 0
+    AND IsRefresh == 0 AND URL <> ''
+GROUP BY URL ORDER BY PageViews DESC LIMIT 10;
 -- q37
-SELECT URL, count(*) AS PageViews
+SELECT Title, COUNT(*) AS PageViews
 FROM {table}
 WHERE
     CounterID = 62 AND EventDate >= Date('2013-07-01') AND EventDate <= Date('2013-07-31') AND DontCountHits == 0
-    AND IsRefresh == 0 AND URL != ''
-GROUP BY URL ORDER BY PageViews DESC LIMIT 10;
+    AND IsRefresh == 0 AND Title <> ''
+GROUP BY Title ORDER BY PageViews DESC LIMIT 10;
 -- q38
-SELECT Title, count(*) AS PageViews
+SELECT URL, COUNT(*) AS PageViews
 FROM {table}
 WHERE
-    CounterID = 62 AND EventDate >= Date('2013-07-01') AND EventDate <= Date('2013-07-31') AND DontCountHits == 0 AND
-    IsRefresh == 0 AND Title != ''
-GROUP BY Title ORDER BY PageViews DESC LIMIT 10;
+    CounterID = 62 AND EventDate >= Date('2013-07-01') AND EventDate <= Date('2013-07-31') AND IsRefresh == 0
+    AND IsLink <> 0 AND IsDownload == 0
+GROUP BY URL ORDER BY PageViews DESC LIMIT 10;
 -- q39
-SELECT URL, count(*) AS PageViews
+SELECT TraficSourceID, SearchEngineID, AdvEngineID, Src, Dst, COUNT(*) AS PageViews
 FROM {table}
 WHERE
-    CounterID = 62 AND EventDate >= Date('2013-07-01') AND EventDate <= Date('2013-07-31') AND IsRefresh == 0 AND
-    IsLink != 0 AND IsDownload == 0
-GROUP BY URL ORDER BY PageViews DESC LIMIT 1000;
+    CounterID = 62 AND EventDate >= Date('2013-07-01') AND EventDate <= Date('2013-07-31') AND IsRefresh == 0
+GROUP BY
+    TraficSourceID, SearchEngineID, AdvEngineID, IF (SearchEngineID = 0 AND AdvEngineID = 0, Referer, '') AS Src,
+    URL AS Dst
+ORDER BY PageViews DESC LIMIT 10;
 -- q40
-SELECT TraficSourceID, SearchEngineID, AdvEngineID, Src, Dst, count(*) AS PageViews
+SELECT URLHash, EventDate, COUNT(*) AS PageViews
 FROM {table}
 WHERE
-    CounterID = 62 AND EventDate >=  Date('2013-07-01') AND EventDate <= Date('2013-07-31') AND IsRefresh == 0
-GROUP BY
-    TraficSourceID, SearchEngineID, AdvEngineID, IF(SearchEngineID = 0 AND AdvEngineID = 0, Referer, '') AS Src,
-    URL AS Dst
-ORDER BY PageViews DESC LIMIT 1000;
+    CounterID = 62 AND EventDate >= Date('2013-07-01') AND EventDate <= Date('2013-07-31') AND IsRefresh == 0
+    AND TraficSourceID IN (-1, 6) AND RefererHash = 3594120000172545465
+GROUP BY URLHash, EventDate ORDER BY PageViews DESC LIMIT 10;
 -- q41
-SELECT URLHash, EventDate, count(*) AS PageViews
+SELECT WindowClientWidth, WindowClientHeight, COUNT(*) AS PageViews
 FROM {table}
 WHERE
-    CounterID = 62 AND EventDate >= Date('2013-07-01') AND EventDate <= Date('2013-07-31') AND IsRefresh == 0 AND
-    TraficSourceID IN (-1, 6) AND RefererHash = Digest::Md5HalfMix('http://example.ru/')
-GROUP BY URLHash, EventDate ORDER BY PageViews DESC LIMIT 100;
+    CounterID = 62 AND EventDate >= Date('2013-07-01') AND EventDate <= Date('2013-07-31') AND IsRefresh == 0
+    AND DontCountHits = 0 AND URLHash = 2868770270353813622
+GROUP BY WindowClientWidth, WindowClientHeight ORDER BY PageViews DESC LIMIT 10;
 -- q42
-SELECT WindowClientWidth, WindowClientHeight, count(*) AS PageViews
-FROM {table}
-WHERE
-    CounterID = 62 AND EventDate >=  Date('2013-07-01') AND EventDate <=  Date('2013-07-31') AND IsRefresh == 0 AND
-    DontCountHits == 0 AND URLHash = Digest::Md5HalfMix('http://example.ru/')
-GROUP BY WindowClientWidth, WindowClientHeight ORDER BY PageViews DESC LIMIT 10000;
--- q43
-SELECT Minute, count(*) AS PageViews
+SELECT Minute, COUNT(*) AS PageViews
 FROM {table}
 WHERE
-    CounterID = 62 AND EventDate >= Date('2013-07-01') AND EventDate <= Date('2013-07-02') AND IsRefresh == 0 AND
-    DontCountHits == 0
-GROUP BY DateTime::ToSeconds(EventTime)/60 As Minute ORDER BY Minute
+    CounterID = 62 AND EventDate >= Date('2013-07-14') AND EventDate <= Date('2013-07-15') AND IsRefresh == 0
+    AND DontCountHits = 0
+GROUP BY DateTime::ToSeconds(EventTime)/60 As Minute ORDER BY Minute LIMIT 10;