OCfilter. How to filter with boolean AND in opencart?

Question

MySQL

Good time everyone! Friends asked to edit the filtering on their site. The filters on their site work like this (I'll write a simplified query, in fact it's big):
SELECT * FROM products WHERE filter_id IN (...)
So the IN() function looks for "PRODUCTS WHERE THERE IS filter1 OR filter2 OR filter3".
I'm looking for the antonym of IN(). Which will give "PRODUCTS WHERE THERE IS FILTER1 AND FILTER2 AND FILTER3".

If there are any other solutions for changing the filtering method in the standard OpenCart3, then I am also happy with them. As I understand it, this is some third-party module that works on ajax. I can’t specify the name of the module, I didn’t find it)