Q&A for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment
SELECT TOP 1000
CreationDate, ShorteningService, id AS [Post Link]
WHEN LOWER(body) LIKE '%tinypic.com%' THEN 'TinyPic'
END AS ShorteningService
WHERE ShorteningService IS NOT NULL
ORDER BY CreationDate DESC