Untitled query #13501

SQL

use arwiki_p;
select p.page_title, CONCAT("Dar"), CONCAT("Q",ips_item_id),
#select CONCAT('[[',p.page_title,']]')
#select CONCAT('[[تصنيف:',p.page_title,']]')
FROM page as p
WHERE p.page_namespace = 0
and p.page_is_redirect = 0 
and not exists (use wikidatawiki_p; 
from wb_items_per_site i
join wb_terms on ips_item_id = term_entity_id and term_type = "description"
where i.ips_site_id='arwiki' and i.ips_item_id not in
(select term_entity_id from wb_terms where ips_item_id = term_entity_id and 
 term_type = "description" and term_language='ar'
and term_entity_id=i.ips_item_id))
and p.page_id not in (select cl_from
		from categorylinks 
		where cl_type="page" and cl_to="لاعبو_كرة_قدم_سعوديون")
        GROUP BY p.page_title

limit 10
;
SQL

Checking query status...
