USE etwiki_p;

SELECT CONCAT("# [[",page_title,"]]") AS page_title, CONCAT("[[",pl_title,"]]") AS pl_title

FROM pagelinks, page

WHERE pl_title NOT LIKE '%(%)%'

AND pl_title NOT LIKE '%:)%'

AND pl_title NOT LIKE '%:-)%'

AND pl_title NOT LIKE '%)))%'

AND pl_title NOT LIKE '%Pre)Thing%'

AND pl_from = page_id

AND pl_from_namespace = 0

AND pl_namespace = 0

AND (pl_title LIKE '%)%)%' OR pl_title LIKE '%(%(%' OR pl_title LIKE '%(%' OR pl_title LIKE '%)%')

#GROUP BY pl_title

ORDER BY page_title ASC, pl_title ASC;