Код: Выделить всё
$condition = array(
'select' => 'sport.id AS sport_id, sport.title AS sport_title',
'with' => array(
'sport'
),
'condition' => 'event_date > :event_date',
'distinct' => true,
'params' => array(
':event_date' => time(),
)
);
$sports = UserBets::model()->findAll($condition);
Код: Выделить всё
SELECT DISTINCT sport.id AS sport_id, sport.title AS sport_title, `t`.`id` AS `t0_c0`, `sport`.`id` AS `t1_c0`, `sport`.`title` AS `t1_c1`, `sport`.`GameTimeShift` AS `t1_c2` FROM `user_bets` `t` LEFT OUTER JOIN `sports` `sport` ON (`t`.`sport_id`=`sport`.`id`) WHERE (event_date > :event_date)
Код: Выделить всё
`t`.`id` AS `t0_c0`, `sport`.`id` AS `t1_c0`, `sport`.`title` AS `t1_c1`, `sport`.`GameTimeShift` AS `t1_c2`
Код: Выделить всё
'select' => 'sport.id AS sport_id, sport.title AS sport_title'