USE hewiki_p;

SELECT page_title

FROM page, templatelinks

WHERE page_id = tl_from

AND tl_namespace = 10 

AND page_title = "misspelling of"

/*AND page_title NOT LIKE '%_władców_%'

AND page_title NOT LIKE '%_team_%'

AND page_title NOT LIKE 'User%'*/

AND page_is_redirect = 0

AND page_namespace = 10 

AND EXISTS

(SELECT *

FROM templatelinks t1

WHERE page_title = t1.tl_title

AND t1.tl_namespace = 10)

/*AND EXISTS

(SELECT *

FROM templatelinks AS t2

WHERE page_id = tl_from

AND page_namespace = tl_from_namespace

AND tl_namespace = 10

AND tl_title LIKE 'Navbox')*/

GROUP BY page_title

ORDER BY page_title ASC;