Fork of Untitled query #11498 by Mr. Ibrahem
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('Sarwikimedia'), 
        CONCAT('قالب:',arwikimedia_p.page.page_title,'') AS arwikimedia
FROM arwiki_p.page#, wikidatawiki_p.page wdp 
JOIN arwikimedia_p.page
ON arwiki_p.page.page_title = arwikimedia_p.page.page_title
LEFT JOIN arwikimedia_p.langlinks
ON ll_from = arwikimedia_p.page.page_id
LEFT JOIN (SELECT * FROM arwikimedia_p.page_props WHERE pp_propname = 'wikibase_item') AS props
ON props.pp_page = arwikimedia_p.page.page_id
LEFT JOIN arwikimedia_p.templatelinks
ON tl_from = arwikimedia_p.page.page_id
#WHERE arwikimedia_p.page.page_namespace = 828 AND arwiki_p.page.page_namespace = 828
WHERE arwikimedia_p.page.page_namespace = 10 AND arwiki_p.page.page_namespace = 10
AND arwiki_p.page.page_is_redirect = 0 AND arwikimedia_p.page.page_is_redirect = 0
and arwiki_p.page.page_title  not like "%/شرح" and arwikimedia_p.page.page_title  not like "%/شرح"
AND ll_title IS NULL 
AND props.pp_value IS NULL
GROUP BY arwiki_p.page.page_title, arwikimedia_p.page.page_title;
#limit 10;
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...