<?xml version="1.0"?>

<queryset>
   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>

<fullquery name="playlist_info">      
      <querytext>
      
    select name, remove_threshold, nvl(sc.songs,0) as songs, mp.playlist_id
     from mp3_playlists mp,
          mp3_playlist_song_count sc
     where mp.playlist_id=:playlist_id
     and   sc.playlist_id(+) = mp.playlist_id

      </querytext>
</fullquery>

 
</queryset>