Benzer kategorilerdeki öksüz maddeler

SQL

USE trwiki_p;
SELECT CONCAT('# [[',page_title,']]') sayfa_adi, cl_to kategori_adi
FROM categorylinks 
JOIN page ON page_id = cl_from 
WHERE cl_to LIKE '%_kadın_oyuncular'
AND page_is_redirect = 0
AND page_namespace = 0
# anlam ayrım sayfası olmasın
AND page_id NOT IN (
  SELECT pp_page
  FROM page_props
  WHERE pp_propname = 'disambiguation'
)

# direk bağlantı almasın 
AND NOT (
  page_title IN (
    SELECT pl_title
    FROM pagelinks
    WHERE pl_namespace = 0
    AND pl_from_namespace = 0
    AND pl_from NOT IN (
    SELECT rd_from
    FROM redirect
    WHERE rd_namespace = 0
    AND rd_title = page_title
  )
 )
# yönlendirme bağlantısı almasın 
	OR (
  	 page_title IN (
     	SELECT rd_title
     	FROM redirect JOIN page AS p2 ON p2.page_id = rd_from JOIN pagelinks AS pl2 ON p2.page_title = pl2.pl_title
     	WHERE rd_namespace = 0
     	AND p2.page_is_redirect = 1
     	AND p2.page_namespace = 0
     	AND pl2.pl_namespace = 0
     	AND pl2.pl_from_namespace = 0
    	)
  	)   
)

ORDER BY cl_to AND THEN page_title;
SQL

Checking query status...
