উইকিপিডিয়া:তথ্যশালা প্রতিবেদন/ভুল লিংক সহ নিবন্ধ/বহিরাকৃতি

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