You are reading a single comment by @rhowe and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@rhowe
select
username,
count(*) as numposts
from
posts p
inner join
users u
on
p.userid = u.id
where
p.id = 123456 and p.created > '5-aug-2011'
group by
u.id
order by
numposts desc