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 ("Q17497520","Q17497540","Q17497743","Q17497756","Q27342682","Q28545726","Q28545729","Q28545874","Q29045434","Q29045435","Q29045967","Q31875366","Q31875386","Q31875417","Q31875440","Q31875465","Q31875470","Q31875486","Q31875508","Q31875541","Q31875544","Q31875585","Q31875614","Q31875650","Q31875660","Q31875693","Q31875699","Q31880832","Q31880840")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q17497520","Q17497540","Q17497743","Q17497756","Q27342682","Q28545726","Q28545729","Q28545874","Q29045434","Q29045435","Q29045967","Q31875366","Q31875386","Q31875417","Q31875440","Q31875465","Q31875470","Q31875486","Q31875508","Q31875541","Q31875544","Q31875585","Q31875614","Q31875650","Q31875660","Q31875693","Q31875699","Q31880832","Q31880840")
    )
#GROUP BY pl_title
#ORDER BY COUNT(*) DESC, pl_namespace, pl_title;
SQL

Checking query status...
