Untitled query #12445

SQL

use lvwiki_p;
SELECT tl_title, COUNT(*)
FROM templatelinks
join page pp on tl_title=pp.page_title and pp.page_is_redirect=0 and pp.page_namespace=10
WHERE tl_namespace = 10
	and tl_title rlike "nfo"
	and tl_from in (SELECT p.page_id
FROM page as p
JOIN page_props as pp ON pp.pp_page = p.page_id AND pp.pp_propname = 'wikibase_item'
JOIN wikidatawiki_p.page as wdp ON wdp.page_title = pp.pp_value AND wdp.page_namespace = 0
LEFT JOIN wikidatawiki_p.pagelinks wdpl ON wdpl.pl_from = wdp.page_id AND (wdpl.pl_title = 'P31' or wdpl.pl_title = 'P279')
			AND wdpl.pl_namespace = 120
WHERE p.page_namespace = 0 AND wdpl.pl_from IS NULL) and tl_from_namespace=0
    # and tl_from_namespace=0# tl_from_namespace=0
GROUP BY tl_title
ORDER BY COUNT(*) DESC;
SQL

Checking query status...
