0

Please login or register to vote for this query.

(click on this box to dismiss)

List all the links to XKCD posts with counts of how many times that is linked (guessing that the most will be xkcd.com/386)

Q&A for Ubuntu users and developers

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

fork query

created feb 8 11 Renesis