0

Please login or register to vote for this query.

(click on this box to dismiss)

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

declare @page int, @psize int;
set @page = ##page:int?1##;
set @psize = ##pagesize:int?5000000##

select
a.id as [Post Link], a.body, a.creationdate
from posts a
inner join posts q on a.parentid = q.id
inner join users u on a.owneruserid = u.id
where u.reputation < ##maxrep:int?50##
and a.posttypeid = 2  -- answers
and q.viewcount < ##viewlimit:int?1000##
and lower(a.body) like '%##query?find a solution?##%'
and a.id between (@page - 1) * @psize and @page * @psize
order by a.creationdate asc

view current version

edited jan 26 20

created jan 25 20 Martijn Pieters