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/tt1675434/' or el_to='https://www.imdb.com/title/tt0107048/' or el_to='https://www.imdb.com/title/tt1535108/' or el_to='https://www.imdb.com/title/tt0056172/' or el_to='https://www.imdb.com/title/tt0914798/' or el_to='https://www.imdb.com/title/tt0339291/' or el_to='https://www.imdb.com/title/tt1340800/' or el_to='https://www.imdb.com/title/tt0080455/' or el_to='https://www.imdb.com/title/tt0449010/' or el_to='https://www.imdb.com/title/tt12801262/' or el_to='https://www.imdb.com/title/tt0376136/' or el_to='https://www.imdb.com/title/tt1083452/' or el_to='https://www.imdb.com/title/tt0403702/' or el_to='https://www.imdb.com/title/tt0970452/' or el_to='https://www.imdb.com/title/tt6977338/' or el_to='https://www.imdb.com/title/tt1014763/' or el_to='https://www.imdb.com/title/tt7668842/' or el_to='https://www.imdb.com/title/tt0460989/' or el_to='https://www.imdb.com/title/tt0363226/' or el_to='https://www.imdb.com/title/tt5116302/' or el_to='https://www.imdb.com/title/tt0112453/' or el_to='https://www.imdb.com/title/tt1730768/' or el_to='https://www.imdb.com/title/tt0093507/' or el_to='https://www.imdb.com/title/tt7221896/' or el_to='https://www.imdb.com/title/tt0118636/' or el_to='https://www.imdb.com/title/tt3922798/' 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/tt0471041/' or el_to='https://www.imdb.com/title/tt6990206/' or el_to='https://www.imdb.com/title/tt0410764/' or el_to='https://www.imdb.com/title/tt0458413/' or el_to='https://www.imdb.com/title/tt0160009/' or el_to='https://www.imdb.com/title/tt0813980/' or el_to='https://www.imdb.com/title/tt4995776/' or el_to='https://www.imdb.com/title/tt7748244/' or el_to='https://www.imdb.com/title/tt0104850/' or el_to='https://www.imdb.com/title/tt1326972/' or el_to='https://www.imdb.com/title/tt2170667/' or el_to='https://www.imdb.com/title/tt0078875/' or el_to='https://www.imdb.com/title/tt6910020/' or el_to='https://www.imdb.com/title/tt14878948/' or el_to='https://www.imdb.com/title/tt10230426/' or el_to='https://www.imdb.com/title/tt0112857/' or el_to='https://www.imdb.com/title/tt0252490/' or el_to='https://www.imdb.com/title/tt0315642/' or el_to='https://www.imdb.com/title/tt7363104/' or el_to='https://www.imdb.com/title/tt0087892/' 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/tt0034167/' or el_to='https://www.imdb.com/title/tt0085474/' or el_to='https://www.imdb.com/title/tt7832124/' or el_to='https://www.imdb.com/title/tt2955316/' or el_to='https://www.imdb.com/title/tt3477064/' or el_to='https://www.imdb.com/title/tt0879843/' or el_to='https://www.imdb.com/title/tt9675274/' or el_to='https://www.imdb.com/title/tt3517870/' or el_to='https://www.imdb.com/title/tt6916362/' or el_to='https://www.imdb.com/title/tt1801051/' or el_to='https://www.imdb.com/title/tt0060934/' or el_to='https://www.imdb.com/title/tt1260502/' or el_to='https://www.imdb.com/title/tt8907992/' 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/tt5075662/' or el_to='https://www.imdb.com/title/tt0397619/' or el_to='https://www.imdb.com/title/tt5229228/' or el_to='https://www.imdb.com/title/tt13109952/' 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/tt1865569/' or el_to='https://www.imdb.com/title/tt0829297/' or el_to='https://www.imdb.com/title/tt6745550/' or el_to='https://www.imdb.com/title/tt0485510/' or el_to='https://www.imdb.com/title/tt6648926/' or el_to='https://www.imdb.com/title/tt0276830/' or el_to='https://www.imdb.com/title/tt7806998/' or el_to='https://www.imdb.com/title/tt5159414/' or el_to='https://www.imdb.com/title/tt1421373/' or el_to='https://www.imdb.com/title/tt2749296/' 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/tt2524674/' or el_to='https://www.imdb.com/title/tt9124428/' or el_to='https://www.imdb.com/title/tt0853153/' or el_to='https://www.imdb.com/title/tt6649108/' or el_to='https://www.imdb.com/title/tt8075016/' or el_to='https://www.imdb.com/title/tt1390535/' or el_to='https://www.imdb.com/title/tt9500372/' or el_to='https://www.imdb.com/title/tt0071935/' or el_to='https://www.imdb.com/title/tt8402090/' or el_to='https://www.imdb.com/title/tt5235348/' or el_to='https://www.imdb.com/title/tt1190722/' or el_to='https://www.imdb.com/title/tt3584496/' 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/tt6149154/' or el_to='https://www.imdb.com/title/tt6616074/' or el_to='https://www.imdb.com/title/tt7807000/' 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/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/tt0470833/' or el_to='https://www.imdb.com/title/tt1532958/' or el_to='https://www.imdb.com/title/tt0169590/') 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...
