SQL
x
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.