Post comments referring to "homework" (last 30d) ... how effin rude some people are!

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

-- Second 'results' tab shows monthly totals.

select  text, creationdate, postid as [Post Link] 
from comments
where text like '%homework%'
and creationdate >= getDate()-30;


select format(creationdate,'yyyy-MM') YearMonth, count(*) cnt
from comments
where text like '%homework%'
and creationdate >= getDate()-30
group by format(creationdate,'yyyy-MM')
order by format(creationdate,'yyyy-MM') desc;

Enter Parameters

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