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 ("Q27828513","Q27828535","Q27828390","Q27828619","Q27828400","Q27828441","Q27828632","Q27828607","Q27828583","Q27828523","Q27828515","Q27828538","Q27828391","Q27828622","Q27828401","Q27828442","Q27828510","Q27828633","Q27828609","Q27828584","Q27828525","Q27828517","Q27828475","Q27828392","Q27828624","Q27828403","Q27828445","Q27828512","Q27828635","Q27828611","Q27828586","Q27828521")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q27828513","Q27828535","Q27828390","Q27828619","Q27828400","Q27828441","Q27828632","Q27828607","Q27828583","Q27828523","Q27828515","Q27828538","Q27828391","Q27828622","Q27828401","Q27828442","Q27828510","Q27828633","Q27828609","Q27828584","Q27828525","Q27828517","Q27828475","Q27828392","Q27828624","Q27828403","Q27828445","Q27828512","Q27828635","Q27828611","Q27828586","Q27828521")
    )
#GROUP BY pl_title
#ORDER BY COUNT(*) DESC, pl_namespace, pl_title;
SQL

Checking query status...
