возможно ли в моделе, в relations(), такого вида,
модель Tutor:
Код: Выделить всё
'school' => array(self::MANY_MANY, 'School', 'user_school(user_id,school_id)'),
Таблица tutor:
____________
|id.|user_id|
|.1.|..12.....|
|.2.|.. 4......|
Получается, чтобы в запросе не user_id = 1, а user_id = 12 было?
Вот сам запрос:
SELECT `school`.`id` AS `t1_c0`, `school`.`lang_id` AS `t1_c1`, `school`.`parent_id` AS `t1_c2`, `school`.`selectable` AS `t1_c3`, `school`.`name` AS `t1_c4` FROM `school` `school` INNER JOIN `user_school` `school_school` ON (`school_school`.`user_id`=:ypl0) AND (`school`.`id`=`school_school`.`school_id`). Bound with :ypl0='1'