Vánoční wikidárky českých wikipedistů 2016

SQL

SELECT 'cs.wikipedia.org' AS project, page_namespace, page_title, user_name, rev_comment, rev_timestamp, CONCAT('https://cs.wikipedia.org/w/index.php?diff=', rev_id) AS link FROM cswiki_p.revision JOIN cswiki_p.page ON rev_page = page_id JOIN cswiki_p.user ON rev_user = user_id WHERE (rev_comment LIKE '%#dárek%' OR rev_comment LIKE '%#darek%') AND rev_timestamp BETWEEN '20161221190000' AND '20170107000000'
UNION SELECT 'commons.wikimedia.org' AS project, page_namespace, page_title, user_name, rev_comment, rev_timestamp, CONCAT('https://commons.wikimedia.org/w/index.php?diff=', rev_id) AS link FROM commonswiki_p.revision JOIN commonswiki_p.page ON rev_page = page_id JOIN commonswiki_p.user ON rev_user = user_id WHERE (rev_comment LIKE '%#dárek%' OR rev_comment LIKE '%#darek%') AND rev_timestamp BETWEEN '20161221190000' AND '20170107000000'
UNION SELECT 'wikidata.org' AS project, page_namespace, page_title, user_name, rev_comment, rev_timestamp, CONCAT('https://www.wikidata.org/w/index.php?diff=', rev_id) AS link FROM wikidatawiki_p.revision JOIN wikidatawiki_p.page ON rev_page = page_id JOIN wikidatawiki_p.user ON rev_user = user_id WHERE (rev_comment LIKE '%#dárek%' OR rev_comment LIKE '%#darek%') AND rev_timestamp BETWEEN '20161221190000' AND '20170107000000'
UNION SELECT 'cs.wikisource.org' AS project, page_namespace, page_title, user_name, rev_comment, rev_timestamp, CONCAT('https://cs.wikisource.org/w/index.php?diff=', rev_id) AS link FROM cswikisource_p.revision JOIN cswikisource_p.page ON rev_page = page_id JOIN cswikisource_p.user ON rev_user = user_id WHERE (rev_comment LIKE '%#dárek%' OR rev_comment LIKE '%#darek%') AND rev_timestamp BETWEEN '20161221190000' AND '20170107000000'
ORDER BY rev_timestamp
SQL

Checking query status...
