arwiki_p-arwikisource_p-10

SQL

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 arwiki_p.page.page_id not in (
	SELECT * FROM wikidatawiki_p.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 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;
SQL

Checking query status...
