2017 - Quarry

SQL

SELECT CONCAT('',arwiki_p.page.page_title,'') AS arwiki
		, CONCAT ('Sarwiki')
		, CONCAT('',arwiki_p.page.page_title,'') AS frwiki
FROM frwiki_p.page
JOIN arwiki_p.page
	ON frwiki_p.page.page_title = arwiki_p.page.page_title
		LEFT JOIN arwiki_p.langlinks
	ON ll_from = arwiki_p.page.page_id
		LEFT JOIN (SELECT * FROM arwiki_p.page_props WHERE pp_propname = 'wikibase_item') AS props
	ON pp_page = arwiki_p.page.page_id
		LEFT JOIN arwiki_p.templatelinks
	ON tl_from = arwiki_p.page.page_id
    
	WHERE arwiki_p.page.page_namespace = 0 AND frwiki_p.page.page_namespace = 0
AND arwiki_p.page.page_is_redirect = 0 AND frwiki_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 arwiki_p.page.page_namespace = tl1.tl_from_namespace
#	AND tl_namespace = 10
	AND cl_to = "صفحات_دون_عنصر_ويكي_بيانات/كائن")
    
/*AND NOT EXISTS (SELECT * FROM frwiki_p.templatelinks AS tl1 WHERE frwiki_p.page.page_id = tl1.tl_from
    AND frwiki_p.page.page_namespace = tl1.tl_from_namespace AND tl_namespace = 10 AND tl_title LIKE 'توضيح')*/
GROUP BY frwiki_p.page.page_title, arwiki_p.page.page_title;
SQL

Checking query status...
