Bonjour,
Oui, ci-joint, je suis en 3.0.3
Slts
SELECT
UPPER(last_name) AS Nom,
first_name AS Prenom,
(SELECT CONCAT(FLOOR(SUM( duration )/600),':',TIME_FORMAT(SEC_TO_TIME((SUM( duration )/600 - FLOOR(SUM( duration )/600))*3600),'%i')) FROM flight INNER JOIN flight_pilot ON flight_pilot.flight_id = flight.id WHERE YEAR(start_date)= $year AND MONTH(start_date)= 1 AND flight_pilot.p
Forum:
Support client