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

-- 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)

fork query

created feb 8 11 Renesis