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 ("Q10119864","Q10120705","Q10124005","Q10124134","Q10127016","Q10138697","Q10148047","Q10149811","Q10151710","Q10165056","Q10168578","Q10170577","Q10181394","Q10185267","Q10185316","Q10186694","Q10198781","Q10203906","Q10215926","Q10224034","Q10225833","Q10227075","Q10227986","Q10237706","Q10245193","Q10254223","Q10255263","Q32461189","Q32662581","Q32665226","Q32667596","Q32671149","Q32679842","Q32684044","Q32688426","Q32695636","Q32696296","Q32698654","Q32711001","Q32711003","Q32711005","Q32711701","Q32719507","Q32719522","Q32719556","Q32719559","Q32719564","Q32719566","Q32719568","Q32719660","Q32719664","Q32719678","Q32719680","Q32719684","Q32719686","Q32719688","Q32719690","Q32719692","Q32719694","Q32719696","Q32719698","Q32719700","Q32719702","Q32719705","Q32719707","Q32719709","Q32719711","Q32719715","Q32719760","Q32719765","Q32719767","Q32719769","Q32719771","Q32719773","Q32719775","Q32719777","Q32719782","Q32719785","Q32719787","Q32719790","Q32719792","Q32719795","Q32719797","Q32719801","Q32719872","Q32719875","Q32719877","Q32719879","Q32719881","Q32719885","Q32719887","Q32719889","Q32719891","Q32719893","Q32719895","Q32719898","Q32719900","Q32719903","Q32719905","Q32719909","Q32719911","Q32719915","Q32719917","Q32719919","Q32719921","Q32719923","Q32719926","Q32719928","Q32719931","Q32719933","Q32719936","Q32719938","Q32719940","Q32719943","Q32719945","Q32719950","Q32719955","Q32719958","Q32719960","Q32719972","Q32719974","Q32719977","Q32719979","Q32719982","Q32719985","Q32719987","Q32719990","Q32719992","Q32720002","Q32720012","Q32720075","Q32720087","Q32720089","Q32720106","Q32720128","Q32720135","Q32720147","Q32720155","Q32720159","Q32720295","Q32720298","Q32720300","Q32720302","Q32720304","Q32720309","Q32720311","Q32720322","Q32720333","Q32720335","Q32720345","Q32720347","Q32720349","Q32720350","Q32720352","Q32720354","Q32720356","Q32720358","Q32720360","Q32720364","Q32720366","Q32720368","Q32720370","Q32720372","Q32720376","Q32720380","Q32720386","Q32720390","Q32720392","Q32720394","Q32720397","Q32720401","Q32720403","Q32720405","Q32720407","Q32720433","Q32720443","Q32720455","Q32720457","Q32720459","Q32720461","Q32720463","Q32720465","Q32720469","Q32720471","Q32720474","Q32720489","Q32720491","Q32720496","Q32720498","Q32720508","Q32720511","Q32720513","Q32720515","Q32720517","Q32720519","Q32720521","Q32720525","Q32720527","Q32720530","Q32720532","Q32720534","Q32720536","Q32720538","Q32720540","Q32720542","Q32720545","Q32720547","Q32720549","Q32720551","Q32720553","Q32720555","Q32720557","Q32720588","Q32720607","Q32720609","Q32720614","Q32720616","Q32720618","Q32720621","Q32720623","Q32720625","Q32720627","Q32720629","Q32720634","Q32720640","Q32720642","Q32720646","Q32720648","Q32720652","Q32720654","Q32720682","Q32720694","Q32720696","Q32720698","Q32720702","Q32720704","Q32720724","Q32720726","Q32720728","Q32720763","Q32720765","Q32720767","Q32720769","Q32720771","Q32720773","Q32720775","Q32720779","Q32720781","Q32720783","Q32720787","Q32720789","Q32720791","Q32720793","Q32720801","Q32720806","Q32720811","Q32720813","Q32720816","Q32720818","Q32720821","Q32720830","Q32720833","Q32720855","Q32720865","Q32720869","Q32720880","Q32720904","Q32720994","Q32721379","Q32721819","Q32722291","Q32722293","Q32722391","Q32722551","Q32722579","Q32722583","Q32722741","Q32722742","Q32722783","Q32722862","Q32722947","Q32722973","Q32723317","Q32724052","Q32724691","Q32725032","Q32725114","Q32725115","Q32725116","Q32725117","Q32725118","Q32725402","Q32725664","Q32725684","Q32725685","Q32725705","Q32726594","Q32726615","Q32726628","Q32727485","Q32727649","Q32727653","Q32727903","Q32727945","Q32728134","Q32728238","Q32728603","Q32729104","Q32729774","Q32730268","Q32730670","Q32731304","Q32731683","Q32731876","Q32732342","Q32732460","Q32732464","Q32732475","Q32732476","Q32732484","Q32732485","Q32732648","Q32732898","Q32733168","Q32733491","Q32733764","Q32735419","Q32736821","Q32737299","Q32737496","Q32737776","Q32738537","Q32738942","Q32739298","Q32739614","Q32739685","Q32740431","Q32740594","Q32740942","Q32741046","Q32741817","Q32743644","Q32743645","Q61174244","Q61177947","Q61177950","Q61178038","Q61178107","Q61178561","Q61184637","Q61189940","Q61189942","Q65672777","Q65673947","Q65674853","Q65675173","Q86168123","Q86185742","Q86198458","Q86200167","Q86205121")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q10119864","Q10120705","Q10124005","Q10124134","Q10127016","Q10138697","Q10148047","Q10149811","Q10151710","Q10165056","Q10168578","Q10170577","Q10181394","Q10185267","Q10185316","Q10186694","Q10198781","Q10203906","Q10215926","Q10224034","Q10225833","Q10227075","Q10227986","Q10237706","Q10245193","Q10254223","Q10255263","Q32461189","Q32662581","Q32665226","Q32667596","Q32671149","Q32679842","Q32684044","Q32688426","Q32695636","Q32696296","Q32698654","Q32711001","Q32711003","Q32711005","Q32711701","Q32719507","Q32719522","Q32719556","Q32719559","Q32719564","Q32719566","Q32719568","Q32719660","Q32719664","Q32719678","Q32719680","Q32719684","Q32719686","Q32719688","Q32719690","Q32719692","Q32719694","Q32719696","Q32719698","Q32719700","Q32719702","Q32719705","Q32719707","Q32719709","Q32719711","Q32719715","Q32719760","Q32719765","Q32719767","Q32719769","Q32719771","Q32719773","Q32719775","Q32719777","Q32719782","Q32719785","Q32719787","Q32719790","Q32719792","Q32719795","Q32719797","Q32719801","Q32719872","Q32719875","Q32719877","Q32719879","Q32719881","Q32719885","Q32719887","Q32719889","Q32719891","Q32719893","Q32719895","Q32719898","Q32719900","Q32719903","Q32719905","Q32719909","Q32719911","Q32719915","Q32719917","Q32719919","Q32719921","Q32719923","Q32719926","Q32719928","Q32719931","Q32719933","Q32719936","Q32719938","Q32719940","Q32719943","Q32719945","Q32719950","Q32719955","Q32719958","Q32719960","Q32719972","Q32719974","Q32719977","Q32719979","Q32719982","Q32719985","Q32719987","Q32719990","Q32719992","Q32720002","Q32720012","Q32720075","Q32720087","Q32720089","Q32720106","Q32720128","Q32720135","Q32720147","Q32720155","Q32720159","Q32720295","Q32720298","Q32720300","Q32720302","Q32720304","Q32720309","Q32720311","Q32720322","Q32720333","Q32720335","Q32720345","Q32720347","Q32720349","Q32720350","Q32720352","Q32720354","Q32720356","Q32720358","Q32720360","Q32720364","Q32720366","Q32720368","Q32720370","Q32720372","Q32720376","Q32720380","Q32720386","Q32720390","Q32720392","Q32720394","Q32720397","Q32720401","Q32720403","Q32720405","Q32720407","Q32720433","Q32720443","Q32720455","Q32720457","Q32720459","Q32720461","Q32720463","Q32720465","Q32720469","Q32720471","Q32720474","Q32720489","Q32720491","Q32720496","Q32720498","Q32720508","Q32720511","Q32720513","Q32720515","Q32720517","Q32720519","Q32720521","Q32720525","Q32720527","Q32720530","Q32720532","Q32720534","Q32720536","Q32720538","Q32720540","Q32720542","Q32720545","Q32720547","Q32720549","Q32720551","Q32720553","Q32720555","Q32720557","Q32720588","Q32720607","Q32720609","Q32720614","Q32720616","Q32720618","Q32720621","Q32720623","Q32720625","Q32720627","Q32720629","Q32720634","Q32720640","Q32720642","Q32720646","Q32720648","Q32720652","Q32720654","Q32720682","Q32720694","Q32720696","Q32720698","Q32720702","Q32720704","Q32720724","Q32720726","Q32720728","Q32720763","Q32720765","Q32720767","Q32720769","Q32720771","Q32720773","Q32720775","Q32720779","Q32720781","Q32720783","Q32720787","Q32720789","Q32720791","Q32720793","Q32720801","Q32720806","Q32720811","Q32720813","Q32720816","Q32720818","Q32720821","Q32720830","Q32720833","Q32720855","Q32720865","Q32720869","Q32720880","Q32720904","Q32720994","Q32721379","Q32721819","Q32722291","Q32722293","Q32722391","Q32722551","Q32722579","Q32722583","Q32722741","Q32722742","Q32722783","Q32722862","Q32722947","Q32722973","Q32723317","Q32724052","Q32724691","Q32725032","Q32725114","Q32725115","Q32725116","Q32725117","Q32725118","Q32725402","Q32725664","Q32725684","Q32725685","Q32725705","Q32726594","Q32726615","Q32726628","Q32727485","Q32727649","Q32727653","Q32727903","Q32727945","Q32728134","Q32728238","Q32728603","Q32729104","Q32729774","Q32730268","Q32730670","Q32731304","Q32731683","Q32731876","Q32732342","Q32732460","Q32732464","Q32732475","Q32732476","Q32732484","Q32732485","Q32732648","Q32732898","Q32733168","Q32733491","Q32733764","Q32735419","Q32736821","Q32737299","Q32737496","Q32737776","Q32738537","Q32738942","Q32739298","Q32739614","Q32739685","Q32740431","Q32740594","Q32740942","Q32741046","Q32741817","Q32743644","Q32743645","Q61174244","Q61177947","Q61177950","Q61178038","Q61178107","Q61178561","Q61184637","Q61189940","Q61189942","Q65672777","Q65673947","Q65674853","Q65675173","Q86168123","Q86185742","Q86198458","Q86200167","Q86205121")
    )
#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...
