Untitled query #87402

SQL

SELECT page_title FROM (
  SELECT lt_title, 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_macrons
JOIN pagelinks pl ON lt_macrons.lt_id = pl.pl_target_id
JOIN page pg ON pl.pl_from = page_id AND pg.page_namespace in (0, 10, 14, 100); /* main, template, category, portal */
SQL

Checking query status...
