yii framework join

$criteria->join="inner join (config as b,area as c,position as d,app as e,config_has_area as f,config_has_position as g,user as a ) ON (
a.Config_id=b.id
and b.id=f.Config_id
and b.id=g.Config_id
and f.Area_id=c.id
and g.Position_id=d.id
and a.Status=$status
and d.id=$position)";