Untitled query #64023

This query is marked as a draft This query has been published by Mahir256.
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 ("Q10001093","Q10004760","Q10005758","Q10005776","Q10006655","Q10006981","Q6193764","Q6337589","Q6337591","Q6337595","Q6337597","Q7443221","Q7447774","Q7463050","Q7477487","Q7477558","Q7477764","Q7478385","Q7478421","Q7478443","Q7676383","Q7787554","Q7824632","Q8009709","Q8011397",
"Q8115918","Q8186762","Q8214256","Q8283917","Q8284173","Q8284373","Q8284520","Q8284546","Q8284634","Q8284651","Q8307882","Q8308155","Q8331592","Q8331842","Q8332198","Q8332990","Q8333030","Q8333102","Q8333372","Q8333576","Q8333740","Q8333767","Q8333865","Q8333883","Q8335191",
"Q8344082","Q8348359","Q8348553","Q8348850","Q8348976","Q8354458","Q8354460","Q8359603","Q8378135","Q8378482","Q8378622","Q8378946","Q8398078","Q8418784","Q8419030","Q8419032","Q8419035","Q8430414","Q8433648","Q8434448","Q8434795","Q8434862","Q8435123","Q8435182","Q8435310",
"Q8435696","Q8435971","Q8436244","Q8436285","Q8436384","Q8436408","Q8439896","Q8440163","Q8440198","Q8440465","Q8440538","Q8440846","Q8441088","Q8441254","Q8441289","Q8441381","Q8441400","Q8441691","Q8441748","Q8441996","Q8442647","Q8442672","Q8442693","Q8442846","Q8450098",
"Q8450251","Q8450570","Q8450843","Q8473321","Q8476828","Q8477056","Q8477392","Q8477674","Q8477895","Q8477928","Q8478078","Q8478180","Q8478435","Q8478630","Q8478794","Q8478821","Q8478911","Q8478930","Q8479261","Q8509125","Q8509823","Q8510292","Q8510471","Q8510492","Q8510677",
"Q8510941","Q8511296","Q8511388","Q8532354","Q8533067","Q8533109","Q8543351","Q8562997","Q8564965","Q8564966","Q8566090","Q8583250","Q8583252","Q8586621","Q8588252","Q8592475","Q8593170","Q8593417","Q8593663","Q8593744","Q8593864","Q8594267","Q8594462","Q8604674","Q8604919",
"Q8605135","Q8605706","Q8605788","Q8626009","Q8626563","Q8626784","Q8626808","Q8627037","Q8627296","Q8627733","Q8629647","Q8629652","Q8629654","Q8642673","Q8642856","Q8643216","Q8643623","Q8644740","Q8644742","Q8645659","Q8647233","Q8653849","Q8656557","Q8657128","Q8657340",
"Q8657604","Q8658085","Q8658247","Q8658361","Q8659709","Q8660164","Q8660912","Q8672871","Q8677404","Q8694483","Q8732303","Q8732305","Q8732311","Q8744793","Q8760109","Q8760834","Q8763448","Q8774101","Q8785087","Q8785574","Q8785884","Q8787509","Q8793354","Q8796744","Q8796865",
"Q8796970","Q8797286","Q8805696","Q8808995","Q8810037","Q8811047","Q8811329","Q8811753","Q8812090","Q8812342","Q8812386","Q8812554","Q8812596","Q8812668","Q8812777","Q8812947","Q8813195","Q8813367","Q8813399","Q8813504","Q8813524","Q8819994","Q8820259","Q8820646","Q8821017",
"Q8821267","Q8821307","Q8821505","Q8821624","Q8821744","Q8821927","Q8822164","Q8822335","Q8822363","Q8822476","Q8829602","Q8829604","Q8829609","Q8839707","Q8840015","Q8840434","Q8841031","Q8841208","Q8847396","Q8848045","Q8848344","Q8848943","Q8849153","Q8856886","Q8856910")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q10001093","Q10004760","Q10005758","Q10005776","Q10006655","Q10006981","Q6193764","Q6337589","Q6337591","Q6337595","Q6337597","Q7443221","Q7447774","Q7463050","Q7477487","Q7477558","Q7477764","Q7478385","Q7478421","Q7478443","Q7676383","Q7787554","Q7824632","Q8009709","Q8011397",
"Q8115918","Q8186762","Q8214256","Q8283917","Q8284173","Q8284373","Q8284520","Q8284546","Q8284634","Q8284651","Q8307882","Q8308155","Q8331592","Q8331842","Q8332198","Q8332990","Q8333030","Q8333102","Q8333372","Q8333576","Q8333740","Q8333767","Q8333865","Q8333883","Q8335191",
"Q8344082","Q8348359","Q8348553","Q8348850","Q8348976","Q8354458","Q8354460","Q8359603","Q8378135","Q8378482","Q8378622","Q8378946","Q8398078","Q8418784","Q8419030","Q8419032","Q8419035","Q8430414","Q8433648","Q8434448","Q8434795","Q8434862","Q8435123","Q8435182","Q8435310",
"Q8435696","Q8435971","Q8436244","Q8436285","Q8436384","Q8436408","Q8439896","Q8440163","Q8440198","Q8440465","Q8440538","Q8440846","Q8441088","Q8441254","Q8441289","Q8441381","Q8441400","Q8441691","Q8441748","Q8441996","Q8442647","Q8442672","Q8442693","Q8442846","Q8450098",
"Q8450251","Q8450570","Q8450843","Q8473321","Q8476828","Q8477056","Q8477392","Q8477674","Q8477895","Q8477928","Q8478078","Q8478180","Q8478435","Q8478630","Q8478794","Q8478821","Q8478911","Q8478930","Q8479261","Q8509125","Q8509823","Q8510292","Q8510471","Q8510492","Q8510677",
"Q8510941","Q8511296","Q8511388","Q8532354","Q8533067","Q8533109","Q8543351","Q8562997","Q8564965","Q8564966","Q8566090","Q8583250","Q8583252","Q8586621","Q8588252","Q8592475","Q8593170","Q8593417","Q8593663","Q8593744","Q8593864","Q8594267","Q8594462","Q8604674","Q8604919",
"Q8605135","Q8605706","Q8605788","Q8626009","Q8626563","Q8626784","Q8626808","Q8627037","Q8627296","Q8627733","Q8629647","Q8629652","Q8629654","Q8642673","Q8642856","Q8643216","Q8643623","Q8644740","Q8644742","Q8645659","Q8647233","Q8653849","Q8656557","Q8657128","Q8657340",
"Q8657604","Q8658085","Q8658247","Q8658361","Q8659709","Q8660164","Q8660912","Q8672871","Q8677404","Q8694483","Q8732303","Q8732305","Q8732311","Q8744793","Q8760109","Q8760834","Q8763448","Q8774101","Q8785087","Q8785574","Q8785884","Q8787509","Q8793354","Q8796744","Q8796865",
"Q8796970","Q8797286","Q8805696","Q8808995","Q8810037","Q8811047","Q8811329","Q8811753","Q8812090","Q8812342","Q8812386","Q8812554","Q8812596","Q8812668","Q8812777","Q8812947","Q8813195","Q8813367","Q8813399","Q8813504","Q8813524","Q8819994","Q8820259","Q8820646","Q8821017",
"Q8821267","Q8821307","Q8821505","Q8821624","Q8821744","Q8821927","Q8822164","Q8822335","Q8822363","Q8822476","Q8829602","Q8829604","Q8829609","Q8839707","Q8840015","Q8840434","Q8841031","Q8841208","Q8847396","Q8848045","Q8848344","Q8848943","Q8849153","Q8856886","Q8856910")
    )
#GROUP BY pl_title
#ORDER BY COUNT(*) DESC, pl_namespace, pl_title;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
