By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `many_to_many_table` (
`conditionID` int(11) NOT NULL,
`packageID` int(11) NOT NULL
);
ALTER TABLE `many_to_many_table`
ADD KEY `conditionID` (`conditionID`,`packageID`);
INSERT INTO `many_to_many_table` (`conditionID`,`packageID`) VALUES
(1, 195), (2, 195), (3, 195), (4, 197), (5, 197), (5, 209), (6, 198), (6, 211), (6, 219), (6, 220);
SELECT
packageID,
conditionID
FROM many_to_many_table
WHERE conditionId IN (1,2,3)
GROUP BY packageID
HAVING SUM(conditionId = 1) > 0
AND SUM(conditionId = 2) > 0
AND SUM(conditionId = 3) > 0;
| packageID | conditionID |
|---|---|
| 195 | 1 |