Query logs

statsdb.sql

d = '155065'          AND namespace_id = '6'          AND article_id = '31922'                ORDER BY pv DESC LIMIT 200
SELECT article_id, pageviews     FROM rollup_wiki_article_pageviews      WHERE article_id IN ( '2411', '2650', '2661', '2136', '2614', '2098', '2830', '2721', '2133' )          AND time_id = '2017-12-10 00:00:00'     AND wiki_id = '931547'          AND period_id = '2'
SELECT 1 as c    FROM rollup_wiki_article_pageviews      WHERE time_id = '2018-01-07 00:00:00'   AND period_id = '2' LIMIT 1
SELECT  namespace_id as namespace,sum(edits) as count  FROM `rollup_wiki_namespace_user_events`  WHERE user_id = '27446087' AND period_id = '1'  GROUP BY namespace_id 
SELECT date_format(time_id,'%Y-%m-%d') AS date, pageviews AS cnt         FROM rollup_wiki_pageviews      WHERE period_id = '1'   AND wiki_id = '610'     AND time_id BETWEEN '2017-10-18'        AND '2018-01-10'
SELECT  wiki_id,SUM(edits) AS edits  FROM `rollup_wiki_user_events`  WHERE period_id = '3' AND (time_id >= NOW() - INTERVAL 90 DAY) AND user_id = '4078552'  GROUP BY wiki_id ORDER BY edits DESC LIMIT 4  
SELECT article_id, pageviews     FROM rollup_wiki_article_pageviews      WHERE article_id IN ( '56267', '56437', '44393', '45037', '44332', '44090', '44212', '46401', '44138', '55433', '43957', '52354', '54984', '54307', '44041', '43071', '53418', '53821', '53823', '54987', '43161', '46616', '44948', '55476', '53841', '43459', '43143', '53820', '43028', '54982', '43470', '43956', '53822', '54983', '54355', '43067' ) 
     AND time_id = '2017-12-24 00:00:00'     AND wiki_id = '930059'          AND period_id = '2'
SELECT  count(fw1.wiki_id) as wam_results_total  FROM `fact_wam_scores` `fw1` left join `fact_wam_scores` `fw2` ON ((fw1.wiki_id = fw2.wiki_id) AND (fw2.time_id = FROM_UNIXTIME(1466380800))) left join `dimension_wikis` `dw` ON ((fw1.wiki_id = dw.wiki_id))  WHERE (fw1.time_id = FROM_UNIXTIME(1466467200)) AND (dw.url like '%%' OR dw.title like '%%') AND fw1.vertical_id IN ('0','1','2','3','4','5','6','7')  AND (fw1.wiki_id NOT IN ('23312','70256','168929','463633','381622','524772','476782','9764','214934','170145','529622','52149','96420','390','468156','690804','197434','29197','88043','37317','466775','402313','169142','746246','119847','57268','1089624')) AND ((dw.url IS NOT NULL AND dw.title IS NOT NULL))  
SELECT  user_id,SUM(edits) as edits  FROM `rollup_wiki_user_events`  WHERE period_id = '2' AND wiki_id = '62648' AND (time_id >= NOW() - INTERVAL 365 DAY) AND (user_id > 0)  GROUP BY user_id ORDER BY edits DESC LIMIT 10  
SELECT  wam  FROM `fact_wam_scores`  WHERE wiki_id = '29374'  ORDER BY time_id DESC LIMIT 1  
SELECT date_format(time_id,'%Y-%m-%d') AS date, pageviews AS cnt         FROM rollup_wiki_pageviews      WHERE period_id = '3'   AND wiki_id = '51610'   AND time_id BETWEEN '2017-12-01'        AND '2018-01-01'
SELECT namespace_id, article_id, pageviews as pv         FROM rollup_wiki_article_pageviews      WHERE time_id = ( CURDATE() - INTERVAL DAYOFWEEK(CURDATE()) - 1 DAY  )          AND period_id = '2'     AND wiki_id = '304'     AND article_id = '48374'                ORDER BY pv DESC LIMIT 200
SELECT time_id as t      FROM rollup_wiki_article_pageviews      WHERE time_id < '2018-01-12 00:00:01'           ORDER BY time_id DESC LIMIT 1
SELECT namespace_id, article_id, pageviews as pv         FROM rollup_wiki_article_pageviews      WHERE time_id = ( CURDATE() - INTERVAL DAYOFWEEK(CURDATE()) - 1 DAY  )          AND period_id = '2'     AND wiki_id = '1015185'         AND namespace_id = '0'                  ORDER BY pv DESC LIMIT 1000
SELECT SUM( creates ) AS creates, SUM( edits ) AS edits, SUM( deletes ) AS deletes, SUM( undeletes ) AS undeletes, user_id       FROM rollup_wiki_namespace_user_events          WHERE period_id = '2'   AND wiki_id = '759985'          AND time_id = '2017-12-31'      AND user_id = '3244635' GROUP BY user_id
SELECT r.wiki_id AS id, pageviews_7day AS pageviews      FROM report_wiki_recent_pageviews AS r                  INNER JOIN dimension_wikis AS d                 ON              r.wiki_id =  d.wiki_id          WHERE d.public = '1'    AND r.lang IN ( 'en', 'ru' )    AND r.hub_name = 'gaming'               ORDER BY pageviews DESC LIMIT 300
SELECT  sum(edits) as cnt  FROM `rollup_wiki_user_events`  WHERE (time_id = '2018-01-10 00:00:00') AND wiki_id = '493764' AND period_id = '1'  LIMIT 1  
SELECT SUM( edits ) AS cnt, date_format(time_id, '%Y-%m-%d') AS date     FROM rollup_wiki_user_events    WHERE time_id BETWEEN '2018-01-05 00:00:00'     AND '2018-01-11 00:00:00'       AND wiki_id = '1669778' 
        AND period_id = '1' GROUP BY date WITH ROLLUP
SHOW VARIABLES LIKE 'read_only';
SELECT article_id, pageviews     FROM rollup_wiki_article_pageviews      WHERE article_id IN ( '21', '20', '19', '18', '17', '16', '13', '1' )   AND time_id = '2017-12-17 00:00:00'     AND wiki_id = '1675176' 
        AND period_id = '2'

• SELECT r.wiki_id AS id, pageviews_7day AS pageviews FROM report_wiki_recent_pageviews AS r
• SELECT count(fw1.wiki_id) as wam_results_total FROM fact_wam_scores fw1 left join fact_wam_scores fw2