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.

Checking query status...