{"sql":"SELECT order_id, rest_id, user_name, user_mobile, user_address, order_time, order_type, total, delivery_fee, fee, order_desc FROM (SELECT o.rest_id, o.order_id,o.user_name,o.user_mobile, o.user_address, o.order_time, 'A' as order_type, o.total_order as total, o.delivery_fee, (o.total_order * (f.fee \/ 100)) fee, o.order_desc FROM tbl_order_details o INNER JOIN fee f\n\tON f.id = o.fee_id\n\tWHERE rest_id=''\n\tUNION\n\tSELECT rest_id, order_id, customer_name, phone,address,creation_date, 'P' order_type, subtotal, delivery_fee, 0 fee, 'Pedido por Télefono' order_desc FROM phone_orders\n\tWHERE rest_id='') Pedidos\n \tORDER BY order_time DESC","success":0}