وصلات حمراء تحتوي على علامات تشكيل

Fork of وصلات حمراء تحتوي على علامات تشكيل by Gerges

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

SQL

SELECT page_title, GROUP_CONCAT(REPLACE(pl_title, '_', ' ') SEPARATOR ',') AS red_links
FROM pagelinks, page
WHERE pl_from = page_id
AND pl_from_namespace = 0
AND pl_namespace = 0
AND pl_title REGEXP 'ُ|ً|َ|ٍ|ِ|ّ'
AND pl_title NOT IN (
    SELECT red_page.page_title
    FROM page AS red_page
WHERE page_namespace = 0)
AND pl_namespace = 0
AND REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(pl_title, '_', ' '), 'ً', ''), 'َ', ''), 'ٍ', ''), 'ِ', ''), 'ّ', '') IN (
    SELECT blue_page.page_title
    FROM page AS blue_page
WHERE blue_page.page_namespace = 0
)
GROUP BY pl_title
ORDER BY pl_title ASC, page_title ASC;

SQL

Checking query status...