New WHERE

gistfile1.txt

SELECT
  date, year, month, day, duration, departure, departureName, destination, destinationName, departureTime, destinationTime, route, landingsDay, landingsNight, distance, remarks, signatureId,
  flight.id AS id,
  flight.aircraftId AS aircraftId,
  flight.trashed AS trashed,
  aircraft.registration AS aircraftRegistration,
  aircraft.makeModel AS aircraftMakeModel,
  aircraftCategory.name AS aircraftCategoryName,
  field.name,
  value.time,
  value.boolean
FROM flight
  LEFT JOIN aircraft ON flight.aircraftId = aircraft.id
  LEFT JOIN aircraftCategory ON aircraftCategory.id = aircraft.aircraftCategoryId
  LEFT JOIN value ON value.flightId = flight.id OR value.aircraftId = flight.aircraftId
  LEFT JOIN field ON field.id = value.fieldId
WHERE
  flight.trashed = 0
    AND CASE WHEN field.id IN ('Day') THEN
      CASE
        WHEN value.boolean = 1 THEN 1
        WHEN value.time > 0 THEN 1
      END
    END
GROUP BY
  flight.id
ORDER BY
  year DESC, month DESC, day DESC, departureTime DESC, flight.modified DESC