<?xml version="1.0"?>
<queryset>

<fullquery name="playlist_info">      
      <querytext>

	    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

      </querytext>
</fullquery>

 
</queryset>