SELECTc0_.idASid_0,c0_.service_dateASservice_date_1,c0_.statusASstatus_2,c0_.exact_weightASexact_weight_3,c0_.billable_weightASbillable_weight_4,c0_.calculated_billable_weightAScalculated_billable_weight_5,c0_.billable_weight_overrideASbillable_weight_override_6,c0_.transport_price_per_tripAStransport_price_per_trip_7,c0_.trip_countAStrip_count_8,c0_.price_per_kgASprice_per_kg_9,c0_.laundry_amountASlaundry_amount_10,c0_.additional_amountASadditional_amount_11,c0_.transport_amountAStransport_amount_12,c0_.total_amountAStotal_amount_13,c0_.calculated_atAScalculated_at_14,c0_.created_atAScreated_at_15,c0_.updated_atASupdated_at_16,c0_.versionASversion_17,c0_.customer_unit_idAScustomer_unit_id_18,c0_.tariff_idAStariff_id_19,c0_.created_by_idAScreated_by_id_20FROMcustomer_orderc0_WHEREc0_.idIN (?,?,?,?,?,?,?,?,?,?) ORDER BYc0_.service_dateDESC,c0_.created_atDESC
SELECTc0_.idASid_0,c0_.service_dateASservice_date_1,c0_.statusASstatus_2,c0_.exact_weightASexact_weight_3,c0_.billable_weightASbillable_weight_4,c0_.calculated_billable_weightAScalculated_billable_weight_5,c0_.billable_weight_overrideASbillable_weight_override_6,c0_.transport_price_per_tripAStransport_price_per_trip_7,c0_.trip_countAStrip_count_8,c0_.price_per_kgASprice_per_kg_9,c0_.laundry_amountASlaundry_amount_10,c0_.additional_amountASadditional_amount_11,c0_.transport_amountAStransport_amount_12,c0_.total_amountAStotal_amount_13,c0_.calculated_atAScalculated_at_14,c0_.created_atAScreated_at_15,c0_.updated_atASupdated_at_16,c0_.versionASversion_17,c0_.customer_unit_idAScustomer_unit_id_18,c0_.tariff_idAStariff_id_19,c0_.created_by_idAScreated_by_id_20FROMcustomer_orderc0_WHEREc0_.idIN (?,?,?,?,?,?,?,?,?,?)
ORDER BYc0_.service_dateDESC,c0_.created_atDESC
SELECTc0_.idASid_0,c0_.service_dateASservice_date_1,c0_.statusASstatus_2,c0_.exact_weightASexact_weight_3,c0_.billable_weightASbillable_weight_4,c0_.calculated_billable_weightAScalculated_billable_weight_5,c0_.billable_weight_overrideASbillable_weight_override_6,c0_.transport_price_per_tripAStransport_price_per_trip_7,c0_.trip_countAStrip_count_8,c0_.price_per_kgASprice_per_kg_9,c0_.laundry_amountASlaundry_amount_10,c0_.additional_amountASadditional_amount_11,c0_.transport_amountAStransport_amount_12,c0_.total_amountAStotal_amount_13,c0_.calculated_atAScalculated_at_14,c0_.created_atAScreated_at_15,c0_.updated_atASupdated_at_16,c0_.versionASversion_17,c0_.customer_unit_idAScustomer_unit_id_18,c0_.tariff_idAStariff_id_19,c0_.created_by_idAScreated_by_id_20FROMcustomer_orderc0_WHEREc0_.idIN ('019ff73f-4717-709e-bf15-9f5472e475ea','019ff25e-1cfd-75f0-8280-5105cd282d8e','019ff22e-9005-70c8-a934-326a5405a943','019ff22a-bcbd-724e-bbdf-9319d1d3bd3a','019ff1cf-b609-787f-83ca-6799c608147a','019ff739-1127-70bd-ae06-61bce6a0f8ef','019ff512-3812-732e-bfe7-68f3f5f0d518','019ff50d-5748-7046-aa6f-46230ca3def0','019ff23e-719e-7b93-84b6-c3efea3326af','019ff220-5000-7bbe-b1a6-2920bc4d5864') ORDER BYc0_.service_dateDESC,c0_.created_atDESC;