$query = \Model_Institution::query()->where('id',\Input::get('institution'))->related(array('stds','students'=>array('join_type'=>'LEFT INNER','related'=>array('stds'=>array('related'=>array('products')),'measurements')))); if(\Input::get('deleted') == 1){ $query->where('students.deleted_at','IS NOT',null); } else { if(\Input::get('q')){ $query->where('students.name','like','%'.\Input::get('q').'%'); } if(\Input::get('gender')){ $query->where('students.gender',\Input::get('gender')); } if(\Input::get('std')){ $query->where('students.stds.id',\Input::get('std')); } if(\Input::get('status')){ $query->where('students.status',\Input::get('status')); } } $institution = $query->get_one(); \Debug::dump($query,$institution);die();