How to correctly compose CDbCriteria many-to-many in Yii?

Question

Yii

Good afternoon!
There are three tables:
t_service
-----------
CODE
NAME
mc_faq
----------
CODE
NAME
DESCRIPTION
l_service_22_faq
----------
CODE
CODE_1
CODE_2
Actually 3rd the plate connects the first 2.
Models:
Service , Faq , LService22Faq
Relationships:
CODE: SELECT ALL

public function relations()
    {
        return array(
            'faq'=>array(self::MANY_MANY, 'Faq',
                'l_service_22_faq(CODE_1, CODE_2)'),
        );
    }

I threw in about what I need (for the subgrid):

$faq = new CActiveDataProvider('Faq', array(
    'criteria' => array(
        'condition' => .... ,
    ),
));

How do I, having a service code, make the CDbCriteria criterion to pull out all the Faq (question-answers) for a given service? For 1:
1 I know how, for MANY:MANY I can’t figure it out(

Answer 1

stackoverflow.com/questions/8044552/search-in-y...