Untitled query #524

SQL

USE etwiki_p;
SELECT et.page_title 'artikkel'#, pp_value, rev_timestamp
FROM revision
LEFT JOIN page et ON rev_page=et.page_id
# LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props ON pp_page = page_id
# LEFT JOIN wikidatawiki_p.page d ON pp_value=d.page_title
# LEFT JOIN wikidatawiki_p.pagelinks ON pl_from=d.page_id
WHERE et.page_namespace=0
AND et.page_is_redirect=0
AND rev_parent_id=0
AND rev_user=278
AND rev_timestamp > 20180720000000 AND rev_timestamp < 20190101000000
# AND pl_namespace=120
# AND pl_title='P4689'
ORDER BY rev_timestamp ASC
SQL

Checking query status...
