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 ("Q10057686","Q10057944","Q10069703","Q10071753","Q10077021","Q10084159","Q10120801","Q10130763","Q10177304","Q10177881","Q10197314","Q10199204","Q10199210","Q10245789","Q15961517","Q16915771","Q17304187","Q18525665","Q18721608","Q18723116","Q18723163","Q18723523","Q18723524","Q18723525","Q18724300","Q18724376","Q18724438","Q18724878","Q18726223","Q18726235","Q18727112","Q18728022","Q18737520","Q18738715","Q18738773","Q18738863","Q18739225","Q18739626","Q18740763","Q18741608","Q18743321","Q18743514","Q18743690","Q21158930","Q21292452","Q21703113","Q24857264","Q24867909","Q24869078","Q24870459","Q24871381","Q24871612","Q24875175","Q28694118","Q28696080","Q30631696","Q30956922","Q30956941","Q30961796","Q30967988")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q10057686","Q10057944","Q10069703","Q10071753","Q10077021","Q10084159","Q10120801","Q10130763","Q10177304","Q10177881","Q10197314","Q10199204","Q10199210","Q10245789","Q15961517","Q16915771","Q17304187","Q18525665","Q18721608","Q18723116","Q18723163","Q18723523","Q18723524","Q18723525","Q18724300","Q18724376","Q18724438","Q18724878","Q18726223","Q18726235","Q18727112","Q18728022","Q18737520","Q18738715","Q18738773","Q18738863","Q18739225","Q18739626","Q18740763","Q18741608","Q18743321","Q18743514","Q18743690","Q21158930","Q21292452","Q21703113","Q24857264","Q24867909","Q24869078","Q24870459","Q24871381","Q24871612","Q24875175","Q28694118","Q28696080","Q30631696","Q30956922","Q30956941","Q30961796","Q30967988")
    )
#GROUP BY pl_title
#ORDER BY COUNT(*) DESC, pl_namespace, pl_title;
SQL

Checking query status...
