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/tt1421373/' or el_to='https://www.imdb.com/title/tt0120882/' or el_to='https://www.imdb.com/title/tt1287878/' or el_to='https://www.imdb.com/title/tt0060584/' or el_to='https://www.imdb.com/title/tt9817070/' or el_to='https://www.imdb.com/title/tt4084744/' or el_to='https://www.imdb.com/title/tt2749296/' or el_to='https://www.imdb.com/title/tt0052080/' or el_to='https://www.imdb.com/title/tt0115693/' or el_to='https://www.imdb.com/title/tt0105399/' or el_to='https://www.imdb.com/title/tt8433210/' or el_to='https://www.imdb.com/title/tt8456098/' or el_to='https://www.imdb.com/title/tt0097050/' or el_to='https://www.imdb.com/title/tt0098360/' or el_to='https://www.imdb.com/title/tt0078252/' or el_to='https://www.imdb.com/title/tt0306734/' or el_to='https://www.imdb.com/title/tt9124428/' or el_to='https://www.imdb.com/title/tt0090667/' or el_to='https://www.imdb.com/title/tt1757742/' or el_to='https://www.imdb.com/title/tt3541262/' or el_to='https://www.imdb.com/title/tt5979872/' or el_to='https://www.imdb.com/title/tt11127690/' or el_to='https://www.imdb.com/title/tt2852400/' or el_to='https://www.imdb.com/title/tt0456470/' or el_to='https://www.imdb.com/title/tt0052151/' or el_to='https://www.imdb.com/title/tt0085327/' or el_to='https://www.imdb.com/title/tt0485323/' or el_to='https://www.imdb.com/title/tt0053270/' or el_to='https://www.imdb.com/title/tt6649108/' or el_to='https://www.imdb.com/title/tt1565958/' or el_to='https://www.imdb.com/title/tt5700224/' or el_to='https://www.imdb.com/title/tt10208198/' or el_to='https://www.imdb.com/title/tt6523720/' or el_to='https://www.imdb.com/title/tt2495118/' or el_to='https://www.imdb.com/title/tt0329388/' or el_to='https://www.imdb.com/title/tt1123373/' or el_to='https://www.imdb.com/title/tt13045890/' or el_to='https://www.imdb.com/title/tt5207158/' or el_to='https://www.imdb.com/title/tt8075016/' or el_to='https://www.imdb.com/title/tt2571140/' or el_to='https://www.imdb.com/title/tt9500372/' or el_to='https://www.imdb.com/title/tt4309356/' or el_to='https://www.imdb.com/title/tt0149601/' or el_to='https://www.imdb.com/title/tt0092906/' or el_to='https://www.imdb.com/title/tt0103950/' or el_to='https://www.imdb.com/title/tt0765833/' or el_to='https://www.imdb.com/title/tt2952602/' or el_to='https://www.imdb.com/title/tt0077914/' or el_to='https://www.imdb.com/title/tt8402090/' or el_to='https://www.imdb.com/title/tt4375438/' or el_to='https://www.imdb.com/title/tt8009744/' or el_to='https://www.imdb.com/title/tt0070842/' or el_to='https://www.imdb.com/title/tt7601480/' or el_to='https://www.imdb.com/title/tt4065552/' or el_to='https://www.imdb.com/title/tt5294966/' or el_to='https://www.imdb.com/title/tt0142236/' or el_to='https://www.imdb.com/title/tt0783532/' or el_to='https://www.imdb.com/title/tt0060277/' 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/tt0077288/' or el_to='https://www.imdb.com/title/tt5235348/' or el_to='https://www.imdb.com/title/tt10534500/' or el_to='https://www.imdb.com/title/tt0252619/' or el_to='https://www.imdb.com/title/tt1268987/' or el_to='https://www.imdb.com/title/tt0018737/' or el_to='https://www.imdb.com/title/tt0099426/' or el_to='https://www.imdb.com/title/tt0142242/' or el_to='https://www.imdb.com/title/tt0324197/' or el_to='https://www.imdb.com/title/tt1314652/' or el_to='https://www.imdb.com/title/tt1190722/' or el_to='https://www.imdb.com/title/tt0061369/' or el_to='https://www.imdb.com/title/tt4370784/' or el_to='https://www.imdb.com/title/tt1533117/' or el_to='https://www.imdb.com/title/tt5221894/' or el_to='https://www.imdb.com/title/tt0058567/' or el_to='https://www.imdb.com/title/tt1838571/' or el_to='https://www.imdb.com/title/tt1913166/' or el_to='https://www.imdb.com/title/tt1456661/' or el_to='https://www.imdb.com/title/tt0054821/' or el_to='https://www.imdb.com/title/tt0063555/' or el_to='https://www.imdb.com/title/tt0056512/' or el_to='https://www.imdb.com/title/tt0449851/' or el_to='https://www.imdb.com/title/tt0090930/' or el_to='https://www.imdb.com/title/tt1805297/' or el_to='https://www.imdb.com/title/tt2036416/' or el_to='https://www.imdb.com/title/tt4769824/' or el_to='https://www.imdb.com/title/tt2261749/' or el_to='https://www.imdb.com/title/tt0765458/' or el_to='https://www.imdb.com/title/tt5114588/' or el_to='https://www.imdb.com/title/tt2468774/' or el_to='https://www.imdb.com/title/tt0434008/' or el_to='https://www.imdb.com/title/tt4991384/' or el_to='https://www.imdb.com/title/tt0804507/' or el_to='https://www.imdb.com/title/tt0094357/' or el_to='https://www.imdb.com/title/tt0092501/' or el_to='https://www.imdb.com/title/tt2330866/' or el_to='https://www.imdb.com/title/tt2165735/' or el_to='https://www.imdb.com/title/tt1059925/' or el_to='https://www.imdb.com/title/tt3169770/' or el_to='https://www.imdb.com/title/tt0108281/' or el_to='https://www.imdb.com/title/tt0127311/' or el_to='https://www.imdb.com/title/tt3584496/' or el_to='https://www.imdb.com/title/tt1869470/' or el_to='https://www.imdb.com/title/tt0425079/' or el_to='https://www.imdb.com/title/tt2358911/' or el_to='https://www.imdb.com/title/tt0096461/' or el_to='https://www.imdb.com/title/tt6736782/' or el_to='https://www.imdb.com/title/tt2010914/' or el_to='https://www.imdb.com/title/tt5082014/' or el_to='https://www.imdb.com/title/tt8160834/' or el_to='https://www.imdb.com/title/tt2905772/' or el_to='https://www.imdb.com/title/tt0374345/' or el_to='https://www.imdb.com/title/tt1531924/' or el_to='https://www.imdb.com/title/tt6616074/' or el_to='https://www.imdb.com/title/tt0082700/' or el_to='https://www.imdb.com/title/tt5813366/' or el_to='https://www.imdb.com/title/tt2599716/' or el_to='https://www.imdb.com/title/tt0105839/' or el_to='https://www.imdb.com/title/tt0367913/' or el_to='https://www.imdb.com/title/tt4552524/' or el_to='https://www.imdb.com/title/tt7807000/' or el_to='https://www.imdb.com/title/tt0377309/' or el_to='https://www.imdb.com/title/tt1043842/' or el_to='https://www.imdb.com/title/tt0093978/' or el_to='https://www.imdb.com/title/tt0387541/' or el_to='https://www.imdb.com/title/tt0190524/' or el_to='https://www.imdb.com/title/tt0088461/' or el_to='https://www.imdb.com/title/tt1954598/' or el_to='https://www.imdb.com/title/tt4914580/' or el_to='https://www.imdb.com/title/tt0996605/' or el_to='https://www.imdb.com/title/tt3921314/' or el_to='https://www.imdb.com/title/tt2358913/' or el_to='https://www.imdb.com/title/tt3108244/' or el_to='https://www.imdb.com/title/tt0429078/' or el_to='https://www.imdb.com/title/tt13423846/' or el_to='https://www.imdb.com/title/tt4809458/' or el_to='https://www.imdb.com/title/tt7851428/' or el_to='https://www.imdb.com/title/tt1663321/' or el_to='https://www.imdb.com/title/tt0470833/' or el_to='https://www.imdb.com/title/tt0408017/' or el_to='https://www.imdb.com/title/tt2082180/' or el_to='https://www.imdb.com/title/tt1650407/' or el_to='https://www.imdb.com/title/tt0479651/' or el_to='https://www.imdb.com/title/tt0330994/' or el_to='https://www.imdb.com/title/tt0267351/' or el_to='https://www.imdb.com/title/tt9794630/') 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...
