abzde

     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