Untitled query #78313

SQL

SELECT 
  CONCAT("* [[",article.page_title, "]]") -- , talk.page_id AS talk_page_id
FROM
  page AS article
  LEFT JOIN page AS talk ON talk.page_title = article.page_title AND talk.page_namespace = 1  AND talk.page_is_redirect = 0
WHERE
 -- article.page_id % 10 = 2
  article.page_namespace = 0
  AND article.page_is_redirect = 0
  AND NOT article.page_title RLIKE "^(قائمة|[0-9]{4})_.*$" -- no dated events or lists
  AND article.page_title LIKE "%كتاب%" -- no dated events or lists
  AND EXISTS (SELECT 1 FROM categorylinks WHERE cl_from = article.page_id and 
              (cl_to = "بوابة_أعلام/مقالات_متعلقة"
)) 
  AND (
    (talk.page_id IS NULL) 
    OR ((talk.page_id IS NOT NULL) AND NOT EXISTS (SELECT 1 FROM categorylinks WHERE cl_from = talk.page_id 
                 and (cl_to LIKE "%مقالات_أعلام" 
                      OR cl_to LIKE "%مشروع_ويكي_أعلام%"))))

ORDER BY article.page_title
SQL

Checking query status...
