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/tt1596363/' or el_to='https://www.imdb.com/title/tt0070047/' or el_to='https://www.imdb.com/title/tt1587310/' or el_to='https://www.imdb.com/title/tt0371724/' or el_to='https://www.imdb.com/title/tt0462322/' or el_to='https://www.imdb.com/title/tt1234548/' or el_to='https://www.imdb.com/title/tt0104348/' or el_to='https://www.imdb.com/title/tt0879870/' or el_to='https://www.imdb.com/title/tt1216487/' or el_to='https://www.imdb.com/title/tt0032455/' or el_to='https://www.imdb.com/title/tt1954470/' or el_to='https://www.imdb.com/title/tt1532503/' or el_to='https://www.imdb.com/title/tt0374546/' or el_to='https://www.imdb.com/title/tt8503618/' or el_to='https://www.imdb.com/title/tt5988370/' or el_to='https://www.imdb.com/title/tt0401711/' or el_to='https://www.imdb.com/title/tt3045616/' or el_to='https://www.imdb.com/title/tt0384116/' or el_to='https://www.imdb.com/title/tt0058946/' or el_to='https://www.imdb.com/title/tt7825208/' or el_to='https://www.imdb.com/title/tt11337862/' or el_to='https://www.imdb.com/title/tt0141369/' or el_to='https://www.imdb.com/title/tt0808399/' or el_to='https://www.imdb.com/title/tt2702724/' or el_to='https://www.imdb.com/title/tt2402101/' or el_to='https://www.imdb.com/title/tt0364385/' or el_to='https://www.imdb.com/title/tt2610768/' or el_to='https://www.imdb.com/title/tt14544192/' or el_to='https://www.imdb.com/title/tt0068555/' or el_to='https://www.imdb.com/title/tt6038600/' or el_to='https://www.imdb.com/title/tt0405336/' or el_to='https://www.imdb.com/title/tt0109348/' or el_to='https://www.imdb.com/title/tt1078188/' or el_to='https://www.imdb.com/title/tt0120910/' or el_to='https://www.imdb.com/title/tt13567480/' or el_to='https://www.imdb.com/title/tt0270053/' or el_to='https://www.imdb.com/title/tt0810988/' or el_to='https://www.imdb.com/title/tt2016894/' or el_to='https://www.imdb.com/title/tt3698408/' or el_to='https://www.imdb.com/title/tt0378947/' or el_to='https://www.imdb.com/title/tt0841044/' or el_to='https://www.imdb.com/title/tt5727282/' or el_to='https://www.imdb.com/title/tt0066765/' or el_to='https://www.imdb.com/title/tt2167266/' or el_to='https://www.imdb.com/title/tt4458206/' or el_to='https://www.imdb.com/title/tt2235108/' or el_to='https://www.imdb.com/title/tt2785032/' or el_to='https://www.imdb.com/title/tt0100998/' or el_to='https://www.imdb.com/title/tt1648216/' or el_to='https://www.imdb.com/title/tt10228134/' or el_to='https://www.imdb.com/title/tt10810424/' or el_to='https://www.imdb.com/title/tt0188674/' or el_to='https://www.imdb.com/title/tt0280491/' or el_to='https://www.imdb.com/title/tt15523010/' or el_to='https://www.imdb.com/title/tt1808223/' or el_to='https://www.imdb.com/title/tt0991178/' or el_to='https://www.imdb.com/title/tt0420087/' or el_to='https://www.imdb.com/title/tt2717860/' or el_to='https://www.imdb.com/title/tt1424310/' or el_to='https://www.imdb.com/title/tt1740047/' or el_to='https://www.imdb.com/title/tt1848902/' or el_to='https://www.imdb.com/title/tt10062556/' or el_to='https://www.imdb.com/title/tt1901024/' or el_to='https://www.imdb.com/title/tt0101316/' or el_to='https://www.imdb.com/title/tt0082783/' or el_to='https://www.imdb.com/title/tt0901507/' or el_to='https://www.imdb.com/title/tt3111426/' or el_to='https://www.imdb.com/title/tt4728338/' 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/tt0059260/' or el_to='https://www.imdb.com/title/tt9620288/' or el_to='https://www.imdb.com/title/tt4088268/' or el_to='https://www.imdb.com/title/tt1663207/' or el_to='https://www.imdb.com/title/tt0100234/' or el_to='https://www.imdb.com/title/tt2965412/' or el_to='https://www.imdb.com/title/tt0025452/' or el_to='https://www.imdb.com/title/tt0056241/' or el_to='https://www.imdb.com/title/tt0076257/' or el_to='https://www.imdb.com/title/tt0090966/' or el_to='https://www.imdb.com/title/tt1704292/' or el_to='https://www.imdb.com/title/tt0236640/' or el_to='https://www.imdb.com/title/tt0077572/' or el_to='https://www.imdb.com/title/tt0252489/' or el_to='https://www.imdb.com/title/tt0893402/' or el_to='https://www.imdb.com/title/tt0085474/' or el_to='https://www.imdb.com/title/tt3083008/' or el_to='https://www.imdb.com/title/tt1436568/' or el_to='https://www.imdb.com/title/tt0253614/' or el_to='https://www.imdb.com/title/tt0808185/' or el_to='https://www.imdb.com/title/tt1023490/' or el_to='https://www.imdb.com/title/tt1434435/' or el_to='https://www.imdb.com/title/tt7830574/' or el_to='https://www.imdb.com/title/tt3471098/' or el_to='https://www.imdb.com/title/tt0095655/' or el_to='https://www.imdb.com/title/tt0128332/' or el_to='https://www.imdb.com/title/tt1103982/' or el_to='https://www.imdb.com/title/tt9345754/' or el_to='https://www.imdb.com/title/tt3477064/' or el_to='https://www.imdb.com/title/tt3399024/' or el_to='https://www.imdb.com/title/tt6017756/' or el_to='https://www.imdb.com/title/tt2126235/' or el_to='https://www.imdb.com/title/tt0104114/' or el_to='https://www.imdb.com/title/tt8597594/' or el_to='https://www.imdb.com/title/tt4195278/' or el_to='https://www.imdb.com/title/tt1935902/' or el_to='https://www.imdb.com/title/tt2967006/' or el_to='https://www.imdb.com/title/tt0389957/' or el_to='https://www.imdb.com/title/tt0399854/' or el_to='https://www.imdb.com/title/tt0006864/' or el_to='https://www.imdb.com/title/tt0499603/' or el_to='https://www.imdb.com/title/tt0338512/' or el_to='https://www.imdb.com/title/tt0041094/' or el_to='https://www.imdb.com/title/tt0201368/' or el_to='https://www.imdb.com/title/tt10481868/' or el_to='https://www.imdb.com/title/tt5304464/' or el_to='https://www.imdb.com/title/tt0113613/' or el_to='https://www.imdb.com/title/tt4867110/' or el_to='https://www.imdb.com/title/tt0200654/' or el_to='https://www.imdb.com/title/tt7456312/' or el_to='https://www.imdb.com/title/tt9506474/' or el_to='https://www.imdb.com/title/tt2517658/' or el_to='https://www.imdb.com/title/tt5192124/' or el_to='https://www.imdb.com/title/tt8442644/' or el_to='https://www.imdb.com/title/tt0298744/' or el_to='https://www.imdb.com/title/tt6857988/' or el_to='https://www.imdb.com/title/tt0086619/' or el_to='https://www.imdb.com/title/tt0021577/' or el_to='https://www.imdb.com/title/tt0825236/' or el_to='https://www.imdb.com/title/tt8615822/' or el_to='https://www.imdb.com/title/tt0397619/' or el_to='https://www.imdb.com/title/tt5133308/' or el_to='https://www.imdb.com/title/tt1311060/' or el_to='https://www.imdb.com/title/tt6101820/' or el_to='https://www.imdb.com/title/tt7318202/' or el_to='https://www.imdb.com/title/tt0113537/' or el_to='https://www.imdb.com/title/tt0256276/' or el_to='https://www.imdb.com/title/tt0080310/' or el_to='https://www.imdb.com/title/tt2459156/' or el_to='https://www.imdb.com/title/tt7670212/' or el_to='https://www.imdb.com/title/tt3646462/' or el_to='https://www.imdb.com/title/tt0964185/' or el_to='https://www.imdb.com/title/tt9625664/' or el_to='https://www.imdb.com/title/tt1264904/' or el_to='https://www.imdb.com/title/tt3622120/' or el_to='https://www.imdb.com/title/tt4163020/' or el_to='https://www.imdb.com/title/tt1836808/' or el_to='https://www.imdb.com/title/tt4157728/' or el_to='https://www.imdb.com/title/tt2883434/' or el_to='https://www.imdb.com/title/tt1667355/' or el_to='https://www.imdb.com/title/tt1558877/' or el_to='https://www.imdb.com/title/tt1629715/' or el_to='https://www.imdb.com/title/tt3702996/' or el_to='https://www.imdb.com/title/tt2376218/' or el_to='https://www.imdb.com/title/tt1632547/' or el_to='https://www.imdb.com/title/tt1838603/' or el_to='https://www.imdb.com/title/tt1196956/' or el_to='https://www.imdb.com/title/tt2064968/' or el_to='https://www.imdb.com/title/tt1661820/' or el_to='https://www.imdb.com/title/tt1133991/' or el_to='https://www.imdb.com/title/tt2505294/' or el_to='https://www.imdb.com/title/tt6474040/' or el_to='https://www.imdb.com/title/tt0485510/' or el_to='https://www.imdb.com/title/tt0252591/' or el_to='https://www.imdb.com/title/tt5563324/' or el_to='https://www.imdb.com/title/tt0083642/' or el_to='https://www.imdb.com/title/tt2707858/' or el_to='https://www.imdb.com/title/tt0276830/' or el_to='https://www.imdb.com/title/tt10739666/' or el_to='https://www.imdb.com/title/tt2077851/' or el_to='https://www.imdb.com/title/tt8465676/' or el_to='https://www.imdb.com/title/tt8400758/' or el_to='https://www.imdb.com/title/tt7806998/' or el_to='https://www.imdb.com/title/tt0120882/' or el_to='https://www.imdb.com/title/tt2314824/' or el_to='https://www.imdb.com/title/tt4558376/' or el_to='https://www.imdb.com/title/tt0113347/' or el_to='https://www.imdb.com/title/tt0420901/' or el_to='https://www.imdb.com/title/tt7209472/' or el_to='https://www.imdb.com/title/tt2180994/' or el_to='https://www.imdb.com/title/tt0473356/' or el_to='https://www.imdb.com/title/tt1757742/' or el_to='https://www.imdb.com/title/tt0468094/' or el_to='https://www.imdb.com/title/tt2271563/' or el_to='https://www.imdb.com/title/tt0853153/' or el_to='https://www.imdb.com/title/tt4107858/' or el_to='https://www.imdb.com/title/tt0110917/' or el_to='https://www.imdb.com/title/tt1523486/' or el_to='https://www.imdb.com/title/tt0053793/' or el_to='https://www.imdb.com/title/tt1741243/' or el_to='https://www.imdb.com/title/tt1837636/' or el_to='https://www.imdb.com/title/tt1674773/' or el_to='https://www.imdb.com/title/tt4419364/' or el_to='https://www.imdb.com/title/tt0290212/' or el_to='https://www.imdb.com/title/tt1427298/' or el_to='https://www.imdb.com/title/tt3210258/' or el_to='https://www.imdb.com/title/tt9500372/' or el_to='https://www.imdb.com/title/tt0427582/' or el_to='https://www.imdb.com/title/tt0086450/' or el_to='https://www.imdb.com/title/tt4309356/' or el_to='https://www.imdb.com/title/tt3107166/' or el_to='https://www.imdb.com/title/tt5751998/' or el_to='https://www.imdb.com/title/tt2690138/' or el_to='https://www.imdb.com/title/tt1680136/' or el_to='https://www.imdb.com/title/tt0765833/' or el_to='https://www.imdb.com/title/tt5616294/' or el_to='https://www.imdb.com/title/tt1760967/' or el_to='https://www.imdb.com/title/tt4180560/' or el_to='https://www.imdb.com/title/tt1521848/' or el_to='https://www.imdb.com/title/tt1173687/' or el_to='https://www.imdb.com/title/tt1465533/' or el_to='https://www.imdb.com/title/tt8108268/' or el_to='https://www.imdb.com/title/tt3859310/' or el_to='https://www.imdb.com/title/tt6609088/' or el_to='https://www.imdb.com/title/tt2150209/' or el_to='https://www.imdb.com/title/tt0252619/' or el_to='https://www.imdb.com/title/tt1075110/' or el_to='https://www.imdb.com/title/tt1781058/' or el_to='https://www.imdb.com/title/tt2095605/' or el_to='https://www.imdb.com/title/tt1859522/' or el_to='https://www.imdb.com/title/tt0286261/' or el_to='https://www.imdb.com/title/tt0281820/' or el_to='https://www.imdb.com/title/tt8743064/' or el_to='https://www.imdb.com/title/tt10741542/' or el_to='https://www.imdb.com/title/tt0139362/' or el_to='https://www.imdb.com/title/tt0383846/' or el_to='https://www.imdb.com/title/tt5334704/' or el_to='https://www.imdb.com/title/tt0063555/' or el_to='https://www.imdb.com/title/tt7209510/' or el_to='https://www.imdb.com/title/tt5208216/' or el_to='https://www.imdb.com/title/tt7476116/' or el_to='https://www.imdb.com/title/tt10847306/' or el_to='https://www.imdb.com/title/tt1555093/' or el_to='https://www.imdb.com/title/tt2261749/' or el_to='https://www.imdb.com/title/tt3013602/' or el_to='https://www.imdb.com/title/tt1181614/' or el_to='https://www.imdb.com/title/tt11213372/' or el_to='https://www.imdb.com/title/tt0330243/' or el_to='https://www.imdb.com/title/tt0127311/' or el_to='https://www.imdb.com/title/tt1687281/' or el_to='https://www.imdb.com/title/tt0090570/' or el_to='https://www.imdb.com/title/tt1347521/' or el_to='https://www.imdb.com/title/tt0300214/' or el_to='https://www.imdb.com/title/tt4114744/' or el_to='https://www.imdb.com/title/tt2011276/' or el_to='https://www.imdb.com/title/tt0787470/' or el_to='https://www.imdb.com/title/tt2290553/' or el_to='https://www.imdb.com/title/tt2905772/' or el_to='https://www.imdb.com/title/tt0796368/' or el_to='https://www.imdb.com/title/tt1901040/' or el_to='https://www.imdb.com/title/tt0251654/' or el_to='https://www.imdb.com/title/tt0253991/' or el_to='https://www.imdb.com/title/tt1176251/' or el_to='https://www.imdb.com/title/tt0430651/' or el_to='https://www.imdb.com/title/tt0237993/' or el_to='https://www.imdb.com/title/tt10895556/' or el_to='https://www.imdb.com/title/tt2544766/' or el_to='https://www.imdb.com/title/tt6792282/' or el_to='https://www.imdb.com/title/tt0100112/' or el_to='https://www.imdb.com/title/tt1309000/' or el_to='https://www.imdb.com/title/tt2186812/' or el_to='https://www.imdb.com/title/tt0171359/' or el_to='https://www.imdb.com/title/tt0077215/' or el_to='https://www.imdb.com/title/tt0361309/' or el_to='https://www.imdb.com/title/tt0926759/' or el_to='https://www.imdb.com/title/tt9592496/' or el_to='https://www.imdb.com/title/tt5711148/' or el_to='https://www.imdb.com/title/tt10885444/' or el_to='https://www.imdb.com/title/tt0116581/' or el_to='https://www.imdb.com/title/tt4911940/' or el_to='https://www.imdb.com/title/tt0216986/' or el_to='https://www.imdb.com/title/tt2082180/' or el_to='https://www.imdb.com/title/tt7279188/' or el_to='https://www.imdb.com/title/tt4986134/' or el_to='https://www.imdb.com/title/tt9185066/' or el_to='https://www.imdb.com/title/tt4621872/' or el_to='https://www.imdb.com/title/tt3780500/' or el_to='https://www.imdb.com/title/tt10515086/' or el_to='https://www.imdb.com/title/tt0084488/' or el_to='https://www.imdb.com/title/tt14217100/' or el_to='https://www.imdb.com/title/tt10993566/' or el_to='https://www.imdb.com/title/tt0169590/' or el_to='https://www.imdb.com/title/tt4366830/') and page_namespace = 0) as T
JOIN externallinks
ON T.page_id = el_from
GROUP BY el_from 
order by T.imdb_link
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...
