Q&A about the site for music historians, critics, and fans
SELECT E.Extension, COUNT(*) AS [Count] FROM ( SELECT TOP 50000 SUBSTRING( P.Body COLLATE Latin1_General_BIN, PATINDEX('%stack.imgur.com/[a-zA-Z0-9][a-zA-Z0-9][a-zA-Z0-9][a-zA-Z0-9][a-zA-Z0-9].%', P.Body COLLATE Latin1_General_BIN)+22, 3 ) AS Extension FROM Posts P WHERE PATINDEX('%stack.imgur.com/[a-zA-Z0-9][a-zA-Z0-9][a-zA-Z0-9][a-zA-Z0-9][a-zA-Z0-9].%', P.Body COLLATE Latin1_General_BIN) > 0 ) E GROUP BY E.Extension ORDER BY COUNT(*) DESC