Untitled query #60523

This query is marked as a draft This query has been published by Mhzavareh90.
SQL

USE enwiki_p;
SELECT T.page_title, T.page_id, T.imdb_link, COUNT(el_to) as num_outlinks from
  (SELECT page_title, page_id, el_to as imdb_link
   FROM page
   JOIN externallinks
   ON page_id = el_from
   WHERE (el_to='https://www.imdb.com/title/tt1270798/' or el_to='https://www.imdb.com/title/tt4972582/' or el_to='https://www.imdb.com/title/tt0103639/' or el_to='https://www.imdb.com/title/tt1104001/' or el_to='https://www.imdb.com/title/tt0332379/' or el_to='https://www.imdb.com/title/tt5311514/' or el_to='https://www.imdb.com/title/tt4263482/' or el_to='https://www.imdb.com/title/tt1899353/' or el_to='https://www.imdb.com/title/tt0266308/' or el_to='https://www.imdb.com/title/tt1038988/' or el_to='https://www.imdb.com/title/tt0978762/' or el_to='https://www.imdb.com/title/tt1661199/' or el_to='https://www.imdb.com/title/tt0087544/' or el_to='https://www.imdb.com/title/tt4178092/' or el_to='https://www.imdb.com/title/tt3470600/' or el_to='https://www.imdb.com/title/tt0088323/' or el_to='https://www.imdb.com/title/tt0113568/' or el_to='https://www.imdb.com/title/tt0472033/' or el_to='https://www.imdb.com/title/tt0097814/' or el_to='https://www.imdb.com/title/tt0373074/' or el_to='https://www.imdb.com/title/tt3567288/' or el_to='https://www.imdb.com/title/tt1588170/' or el_to='https://www.imdb.com/title/tt12801262/' or el_to='https://www.imdb.com/title/tt2265171/' or el_to='https://www.imdb.com/title/tt0373051/' or el_to='https://www.imdb.com/title/tt0085959/' or el_to='https://www.imdb.com/title/tt0421239/' or el_to='https://www.imdb.com/title/tt0385004/' or el_to='https://www.imdb.com/title/tt1187064/' or el_to='https://www.imdb.com/title/tt2631186/' or el_to='https://www.imdb.com/title/tt1386932/' or el_to='https://www.imdb.com/title/tt0318462/' or el_to='https://www.imdb.com/title/tt2980592/' or el_to='https://www.imdb.com/title/tt0118998/' or el_to='https://www.imdb.com/title/tt2382009/' or el_to='https://www.imdb.com/title/tt1568921/' or el_to='https://www.imdb.com/title/tt1126591/' or el_to='https://www.imdb.com/title/tt4849438/' or el_to='https://www.imdb.com/title/tt1555149/' or el_to='https://www.imdb.com/title/tt2013293/' or el_to='https://www.imdb.com/title/tt1512235/' or el_to='https://www.imdb.com/title/tt0286112/' or el_to='https://www.imdb.com/title/tt0446059/' or el_to='https://www.imdb.com/title/tt7456310/' or el_to='https://www.imdb.com/title/tt1245112/' or el_to='https://www.imdb.com/title/tt1323045/' or el_to='https://www.imdb.com/title/tt0111507/' or el_to='https://www.imdb.com/title/tt10886166/' or el_to='https://www.imdb.com/title/tt6977338/' or el_to='https://www.imdb.com/title/tt6566576/' or el_to='https://www.imdb.com/title/tt0156887/' or el_to='https://www.imdb.com/title/tt0178868/' or el_to='https://www.imdb.com/title/tt1527788/' or el_to='https://www.imdb.com/title/tt5323662/' or el_to='https://www.imdb.com/title/tt0046911/' or el_to='https://www.imdb.com/title/tt1436045/' or el_to='https://www.imdb.com/title/tt0808506/' or el_to='https://www.imdb.com/title/tt1190539/' or el_to='https://www.imdb.com/title/tt8633478/' or el_to='https://www.imdb.com/title/tt5215952/' or el_to='https://www.imdb.com/title/tt4971344/' or el_to='https://www.imdb.com/title/tt0015648/' or el_to='https://www.imdb.com/title/tt0385700/' or el_to='https://www.imdb.com/title/tt3848892/' or el_to='https://www.imdb.com/title/tt0120157/' or el_to='https://www.imdb.com/title/tt7668842/' or el_to='https://www.imdb.com/title/tt0402910/' or el_to='https://www.imdb.com/title/tt9701940/' or el_to='https://www.imdb.com/title/tt2888046/' or el_to='https://www.imdb.com/title/tt0096933/' or el_to='https://www.imdb.com/title/tt2121382/' or el_to='https://www.imdb.com/title/tt0019254/' or el_to='https://www.imdb.com/title/tt4080728/' or el_to='https://www.imdb.com/title/tt0060107/' or el_to='https://www.imdb.com/title/tt0021814/' or el_to='https://www.imdb.com/title/tt0095250/' or el_to='https://www.imdb.com/title/tt0050613/' or el_to='https://www.imdb.com/title/tt2758880/' or el_to='https://www.imdb.com/title/tt0104684/' or el_to='https://www.imdb.com/title/tt0062229/' or el_to='https://www.imdb.com/title/tt0169858/' or el_to='https://www.imdb.com/title/tt2404461/' or el_to='https://www.imdb.com/title/tt0493405/' or el_to='https://www.imdb.com/title/tt0425637/' or el_to='https://www.imdb.com/title/tt0111512/' or el_to='https://www.imdb.com/title/tt5116302/' or el_to='https://www.imdb.com/title/tt4176826/' or el_to='https://www.imdb.com/title/tt9701942/' or el_to='https://www.imdb.com/title/tt10431500/' or el_to='https://www.imdb.com/title/tt0875034/' or el_to='https://www.imdb.com/title/tt0088794/' or el_to='https://www.imdb.com/title/tt2576852/' or el_to='https://www.imdb.com/title/tt2318092/' or el_to='https://www.imdb.com/title/tt0131369/' or el_to='https://www.imdb.com/title/tt0857191/' or el_to='https://www.imdb.com/title/tt0074811/' or el_to='https://www.imdb.com/title/tt2140203/' or el_to='https://www.imdb.com/title/tt0190641/' or el_to='https://www.imdb.com/title/tt0133385/' or el_to='https://www.imdb.com/title/tt0238936/' or el_to='https://www.imdb.com/title/tt11032374/' or el_to='https://www.imdb.com/title/tt2591814/' or el_to='https://www.imdb.com/title/tt0779982/' or el_to='https://www.imdb.com/title/tt2113681/' or el_to='https://www.imdb.com/title/tt5862312/' or el_to='https://www.imdb.com/title/tt0095675/' or el_to='https://www.imdb.com/title/tt0080179/' or el_to='https://www.imdb.com/title/tt0127357/' or el_to='https://www.imdb.com/title/tt7221896/' or el_to='https://www.imdb.com/title/tt1703148/' or el_to='https://www.imdb.com/title/tt0495596/' or el_to='https://www.imdb.com/title/tt0116191/' or el_to='https://www.imdb.com/title/tt1590089/' or el_to='https://www.imdb.com/title/tt0051808/' or el_to='https://www.imdb.com/title/tt0347246/' or el_to='https://www.imdb.com/title/tt1073241/' or el_to='https://www.imdb.com/title/tt3398268/' or el_to='https://www.imdb.com/title/tt0427954/' or el_to='https://www.imdb.com/title/tt14723224/' or el_to='https://www.imdb.com/title/tt7060344/' or el_to='https://www.imdb.com/title/tt0107692/' or el_to='https://www.imdb.com/title/tt10155932/' or el_to='https://www.imdb.com/title/tt0424774/' or el_to='https://www.imdb.com/title/tt2213054/' or el_to='https://www.imdb.com/title/tt0388473/' or el_to='https://www.imdb.com/title/tt0080491/' or el_to='https://www.imdb.com/title/tt1649444/' or el_to='https://www.imdb.com/title/tt0089374/' or el_to='https://www.imdb.com/title/tt0112913/' or el_to='https://www.imdb.com/title/tt0409904/' or el_to='https://www.imdb.com/title/tt10895576/' or el_to='https://www.imdb.com/title/tt0108500/' or el_to='https://www.imdb.com/title/tt10620868/' or el_to='https://www.imdb.com/title/tt11655202/' or el_to='https://www.imdb.com/title/tt1462900/' or el_to='https://www.imdb.com/title/tt6990206/' or el_to='https://www.imdb.com/title/tt6341832/' or el_to='https://www.imdb.com/title/tt2016894/' or el_to='https://www.imdb.com/title/tt0078718/' or el_to='https://www.imdb.com/title/tt1171701/' or el_to='https://www.imdb.com/title/tt6304162/' or el_to='https://www.imdb.com/title/tt1641638/' or el_to='https://www.imdb.com/title/tt7725596/' or el_to='https://www.imdb.com/title/tt0308379/' or el_to='https://www.imdb.com/title/tt3792960/' or el_to='https://www.imdb.com/title/tt0101640/' or el_to='https://www.imdb.com/title/tt1174954/' or el_to='https://www.imdb.com/title/tt0180734/' or el_to='https://www.imdb.com/title/tt0053459/' or el_to='https://www.imdb.com/title/tt0758742/' or el_to='https://www.imdb.com/title/tt3387648/' or el_to='https://www.imdb.com/title/tt2076298/' or el_to='https://www.imdb.com/title/tt0411272/' or el_to='https://www.imdb.com/title/tt8850222/' or el_to='https://www.imdb.com/title/tt0463872/' or el_to='https://www.imdb.com/title/tt0325655/' or el_to='https://www.imdb.com/title/tt1474276/' or el_to='https://www.imdb.com/title/tt0813980/' or el_to='https://www.imdb.com/title/tt2980794/' or el_to='https://www.imdb.com/title/tt3278330/' or el_to='https://www.imdb.com/title/tt7057496/' or el_to='https://www.imdb.com/title/tt0077713/' or el_to='https://www.imdb.com/title/tt4458206/' or el_to='https://www.imdb.com/title/tt2263944/' or el_to='https://www.imdb.com/title/tt4995776/' or el_to='https://www.imdb.com/title/tt8633462/' or el_to='https://www.imdb.com/title/tt0106332/' or el_to='https://www.imdb.com/title/tt5198068/' or el_to='https://www.imdb.com/title/tt10530176/' or el_to='https://www.imdb.com/title/tt0913968/' or el_to='https://www.imdb.com/title/tt0118845/' or el_to='https://www.imdb.com/title/tt5607714/' or el_to='https://www.imdb.com/title/tt0386005/' or el_to='https://www.imdb.com/title/tt0067824/' or el_to='https://www.imdb.com/title/tt0291350/' or el_to='https://www.imdb.com/title/tt1465487/' or el_to='https://www.imdb.com/title/tt0038348/' or el_to='https://www.imdb.com/title/tt2582502/' or el_to='https://www.imdb.com/title/tt0091223/' or el_to='https://www.imdb.com/title/tt7961060/' or el_to='https://www.imdb.com/title/tt1729637/' or el_to='https://www.imdb.com/title/tt0057091/' or el_to='https://www.imdb.com/title/tt9252468/' or el_to='https://www.imdb.com/title/tt1979319/' or el_to='https://www.imdb.com/title/tt7748244/' or el_to='https://www.imdb.com/title/tt0263438/' or el_to='https://www.imdb.com/title/tt8721424/' or el_to='https://www.imdb.com/title/tt2832470/' or el_to='https://www.imdb.com/title/tt1326972/' or el_to='https://www.imdb.com/title/tt0497137/' or el_to='https://www.imdb.com/title/tt2321405/' or el_to='https://www.imdb.com/title/tt2170667/' or el_to='https://www.imdb.com/title/tt0466460/' or el_to='https://www.imdb.com/title/tt0110200/' or el_to='https://www.imdb.com/title/tt6628102/' or el_to='https://www.imdb.com/title/tt0449061/' or el_to='https://www.imdb.com/title/tt6910020/' or el_to='https://www.imdb.com/title/tt10199590/' or el_to='https://www.imdb.com/title/tt12838766/' or el_to='https://www.imdb.com/title/tt0046478/' or el_to='https://www.imdb.com/title/tt4272866/' or el_to='https://www.imdb.com/title/tt7642818/' or el_to='https://www.imdb.com/title/tt1424310/' or el_to='https://www.imdb.com/title/tt2625030/' or el_to='https://www.imdb.com/title/tt5859238/' or el_to='https://www.imdb.com/title/tt0057831/' or el_to='https://www.imdb.com/title/tt0923811/' or el_to='https://www.imdb.com/title/tt0082307/' or el_to='https://www.imdb.com/title/tt0837106/' or el_to='https://www.imdb.com/title/tt3347976/' or el_to='https://www.imdb.com/title/tt0082484/' or el_to='https://www.imdb.com/title/tt0210234/' or el_to='https://www.imdb.com/title/tt3819668/' or el_to='https://www.imdb.com/title/tt7914416/' or el_to='https://www.imdb.com/title/tt0096251/' or el_to='https://www.imdb.com/title/tt0342492/' or el_to='https://www.imdb.com/title/tt2608224/' or el_to='https://www.imdb.com/title/tt0067355/' or el_to='https://www.imdb.com/title/tt2471640/' or el_to='https://www.imdb.com/title/tt6878038/' or el_to='https://www.imdb.com/title/tt1702425/' or el_to='https://www.imdb.com/title/tt0104558/' or el_to='https://www.imdb.com/title/tt2368553/' or el_to='https://www.imdb.com/title/tt0101258/' or el_to='https://www.imdb.com/title/tt2316801/' or el_to='https://www.imdb.com/title/tt0116704/' or el_to='https://www.imdb.com/title/tt0101316/' or el_to='https://www.imdb.com/title/tt0337103/' or el_to='https://www.imdb.com/title/tt1230385/' or el_to='https://www.imdb.com/title/tt14878948/' or el_to='https://www.imdb.com/title/tt0067445/' or el_to='https://www.imdb.com/title/tt2238032/' or el_to='https://www.imdb.com/title/tt0409184/' or el_to='https://www.imdb.com/title/tt1322930/' or el_to='https://www.imdb.com/title/tt0790623/' or el_to='https://www.imdb.com/title/tt1753496/' or el_to='https://www.imdb.com/title/tt11260832/' or el_to='https://www.imdb.com/title/tt0199683/' or el_to='https://www.imdb.com/title/tt0312843/' or el_to='https://www.imdb.com/title/tt0082377/' or el_to='https://www.imdb.com/title/tt6788942/' or el_to='https://www.imdb.com/title/tt10521092/' or el_to='https://www.imdb.com/title/tt0860906/' or el_to='https://www.imdb.com/title/tt0253997/' or el_to='https://www.imdb.com/title/tt0253779/' or el_to='https://www.imdb.com/title/tt0420251/' or el_to='https://www.imdb.com/title/tt3672840/' or el_to='https://www.imdb.com/title/tt0095990/' or el_to='https://www.imdb.com/title/tt5882970/' or el_to='https://www.imdb.com/title/tt0875113/' or el_to='https://www.imdb.com/title/tt5607028/' or el_to='https://www.imdb.com/title/tt0252490/' or el_to='https://www.imdb.com/title/tt0424227/' or el_to='https://www.imdb.com/title/tt2659414/' or el_to='https://www.imdb.com/title/tt0058625/' or el_to='https://www.imdb.com/title/tt0091431/' or el_to='https://www.imdb.com/title/tt4088268/' or el_to='https://www.imdb.com/title/tt0095403/' or el_to='https://www.imdb.com/title/tt0079221/' or el_to='https://www.imdb.com/title/tt3449292/' or el_to='https://www.imdb.com/title/tt0315642/' or el_to='https://www.imdb.com/title/tt0456396/' or el_to='https://www.imdb.com/title/tt7363104/' or el_to='https://www.imdb.com/title/tt0103285/' or el_to='https://www.imdb.com/title/tt4558362/' or el_to='https://www.imdb.com/title/tt2279864/' or el_to='https://www.imdb.com/title/tt1499666/' or el_to='https://www.imdb.com/title/tt0072281/' or el_to='https://www.imdb.com/title/tt1291652/' or el_to='https://www.imdb.com/title/tt0369060/' or el_to='https://www.imdb.com/title/tt0089153/' or el_to='https://www.imdb.com/title/tt1649443/' or el_to='https://www.imdb.com/title/tt0095800/' or el_to='https://www.imdb.com/title/tt0110081/' or el_to='https://www.imdb.com/title/tt0085474/' or el_to='https://www.imdb.com/title/tt0348121/' or el_to='https://www.imdb.com/title/tt7832124/' or el_to='https://www.imdb.com/title/tt1291465/' or el_to='https://www.imdb.com/title/tt0110963/' or el_to='https://www.imdb.com/title/tt0271946/' or el_to='https://www.imdb.com/title/tt6752992/' or el_to='https://www.imdb.com/title/tt0054407/' or el_to='https://www.imdb.com/title/tt2955316/' or el_to='https://www.imdb.com/title/tt8649186/' or el_to='https://www.imdb.com/title/tt5084170/' or el_to='https://www.imdb.com/title/tt1911553/' or el_to='https://www.imdb.com/title/tt0191043/' or el_to='https://www.imdb.com/title/tt0086373/' or el_to='https://www.imdb.com/title/tt3508840/' or el_to='https://www.imdb.com/title/tt0072901/' or el_to='https://www.imdb.com/title/tt7711170/' or el_to='https://www.imdb.com/title/tt0810827/' or el_to='https://www.imdb.com/title/tt0176783/' or el_to='https://www.imdb.com/title/tt2061702/' or el_to='https://www.imdb.com/title/tt0193253/' or el_to='https://www.imdb.com/title/tt0085127/' or el_to='https://www.imdb.com/title/tt3477064/' or el_to='https://www.imdb.com/title/tt3704538/' or el_to='https://www.imdb.com/title/tt0879843/' or el_to='https://www.imdb.com/title/tt0808240/' or el_to='https://www.imdb.com/title/tt1121794/' or el_to='https://www.imdb.com/title/tt0108148/' or el_to='https://www.imdb.com/title/tt7458762/' or el_to='https://www.imdb.com/title/tt2844798/' or el_to='https://www.imdb.com/title/tt0070233/' or el_to='https://www.imdb.com/title/tt0118826/' or el_to='https://www.imdb.com/title/tt0290329/' or el_to='https://www.imdb.com/title/tt2027140/' or el_to='https://www.imdb.com/title/tt0422295/' or el_to='https://www.imdb.com/title/tt6439558/' or el_to='https://www.imdb.com/title/tt0108432/' or el_to='https://www.imdb.com/title/tt0263975/' or el_to='https://www.imdb.com/title/tt3029558/' or el_to='https://www.imdb.com/title/tt0484877/' or el_to='https://www.imdb.com/title/tt1550312/' or el_to='https://www.imdb.com/title/tt9675274/' or el_to='https://www.imdb.com/title/tt0870090/' or el_to='https://www.imdb.com/title/tt3517870/' or el_to='https://www.imdb.com/title/tt0384369/' or el_to='https://www.imdb.com/title/tt0940709/' or el_to='https://www.imdb.com/title/tt0090248/' or el_to='https://www.imdb.com/title/tt0116790/' or el_to='https://www.imdb.com/title/tt1588895/' or el_to='https://www.imdb.com/title/tt0111579/' or el_to='https://www.imdb.com/title/tt6916362/' or el_to='https://www.imdb.com/title/tt0338512/' or el_to='https://www.imdb.com/title/tt0107156/' or el_to='https://www.imdb.com/title/tt0016847/' or el_to='https://www.imdb.com/title/tt1839494/' or el_to='https://www.imdb.com/title/tt1975249/' or el_to='https://www.imdb.com/title/tt6864046/' or el_to='https://www.imdb.com/title/tt0456149/' or el_to='https://www.imdb.com/title/tt1579247/' or el_to='https://www.imdb.com/title/tt0110882/' or el_to='https://www.imdb.com/title/tt1718199/' or el_to='https://www.imdb.com/title/tt0144715/' or el_to='https://www.imdb.com/title/tt1597522/' or el_to='https://www.imdb.com/title/tt1801051/' or el_to='https://www.imdb.com/title/tt1260502/' or el_to='https://www.imdb.com/title/tt2299842/' or el_to='https://www.imdb.com/title/tt8907992/' or el_to='https://www.imdb.com/title/tt2070649/' or el_to='https://www.imdb.com/title/tt2852458/' or el_to='https://www.imdb.com/title/tt7160070/' or el_to='https://www.imdb.com/title/tt7489816/' or el_to='https://www.imdb.com/title/tt1854236/' or el_to='https://www.imdb.com/title/tt3296658/' or el_to='https://www.imdb.com/title/tt0160611/' or el_to='https://www.imdb.com/title/tt8442644/' or el_to='https://www.imdb.com/title/tt0235679/' or el_to='https://www.imdb.com/title/tt1653690/' or el_to='https://www.imdb.com/title/tt5075662/' or el_to='https://www.imdb.com/title/tt0101318/' or el_to='https://www.imdb.com/title/tt6777338/' or el_to='https://www.imdb.com/title/tt0860907/' or el_to='https://www.imdb.com/title/tt0381348/' or el_to='https://www.imdb.com/title/tt0021577/' or el_to='https://www.imdb.com/title/tt6336356/' or el_to='https://www.imdb.com/title/tt0169880/' or el_to='https://www.imdb.com/title/tt3560686/' or el_to='https://www.imdb.com/title/tt5968274/' or el_to='https://www.imdb.com/title/tt5229228/' or el_to='https://www.imdb.com/title/tt0102293/' or el_to='https://www.imdb.com/title/tt2072230/' or el_to='https://www.imdb.com/title/tt0831888/' or el_to='https://www.imdb.com/title/tt4120176/' or el_to='https://www.imdb.com/title/tt13109952/' or el_to='https://www.imdb.com/title/tt3697626/' or el_to='https://www.imdb.com/title/tt0093342/' or el_to='https://www.imdb.com/title/tt3759416/' or el_to='https://www.imdb.com/title/tt0374339/' or el_to='https://www.imdb.com/title/tt3646462/' or el_to='https://www.imdb.com/title/tt5460658/' or el_to='https://www.imdb.com/title/tt0992911/' or el_to='https://www.imdb.com/title/tt1146438/' or el_to='https://www.imdb.com/title/tt7236034/' or el_to='https://www.imdb.com/title/tt0059550/' or el_to='https://www.imdb.com/title/tt0184526/' or el_to='https://www.imdb.com/title/tt4157728/' or el_to='https://www.imdb.com/title/tt1808197/' or el_to='https://www.imdb.com/title/tt2351310/' or el_to='https://www.imdb.com/title/tt3100274/' or el_to='https://www.imdb.com/title/tt1865569/' or el_to='https://www.imdb.com/title/tt0062687/' or el_to='https://www.imdb.com/title/tt11750282/' or el_to='https://www.imdb.com/title/tt1632547/' or el_to='https://www.imdb.com/title/tt1772424/' or el_to='https://www.imdb.com/title/tt0110647/' or el_to='https://www.imdb.com/title/tt4271918/' or el_to='https://www.imdb.com/title/tt0829297/' or el_to='https://www.imdb.com/title/tt1259574/' or el_to='https://www.imdb.com/title/tt2017561/' or el_to='https://www.imdb.com/title/tt6745550/' or el_to='https://www.imdb.com/title/tt0365675/' or el_to='https://www.imdb.com/title/tt1447508/' or el_to='https://www.imdb.com/title/tt2668134/' or el_to='https://www.imdb.com/title/tt0478024/' or el_to='https://www.imdb.com/title/tt3029556/' or el_to='https://www.imdb.com/title/tt6648926/' or el_to='https://www.imdb.com/title/tt3877674/' or el_to='https://www.imdb.com/title/tt1634013/' or el_to='https://www.imdb.com/title/tt0120125/' or el_to='https://www.imdb.com/title/tt6206564/' or el_to='https://www.imdb.com/title/tt0276830/' or el_to='https://www.imdb.com/title/tt0389328/' or el_to='https://www.imdb.com/title/tt2210479/' or el_to='https://www.imdb.com/title/tt2025526/' or el_to='https://www.imdb.com/title/tt1701210/' or el_to='https://www.imdb.com/title/tt7806998/' or el_to='https://www.imdb.com/title/tt5159414/') and page_namespace = 0) as T
JOIN externallinks
ON T.page_id = el_from
GROUP BY el_from 
order by COUNT(el_to) DESC
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...
