linkuri roșii în articolele X

SQL

USE rowiki_p;
SELECT /*distinct*/ pl_title, COUNT(pl_title)
FROM pagelinks
JOIN categorylinks
	ON pl_from = cl_from
WHERE pl_from_namespace = 0 and pl_namespace = 0
#	AND cl_type = "page"
    AND cl_to = "Centura_de_asteroizi"#"Obiecte_astronomice_descoperite_în_1988"#"Obiecte_astronomice_descoperite_în_1988"
#  test  and pl_from = 1386302;#pl_title = "5430_Luu";
	AND NOT EXISTS (
      SELECT *
      FROM page
      WHERE pl_title = page_title
      	AND page_namespace = 0
    )
    group by pl_title
    having COUNT(pl_title) > 4
ORDER BY COUNT(pl_title) desc
#LIMIT 10;/**/
SQL

Checking query status...
