an error occured: (psycopg.errors.InvalidColumnReference) for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 5: ...er = wt_beatle_catalogus.katalognummer)) ORDER BY wt_beatle_... ^ [SQL: SELECT DISTINCT wt_beatle_catalogus.katalognummer, wt_beatle_catalogus.underfamilj, wt_beatle_catalogus.underfamiljsvenska, wt_beatle_catalogus.familj, wt_beatle_catalogus.familjsvenska, wt_beatle_catalogus.subgenus, wt_beatle_catalogus.overfamilj, wt_beatle_catalogus.overslakte, wt_beatle_catalogus.underordning, wt_beatle_catalogus.svensktnamn, wt_beatle_catalogus.edvkod, wt_beatle_catalogus.dispute, wt_beatle_catalogus.disputesp, wt_beatle_catalogus.disputekom, wt_beatle_catalogus.moderid, wt_beatle_catalogus.utbr FROM wt_beatle_catalogus JOIN wt_beatle_synonym ON wt_beatle_synonym.katalognummer = wt_beatle_catalogus.katalognummer WHERE wt_beatle_synonym.giltig = %(giltig_1)s::BIGINT AND wt_beatle_synonym.slakte = %(slakte_1)s::VARCHAR AND (EXISTS (SELECT * FROM wt_beatle_catalogus_omr WHERE wt_beatle_catalogus_omr.omrid = %(omrid_1)s::BIGINT AND wt_beatle_catalogus_omr.katalognummer = wt_beatle_catalogus.katalognummer)) ORDER BY wt_beatle_synonym.slakte, wt_beatle_synonym.art LIMIT %(param_1)s::INTEGER OFFSET %(param_2)s::INTEGER] [parameters: {'giltig_1': 1, 'slakte_1': 'Cylindera', 'omrid_1': 37, 'param_1': 20, 'param_2': 0}] (Background on this error at: https://sqlalche.me/e/21/f405)