دوویرگول ایالات_متحده_آمریکا

SQL

USE fawiki_p;

WITH RECURSIVE subcategories AS (
  SELECT page_id, page_title
  FROM page
  WHERE page_namespace = 14
  AND page_title = 'رده:ایالات_متحده_آمریکا'
  
  UNION ALL
  
  SELECT p.page_id, p.page_title
  FROM page p
  INNER JOIN categorylinks cl ON p.page_title = cl.cl_to
  INNER JOIN subcategories sc ON cl.cl_from = sc.page_id
  WHERE p.page_namespace = 14
)

SELECT p.page_title
FROM page p
LEFT JOIN redirect r ON r.rd_from = p.page_id
INNER JOIN categorylinks cl ON p.page_id = cl.cl_from
INNER JOIN subcategories sc ON cl.cl_to = sc.page_title
WHERE p.page_namespace = 0
AND r.rd_from IS NULL
AND p.page_title LIKE '%،%،%' 
AND p.page_title NOT LIKE '%،%(%'
AND p.page_title NOT LIKE '%(%،%';

SQL

Checking query status...