0

Please login or register to vote for this query.

(click on this box to dismiss)

A better version (based heavily on http://data.stackexchange.com/serverfault/s/915/most-popular-xkcd-links). Now supports four-digit comic numbers!

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

-- Improved XKCD Finder 
-- A better version
SELECT
  SUBSTRING(C.Text, 
    CHARINDEX('xkcd.com/', C.Text) + 9,
    3
  ) AS CommentComicNumber, 'http://xkcd.com/' + SUBSTRING(C.Text,CHARINDEX('xkcd.com/',C.Text) + 9,3),
  count(*) AS CommentCount
  
FROM Comments as C
WHERE C.Text like '%xkcd.com/%'
GROUP BY 
  SUBSTRING(C.Text,
    CHARINDEX('xkcd.com/', C.Text) + 9,
    3
  )
ORDER BY count(*) DESC;

view current version

edited feb 9 11

created feb 9 11 tom