صفحات مع ایک سے زائد خانہ معلومات

SQL

USE urwiki_p;
SELECT pages.page_title, pages.page_namespace, GROUP_CONCAT(tl_title ORDER BY tl_title ASC SEPARATOR ", ")
	FROM templatelinks
    JOIN (SELECT * FROM page WHERE page_is_redirect = 0) AS templates
		ON templates.page_title = tl_title AND templates.page_namespace = tl_namespace
	JOIN page AS pages
		ON pages.page_id = tl_from
WHERE pages.page_namespace = 0
AND tl_title LIKE "Infobox&_%" ESCAPE "&"
AND tl_title NOT LIKE "%/%"
AND tl_title NOT LIKE "%&_položka%" ESCAPE "&"
AND tl_title NOT LIKE "%&_medaile%" ESCAPE "&"
AND tl_title NOT LIKE "%podinfobox%"
AND tl_title NOT IN ("Infobox_hlavička", "Infobox_konec", "Infobox_obrázek", "Infobox_Skladba_(chronologie)", "Infobox_začátek",
                     "Infobox_-_chronologie", "Infobox_-_kostel")
GROUP BY tl_from HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC, pages.page_title, pages.page_namespace;
SQL

Checking query status...
