Replicas browser and optimizer
This query is marked as a draft
This query has been published
USE wikidatawiki_p; SELECT CONCAT('Q', term_entity_id, '') AS id, term_text,ips_site_page from wb_terms , pagelinks as p1, wb_items_per_site, pagelinks as p2 WHERE term_entity_type = 'item' AND term_language = 'ar' AND term_type = 'label' and term_entity_id = ips_item_id AND ips_site_id = 'arwiki' AND p1.pl_from = term_entity_id AND p1.pl_namespace = 0 AND p1.pl_title = 'Q5' AND p2.pl_from = term_entity_id AND p2.pl_namespace = 120 AND p2.pl_title = 'P21' AND ips_site_page IS NULL #ORDER BY term_entity_id GROUP BY term_entity_id limit 10;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in