<?php
$criteria->having='hello = :param AND hello2 = :param2';
$criteria->params[':param']=$someValue;
$criteria->params[':param2']=$someValue2;
$criteria->with=array('relation');
return new CActiveDataProvider($this, array(
            'criteria'=>$criteria,
));