Untitled query #19154

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 "Infobox%" 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 = 'enwiki' 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;

SELECT REPLACE(tl_title, "_", " ") As tmpl, COUNT(*) As cnt, "" as QID
FROM dewiki_p.templatelinks, dewiki_p.page_props As wpage_props
WHERE  tl_title like "Infobox%" 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 = 'dewiki' 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;

SELECT REPLACE(tl_title, "_", " ") As tmpl, COUNT(*) As cnt, "" as QID
FROM frwiki_p.templatelinks, frwiki_p.page_props As wpage_props
WHERE  tl_title like "Infobox%" 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 = 'frwiki' 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;

SELECT REPLACE(tl_title, "_", " ") As tmpl, COUNT(*) As cnt, "" as QID
FROM eswiki_p.templatelinks, eswiki_p.page_props As wpage_props
WHERE  tl_title like "Ficha%" 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 = 'eswiki' 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...
