gistfile1.sql

select root_id from jrridley_circlenew.post where root_id > 0 group by root_id order by count(root_id) DESC, create_date AS a INNER JOIN
(select p.post_id, group_id, parent_id, root_id, concat(u.first_name, ' ' , u.last_name), p.title, content, create_date from jrridley_circlenew.post p inner join jrridley_circlenew.users u on p.user_id = u.user_id)as b on a.post_id = b.post_id;