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<br>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'unchecked=0 ORDER BY date DESC LIMIT 0,50' at line 1