SELECT
SO.driver_id, SO.tracking_no, MTS.start_time as time_slot_from, MTS.end_time as time_slot_to,
PARTNER.street as customer_address, SO.delivery_time, PARTNER.name as customer_name, RIGHT(SO.partner_phone,9) as customer_phone,
SO.product_description, SUPPLIER.name as supplier_name, SO.schedule_channel,
SO.delivery_coordinates, SO.w3w_receiver as scheduled_coordinates, SO.commitment_date
FROM
sale_order as SO INNER JOIN res_partner as PARTNER ON SO.partner_id = PARTNER.id
INNER JOIN res_partner as SUPPLIER ON SO.supplier_id = SUPPLIER.id
INNER JOIN mena_timeslot as MTS ON SO.shift = MTS.id
WHERE
SO.company_id=1 AND SO.is_c2c=false AND SO.rtos IS NULL AND
SO.commitment_date >= '%s' AND SO.commitment_date <= '%s'