Invalid query : SQLSTATE[42S22]: Column not found: 1054 Unknown column 'spotter_output.date' in 'order clause' Whole query: SELECT spotter_archive_output.* FROM spotter_archive_output WHERE spotter_archive_output.ident <> '' AND spotter_archive_output.ident = :ident ORDER BY spotter_output.date ASC LIMIT 25 OFFSET 100