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 ("Q22165715","Q22163148","Q22163300","Q22163461","Q22163549","Q22163864","Q22163932","Q22164064","Q22164347","Q22164413","Q22164473","Q22164685","Q22164812","Q22165209","Q22165219","Q22165376","Q22165382","Q22165707","Q22165918","Q22166345","Q22166405","Q22166547","Q22166574")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q22165715","Q22163148","Q22163300","Q22163461","Q22163549","Q22163864","Q22163932","Q22164064","Q22164347","Q22164413","Q22164473","Q22164685","Q22164812","Q22165209","Q22165219","Q22165376","Q22165382","Q22165707","Q22165918","Q22166345","Q22166405","Q22166547","Q22166574")
    )
#GROUP BY pl_title
#ORDER BY COUNT(*) DESC, pl_namespace, pl_title;
SQL

Checking query status...
