rnbox

select t.* from `topics` t, (select max(`date`), `topic_id` from `posts` where `user_id`='$user_id' group_by `topic_id` having max(`date`)) q where t.`id`=q.`topic_id` order by q.`date`