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 ("Q26207655","Q26208152","Q26209084","Q26269338","Q26272247","Q26722204","Q26944043","Q27039161","Q27052308","Q27188723","Q27517349","Q27791027","Q27794735","Q27795077","Q27813802","Q27959056","Q27971337","Q27993463","Q28019194","Q28021237","Q28021779")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q26207655","Q26208152","Q26209084","Q26269338","Q26272247","Q26722204","Q26944043","Q27039161","Q27052308","Q27188723","Q27517349","Q27791027","Q27794735","Q27795077","Q27813802","Q27959056","Q27971337","Q27993463","Q28019194","Q28021237","Q28021779")
    )
#GROUP BY pl_title
#ORDER BY COUNT(*) DESC, pl_namespace, pl_title;
SQL

Checking query status...
