[magic]

select object.*,comments.f_id, count(comments.f_id) as number from comments,object where object.f_id = comments.f_id group by comments.f_id ORDER by number desc;

men jag är ingen SQL kung, hoppas den stämmer.