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 ("Q105429183","Q13240225","Q13240280","Q13240364","Q13240422","Q13240483","Q13240676","Q13241188","Q13242203","Q15126395","Q15126856","Q24925228","Q24974357","Q25011114","Q30725961","Q55986729","Q65703246","Q8178426","Q8179347","Q8180342","Q8184683","Q8187268","Q8190123","Q8191680","Q8193277","Q8194929","Q8196623","Q8198370","Q8200691","Q8203495","Q86772459")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q105429183","Q13240225","Q13240280","Q13240364","Q13240422","Q13240483","Q13240676","Q13241188","Q13242203","Q15126395","Q15126856","Q24925228","Q24974357","Q25011114","Q30725961","Q55986729","Q65703246","Q8178426","Q8179347","Q8180342","Q8184683","Q8187268","Q8190123","Q8191680","Q8193277","Q8194929","Q8196623","Q8198370","Q8200691","Q8203495","Q86772459")
    )
#GROUP BY pl_title
#ORDER BY COUNT(*) DESC, pl_namespace, pl_title;
SQL

Checking query status...
