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 ("Q8989549","Q8989550","Q8989561","Q8989585","Q8989599","Q8989609","Q8989663","Q8989666","Q8989677","Q8989692","Q8989696","Q8989699","Q8989715","Q8989722","Q8989742","Q8989747","Q8989764","Q8989766","Q8989784","Q8989844","Q8989867","Q8989870","Q8989930","Q8989936","Q8989943")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q8989549","Q8989550","Q8989561","Q8989585","Q8989599","Q8989609","Q8989663","Q8989666","Q8989677","Q8989692","Q8989696","Q8989699","Q8989715","Q8989722","Q8989742","Q8989747","Q8989764","Q8989766","Q8989784","Q8989844","Q8989867","Q8989870","Q8989930","Q8989936","Q8989943")
    )
#GROUP BY pl_title
#ORDER BY COUNT(*) DESC, pl_namespace, pl_title;
SQL

Checking query status...
