trwiki:Wrong links in articles

Fork of trwiki:Wrong links in articles by Evolutionoftheuniverse

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

SQL

USE trwiki_p;
SELECT page_title AS page_title, REPLACE(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_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;

SQL

Checking query status...