Untitled query #19278

SQL

select now();

use  wikidatawiki_p;
SELECT REPLACE(tl_title, "_", " ") As tmpl, COUNT(*) As cnt, "" as QID
FROM enwiki_p.templatelinks, enwiki_p.page_props As wpage_props
WHERE  tl_title like "تصنيف:%" and tl_from = wpage_props.pp_page AND wpage_props.pp_propname = "wikibase_item" 
		AND wpage_props.pp_page = tl_from
        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 = 'arwiki' AND pp_page = epp_page_id 
                                     		AND pp_propname = "wb-claims" AND epp_entity_id = ips_item_id 
                                     AND epp_entity_type = "item" AND page_id = pp_page
										and pp_sortkey=0)
GROUP BY tl_title ORDER BY COUNT(tl_title) DESC
SQL

Checking query status...
