select
                if(length(TRIM(BOTH '\"' FROM vatcom.value)) = 0 and length(TRIM(BOTH '\"' FROM vatadd.value)) = 0 and length(TRIM(BOTH '\"' FROM vatcode.value)) = 0, 0, 1) as requireVAT,
                concat(so.suborder_id, '_', so.order_id) as orderId,
                dp.name as deliveryPartner, so.delivery_id as deliveryId,
                payment.method as paymentMethod,
                CONCAT(sab.street ,' ', sab.city,' ', sab.region ,' ', sab.country_id) AS billingAddress,
                CONCAT(sab.lastname,' ', sab.firstname) as billingName,
                sab.telephone AS billingPhone,
                CONCAT(sab.street ,' ', sab.city,' ', sab.region ,' ', sab.country_id) AS shippingAddress,
                sa.street AS shippingStreet, sa.city as district, sa.region as province,
                CONCAT(sab.lastname,' ', sab.firstname) as shippingName,
                sab.telephone AS shippingPhone,
                customernote.value as note,
                sum(if(sb.bundle_id is null, soi.price, (1-sb.saving) * soi.price) * if(sb.bundle_id is null, soi.qty, sb.qty * soi.qty)) + ifnull(so.cod_fee, 0) + ifnull(so.shipping_fee, 0) - ifnull(so.discount_amount, 0) + ifnull(so.giftwrap_fee, 0) - ifnull(so.tryout_discount, 0) as total
                from fahasa_suborder so
                join fahasa_suborder_item soi on so.order_id = soi.order_id and so.suborder_id = soi.suborder_id
                left join fahasa_suborder_bundle sb on soi.bundle_id = sb.bundle_id and soi.suborder_id = sb.suborder_id and soi.bundle_type = sb.bundle_type
                join fhs_sales_flat_order o on o.increment_id = so.order_id
                JOIN fhs_sales_flat_order_address sab      ON o.billing_address_id = sab.entity_id
                JOIN fhs_sales_flat_order_address sa       ON o.shipping_address_id = sa.entity_id
                join fhs_sales_flat_order_payment payment on payment.parent_id = o.entity_id
                LEFT JOIN fhs_fieldsmanager_orders customernote ON customernote.entity_id = o.entity_id AND customernote.attribute_id = '172'
                join fahasa_delivery_partner dp on dp.id = so.self_ship
                LEFT JOIN fhs_fieldsmanager_orders vatcom       ON vatcom.entity_id = o.entity_id and vatcom.attribute_id = '147'
                LEFT JOIN fhs_fieldsmanager_orders vatadd       ON vatadd.entity_id = o.entity_id and vatadd.attribute_id = '148'
                LEFT JOIN fhs_fieldsmanager_orders vatcode      ON vatcode.entity_id = o.entity_id and vatcode.attribute_id = '149'
                where so.parent_id is null
                and so.suborder_id = {$suborder_id}
                group by so.suborder_id;