oracle8.1.6 select name, mp.playlist_id, nvl(sc.songs,0) as songs from acs_objects, mp3_playlists mp, mp3_playlist_song_count sc where object_id = mp.playlist_id and context_id = :package_id and mp.playlist_id = sc.playlist_id(+) order by name 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 > sysdate - 1 order by creation_date desc) where rownum < 10