t100: destinations

Custom SQL query (hide)

SELECT
  year || '-' || printf('%02d', month) AS date,
  dest,
  dest_city_name,
  sum(departures_performed) as deps,
  sum(seats) as seats,
  sum(passengers) as total_pax,
  sum(freight) as freight,
  '/t100/route?origin=' || origin || '&dest=' || dest || '&_hide_sql=1' as more_detail
FROM t100 AS t
WHERE origin = :origin
  AND (NULLIF(:year, '') IS NULL OR year = CAST(:year AS integer))
GROUP by dest, date
ORDER BY
  date DESC,
  CASE :sort_column
    WHEN 'departures' THEN deps
    WHEN 'seats' THEN seats
    WHEN 'passengers' THEN total_pax
    WHEN 'freight' THEN freight
    ELSE dest_city_name
  END
  DESC