select name, mp.playlist_id, coalesce(sc.songs,0) as songs from acs_objects join mp3_playlists mp on (object_id = mp.playlist_id) left join mp3_playlist_song_count sc using (playlist_id) where context_id = :package_id order by name