USE trwiki_p;

SELECT page_title, 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_title NOT LIKE '('

AND pl_title NOT LIKE ')'

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;