Wikipedia Pages without Wikidata Items

SQL

SELECT DISTINCT
  page.page_title,
  page.page_len,
  cl.cl_to
FROM page
JOIN categorylinks cl ON page.page_id = cl.cl_from
LEFT JOIN page_props pp ON page.page_id = pp.pp_page
  AND pp.pp_propname = 'wikibase_item'
WHERE page.page_namespace = 0
  AND page.page_is_redirect = 0
  AND pp.pp_value IS NULL
  AND cl.cl_to LIKE '%category' -- replace the category with your category name of your choice
ORDER BY page.page_title;

AخA
 
SELECT DISTINCT  page.page_title,  page.page_len,  cl.cl_toFROM pageJOIN categorylinks cl ON page.page_id = cl.cl_fromLEFT JOIN page_props pp ON page.page_id = pp.pp_page  AND pp.pp_propname = 'wikibase_item'WHERE page.page_namespace = 0  AND page.page_is_redirect = 0  AND pp.pp_value IS NULL  AND cl.cl_to LIKE '%category' -- replace the category with your category name of your choiceORDER BY page.page_title;

SQL

Checking query status...