0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for administrators and users of the CiviCRM Constituent Relationship Management software

-- Stack Exchange requires that a title has at least 15 chars and
-- that bodies (q's and a's) have at least 30 chars so you can't
-- retrieve posts that have less than 12 chars

SELECT p.Id AS [Post Link], u.DisplayName, LEN(Title) AS [Title Length], p.Score, p.ViewCount, p.Tags
FROM Posts p
JOIN Users u ON u.Id = p.OwnerUserId
WHERE LEN(Title) <= 20
AND p.PostTypeId = 1
ORDER BY LEN(Title) DESC

fork query

created mar 7 CrSb0001