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 ("Q100396993","Q107137802","Q108539080","Q108539360","Q108539470","Q110889594","Q30533774","Q30533950","Q30534143","Q30565355","Q30565369","Q30565577","Q31194426","Q31195368","Q31201349","Q33059143","Q33059214","Q33059220","Q35487597","Q35491165","Q35491336","Q35491519","Q35491532","Q35491853","Q35496905","Q39777520","Q40573785","Q40573821","Q40574300","Q41631664","Q41631853","Q42422943","Q42423263","Q42498985","Q44106263","Q46233762","Q46233802","Q46233894","Q47475622","Q47514539","Q49208581","Q49208633","Q49225753","Q50078090","Q50739054","Q50739195","Q52232464","Q52233039","Q52233656","Q52233732","Q52234159","Q52522351","Q52524275","Q53771701","Q53772306","Q53772308","Q53772314","Q53772319","Q53772461","Q53772620","Q53772807","Q53772809","Q54347209","Q58807452","Q77971819")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q100396993","Q107137802","Q108539080","Q108539360","Q108539470","Q110889594","Q30533774","Q30533950","Q30534143","Q30565355","Q30565369","Q30565577","Q31194426","Q31195368","Q31201349","Q33059143","Q33059214","Q33059220","Q35487597","Q35491165","Q35491336","Q35491519","Q35491532","Q35491853","Q35496905","Q39777520","Q40573785","Q40573821","Q40574300","Q41631664","Q41631853","Q42422943","Q42423263","Q42498985","Q44106263","Q46233762","Q46233802","Q46233894","Q47475622","Q47514539","Q49208581","Q49208633","Q49225753","Q50078090","Q50739054","Q50739195","Q52232464","Q52233039","Q52233656","Q52233732","Q52234159","Q52522351","Q52524275","Q53771701","Q53772306","Q53772308","Q53772314","Q53772319","Q53772461","Q53772620","Q53772807","Q53772809","Q54347209","Q58807452","Q77971819")
    )
#GROUP BY pl_title
#ORDER BY COUNT(*) DESC, pl_namespace, pl_title;
SQL

Checking query status...
