Select item from many-to-many table that has all these details... proper solution?

Answer 1

Your query looks ok, but you could do the filtering in SQL using HAVING clause:

SELECT scenid, COUNT(*)
FROM `TABLE`
WHERE mapid IN ( 01, 02, 03 )
GROUP BY scenid
HAVING COUNT(*) = 3
ORDER BY scenid ASC