Untitled query #92011

SQL

SELECT p.page_title
FROM page AS p
JOIN page_props AS pp ON pp.pp_page = p.page_id AND pp.pp_propname = 'wikibase_item'
JOIN wb_items_per_site AS wbs ON wbs.wb_item_id = pp.pp_value
WHERE p.page_namespace = 0  -- Main namespace
  AND p.page_is_redirect = 0  -- Exclude redirects
  AND p.page_title NOT LIKE '%/%'  -- Exclude subpages
GROUP BY p.page_title
HAVING COUNT(wbs.wb_site_id) = 1  -- Exactly one sitelink
ORDER BY p.page_title;

​x
 
SELECT p.page_titleFROM page AS pJOIN page_props AS pp ON pp.pp_page = p.page_id AND pp.pp_propname = 'wikibase_item'JOIN wb_items_per_site AS wbs ON wbs.wb_item_id = pp.pp_valueWHERE p.page_namespace = 0  -- Main namespace  AND p.page_is_redirect = 0  -- Exclude redirects  AND p.page_title NOT LIKE '%/%'  -- Exclude subpagesGROUP BY p.page_titleHAVING COUNT(wbs.wb_site_id) = 1  -- Exactly one sitelinkORDER BY p.page_title;​

SQL

Checking query status...