DECLARE @displayname varchar(100) = '##displayname##' sel...


Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

DECLARE @displayname varchar(100) = '##displayname##'
--select len(@displayname),@displayname
--select * from users where displayname=@displayname
select top 10 as ID,q.title as Title,len(a.body) as Length from posts a,posts q where a.parentid = and a.owneruserid in (select id from users where displayname=@displayname) order by len(a.body) desc

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results