Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS

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

-- Most Common Titles
-- find the most common question titles

select lower(title) as "Title", count(*) as "Count" from posts
where posttypeid = 1 --question
group by lower(title)
having count(*) > 2
order by "Count" desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results