1234 SELECT DISTINCT *, UNIX_TIMESTAMP(post.date) FROM rootpost, `post` WHERE rootpost.object=1 AND post.id=rootpost.caption unchecked=0 ORDER BY date DESC LIMIT 0,50