صور تستخدم في تصنيف صفحات_تحوي_وصلات_ملفات_معطوبة

SQL

SELECT
   /* REPLACE(GROUP_CONCAT(REPLACE(il.il_to, "_", " ")), ",", "#,#") AS linked_images,*/
    CASE WHEN p.page_namespace = 2 THEN CONCAT('مستخدم:', REPLACE(p.page_title, "_", " ")) ELSE REPLACE(p.page_title, "_", " ") END AS page_title,
    p.page_namespace
FROM
    page AS p
INNER JOIN categorylinks AS category ON p.page_id = category.cl_from
LEFT JOIN imagelinks AS il ON p.page_id = il.il_from
WHERE
    p.page_is_redirect = 0
    AND il.il_from_namespace = 0
    AND il.il_to NOT LIKE "//%"
    AND il.il_to NOT LIKE "%ogg"
    AND il.il_to LIKE "%.%"
    AND category.cl_to = "صفحات_تحوي_وصلات_ملفات_معطوبة"
    AND (p.page_namespace = 0 OR  p.page_namespace = 2)
GROUP BY p.page_title

SQL

Checking query status...