nlwiki Main page protection

SQL

SELECT lt_namespace, lt_title, GROUP_CONCAT(DISTINCT pr_type), GROUP_CONCAT(DISTINCT pr_level), GROUP_CONCAT(DISTINCT pr_cascade), 
	GROUP_CONCAT(DISTINCT pr_user), GROUP_CONCAT(DISTINCT pr_expiry)
FROM 
	(SELECT * FROM templatelinks WHERE tl_from=(SELECT page_id FROM page WHERE page_namespace=0 AND page_title='Hoofdpagina')) AS tl
	INNER JOIN linktarget ON tl_target_id=lt_id
    INNER JOIN page t ON page_namespace=lt_namespace AND page_title=lt_title
	LEFT JOIN page_restrictions ON pr_page=t.page_id
GROUP BY lt_namespace, lt_title
SQL

Checking query status...
