arwiki_p-arwikisource_p-10

SQL

/*
wikiversity
wikiquote
wikisource
wikibooks
wiktionary
wikinews
*/
SELECT  CONCAT('بوابة:',arwiki_p.page.page_title,'') AS arwiki
		,CONCAT('Sarwikibooks')
        ,CONCAT('بوابة:',arwikibooks_p.page.page_title,'') AS arwikibooks
      # ,CONCAT('',pasas.pp_value,'') AS item_id
FROM arwiki_p.page#, wikidatawiki_p.page wdp 
JOIN arwikibooks_p.page
ON arwiki_p.page.page_title = arwikibooks_p.page.page_title
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 wikidatawiki_p.wb_items_per_site WHERE ips_site_id = 'arwikibooks') as ddff
ON ddff.ips_item_id = arwiki_p.page.page_id


WHERE arwikibooks_p.page.page_namespace = 100 AND arwiki_p.page.page_namespace = 100
AND arwiki_p.page.page_is_redirect = 0 AND arwikibooks_p.page.page_is_redirect = 0
#AND ll_title IS NULL 
#AND props.pp_value IS NULL
#and arwiki_p.page.page_title  like "مواليد_%" 
     #or arwiki_p.page.page_title  like "وفيات_%")
AND ddff.ips_site_page IS NULL
GROUP BY arwiki_p.page.page_title, arwikibooks_p.page.page_title
#limit 10;
SQL

Checking query status...
