postgresql7.1 select title, mp3_id, creation_date from (select title, mp3_id, creation_date from mp3_mp3s_not_deleted, acs_objects where mp3_id = object_id and creation_date > current_timestamp - 1 order by creation_date desc) nd limit 10