Replicas browser and optimizer
Pages that don't have arabic label at Wikidata
This query is marked as a draft
This query has been published
USE wikidatawiki_p; SELECT CONCAT("[[d:Q",ips_item_id, "|Q", ips_item_id, "]]"), CONCAT("[[",ips_site_page,"]]") FROM wb_items_per_site i WHERE i.ips_site_id='urwiki' AND NOT EXISTS (SELECT term_entity_id FROM wb_terms WHERE i.ips_item_id = term_entity_id AND term_type = "label" AND term_language='ur' LIMIT 1) GROUP BY ips_item_id LIMIT 500;
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