SELECT DISTINCT
                forum_topics.topic_id,
                forum_topics.plid,
                forum_topics.subject,
                UNIX_TIMESTAMP(forum_posts.date) AS dateposted,
                forum_posts.plid
        FROM 
                forum_topics
                INNER JOIN 
                forum_posts
        ON
                forum_topics.topic_id = forum_posts.topic_id 
        WHERE
                forum_topics.forum_id=0
                AND forum_topics.sub_id=0
                AND forum_topics.sticky=0
        ORDER BY 
                dateposted DESC