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('Sarwikisource'),
CONCAT('قالب:',arwikisource_p.page.page_title,'') AS arwikisource
# CONCAT('',poo.ips_site_page,'') AS item_id
FROM arwiki_p.page#, wikidatawiki_p.page wdp
JOIN arwikisource_p.page
ON arwiki_p.page.page_title = arwikisource_p.page.page_title
LEFT JOIN arwikisource_p.langlinks
ON ll_from = arwikisource_p.page.page_id
LEFT JOIN (SELECT * FROM wikidatawiki_p.wb_items_per_site #WHERE ips_site_id = "arwikisource"
) AS poo
ON arwiki_p.page.page_id = poo.ips_item_id AND poo.ips_site_id = 'arwikisource'
#LEFT JOIN (SELECT * FROM arwikisource_p.page_props WHERE pp_propname = 'wikibase_item') AS props
#ON props.pp_page = arwikisource_p.page.page_id
LEFT JOIN arwikisource_p.templatelinks
ON tl_from = arwikisource_p.page.page_id
WHERE arwikisource_p.page.page_namespace = 828 AND arwiki_p.page.page_namespace = 828
AND arwiki_p.page.page_is_redirect = 0 AND arwikisource_p.page.page_is_redirect = 0
AND ll_title IS NULL
#AND props.pp_value IS NULL
#AND poo.ips_site_page IS NULL
/*
AND NOT EXISTS(
SELECT * FROM wb_items_per_site AS wbD
WHERE wbD.ips_item_id = arwiki_p.page.page_id
AND wbD.ips_site_id = 'arwikisource'
)
and not exists
(select * from arwikisource_p.wb_items_per_site
where ips_site_id = 'arwiki' and ips_item_id = arwikisource_p.page.page_id)
*/
GROUP BY arwiki_p.page.page_title, arwikisource_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.