Untitled query #1276

SQL

# test
# See also https://upload.wikimedia.org/wikipedia/commons/f/f7/MediaWiki_1.24.1_database_schema.svg
# https://mariadb.com/
use wikidatawiki_p; 

SELECT 
	REPLACE(tl_title, "_", " ") As category_at_Wikipedia_1234567890_1234567890, 
    #CONCAT("Q",ips_item_id) AS QID, 
    COUNT(*) As NumberOfItemsWithoutStatement
FROM 
	ptwiki_p.templatelinks, 
	ptwiki_p.page_props As wpage_props
    # ,wb_items_per_site
WHERE cl_from = wpage_props.pp_page
AND wpage_props.pp_propname = "wikibase_item" 
AND wpage_props.pp_page = tl_from
#AND cl_type = "page"
AND wpage_props.pp_value IN (
SELECT page_title 
  FROM 
	page, 
	page_props, 
	wb_entity_per_page, 
	wb_items_per_site
  WHERE ips_site_id = "ptwiki"
AND pp_page = epp_page_id
AND pp_propname = "wb-claims" 
AND pp_sortkey = 0  #same as pp_value
AND epp_entity_id = ips_item_id
AND epp_entity_type = "item"
AND page_id = pp_page)
#AND CONCAT("Category:", REPLACE(cl_to, "_", " ")) = ips_site_page
#AND ips_site_id = "enwiki"
GROUP BY tl_title 
HAVING COUNT(tl_title)>99
ORDER BY COUNT(tl_title) DESC
SQL

Checking query status...
