2017 - Quarry

SQL

SELECT CONCAT('',frwiki_p.page.page_title,'') AS arwiki
		, CONCAT ('Sarwiki')
		, CONCAT('',frwiki_p.page.page_title,'') AS frwiki
FROM arwiki_p.page
JOIN frwiki_p.page
	ON arwiki_p.page.page_title = frwiki_p.page.page_title
		LEFT JOIN frwiki_p.langlinks
	ON ll_from = frwiki_p.page.page_id
		LEFT JOIN (SELECT * FROM frwiki_p.page_props WHERE pp_propname = 'wikibase_item') AS props
	ON pp_page = frwiki_p.page.page_id
		LEFT JOIN frwiki_p.templatelinks
	ON tl_from = frwiki_p.page.page_id
    
	WHERE frwiki_p.page.page_namespace = 0 AND arwiki_p.page.page_namespace = 0
AND frwiki_p.page.page_is_redirect = 0 AND arwiki_p.page.page_is_redirect = 0

AND ll_title IS NULL
AND pp_value IS NULL

AND EXISTS
	(SELECT * FROM arwiki_p.categorylinks AS tl1
	WHERE arwiki_p.page.page_id = tl1.cl_from
#	AND frwiki_p.page.page_namespace = tl1.tl_from_namespace
#	AND tl_namespace = 10
	AND cl_to = "صفحات_دون_عنصر_ويكي_بيانات")
    
/*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, frwiki_p.page.page_title;
SQL

Checking query status...
