Re: Tarifs horaires
Date: jeudi 4 juin 2009 19:44:33
Hmm un bug. Bref copiez-collez la requête ci-dessus où j'ai pris le soin d'enlever tous les caractères espaces :
SELECT
DATE_FORMAT(flight.start_date,'%d/%m/%Y') AS Date,
TIME_FORMAT(flight.start_date,'%H:%i') AS Time,
aircraft.callsign AS Callsign,
authentication.last_name AS Lastname,
authentication.first_name AS Firstname,
CONCAT(FLOOR(flight.duration/600),':',
TIME_FORMAT(SEC_TO_TIME((flight.duration/600-FLOOR(flight.duration/600))*3600),'%i'))
AS FlightTime
FROM flight
LEFT JOIN flight_account_entry ON flight.id=flight_account_entry.flight_id
LEFT JOIN aircraft ON aircraft.id=flight.aircraft_id
LEFT JOIN flight_pilot ON flight_pilot.flight_id=flight.id
LEFT JOIN authentication ON authentication.id=flight_pilot.pilot_id
WHERE
flight_account_entry.account_entry_id IS NULL
AND flight.airborne=0
AND flight_pilot.num=0