Untitled query #60538

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/tt0111161/' or el_to='https://www.imdb.com/title/tt0468569/' or el_to='https://www.imdb.com/title/tt1375666/' or el_to='https://www.imdb.com/title/tt0137523/' or el_to='https://www.imdb.com/title/tt0109830/' or el_to='https://www.imdb.com/title/tt0110912/' or el_to='https://www.imdb.com/title/tt0133093/' or el_to='https://www.imdb.com/title/tt0120737/' or el_to='https://www.imdb.com/title/tt0167260/' or el_to='https://www.imdb.com/title/tt0068646/' or el_to='https://www.imdb.com/title/tt0816692/' or el_to='https://www.imdb.com/title/tt1345836/' or el_to='https://www.imdb.com/title/tt0167261/' or el_to='https://www.imdb.com/title/tt0114369/' or el_to='https://www.imdb.com/title/tt1853728/' or el_to='https://www.imdb.com/title/tt0172495/' or el_to='https://www.imdb.com/title/tt0372784/' or el_to='https://www.imdb.com/title/tt0361748/' or el_to='https://www.imdb.com/title/tt0102926/' or el_to='https://www.imdb.com/title/tt0848228/' or el_to='https://www.imdb.com/title/tt0120815/' or el_to='https://www.imdb.com/title/tt0076759/' or el_to='https://www.imdb.com/title/tt0993846/' or el_to='https://www.imdb.com/title/tt0108052/' or el_to='https://www.imdb.com/title/tt0482571/' or el_to='https://www.imdb.com/title/tt0407887/' or el_to='https://www.imdb.com/title/tt0120689/' or el_to='https://www.imdb.com/title/tt0080684/' or el_to='https://www.imdb.com/title/tt1130884/' or el_to='https://www.imdb.com/title/tt0071562/' or el_to='https://www.imdb.com/title/tt0209144/' or el_to='https://www.imdb.com/title/tt0499549/' or el_to='https://www.imdb.com/title/tt0088763/' or el_to='https://www.imdb.com/title/tt0169547/' or el_to='https://www.imdb.com/title/tt2015381/' or el_to='https://www.imdb.com/title/tt0120338/' or el_to='https://www.imdb.com/title/tt7286456/' or el_to='https://www.imdb.com/title/tt0110413/' or el_to='https://www.imdb.com/title/tt0099685/' or el_to='https://www.imdb.com/title/tt0434409/' or el_to='https://www.imdb.com/title/tt0120586/' or el_to='https://www.imdb.com/title/tt0266697/' or el_to='https://www.imdb.com/title/tt0910970/' or el_to='https://www.imdb.com/title/tt0325980/' or el_to='https://www.imdb.com/title/tt0103064/' or el_to='https://www.imdb.com/title/tt0114814/' or el_to='https://www.imdb.com/title/tt0120382/' or el_to='https://www.imdb.com/title/tt0112573/' or el_to='https://www.imdb.com/title/tt0086190/' or el_to='https://www.imdb.com/title/tt0371746/' or el_to='https://www.imdb.com/title/tt0110357/' or el_to='https://www.imdb.com/title/tt0266543/' or el_to='https://www.imdb.com/title/tt1049413/' or el_to='https://www.imdb.com/title/tt4154796/' or el_to='https://www.imdb.com/title/tt0105236/' or el_to='https://www.imdb.com/title/tt1431045/' or el_to='https://www.imdb.com/title/tt0073486/' or el_to='https://www.imdb.com/title/tt0338013/' or el_to='https://www.imdb.com/title/tt0081505/' or el_to='https://www.imdb.com/title/tt0167404/' or el_to='https://www.imdb.com/title/tt4154756/' or el_to='https://www.imdb.com/title/tt1392190/' or el_to='https://www.imdb.com/title/tt0114709/' or el_to='https://www.imdb.com/title/tt0082971/' or el_to='https://www.imdb.com/title/tt2267998/' or el_to='https://www.imdb.com/title/tt0107290/' or el_to='https://www.imdb.com/title/tt0477348/' or el_to='https://www.imdb.com/title/tt0119217/' or el_to='https://www.imdb.com/title/tt0264464/' or el_to='https://www.imdb.com/title/tt2488496/' or el_to='https://www.imdb.com/title/tt0268978/' or el_to='https://www.imdb.com/title/tt1392170/' or el_to='https://www.imdb.com/title/tt0198781/' or el_to='https://www.imdb.com/title/tt0078748/' or el_to='https://www.imdb.com/title/tt0095016/' or el_to='https://www.imdb.com/title/tt0088247/' or el_to='https://www.imdb.com/title/tt1010048/' or el_to='https://www.imdb.com/title/tt0208092/' or el_to='https://www.imdb.com/title/tt1201607/' or el_to='https://www.imdb.com/title/tt1675434/' or el_to='https://www.imdb.com/title/tt3659388/' or el_to='https://www.imdb.com/title/tt0180093/' or el_to='https://www.imdb.com/title/tt2395427/' or el_to='https://www.imdb.com/title/tt1300854/' or el_to='https://www.imdb.com/title/tt1454468/' or el_to='https://www.imdb.com/title/tt0435761/' or el_to='https://www.imdb.com/title/tt0066921/' or el_to='https://www.imdb.com/title/tt0800369/' or el_to='https://www.imdb.com/title/tt0458339/' or el_to='https://www.imdb.com/title/tt1843866/' or el_to='https://www.imdb.com/title/tt0086250/' or el_to='https://www.imdb.com/title/tt0903624/' or el_to='https://www.imdb.com/title/tt0253474/' or el_to='https://www.imdb.com/title/tt2582802/' or el_to='https://www.imdb.com/title/tt0118715/' or el_to='https://www.imdb.com/title/tt0075314/' or el_to='https://www.imdb.com/title/tt0246578/' or el_to='https://www.imdb.com/title/tt1228705/' or el_to='https://www.imdb.com/title/tt0120915/' or el_to='https://www.imdb.com/title/tt0416449/' or 
el_to='https://www.imdb.com/title/tt0291172/' or el_to='https://www.imdb.com/title/tt0058672/' or el_to='https://www.imdb.com/title/tt0084370/' or el_to='https://www.imdb.com/title/tt0088748/' or el_to='https://www.imdb.com/title/tt1278449/' or el_to='https://www.imdb.com/title/tt0102900/' or el_to='https://www.imdb.com/title/tt2555958/' or el_to='https://www.imdb.com/title/tt0478813/' or el_to='https://www.imdb.com/title/tt4911940/' or el_to='https://www.imdb.com/title/tt1247662/' or el_to='https://www.imdb.com/title/tt0216986/' or el_to='https://www.imdb.com/title/tt0068156/' or el_to='https://www.imdb.com/title/tt0064110/' or el_to='https://www.imdb.com/title/tt0107612/' or el_to='https://www.imdb.com/title/tt0038988/' or el_to='https://www.imdb.com/title/tt9026184/' or el_to='https://www.imdb.com/title/tt8976576/' or el_to='https://www.imdb.com/title/tt3923662/' or el_to='https://www.imdb.com/title/tt0114272/' or el_to='https://www.imdb.com/title/tt0408017/' or el_to='https://www.imdb.com/title/tt1954206/' or el_to='https://www.imdb.com/title/tt7758160/' or el_to='https://www.imdb.com/title/tt0092534/' or el_to='https://www.imdb.com/title/tt0099512/' or el_to='https://www.imdb.com/title/tt2082180/' or el_to='https://www.imdb.com/title/tt0076245/' or el_to='https://www.imdb.com/title/tt0772168/' or el_to='https://www.imdb.com/title/tt0367478/' or el_to='https://www.imdb.com/title/tt7279188/' or el_to='https://www.imdb.com/title/tt2933474/' or el_to='https://www.imdb.com/title/tt0110823/' or el_to='https://www.imdb.com/title/tt1650407/' or el_to='https://www.imdb.com/title/tt0804505/' or el_to='https://www.imdb.com/title/tt8058874/' or el_to='https://www.imdb.com/title/tt0351461/' or el_to='https://www.imdb.com/title/tt1228953/' or el_to='https://www.imdb.com/title/tt0066516/' or el_to='https://www.imdb.com/title/tt2126362/' or el_to='https://www.imdb.com/title/tt0068278/' or el_to='https://www.imdb.com/title/tt0354356/' or el_to='https://www.imdb.com/title/tt0089110/' or el_to='https://www.imdb.com/title/tt0048696/' or el_to='https://www.imdb.com/title/tt1958043/' or el_to='https://www.imdb.com/title/tt0076489/' or el_to='https://www.imdb.com/title/tt0497323/' or el_to='https://www.imdb.com/title/tt0095304/' or el_to='https://www.imdb.com/title/tt2325977/' 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/tt0479651/' or el_to='https://www.imdb.com/title/tt2318527/' or el_to='https://www.imdb.com/title/tt0101985/' or el_to='https://www.imdb.com/title/tt0029811/' or el_to='https://www.imdb.com/title/tt0090274/' or el_to='https://www.imdb.com/title/tt10515086/' or el_to='https://www.imdb.com/title/tt0065446/' 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/tt0079100/' or el_to='https://www.imdb.com/title/tt7083526/' or el_to='https://www.imdb.com/title/tt6828390/' or el_to='https://www.imdb.com/title/tt1068956/' or el_to='https://www.imdb.com/title/tt0089748/' or el_to='https://www.imdb.com/title/tt0372334/' or el_to='https://www.imdb.com/title/tt0118647/' or el_to='https://www.imdb.com/title/tt8750570/' or el_to='https://www.imdb.com/title/tt0063671/' or el_to='https://www.imdb.com/title/tt0068309/' or el_to='https://www.imdb.com/title/tt10993566/' or el_to='https://www.imdb.com/title/tt0064793/' or el_to='https://www.imdb.com/title/tt4104022/' or el_to='https://www.imdb.com/title/tt0108442/' or el_to='https://www.imdb.com/title/tt3722614/' or el_to='https://www.imdb.com/title/tt1020055/' or el_to='https://www.imdb.com/title/tt0067900/' or el_to='https://www.imdb.com/title/tt0081207/' or el_to='https://www.imdb.com/title/tt0330994/' or el_to='https://www.imdb.com/title/tt10483386/' or el_to='https://www.imdb.com/title/tt1976989/' or el_to='https://www.imdb.com/title/tt1532958/' or el_to='https://www.imdb.com/title/tt0169590/' or el_to='https://www.imdb.com/title/tt0843326/' or el_to='https://www.imdb.com/title/tt1436559/' or el_to='https://www.imdb.com/title/tt0267351/' or el_to='https://www.imdb.com/title/tt0082498/' or el_to='https://www.imdb.com/title/tt0045920/' or el_to='https://www.imdb.com/title/tt0059575/' or el_to='https://www.imdb.com/title/tt0053085/' or el_to='https://www.imdb.com/title/tt0102802/' or el_to='https://www.imdb.com/title/tt1020543/' or el_to='https://www.imdb.com/title/tt1386925/' or el_to='https://www.imdb.com/title/tt0061584/' or el_to='https://www.imdb.com/title/tt9794630/' or el_to='https://www.imdb.com/title/tt3774802/' or el_to='https://www.imdb.com/title/tt1433207/' or el_to='https://www.imdb.com/title/tt0780583/' or el_to='https://www.imdb.com/title/tt4366830/' or el_to='https://www.imdb.com/title/tt0473024/' ) 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...
