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 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 '20161221210000' AND '20170101000000'
UNION SELECT 'commons.wikimedia.org' AS project, page_namespace, page_title, user_name, rev_comment, rev_timestamp 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 '20161221210000' AND '20170101000000'
UNION SELECT 'wikidata.org' AS project, page_namespace, page_title, user_name, rev_comment, rev_timestamp 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 '20161221210000' AND '20170101000000'
UNION SELECT 'cs.wikisource.org' AS project, page_namespace, page_title, user_name, rev_comment, rev_timestamp 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 '20161221210000' AND '20170101000000'
ORDER BY rev_timestamp
SQL

Checking query status...
