Quote:
Originally posted by extreme
Uhm ...
... LEFT JOIN votes ON votes.code = update_info.code ... ?
|
seems about right to me

would give the following query:
SELECT update_info.code, update_info.collection, update_info.short_name, UNIX_TIMESTAMP(update_info.date_start) AS date_start, update_info.total_votes, update_info.total_score, votes.ip_address
FROM update_info
LEFT JOIN votes ON votes.code = update_info.code
WHERE date_start < now( )
ORDER BY date_start DESC
LIMIT 2 , 2;