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 ("Q10053724","Q10744763","Q10750040","Q30968431","Q30994369","Q30996043","Q31003194","Q31024963","Q31045499","Q31045659","Q31070984","Q31070992","Q31081475","Q32382883","Q61007464","Q61016818","Q61017759","Q61034487","Q65652092","Q65653883","Q65654038","Q9571575","Q9629661","Q9658140","Q97442155","Q97444644")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q10053724","Q10744763","Q10750040","Q30968431","Q30994369","Q30996043","Q31003194","Q31024963","Q31045499","Q31045659","Q31070984","Q31070992","Q31081475","Q32382883","Q61007464","Q61016818","Q61017759","Q61034487","Q65652092","Q65653883","Q65654038","Q9571575","Q9629661","Q9658140","Q97442155","Q97444644")
    )
#GROUP BY pl_title
#ORDER BY COUNT(*) DESC, pl_namespace, pl_title;
SQL

Checking query status...
