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 ("Q1001000","Q1009697","Q1025530","Q10313050","Q10317593","Q10320367","Q10330683","Q10332882","Q10337183","Q10350497","Q10358229","Q10371962","Q10373356","Q10374630","Q10378403","Q10387211","Q10411953","Q10428277","Q10472194","Q10518404","Q10570921","Q10577559","Q10577591","Q10577872","Q10579147")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q1001000","Q1009697","Q1025530","Q10313050","Q10317593","Q10320367","Q10330683","Q10332882","Q10337183","Q10350497","Q10358229","Q10371962","Q10373356","Q10374630","Q10378403","Q10387211","Q10411953","Q10428277","Q10472194","Q10518404","Q10570921","Q10577559","Q10577591","Q10577872","Q10579147")
    )
#GROUP BY pl_title
#ORDER BY COUNT(*) DESC, pl_namespace, pl_title;
SQL

Checking query status...
