Q&A about the site for people organizing, marketing or licensing open source development projects
DECLARE @SiteUrl VARCHAR(MAX) SET @SiteUrl = ( SELECT 'https://' + CASE WHEN DB_NAME() = 'StackOverflow' THEN 'stackoverflow' WHEN DB_NAME() = 'ServerFault' THEN 'serverfault' WHEN DB_NAME() = 'SuperUser' THEN 'superuser' WHEN DB_NAME() LIKE 'StackExchange.%%' THEN REPLACE(DB_NAME(), 'StackExchange.', '') ELSE 'stackexchange' -- Default or if it doesn't match anything specific END + '.stackexchange.com/q/' ) SELECT q.Id AS QuestionId, q.Title AS QuestionTitle, q.ViewCount AS ViewCount, CONCAT(LOWER(@SiteUrl), q.Id) AS QuestionURL FROM Posts a JOIN Posts q ON a.ParentId = q.Id WHERE a.PostTypeId = 2 -- This denotes an Answer AND a.OwnerUserId = ##UserId:int## ORDER BY q.ViewCount DESC