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 ("Q100979506","Q101145871","Q102242940","Q102243011","Q102401637","Q103448948","Q104005337","Q104041556","Q104041576","Q104553855","Q104554236","Q104580030","Q104584171","Q104585704","Q104585815","Q104800687","Q104813734","Q104813736","Q104813771","Q104813776","Q105064049","Q105127986","Q105164955","Q105203943","Q105267656",
"Q105290609","Q105317497","Q105330166","Q105333616","Q105435488","Q105484730","Q105553937","Q105596689","Q105598689","Q105626093","Q105716053","Q105744608","Q105851606","Q106408603","Q106522404","Q106528835","Q106843645","Q107097981","Q107146452","Q107337303","Q107397508","Q107549581","Q107711944","Q107901914","Q108105026",
"Q108146555","Q108472906","Q108747569","Q108747573","Q108799930","Q109169525","Q109173340","Q109173401","Q109296862","Q109332935","Q109367037","Q109708508","Q109805207","Q109906770","Q109978012","Q110097293","Q110150578","Q110270022","Q110291239","Q110309237","Q110393901","Q110619355","Q110620030","Q110620073","Q110635382",
"Q110644903","Q111128746","Q111128747","Q111923708","Q111926982","Q111936210","Q111936733","Q111939463","Q112056002","Q112118694","Q112612793","Q112629406","Q112629415","Q112629420","Q112816852","Q113486048","Q113486437","Q113614376","Q113860914","Q114065099","Q114065183","Q114065205","Q114201687","Q114222789","Q114223032",
"Q114347346","Q114568173","Q114721509","Q114721510","Q114958407","Q114958411","Q114982987","Q115197838","Q115322016","Q115534393","Q115566962","Q115606117","Q115617190","Q115617558","Q115617597","Q115617655","Q115617661","Q115617672","Q115617684","Q115617686","Q115617696","Q115641915","Q115705930","Q115740011","Q115740016",
"Q115740022","Q115740030","Q115740032","Q115740062","Q115740064","Q115740073","Q115740086","Q115740100","Q115740119","Q115740130","Q115764105","Q115766740","Q115781747","Q115821716","Q115862722","Q115863369","Q115864405","Q115864406","Q116149048","Q116190899","Q116268203","Q116447797","Q116447806","Q116452629","Q116458056",
"Q116558843","Q116622142","Q116760215","Q116773460","Q116778814","Q116778892","Q116948348","Q116952023","Q116977223","Q117079134","Q117088218","Q117260521","Q117275001","Q117307873","Q117353009","Q117354053","Q117397899","Q117406383","Q117406386","Q117409156","Q117477456","Q117708918","Q117708943","Q118149465","Q118150363",
"Q118151942","Q118189188","Q118233812","Q118234983","Q118235011","Q118235063","Q118235425","Q118391415","Q118469456","Q118714720","Q119092145","Q119092174","Q119152579","Q119168764","Q119204916","Q119248523","Q119320282","Q119351299","Q119806603","Q119820414","Q119852337","Q120472505","Q120488606","Q120489242","Q120545893",
"Q120580054","Q120583783","Q120644355","Q120686131","Q120686936","Q120692136","Q120692170","Q120692302","Q120692470","Q120706018","Q120732269","Q120733404","Q120733506","Q120761790","Q120802587","Q120830125","Q120861473","Q120880822","Q120893600","Q120912476","Q120937840","Q120971975","Q120979528","Q120993855","Q120998506",
"Q121033661","Q121061032","Q121120744","Q121198510","Q121267243","Q121349480","Q121461644","Q121600442","Q121605730","Q121607097","Q121759938","Q121766436","Q121793046","Q122009619","Q122163090","Q122171087","Q122230874","Q122332944","Q122411491","Q122641182","Q122692154","Q122700333","Q122709866","Q122752655","Q122766278"
)
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q100979506","Q101145871","Q102242940","Q102243011","Q102401637","Q103448948","Q104005337","Q104041556","Q104041576","Q104553855","Q104554236","Q104580030","Q104584171","Q104585704","Q104585815","Q104800687","Q104813734","Q104813736","Q104813771","Q104813776","Q105064049","Q105127986","Q105164955","Q105203943","Q105267656",
"Q105290609","Q105317497","Q105330166","Q105333616","Q105435488","Q105484730","Q105553937","Q105596689","Q105598689","Q105626093","Q105716053","Q105744608","Q105851606","Q106408603","Q106522404","Q106528835","Q106843645","Q107097981","Q107146452","Q107337303","Q107397508","Q107549581","Q107711944","Q107901914","Q108105026",
"Q108146555","Q108472906","Q108747569","Q108747573","Q108799930","Q109169525","Q109173340","Q109173401","Q109296862","Q109332935","Q109367037","Q109708508","Q109805207","Q109906770","Q109978012","Q110097293","Q110150578","Q110270022","Q110291239","Q110309237","Q110393901","Q110619355","Q110620030","Q110620073","Q110635382",
"Q110644903","Q111128746","Q111128747","Q111923708","Q111926982","Q111936210","Q111936733","Q111939463","Q112056002","Q112118694","Q112612793","Q112629406","Q112629415","Q112629420","Q112816852","Q113486048","Q113486437","Q113614376","Q113860914","Q114065099","Q114065183","Q114065205","Q114201687","Q114222789","Q114223032",
"Q114347346","Q114568173","Q114721509","Q114721510","Q114958407","Q114958411","Q114982987","Q115197838","Q115322016","Q115534393","Q115566962","Q115606117","Q115617190","Q115617558","Q115617597","Q115617655","Q115617661","Q115617672","Q115617684","Q115617686","Q115617696","Q115641915","Q115705930","Q115740011","Q115740016",
"Q115740022","Q115740030","Q115740032","Q115740062","Q115740064","Q115740073","Q115740086","Q115740100","Q115740119","Q115740130","Q115764105","Q115766740","Q115781747","Q115821716","Q115862722","Q115863369","Q115864405","Q115864406","Q116149048","Q116190899","Q116268203","Q116447797","Q116447806","Q116452629","Q116458056",
"Q116558843","Q116622142","Q116760215","Q116773460","Q116778814","Q116778892","Q116948348","Q116952023","Q116977223","Q117079134","Q117088218","Q117260521","Q117275001","Q117307873","Q117353009","Q117354053","Q117397899","Q117406383","Q117406386","Q117409156","Q117477456","Q117708918","Q117708943","Q118149465","Q118150363",
"Q118151942","Q118189188","Q118233812","Q118234983","Q118235011","Q118235063","Q118235425","Q118391415","Q118469456","Q118714720","Q119092145","Q119092174","Q119152579","Q119168764","Q119204916","Q119248523","Q119320282","Q119351299","Q119806603","Q119820414","Q119852337","Q120472505","Q120488606","Q120489242","Q120545893",
"Q120580054","Q120583783","Q120644355","Q120686131","Q120686936","Q120692136","Q120692170","Q120692302","Q120692470","Q120706018","Q120732269","Q120733404","Q120733506","Q120761790","Q120802587","Q120830125","Q120861473","Q120880822","Q120893600","Q120912476","Q120937840","Q120971975","Q120979528","Q120993855","Q120998506",
"Q121033661","Q121061032","Q121120744","Q121198510","Q121267243","Q121349480","Q121461644","Q121600442","Q121605730","Q121607097","Q121759938","Q121766436","Q121793046","Q122009619","Q122163090","Q122171087","Q122230874","Q122332944","Q122411491","Q122641182","Q122692154","Q122700333","Q122709866","Q122752655","Q122766278"
)
    )
#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...
