Extract threads only

[Dave]

Just wrap the from_unixtime function around the dateline column.

SELECT thread.title, post.pagetext, from_unixtime(thread.dateline) AS date
FROM thread
INNER JOIN post ON thread.firstpostid = post.postid