2017 - Quarry

SQL

SELECT CONCAT('',arwikiquote_p.page.page_title,'') AS arwikiquote, CONCAT ('Sarwikiquote'), CONCAT('',arwiki_p.page.page_title,'') AS arwiki
FROM arwiki_p.page
	JOIN arwikiquote_p.page
		ON arwiki_p.page.page_title = arwikiquote_p.page.page_title
	LEFT JOIN arwikiquote_p.langlinks
		ON ll_from = arwikiquote_p.page.page_id
	LEFT JOIN (SELECT * FROM arwikiquote_p.page_props WHERE pp_propname = 'wikibase_item') AS props
		ON pp_page = arwikiquote_p.page.page_id
	LEFT JOIN arwikiquote_p.templatelinks
		ON tl_from = arwikiquote_p.page.page_id
	WHERE arwikiquote_p.page.page_namespace = 0
    AND arwikiquote_p.page.page_is_redirect = 0
    AND arwiki_p.page.page_namespace = 0
    AND arwiki_p.page.page_is_redirect = 0
    AND ll_title IS NULL
    AND pp_value IS NULL
    AND NOT EXISTS
      (SELECT * FROM arwikiquote_p.templatelinks AS tl1
      WHERE arwikiquote_p.page.page_id = tl1.tl_from
      AND arwikiquote_p.page.page_namespace = tl1.tl_from_namespace
      AND tl_namespace = 10
      AND tl_title LIKE 'توضيح')
    AND NOT EXISTS
      (SELECT * FROM arwiki_p.templatelinks AS tl1
      WHERE arwiki_p.page.page_id = tl1.tl_from
      AND arwiki_p.page.page_namespace = tl1.tl_from_namespace
      AND tl_namespace = 10
      AND tl_title LIKE 'توضيح')
	GROUP BY arwiki_p.page.page_title, arwikiquote_p.page.page_title
    limit 100;
SQL

Checking query status...
