Untitled query #4740

SQL

USE cswiki_p;
DESCRIBE templatelinks;
SELECT page_title, anon, liu FROM categorylinks
	JOIN page
		ON cl_from = page_id
	JOIN (SELECT rev_page, COUNT(*) AS anon FROM revision WHERE rev_user > 0) AS anon
		ON anon = page_id
	JOIN (SELECT rev_page, COUNT(*) AS liu FROM revision WHERE rev_user > 0) AS liu
		ON liu = page_id
	JOIN templatelinks AS ib
		ON ib.tl_from = page_id AND ib.tl_namespace = 10 AND ib.tl_title LIKE "Infobox%"
	JOIN templatelinks AS nb
		ON nb.tl_from = page_id AND nb.tl_namespace = 10 AND nb.tl_title IN (
			SELECT page_title FROM templatelinks
				JOIN page ON page_id = tl_from
          		WHERE tl_title = "Navbox" AND tl_namespace = 10 AND tl_from_namespace = 10
        )
	JOIN pagelinks AS portal
		ON pl_from = page_id AND pl_namespace = 100
WHERE cl_to = "Ialští malíři"
GROUP BY page_id
LIMIT 10;
SQL

Checking query status...
