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 ("Q9788849","Q9789067","Q9818785","Q9819746","Q9822014","Q9857619","Q9858101","Q9858518","Q9863206","Q9863549","Q9863577","Q9863711","Q9863917","Q9863809","Q9863967","Q9864213","Q9864334","Q9864448","Q9864687","Q9864877","Q9865027","Q9865150","Q9879015","Q9879138","Q9879198","Q9879422","Q9879610","Q9879829","Q9879865","Q9880381","Q9880491","Q9880598","Q9880646","Q9881611","Q9888780","Q9891777","Q9893092","Q9893187","Q9893315","Q9893538","Q9893927","Q9906850","Q9908722","Q9908844","Q9912785","Q9916685","Q9917291","Q9918271","Q9918806","Q9919029","Q9946736","Q9948118","Q9952246","Q9952405","Q9946583","Q9953101","Q9953371","Q9953655","Q9954008","Q9954986","Q9956155","Q9957139","Q9962736","Q9962971","Q9963128","Q9963719","Q9964203","Q9973037")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q9788849","Q9789067","Q9818785","Q9819746","Q9822014","Q9857619","Q9858101","Q9858518","Q9863206","Q9863549","Q9863577","Q9863711","Q9863917","Q9863809","Q9863967","Q9864213","Q9864334","Q9864448","Q9864687","Q9864877","Q9865027","Q9865150","Q9879015","Q9879138","Q9879198","Q9879422","Q9879610","Q9879829","Q9879865","Q9880381","Q9880491","Q9880598","Q9880646","Q9881611","Q9888780","Q9891777","Q9893092","Q9893187","Q9893315","Q9893538","Q9893927","Q9906850","Q9908722","Q9908844","Q9912785","Q9916685","Q9917291","Q9918271","Q9918806","Q9919029","Q9946736","Q9948118","Q9952246","Q9952405","Q9946583","Q9953101","Q9953371","Q9953655","Q9954008","Q9954986","Q9956155","Q9957139","Q9962736","Q9962971","Q9963128","Q9963719","Q9964203","Q9973037")
    )
#GROUP BY pl_title
#ORDER BY COUNT(*) DESC, pl_namespace, pl_title;
SQL

Checking query status...
