Untitled query #29856

SQL

#show create table plwikisource_p.revision;show create table plwikisource_p.page;
SET @data='2018093000';
SELECT 'pl' as lang, page_title, rev_user, rev_user_text, rev_timestamp, rev_comment
  FROM plwikisource_p.page JOIN plwikisource_p.categorylinks ON page_id=cl_from JOIN plwikisource_p.revision ON page_id=rev_page
  WHERE cl_to = 'Uwierzytelniona' AND page_namespace = 100 AND rev_timestamp > @data
UNION
SELECT 'de' as lang, page_title, rev_user, rev_user_text, rev_timestamp, rev_comment
  FROM dewikisource_p.page JOIN dewikisource_p.categorylinks ON page_id=cl_from JOIN dewikisource_p.revision ON page_id=rev_page
  WHERE cl_to = 'Fertig' AND page_namespace = 102 AND rev_timestamp > @data
ORDER BY 4 DESC;
SQL

Checking query status...
