To find those that required a lot of work. :-)
Or a copy/paste. :-(
Q&A for administrators, end users, developers and designers for Craft CMS
-- The longest answers.
-- To find those that required a lot of work. :-)
-- Or a copy/paste. :-(
SELECT TOP 1000 Id AS [Post Link], OwnerUserId as [User Link], LEN(Body) AS Length, LastActivityDate AS [Last Activity Date] FROM Posts WHERE PostTypeId = 2 ORDER BY Length DESC