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 ("Q10007452","Q10057274","Q10062955","Q10063759","Q10064302","Q10064949","Q10065617","Q10066023","Q10066686","Q10067275","Q10068001","Q10071536","Q10072219","Q10072681","Q10073148","Q10073520","Q10073941","Q10074200","Q10074817","Q10075319","Q10075898","Q10078110","Q10078394","Q10078881","Q10079459","Q10079899","Q10080327","Q10080713","Q10081047","Q10081400","Q10081760","Q10084532","Q10085008","Q10085465","Q10086189","Q10086718","Q10087278","Q10087655","Q10090273","Q10091225","Q32729956","Q32732896","Q32732919","Q9731185","Q9746494","Q9759736","Q9776771","Q9793168","Q9809905","Q9830803","Q9885367")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q10007452","Q10057274","Q10062955","Q10063759","Q10064302","Q10064949","Q10065617","Q10066023","Q10066686","Q10067275","Q10068001","Q10071536","Q10072219","Q10072681","Q10073148","Q10073520","Q10073941","Q10074200","Q10074817","Q10075319","Q10075898","Q10078110","Q10078394","Q10078881","Q10079459","Q10079899","Q10080327","Q10080713","Q10081047","Q10081400","Q10081760","Q10084532","Q10085008","Q10085465","Q10086189","Q10086718","Q10087278","Q10087655","Q10090273","Q10091225","Q32729956","Q32732896","Q32732919","Q9731185","Q9746494","Q9759736","Q9776771","Q9793168","Q9809905","Q9830803","Q9885367")
    )
#GROUP BY pl_title
#ORDER BY COUNT(*) DESC, pl_namespace, pl_title;
SQL

Checking query status...
