Fork of
PT2018
by Viswaprabha
This query is marked as a draft
This query has been published
by Viswaprabha.
SQL
x
USE mlwiki_p;
SELECT
'ml', t.TotBytes, t.page_lang, t.page_id AS PID, r2.rev_id AS CreateRID, r2.rev_timestamp AS CreateTime, r2.rev_user_text AS Creator,
r1.rev_id AS LastRID, r1.rev_timestamp AS LastTime, r1.rev_user_text AS LastEditor, r1.rev_len AS LastSize,
t.cnt AS Edits, t.page_title AS Title, q.eu_entity_id
FROM (
SELECT COUNT(*) AS cnt,p.page_lang, SUM(r.rev_len) as TotBytes, r.rev_timestamp, p.page_id, p.page_title, p.page_latest, p.page_namespace
FROM revision r LEFT JOIN page p ON p.page_id = r.rev_page WHERE r.rev_page IN (
SELECT page_id FROM page p2 WHERE p2.page_namespace = 0 AND p2.page_title IN (
SELECT page_title FROM page WHERE page_id IN (
SELECT cl_from FROM categorylinks WHERE cl_to = '2018ലെ_പ്രോജക്റ്റ്_ടൈഗർ_തിരുത്തൽ_യജ്ഞത്തിന്റെ_ഭാഗമായി_സൃഷ്ടിക്കപ്പെട്ട_ലേഖനങ്ങൾ'
))) AND p.page_namespace = 0
GROUP BY page_namespace, page_title ) AS t
LEFT JOIN revision r2 ON r2.rev_page = t.page_id AND r2.rev_parent_id = 0
LEFT JOIN revision r1 ON r1.rev_id = t.page_latest
LEFT JOIN wbc_entity_usage q ON q.eu_page_id = t.page_latest
;
/*GROUP BY t1.page_namespace, t1.page_title AS tq;*/
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.