enwiki_p-arwiki_p-828

SQL

SELECT  #CONCAT('CREATE\n'),CONCAT('LAST'), CONCAT('Senwiki'), 
		CONCAT('Module:',enwiki_p.page.page_title,'') AS arwiki, 
		CONCAT('Sarwiki'), 
       CONCAT('Module:',arwiki_p.page.page_title,'') AS arwikisource
 #       CONCAT('',poo.ips_site_page,'') AS item_id
FROM enwiki_p.page#, wikidatawiki_p.page wdp 
JOIN arwiki_p.page
ON enwiki_p.page.page_title = arwiki_p.page.page_title
LEFT JOIN arwiki_p.langlinks
ON ll_from = arwiki_p.page.page_id

LEFT JOIN (SELECT * FROM wikidatawiki_p.wb_items_per_site #WHERE ips_site_id = "arwikisource" 
          ) AS poo

ON enwiki_p.page.page_id = poo.ips_item_id  AND poo.ips_site_id = 'arwikisource' 

#LEFT JOIN (SELECT * FROM arwiki_p.page_props WHERE pp_propname = 'wikibase_item') AS props
#ON props.pp_page = arwiki_p.page.page_id
LEFT JOIN (SELECT * FROM enwiki_p.page_props WHERE pp_propname = 'wikibase_item') AS peeeeeee
ON peeeeeee.pp_page = enwiki_p.page.page_id

LEFT JOIN arwiki_p.templatelinks
ON tl_from = arwiki_p.page.page_id
WHERE arwiki_p.page.page_namespace = 828 AND enwiki_p.page.page_namespace = 828
AND enwiki_p.page.page_is_redirect = 0 AND arwiki_p.page.page_is_redirect = 0
#AND ll_title IS NULL 
and enwiki_p.page.page_title not like "%/sandbox"
or enwiki_p.page.page_title not like "%/doc"
#AND props.pp_value IS NULL
AND peeeeeee.pp_value IS  NULL
/*AND wpage_props.pp_value IN ( SELECT page_title
                             FROM page, page_props, wb_entity_per_page, wb_items_per_site
                             WHERE ips_site_id = 'arwiki' AND pp_page = epp_page_id 
                             AND pp_propname = "wb-claims" AND epp_entity_id = ips_item_id 
                             AND epp_entity_type = "item" AND page_id = pp_page
                             and pp_sortkey=0)*/
#AND poo.ips_site_page IS NULL

AND NOT EXISTS(
	SELECT * FROM wb_items_per_site AS wbD
	WHERE wbD.ips_item_id = enwiki_p.page.page_id
	AND wbD.ips_site_id = 'arwiki'
)
/*
and not exists
			(select * from arwiki_p.wb_items_per_site 
             where ips_site_id = 'arwiki' and ips_item_id =  arwiki_p.page.page_id)
*/
GROUP BY enwiki_p.page.page_title, arwiki_p.page.page_title;
#limit 10;ي
SQL

Checking query status...
