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 ("Q24688337","Q24690823","Q24697049","Q24697047","Q24697046","Q24697043","Q24697041","Q24697040","Q24691717","Q24691407","Q24691179","Q24691060","Q24690942","Q24690902","Q24688265","Q24688190","Q24688159","Q24688132","Q24688105","Q24687425","Q24687402","Q24687443","Q24687452","Q24687456","Q24687465","Q24688062","Q24688080")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q24688337","Q24690823","Q24697049","Q24697047","Q24697046","Q24697043","Q24697041","Q24697040","Q24691717","Q24691407","Q24691179","Q24691060","Q24690942","Q24690902","Q24688265","Q24688190","Q24688159","Q24688132","Q24688105","Q24687425","Q24687402","Q24687443","Q24687452","Q24687456","Q24687465","Q24688062","Q24688080")
    )
#GROUP BY pl_title
#ORDER BY COUNT(*) DESC, pl_namespace, pl_title;
SQL

Checking query status...
