Untitled query #32791

SQL

use arwiki_p;
/*select page_title from page
inner join categorylinks
on cl_from = page_id
inner join page_props
on pp_page = page_id
where cl_to like "مقالات_مختارة" 
and page_namespace = 0
and page_is_redirect = 0
and pp_propname like ""
select * from wikidatawiki_p.wb_terms where wikidatawiki_p.wb_terms.term_full_entity_id = "Q14332";*/
/*select page_title from page
inner join categorylinks
on cl_from = page_id
where (cl_to like "مقالات_جيدة" or cl_to like "مقالات_مختارة")
and page_namespace = 0
and page_is_redirect = 0
and page_id not in (select pp_page from page_props where pp_page = page_id and pp_propname like "wikibase-badge%");*/
select page_title from page
inner join categorylinks
on cl_from = page_id
inner join page_props
on pp_page = page_id
where (cl_to like "مقالات_جيدة")
and page_namespace = 0
and page_is_redirect = 0
and pp_propname like "wikibase_item"
and (select wikidatawiki_p.wb_terms.term_full_entity_id
					from wikidatawiki_p.wb_terms 
                    where wikidatawiki_p.wb_terms.term_language like "ar"
                    and wikidatawiki_p.wb_terms.term_type like "description"
                    and wikidatawiki_p.wb_terms.term_entity_type like "item"
     				and wikidatawiki_p.wb_terms.term_full_entity_id = pp_value 
     				limit 1) is null;
SQL

Checking query status...
