cocobo

NORMAL:

amarok:       [CollectionDB] MYSQL QUERY: const QString& statement = SELECT statistics.rating FROM statistics  WHERE 1 AND ( 0 OR statistics.url = BINARY './Mp3/Film OST/Battle Royale OST/Battle Royale OST - Track  7.mp3' AND statistics.deviceid = 5  OR statistics.url = BINARY './mnt/filmdisk/Mp3/Film OST/Battle Royale OST/Battle Royale OST - Track  7.mp3' AND statistics.deviceid = -1  ) ;
amarok: RESULT: QStringList values = (8)


FUCKED:

amarok:       [CollectionDB] MYSQL QUERY: const QString& statement = SELECT statistics.rating FROM statistics  WHERE 1 AND ( 0 OR statistics.url = BINARY './Mp3/Other/Bomfunk mc''s/Bomfunk mc''s - Burnin'' sneakers/Bomfunk Mc''s - Burnin'' sneakers - 06 - Freak It On.mp3' AND statistics.deviceid = 5  OR statistics.url = BINARY './mnt/filmdisk/Mp3/Other/Bomfunk mc''s/Bomfunk mc''s - Burnin'' sneakers/Bomfunk Mc''s - Burnin'' sneakers - 06 - Freak It On.mp3' AND statistics.deviceid = -1  ) ;
amarok: RESULT: QStringList values = (0,8)