Untitled query #4740

SQL

USE cswiki_p;
DESCRIBE categorylinks;
SELECT page_title, anons, lius, GROUP_CONCAT(DISTINCT ib.tl_title) AS ibox, GROUP_CONCAT(DISTINCT nb.tl_title) AS ibox
	FROM (SELECT * FROM categorylinks WHERE cl_to = "Italští_malíři") AS category
	JOIN page
		ON cl_from = page_id
	LEFT JOIN (SELECT rev_page, COUNT(DISTINCT rev_user_text) AS anons FROM revision WHERE rev_user = 0 GROUP BY rev_page) AS anon
		ON anon.rev_page = page_id
	LEFT JOIN (SELECT rev_page, COUNT(DISTINCT rev_user_text) AS lius FROM revision WHERE rev_user > 0 GROUP BY rev_page) AS liu
		ON liu.rev_page = page_id
	LEFT JOIN templatelinks AS ib
		ON ib.tl_from = page_id AND ib.tl_namespace = 10 AND ib.tl_title RLIKE "^Infobox\b[^/]+$"
	LEFT 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
        )
	LEFT JOIN pagelinks AS portal
		ON pl_from = page_id AND pl_namespace = 100
GROUP BY page_id
LIMIT 10;
SQL

Checking query status...
