at512

<?xml version="1.0" encoding="utf-8"?>
<category isOpen="true" product="Amarok" version="1.4-SVN" formatversion="1.6" name="Smart Playlists" >
 <smartplaylist name="Untitled" >
  <matches glue="OR" >
   <criteria field="artist.name" condition="contains" >
    <value>bob</value>
   </criteria>
  </matches>
  <sqlquery>SELECT album.name, artist.name, genre.name, tags.title, year.name, tags.comment, tags.track, tags.bitrate, tags.discnumber, tags.length, tags.samplerate, tags.filesize, tags.url, tags.sampler FROM tags LEFT JOIN year ON year.id=tags.year
LEFT JOIN genre ON genre.id=tags.genre LEFT JOIN artist ON artist.id=tags.artist LEFT JOIN album ON album.id=tags.album WHERE ( (artist.name LIKE '%bob%' ESCAPE '/' ) );</sqlquery>
 </smartplaylist>
 <smartplaylist name="ny" >
  <matches glue="OR" >
   <criteria field="artist.name" condition="contains" >
    <value>Neil Young</value>
   </criteria>
  </matches>
  <orderby field="statistics.playcounter" order="DESC" />
  <sqlquery>SELECT album.name, artist.name, genre.name, tags.title, year.name, tags.comment, tags.track, tags.bitrate, tags.discnumber, tags.length, tags.samplerate, tags.filesize, tags.url, tags.sampler, tags.filetype, tags.composer FROM tags LEFT JOIN year ON year.id=tags.year LEFT JOIN genre ON genre.id=tags.genre LEFT JOIN artist ON artist.id=tags.artist LEFT JOIN album ON album.id=tags.album LEFT JOIN statistics ON statistics.url=tags.url WHERE ( (artist.name LIKE '%Neil Young%' ESCAPE '/'
) ) ORDER BY statistics.playcounter DESC;</sqlquery>
 </smartplaylist>
 <default isOpen="true" type="smartplaylist" />
</category>