Stuff

SELECT 
	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 
ORDER BY 
	dateposted