Untitled query #85830

SQL

SELECT 
 page_title as category, 
 cat_pages as cat_size, 
 page_len as text_size, 
 actor_name as last_user, 
 left(rev_timestamp,12) as last_edit, 
 length(page_title) as len_name, 
 page_is_new as is_new, 
 pp_value as wikidata, 
 page_id 
FROM category
JOIN (
SELECT page_title, page_id, page_len, page_is_new, COUNT( cl2.cl_to) as ct
	FROM categorylinks as cl1, page, categorylinks as cl2
    WHERE cl1.cl_to = 'Uses_of_Wikidata_Infobox_with_no_item' 
    AND cl1.cl_type = 'subcat' 
    AND cl1.cl_from = page_id
    AND page_namespace = 14
    AND page_is_redirect = 0
    AND cl2.cl_from = page_id
    AND cl2.cl_type = "subcat"
GROUP BY page_title, page_id, page_len, page_is_new
  HAVING ct=1) AS pagetmp ON cat_title = page_title
SQL

Checking query status...
