des1roer

SELECT 
  ch.`id_call`,
  ch.`dt_status`,
  ch.`status`
FROM 
  `call_history` ch,
  (select max(dt_status), id from call_history 
  group by id_call
  ) ch2
  where ch.id = ch2.id

$connection = Yii::app()->db;
    $sql = "
               SELECT COUNT(*) FROM `t_product` `t` WHERE EXIST=:ycp0 AND CAT=:ycp1 
AND
 (NAME LIKE :ycp2 OR NAME_EN LIKE :ycp3 OR NAME_EXCEL LIKE :ycp4 OR NAME_MENU LIKE :ycp5)
                                ";
    $dataReader = $connection->createCommand($sql)->query();
    $rows = $dataReader->readAll();