public function getPouleTeams() { $query = "SELECT PouleTeam.id\n\t\t\t\t\tFROM PouleTeam \n\t\t\t\t\tWHERE team_nefub_id = '" . $this->nefub_id . "'\n\t\t\t\t\tGROUP BY poule_nefub_id\n\t\t\t\t\tORDER BY team_nefub_id ASC"; return PouleTeam::getAllFromQuery($query); }
public function getPouleTeams() { $query = "SELECT PouleTeam.id FROM PouleTeam\n\t\t\t\t\tLEFT JOIN Team ON PouleTeam.team_nefub_id = Team.nefub_id\n\t\t\t\t\tWHERE PouleTeam.poule_nefub_id = '" . $this->nefub_id . "'\n\t\t\t\t\tGROUP BY Team.nefub_id\n\t\t\t\t\tORDER BY PouleTeam.ranking ASC, Team.name ASC\n\t\t\t\t\t"; return PouleTeam::getAllFromQuery($query); }