1234 SELECT DISTINCT *, UNIX_TIMESTAMP(quotetheme.date) FROM quotesquotetheme, `quotetheme` WHERE quotesquotetheme.object=1 AND quotetheme.id=quotesquotetheme.caption ORDER BY (porder) ASC