Untitled query #70964

SQL

USE tawiki_p;
SELECT pages.page_title, pages.page_namespace
	FROM templatelinks
    JOIN (SELECT * FROM page WHERE page_is_redirect = 0) AS templates
    	ON templates.page_title = page_title AND templates.page_namespace = page_namespace
	JOIN page AS pages
		ON pages.page_id = tl_from
WHERE pages.page_namespace = 0
ORDER BY pages.page_title;
SELECT templates FROM (
	SELECT tl_from AS id, page_title AS templates
	FROM templatelinks
	WHERE tl_from_namespace = 10
	AND page_title LIKE "Infobox&_%" ESCAPE "&"
  	LEFT JOIN imagelinks
    ON il_from = page_id
	WHERE il_from IS NULL
)
JOIN page ON page_id = id
GROUP BY templates
SQL

Checking query status...
