SELECT si.*
FROM shop__items si
JOIN shop__items_params sip ON si.id = sip.item_id
WHERE si.inactive = 0
AND sip.param_id IN ()
GROUP BY si.id
HAVING COUNT(DISTINCT sip.param_id) = 0
<hr>