Untitled query #32791

SQL

use arwiki_p;
select * from wikidatawiki_p.wb_terms limit 10;
/*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 "مقالات_جيدة" or cl_to like "مقالات_مختارة")
and page_namespace = 0
and page_is_redirect = 0
and pp_propname like "wikibase_item"
and pp_value not in (select wikidatawiki_p.wb_terms.term_full_entity_id
					from wikidatawiki_p.wb_terms 
                    where wikidatawiki_p.wb_terms.term_full_entity_id = pp_value
                    and wikidatawiki_p.wb_terms.term_language like "ar"
                    and (wikidatawiki_p.wb_terms.term_type like "description"));*/
SQL

Checking query status...
