Hi Everyone!

I’ve found a bunch of articles about a similar problem. Peoples’s articles talk about the MANY_MANY and filter by one parameter.

I want to filter MANY_MANY where parameter = value1 AND parameter = value2 at the same time.

I found a solution:

SELECT shops.*, COUNT(*) AS c

FROM shop_goods, goods, shops

WHERE mm_goods_id = good_id AND mm_shop_id = shop_id

AND goods_name IN ('tea', 'milk', 'wine')

GROUP BY shop_id 

HAVING c = 3

the most important thing is "HAVING c = 3" because i want to find the shops where tea,milk,wine exist at the same time.

How to use this case in yii not to resort to use SQL code?