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.