Untitled query #60747

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/tt7668842/' or el_to='https://www.imdb.com/title/tt7221896/' or el_to='https://www.imdb.com/title/tt6990206/' or el_to='https://www.imdb.com/title/tt0813980/' or el_to='https://www.imdb.com/title/tt7748244/' or el_to='https://www.imdb.com/title/tt2170667/' 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/tt0252490/' or el_to='https://www.imdb.com/title/tt4558362/' 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/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/tt5075662/' 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/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/tt6648926/' 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/tt9124428/' or el_to='https://www.imdb.com/title/tt6649108/' 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/tt7807000/' 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/tt0169590/') and page_namespace = 0) as T
JOIN externallinks
ON T.page_id = el_from
GROUP BY el_from 
order by T.imdb_link
SQL

Checking query status...
