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 ("Q104842211","Q109286690","Q108898090","Q29538211","Q30273350","Q25570002","Q12367125","Q2047437","Q28947632","Q56409157","Q10743677","Q60879804","Q110647831","Q81637034","Q98113377","Q104840725","Q110903574")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q104842211","Q109286690","Q108898090","Q29538211","Q30273350","Q25570002","Q12367125","Q2047437","Q28947632","Q56409157","Q10743677","Q60879804","Q110647831","Q81637034","Q98113377","Q104840725","Q110903574")
    )
#GROUP BY pl_title
#ORDER BY COUNT(*) DESC, pl_namespace, pl_title;
SQL

Checking query status...
