Query test 5 - Quarry

SQL

SELECT
	COUNT(*) AS `count`,
    lt_namespace AS ns,
    lt_title AS title,
    GROUP_CONCAT(DISTINCT pr_type) AS type,
    GROUP_CONCAT(DISTINCT pr_level) AS `level`,
    GROUP_CONCAT(DISTINCT pr_expiry) AS expiry
FROM templatelinks, linktarget, page LEFT JOIN page_restrictions ON page_id=pr_page
WHERE page_namespace=lt_namespace AND page_title=lt_title AND lt_id=tl_target_id
AND lt_namespace = 10
AND pr_level NOT IN ('sysop')
AND pr_expiry NOT IN ('infinity')
GROUP BY lt_namespace, lt_title
ORDER BY `count` DESC
LIMIT 10;
SQL

Checking query status...
