SELECT *,c.Jour_Entrainement_1 as JE_1,c.Jour_Entrainement_2 as JE_2 FROM clubs_resp_equipes c join Equipes e on e.eq_ref=c.Eq_Nr where e.Saison='18-19' and c.Active='J' and e.Aktiv='1' group by c.Eq_Nr order by Reihenfolge asc
Responsables d'équipe et Entrainements 18-19
ResponsablesEntrainements
EquipeEntraineurSuppleantClub responsableJoue àJourHoraireLieuJourHoraireLieu
Equipe 1Club responsable: SEEBACHClub responsable: SEEBACHSEEBACHSchleithalMardi19h30SEEBACHJeudi19h30SEEBACH
Equipe 2Club responsable: SEEBACHYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and Nr<>0 order by Nom,Prenom' at line 1