$res = Yii::app()->db->createCommand()
//->select('id,title,img1')
->selectDistinct('real_estate.id,title,img1')
->from('real_estate')
->leftJoin('SourceMessage','((real_estate.title = SourceMessage.message) or (real_estate.description = SourceMessage.message))' )
->leftJoin('Message', 'SourceMessage.id = Message.id')
->where('(Message.language="' . $lang . '" And Message.translation LIKE "%' . $_POST['query'] . '%" and real_estate.activ=1)')
->queryAll();
$res = new CSqlDataProvider($res,array('keyField' => 'id',
));
How can i solve this.
If i use ->text i also get an error