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('',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.