Untitled query #3889

SQL

use fawiki_p;
SELECT
  page_title,
  pl_title/*,
  CASE
    WHEN c2.cl_to IS NULL THEN NULL
    ELSE '{{yes}}'
  END AS under_construction*/
FROM page 
JOIN pagelinks
  ON page_id = pl_from
/*LEFT JOIN categorylinks c2
  ON page_id = c2.cl_from
  AND c2.cl_to = 'صفحه‌های_گسترده_در_دست_ساخت'*/
WHERE
  page_namespace = 0
  AND pl_namespace IN (2, 3)
  /* AND NOT EXISTS (
    SELECT c1.cl_to
    FROM categorylinks c1
    WHERE
      page_id = c1.cl_from
      AND c1.cl_to = 'مقاله‌های_نامزد_حذف_سریع'
  ) */
SQL

Checking query status...
