I would first store your original query's results in a temp table:
CREATE TEMPORARY TABLE tmpTracks
SELECT AudioTrack.*
FROM AudioTrack
INNER JOIN AudioTracks_Categories
ON AudioTrack.AudioTrack_id = AudioTracks_Categories.AudioTrack_id
WHERE AudioTracks_Categories.Category_id IN (cat1,ca
I have two tables, let's say AudioTrack and Category
Every AudioTrack record can belong to one or more ( or none )
Categories.
I have created an intermediate table, AudioTracks_ Categories
containing only the IDs of AudioTrack and Category to keep track of the
link.
to find all tracks belonging
