Invalid query : SQLSTATE[42S22]: Column not found: 1054 Unknown column 'marine_output.arrival_airport_city' in 'order clause' Whole query: SELECT marine_output.* FROM marine_output WHERE marine_output.ident <> '' AND DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) = :date ORDER BY marine_output.arrival_airport_city ASC LIMIT 25 OFFSET 0