Wikipediapages without WikiData Items, ordered by Pageviews

SQL

SELECT DISTINCT
  p.page_title,
  p.page_len,
  cl.cl_to,
  COALESCE(SUM(acc.hit_count), 0) as page_views
FROM page p
JOIN categorylinks cl ON p.page_id = cl.cl_from
LEFT JOIN page_props pp ON p.page_id = pp.pp_page
  AND pp.pp_propname = 'wikibase_item'
LEFT JOIN logging_userindex acc ON p.page_title = acc.page_title 
  AND acc.page_namespace = 0
WHERE p.page_namespace = 0
  AND p.page_is_redirect = 0
  AND pp.pp_value IS NULL
  AND cl.cl_to LIKE '%category'
GROUP BY p.page_title, p.page_len, cl.cl_to
ORDER BY page_views DESC, p.page_title;

SQL

Checking query status...