0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users of Linux, FreeBSD and other Un*x-like operating systems

select 
p.id as [post link]
, p.title
, p.creationdate
from posts p
join posttags pt on p.id = pt.postid
join tags t on pt.tagid = t.id
group by 
p.id
, p.title
, p.creationdate
having count(t.id) >= 5 
order by p.creationdate desc;

fork query

created jul 16 anonymous