PDO query

pdo.php

<?php
$items = Yii::app()->db->createCommand()
                ->select(array(
                    "t.id",
                    "DATE_FORMAT(`t`.`date_start`,'%d.%m.%Y') AS `date`",
                    //"DATE_FORMAT(`t`.`date_start`,'%H:%i') AS `time_start`",
                    //"DATE_FORMAT(`t`.`date_stop`,'%H:%i') AS `time_stop`",
                    "tr.number AS tr_number",
                    "s.output",
                    "CONCAT(`dr`.`sname`,' ',SUBSTR(`dr`.`name`, 1),'. ',SUBSTR(`dr`.`pname`, 1),'.') AS `driver_fio`",
                    "CONCAT(`co`.`sname`,' ',SUBSTR(`co`.`name`, 1),'. ',SUBSTR(`co`.`pname`, 1),'.') AS `conductor_fio`",
                    "TIME_FORMAT(`s`.`time_check_out`,'%H:%i') AS `time_out`",
                    "TIME_FORMAT(`s`.`time_check_in`,'%H:%i') AS `time_in`",
                ))
                ->from("tract t")
                ->leftJoin("transport tr", "`tr`.`id` = `t`.`id_transport`")
                ->leftJoin("tract_shift ts", "`ts`.`id_tract` = `t`.`id`")
                ->leftJoin("schedule_shift ss", "`ss`.`id` = `ts`.`id_schedule_shift`")
                ->leftJoin("ref_shift rs", "`rs`.`id` = `ss`.`id_shift`")
                ->leftJoin("personal dr", "`dr`.`id` = `ts`.`id_driver`")
                ->leftJoin("personal co", "`co`.`id` = `ts`.`id_conductor`")
                ->leftJoin("schedule s", "`s`.`id` = `ss`.`id_schedule`")
                ->leftJoin("routes r", "`r`.`id` = `s`.`id_routes`")
                ->where($conditionString, $BindParamsArray)
                ->order("t.date_start","s.output")
                ->queryAll();
//                ->text;