Untitled query #70964

SQL

USE tawiki_p;
SELECT pages.page_title
	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
SELECT templates FROM (
	SELECT tl_from AS id, tl_title AS templates
	FROM templatelinks
	WHERE tl_from_namespace = 10
	AND tl_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...
