return $this->alias("ser")
->join("project p", "ser.project_id=p.project_id")
->join("channel c", "ser.channel_id=c.channel_id")
->field("ser.*")
->where(["p.project_name"=>['like',"%".$where."%"]])->limit($offset, $limit)->order($sortfield)->select();