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

0

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 a.id as ID,q.title as Title,len(a.body) as Length from posts a,posts q where a.parentid = q.id and a.owneruserid in (select id from users where displayname=@displayname) order by len(a.body) desc

Enter Parameters

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