dewiki no claims by infobox

SQL

select now();
/*
wb_terms
term_full_entity_id = pilnais id
term_entity_type = 'item'

wb_items_per_site
ips_item_id - numerical id
*/

use  wikidatawiki_p;
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 wb_terms.term_full_entity_id
FROM page_props
join page on page.page_namespace=0 and pp_sortkey=0 and page.page_id=page_props.pp_page
join wb_terms on page.page_title=wb_terms.term_full_entity_id
        
        )
GROUP BY tl_title ORDER BY COUNT(tl_title) DESC
SQL

Checking query status...
