SQL
AخA
USE trwiki_p;
SELECT CONCAT("[[",page_title,"]]") AS page_title
FROM page
WHERE page_title NOT LIKE '%(%)%'
AND page_title NOT LIKE '%:)%'
AND page_title NOT LIKE '%:-)%'
AND page_title NOT LIKE '%)))%'
AND page_title NOT LIKE '%Pre)Thing%'
AND page_title NOT LIKE '('
AND page_title NOT LIKE ')'
AND page_namespace = 0
AND (page_title LIKE '%)%)%' OR page_title LIKE '%(%(%' OR page_title LIKE '%(%' OR page_title LIKE '%)%')
GROUP BY page_title
ORDER BY page_title ASC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.