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)