This query is marked as a draft This query has been published by Mr. Ibrahem.

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.

Checking query status...