Untitled query #12407

SQL

use lvwiki_p;
SELECT tl_title, COUNT(*)
FROM templatelinks
WHERE tl_namespace = 10
	and tl_from rlike "nfoka"
	and tl_from in (select page_id from pagelinks pl join page p on p.page_namespace=0 and page_title=pl_title
						where pl.pl_from=328842 and pl.pl_namespace=0) and tl_from_namespace=0
    # and tl_from_namespace=0# tl_from_namespace=0
GROUP BY tl_title
ORDER BY COUNT(*) DESC;

SELECT tl_title, COUNT(*)
FROM templatelinks
WHERE tl_namespace = 10
	and tl_from rlike "nfoka"
	and tl_from in (select page_id from pagelinks pl join page p on p.page_namespace=0 and page_title=pl_title
						where pl.pl_from=330275 and pl.pl_namespace=0) 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...
