Need moar tags

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

SELECT
    q.Id AS [Post Link],
    q.Score AS [Question Score],
    q.Tags,
    TagCount,
    a.Score AS [Answer Score],
    a.CreationDate AS [Answer Date]
FROM Posts AS a
INNER JOIN Posts AS q ON a.ParentId = q.Id
CROSS APPLY (
    SELECT COUNT(*) AS TagCount
    FROM PostTags
    WHERE PostTags.PostId = q.Id
) AS CA
WHERE a.OwnerUserId = ##UserId##
AND a.DeletionDate IS NULL
ORDER BY TagCount, a.Score, a.CreationDate

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results