Most popular XKCD links

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)

Ask Ubuntu

Q&A for Ubuntu users and developers

-- Most popular XKCD links
-- 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)

SELECT
  SUBSTRING(Text, 7, 100) AS ComicNumber,
  count(*)
FROM Comments
WHERE Text like '%xkcd.com/%'
GROUP BY SUBSTRING(Text, 7, 100)

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results