$criteria = new CDbCriteria;
$criteria->together=true;
$criteria->having="distance < 100";
$criteria->order="distance ASC";
$criteria->with= array('place_geometry'=>array('select'=>'place_id,center,'.new CDbExpression('(3959 * acos( cos( radians('.$lat.') ) * cos( radians( X(center) ) ) * cos( radians( Y(center) ) - radians('.$lon.') ) + sin( radians('.$lat.') ) * sin( radians( X(center) ) ) )) as distance')));
$dataProvider = new CActiveDataProvider(Place::model()->active()->includesMember($id),
array('criteria'=> $criteria,
'pagination'=> array(
'pageSize'=> 10,
),
));