Untitled query #7319

SELECT REPLACE(tl_title, "_", " ") As tmpl, COUNT(*) As cnt, "" as QID
FROM lvwiki_p.templatelinks, lvwiki_p.page_props As wpage_props
WHERE 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 = "' + sit + '" AND pp_page = epp_page_id AND pp_propname = "wb-claims"
                                 	AND pp_sortkey = '+str(numberofclaims)+' AND epp_entity_id = ips_item_id
                                 	AND epp_entity_type = "item" AND page_id = pp_page)
GROUP BY tl_title
HAVING COUNT(tl_title)>10
ORDER BY COUNT(tl_title) DESC

SQL

use lvwiki_p;
SELECT REPLACE(tl_title, "_", " ") As tmpl, COUNT(*) As cnt
#FROM page AS wp
from templatelinks tl# ON tl.tl_from = wp.page_id and tl_namespace=10
#select tl.tl_from from templatelinks tl
#						where tl.tl_title="Ezera_infokaste" and tl_namespace=10 and tl.tl_from_namespace=0
#JOIN templatelinks tl ON tl.tl_from = wp.page_id and tl_namespace=10
LEFT JOIN page_props AS pp
  ON pp.pp_page = tl.tl_from AND pp.pp_propname = 'wikibase_item'
WHERE wp.page_namespace = 0 and tl_namespace=10 and tl.tl_from_namespace=0
AND   pp_value IS NULL
GROUP BY tl_title
#HAVING COUNT(tl_title)>10
ORDER BY COUNT(tl_title) DESC

SQL

Checking query status...