SELECT DISTINCT
`forum_topics`.`forum_id`,
`forum_topics`.`topic`,
`forum_topics`.`date`,
`forum_topics`.`views`,
`forum_topics`.`id`
FROM
`forum_topics`
JOIN `forum_posts` ON (`forum_topics`.`id` = `forum_posts`.`topic_id`)
ORDER BY
`forum_posts`.`date` DESC
SELECT DISTINCT
ft.id,
ft.topic,
ft.date_posted,
ft.views,
ft.forum_id
FROM
forum_topics as ft
JOIN forum_posts as fp
ON ft.id = fp.topic_id
GROUP BY ft.id
ORDER BY fp.date_posted DESC