Wrong links in articles on zhwiki

Fork of Wrong links in articles on zhwiki by Leahhh233

This query is marked as a draft This query has been published by Rahuljb.

SQL

USE enwiki_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;

SQL

Checking query status...