[Amarok] improved filtering in the collection browsers, no

[Casey Link]

> Both the view and querymaker work correctly from what I can see. What
> is not working correctly is that SqlCollectionLocation::remove() a)
> removes the wrong row from the tracks table(it should be WHERE url =
> %1 instead of WHERE id = %1 ... again) and b) does not clear all the
> other tables (e.g. artists, albums, ...) when necessary.

Thanks for the quick response!

Just to be clear the query should be:
"DELETE FROM tracks where url = %1;"   where %1 is the id?

Also, aren't there foreign key constraints to remove artists/albums
when tracks are deleted?