amarok: [CollectionDB] Query-start: SELECT DISTINCT artist.name FROM tags LEFT JOIN artist ON artist.id=tags.artist LEFT JOIN statistics ON statistics.url=tags.url AND statistics.deviceid = tags.deviceid WHERE 1 AND ( 0 OR ( COALESCE(statistics.rating,0) = '8' ) ) AND tags.sampler = 0 AND tags.deviceid IN (1,2,12,-1) ORDER BY LOWER( artist.name ) ;
amarok: [CollectionDB] SQL-query (0.19s): SELECT DISTINCT artist.name FROM tags LEFT JOIN artist ON artist.id=tags.artist LEFT JOIN statistics ON statistics.url=tags.url AND statistics.deviceid = tags.deviceid WHERE 1 AND ( 0 OR ( COALESCE(statistics.rating,0) = '8' ) ) AND tags.sampler = 0 AND tags.deviceid IN (1,2,12,-1) ORDER BY LOWER( artist.name ) ;
amarok: [CollectionDB] Query-start: SELECT DISTINCT artist.name FROM tags LEFT JOIN artist ON artist.id=tags.artist LEFT JOIN statistics ON statistics.url=tags.url AND statistics.deviceid = tags.deviceid WHERE 1 AND ( 0 OR ( COALESCE(statistics.rating,0) = '8' ) ) AND tags.sampler = 1 AND tags.deviceid IN (1,2,12,-1) LIMIT 1 OFFSET 0 ;
amarok: [CollectionDB] SQL-query (0.01s): SELECT DISTINCT artist.name FROM tags LEFT JOIN artist ON artist.id=tags.artist LEFT JOIN statistics ON statistics.url=tags.url AND statistics.deviceid = tags.deviceid WHERE 1 AND ( 0 OR ( COALESCE(statistics.rating,0) = '8' ) ) AND tags.sampler = 1 AND tags.deviceid IN (1,2,12,-1) LIMIT 1 OFFSET 0 ;