Untitled query #64023

SQL

SELECT DISTINCT pl_title#, COUNT(*)
FROM pagelinks
LEFT JOIN page ON 
	pl_title = page_title 
	AND pl_namespace = page_namespace
WHERE
	pl_from_namespace IN (0, 120, 146)
	AND pl_namespace IN (0, 120, 146)
	AND pl_title in ("Q32524806","Q9711861","Q9714813","Q9715498","Q32524582","Q9715738","Q9719092","Q32516634","Q32516638","Q9719388","Q32516651","Q9722966","Q9723759","Q32514167","Q9724770","Q9730562","Q15195714","Q25331861","Q8864843","Q8864845","Q25331869","Q25331876","Q25331874","Q25331878","Q25331884","Q25331883","Q8864871","Q8864875","Q8864892","Q13298019","Q8864935","Q8864946")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q32524806","Q9711861","Q9714813","Q9715498","Q32524582","Q9715738","Q9719092","Q32516634","Q32516638","Q9719388","Q32516651","Q9722966","Q9723759","Q32514167","Q9724770","Q9730562","Q15195714","Q25331861","Q8864843","Q8864845","Q25331869","Q25331876","Q25331874","Q25331878","Q25331884","Q25331883","Q8864871","Q8864875","Q8864892","Q13298019","Q8864935","Q8864946")
    )
#GROUP BY pl_title
#ORDER BY COUNT(*) DESC, pl_namespace, pl_title;
SQL

Checking query status...
