Untitled query #87402

SQL

SELECT p_filtered.page_title 
FROM (
    SELECT lt_id 
    FROM linktarget 
    WHERE lt_title IN ('ahikouka','akitio','akura','apiti','atiamuri','awhitu','awhitu central','colac bay/oraka','east takaka','east tamaki','east tamaki heights','eketahuna','hamama','hawea flat','hawera','hukerenui','kahikatea pa','kaikoura','kopuaranga','kuaotunu','kuaotunu west','kumeu','lake hawea','lake omapere','lower kawhatau','mahia','mahia beach','mahina bay','makara','makara beach','makareao','manawatu','mangarakau','mangatawhai','mangatawhiri','mangere','mangere bridge','mangere east','mangonui','mapua','marahau','mariri','mataikotare','matata','mokau','morere','motu','motumanawa / pollen island','ngahape','ngahinapouri','ngaruawahia','ngatimoti','ngongotaha','ngongotaha valley','nuhaka','oakura','oakura','ohaeawai','ohau','ohaupo','ohingaiti','ohiwa','ohope','ohura','okaihau','okarito','okato','okiwi bay','okura','omapere','omiha','omokoroa','omokoroa beach','onoke','opaheke','opaki','oparara','oparau','opotiki','opou','opunake','orere','orere point','otahuhu','otaki','otaki beach','otaki forks','otane','otara','otara','otaua','otumoetai','owhango','owhata','owhata','owhiro','owhiro','owhiro bay','paekakariki','paekakariki hill','pahaoa','pakawau','pakuratahi','pangatotara','papakowhai','parae karetu','paremoremo','pauatahanui','pohara','pokeno','porangahau','port ohope','port puponga','port whangarei','puerua','pukio','pukorokoro / miranda','pukorokoro / miranda hot springs','puponga','purakaunui','puramahoi','putaruru','rakau','rangaiika','rangitumau','ranui','ratana','ruakaka','ruakokoputuna','runanga pa','tahunanui','taita','takaka','takapuwahia','takou bay','tamaki','taneatua','tangarakau','taupo','taupo bay','tawharanui','te akau','te akau south','te atatu peninsula','te atatu south','te hapua','te kopuru','te marua','te pohue','te rapaki-o-te rakiwhakaputa','tinui','tirau','tiraumea','titahi bay','tongaporutu','torere','totara park','totara vale','totaranui','tui glen','turangi','umukuri','upper atiamuri','upper kawhatau','upper takaka','waihaha','waitakere','waima','waima valley','waimarama','waipatiki beach','wairau pa','wairoa pa','waitakere','waitarere','waitotara','wanaka','whakamarama','whakatane','whakatiwai','whangaimoana','whangakea / pandora','whangamata','whangamomona','whangaparaoa','whangaparaoa','whangape','whangarei','whangarei heads','wharekopae','wharepuhunga')
) AS lt_filtered
JOIN pagelinks pl ON lt_filtered.lt_id = pl.pl_target_id
JOIN (
    SELECT page_id, page_title 
    FROM page 
    WHERE page_namespace IN (0, 10, 14, 100) /* main, template, category, portal */
) AS p_filtered ON pl.pl_from = p_filtered.page_id;
SQL

Checking query status...
