Untitled query #524

SQL

USE etwiki_p;
SELECT
  CONCAT('[[', et.page_title,']]'), 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 pl_namespace=120
AND pl_title!='P4689'
ORDER BY rev_timestamp ASC
SQL

Checking query status...
