Untitled query #41400

SQL

SELECT  CONCAT('Template:',enwiki_p.page.page_title,'') AS enwiki_p, 
		CONCAT('Sarwiki'), 
        CONCAT('Template:',arwiki_p.page.page_title,'') AS arwiki_p
FROM enwiki_p.page#, wikidatawiki_p.page wdp 
JOIN arwiki_p.page
ON arwiki_p.page.page_title = enwiki_p.page.page_title
LEFT JOIN arwiki_p.langlinks
ON ll_from = enwiki_p.page.page_id

LEFT JOIN (SELECT * FROM enwiki_p.page_props WHERE pp_propname = 'wikibase_item') AS propsen
ON propsen.pp_page = enwiki_p.page.page_id       #wikidata item
#LEFT JOIN (SELECT * FROM enwiki_p.page_props WHERE pp_propname = 'wikibase_item') AS linkenar
#ON linkenar.pp_page = arwiki_p.page.page_id       #wikidata item

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

#LEFT JOIN enwiki_p.templatelinks
#ON tl_from = enwiki_p.page.page_id
#WHERE enwiki_p.page.page_namespace = 828 AND arwiki_p.page.page_namespace = 828
WHERE enwiki_p.page.page_namespace =10 AND arwiki_p.page.page_namespace = 10
AND arwiki_p.page.page_is_redirect = 0 AND enwiki_p.page.page_is_redirect = 0
#and arwiki_p.page.page_title  like "Fb_%"
and arwiki_p.page.page_title  not like "%/شرح" and enwiki_p.page.page_title  not like "%/doc"
and arwiki_p.page.page_title  not like "%/ملعب" and enwiki_p.page.page_title  not like "%/sandbox"
AND ll_title IS NULL 
#AND linkenar.pp_value IS  NULL
AND propsar.pp_value IS NULL
AND propsen.pp_value IS not NULL
GROUP BY arwiki_p.page.page_title, enwiki_p.page.page_title;
#limit 10;
SQL

Checking query status...
