SQL
x
SELECT CONCAT('قالب:',arwiki_p.page.page_title,'') AS arwiki,
CONCAT('Sarwikisource'),
CONCAT('قالب:',arwikisource_p.page.page_title,'') AS arwikisource,
CONCAT('',pasas.pp_value,'') 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 #and ll_lang ='ar'
LEFT JOIN (SELECT * FROM arwiki_p.page_props WHERE pp_propname = 'wikibase_item') AS pasas
ON pasas.pp_page = arwiki_p.page.page_id
#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 (SELECT * FROM wikidatawiki_p.wb_items_per_site WHERE ips_site_id = "arwikisource" ) AS poo
ON poo.ips_item_id = arwiki_p.page.page_id
*/
WHERE arwikisource_p.page.page_namespace = 10 AND arwiki_p.page.page_namespace = 10
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.
Query status: complete
Executed on Tue, 02 Aug 2016 14:59:59 UTC.