SELECTo0_.idASid_0,o0_.platform_idASplatform_id_1,o0_.source_idASsource_id_2,o0_.type_idAStype_id_3,o0_.client_idASclient_id_4,o0_.client_work_point_idASclient_work_point_id_5,o0_.car_idAScar_id_6,o0_.driver_idASdriver_id_7,o0_.delivery_dateASdelivery_date_8,o0_.production_day_idASproduction_day_id_9,o0_.status_idASstatus_id_10,o0_.payment_method_idASpayment_method_id_11,o0_.has_invoiceAShas_invoice_12,o0_.invoice_seriesASinvoice_series_13,o0_.invoice_numberASinvoice_number_14,o0_.has_storno_invoiceAShas_storno_invoice_15,o0_.storno_invoice_numberASstorno_invoice_number_16,o0_.storno_invoice_seriesASstorno_invoice_series_17,o0_.has_cargo_noticeAShas_cargo_notice_18,o0_.cargo_notice_fileAScargo_notice_file_19,o0_.user_createdASuser_created_20,o0_.date_createdASdate_created_21,o0_.is_activeASis_active_22,c1_.nameASname_23,c1_.aliasASalias_24,c2_.nameASname_25,d3_.firstnameASfirstname_26,d3_.lastnameASlastname_27,c4_.nameASname_28,c4_.colorAScolor_29,c5_.labelASlabel_30,c5_.collectedAScollected_31,c5_.collected_not_vatAScollected_not_vat_32,p6_.dateASdate_33FROM`order`o0_LEFT JOINclientc1_ON (o0_.client_id=c1_.id) LEFT JOINclient_work_pointc2_ON (o0_.client_work_point_id=c2_.id) LEFT JOINdriverd3_ON (o0_.driver_id=d3_.id) LEFT JOINconfig_payment_methodc5_ON (o0_.payment_method_id=c5_.id) LEFT JOINconfig_order_statusc4_ON (o0_.status_id=c4_.id) LEFT JOINproduction_dayp6_ON (o0_.production_day_id=p6_.id) WHEREo0_.company_id=?ANDo0_.is_active=?ANDp6_.date=?ANDo0_.production_day_id=?ANDo0_.driver_id=?ORDER BYo0_.idDESC
SELECTo0_.idASid_0,o0_.platform_idASplatform_id_1,o0_.source_idASsource_id_2,o0_.type_idAStype_id_3,o0_.client_idASclient_id_4,o0_.client_work_point_idASclient_work_point_id_5,o0_.car_idAScar_id_6,o0_.driver_idASdriver_id_7,o0_.delivery_dateASdelivery_date_8,o0_.production_day_idASproduction_day_id_9,o0_.status_idASstatus_id_10,o0_.payment_method_idASpayment_method_id_11,o0_.has_invoiceAShas_invoice_12,o0_.invoice_seriesASinvoice_series_13,o0_.invoice_numberASinvoice_number_14,o0_.has_storno_invoiceAShas_storno_invoice_15,o0_.storno_invoice_numberASstorno_invoice_number_16,o0_.storno_invoice_seriesASstorno_invoice_series_17,o0_.has_cargo_noticeAShas_cargo_notice_18,o0_.cargo_notice_fileAScargo_notice_file_19,o0_.user_createdASuser_created_20,o0_.date_createdASdate_created_21,o0_.is_activeASis_active_22,c1_.nameASname_23,c1_.aliasASalias_24,c2_.nameASname_25,d3_.firstnameASfirstname_26,d3_.lastnameASlastname_27,c4_.nameASname_28,c4_.colorAScolor_29,c5_.labelASlabel_30,c5_.collectedAScollected_31,c5_.collected_not_vatAScollected_not_vat_32,p6_.dateASdate_33FROM`order`o0_LEFT JOINclientc1_ON (o0_.client_id=c1_.id)
LEFT JOINclient_work_pointc2_ON (
o0_.client_work_point_id=c2_.id
)
LEFT JOINdriverd3_ON (o0_.driver_id=d3_.id)
LEFT JOINconfig_payment_methodc5_ON (o0_.payment_method_id=c5_.id)
LEFT JOINconfig_order_statusc4_ON (o0_.status_id=c4_.id)
LEFT JOINproduction_dayp6_ON (o0_.production_day_id=p6_.id)
WHEREo0_.company_id=?ANDo0_.is_active=?ANDp6_.date=?ANDo0_.production_day_id=?ANDo0_.driver_id=?ORDER BYo0_.idDESC
SELECTo0_.idASid_0,o0_.platform_idASplatform_id_1,o0_.source_idASsource_id_2,o0_.type_idAStype_id_3,o0_.client_idASclient_id_4,o0_.client_work_point_idASclient_work_point_id_5,o0_.car_idAScar_id_6,o0_.driver_idASdriver_id_7,o0_.delivery_dateASdelivery_date_8,o0_.production_day_idASproduction_day_id_9,o0_.status_idASstatus_id_10,o0_.payment_method_idASpayment_method_id_11,o0_.has_invoiceAShas_invoice_12,o0_.invoice_seriesASinvoice_series_13,o0_.invoice_numberASinvoice_number_14,o0_.has_storno_invoiceAShas_storno_invoice_15,o0_.storno_invoice_numberASstorno_invoice_number_16,o0_.storno_invoice_seriesASstorno_invoice_series_17,o0_.has_cargo_noticeAShas_cargo_notice_18,o0_.cargo_notice_fileAScargo_notice_file_19,o0_.user_createdASuser_created_20,o0_.date_createdASdate_created_21,o0_.is_activeASis_active_22,c1_.nameASname_23,c1_.aliasASalias_24,c2_.nameASname_25,d3_.firstnameASfirstname_26,d3_.lastnameASlastname_27,c4_.nameASname_28,c4_.colorAScolor_29,c5_.labelASlabel_30,c5_.collectedAScollected_31,c5_.collected_not_vatAScollected_not_vat_32,p6_.dateASdate_33FROM`order`o0_LEFT JOINclientc1_ON (o0_.client_id=c1_.id) LEFT JOINclient_work_pointc2_ON (o0_.client_work_point_id=c2_.id) LEFT JOINdriverd3_ON (o0_.driver_id=d3_.id) LEFT JOINconfig_payment_methodc5_ON (o0_.payment_method_id=c5_.id) LEFT JOINconfig_order_statusc4_ON (o0_.status_id=c4_.id) LEFT JOINproduction_dayp6_ON (o0_.production_day_id=p6_.id) WHEREo0_.company_id=1ANDo0_.is_active=1ANDp6_.date='2025-12-06 00:00:00'ANDo0_.production_day_id=210ANDo0_.driver_id=7ORDER BYo0_.idDESC;