SELECT shipment_detail.id_shipment,shipment_detail.part_number,shipment_detail.pallet_id,shipment_detail.quantity,shipment_detail.item_net_weight,shipment_detail.uom,shipment_detail.oa_number,
            (SELECT items.part_description_eng FROM items WHERE items.part_number = shipment_detail.part_number ) AS part_description,
            (SELECT items.product_hierarchy FROM items WHERE items.part_number = shipment_detail.part_number ) AS product_hierarchy,
            (SELECT order_acknowledgement.order_date FROM order_acknowledgement WHERE order_acknowledgement.order_no = shipment_detail.oa_number) AS oa_date,
            (SELECT price_list_detail.lmi_dn FROM price_list_detail JOIN price_list ON price_list.id_price = price_list_detail.id_price WHERE shipment_detail.part_number = price_list_detail.part_number AND price_list.price_type ="Dealer" AND price_list.status = "aktif" ORDER BY price_list.date_of_price DESC LIMIT 0,1) AS price_dealer_1,
            (SELECT price_list_detail.lmi_dn FROM price_list_detail JOIN price_list ON price_list.id_price = price_list_detail.id_price WHERE shipment_detail.part_number = price_list_detail.part_number AND price_list.price_type ="Dealer" AND price_list.status = "aktif" ORDER BY price_list.date_of_price DESC LIMIT 1,1) AS price_dealer_2,
            (SELECT price_list_detail.lmi_dn FROM price_list_detail JOIN price_list ON price_list.id_price = price_list_detail.id_price WHERE shipment_detail.part_number = price_list_detail.part_number AND price_list.price_type ="Dealer" AND price_list.status = "aktif" ORDER BY price_list.date_of_price DESC LIMIT 2,1) AS price_dealer_3,
            (SELECT price_list.date_of_price FROM price_list_detail JOIN price_list ON price_list.id_price = price_list_detail.id_price WHERE shipment_detail.part_number = price_list_detail.part_number AND price_list.price_type ="Dealer" AND price_list.status = "aktif" ORDER BY price_list.date_of_price DESC LIMIT 0,1) AS price_dealer_date_1,
            (SELECT price_list.date_of_price FROM price_list_detail JOIN price_list ON price_list.id_price = price_list_detail.id_price WHERE shipment_detail.part_number = price_list_detail.part_number AND price_list.price_type ="Dealer" AND price_list.status = "aktif" ORDER BY price_list.date_of_price DESC LIMIT 1,1) AS price_dealer_date_2,
            (SELECT price_list.date_of_price FROM price_list_detail JOIN price_list ON price_list.id_price = price_list_detail.id_price WHERE shipment_detail.part_number = price_list_detail.part_number AND price_list.price_type ="Dealer" AND price_list.status = "aktif" ORDER BY price_list.date_of_price DESC LIMIT 2,1) AS price_dealer_date_3,
            (SELECT price_list_detail.lmi_dn FROM price_list_detail JOIN price_list ON price_list.id_price = price_list_detail.id_price WHERE shipment_detail.part_number = price_list_detail.part_number AND price_list.price_type ="HDAP" AND price_list.status = "aktif" ORDER BY price_list.date_of_price DESC LIMIT 0,1) AS price_hd_1,
            (SELECT price_list_detail.lmi_dn FROM price_list_detail JOIN price_list ON price_list.id_price = price_list_detail.id_price WHERE shipment_detail.part_number = price_list_detail.part_number AND price_list.price_type ="HDAP" AND price_list.status = "aktif" ORDER BY price_list.date_of_price DESC LIMIT 1,1) AS price_hd_2,
            (SELECT price_list_detail.lmi_dn FROM price_list_detail JOIN price_list ON price_list.id_price = price_list_detail.id_price WHERE shipment_detail.part_number = price_list_detail.part_number AND price_list.price_type ="HDAP" AND price_list.status = "aktif" ORDER BY price_list.date_of_price DESC LIMIT 2,1) AS price_hd_3,
            (SELECT price_list.date_of_price FROM price_list_detail JOIN price_list ON price_list.id_price = price_list_detail.id_price WHERE shipment_detail.part_number = price_list_detail.part_number AND price_list.price_type ="HDAP" AND price_list.status = "aktif" ORDER BY price_list.date_of_price DESC LIMIT 2,1) AS price_hd_date_1,
            (SELECT price_list.date_of_price FROM price_list_detail JOIN price_list ON price_list.id_price = price_list_detail.id_price WHERE shipment_detail.part_number = price_list_detail.part_number AND price_list.price_type ="HDAP" AND price_list.status = "aktif" ORDER BY price_list.date_of_price DESC LIMIT 2,1) AS price_hd_date_2,
            (SELECT price_list.date_of_price FROM price_list_detail JOIN price_list ON price_list.id_price = price_list_detail.id_price WHERE shipment_detail.part_number = price_list_detail.part_number AND price_list.price_type ="HDAP" AND price_list.status = "aktif" ORDER BY price_list.date_of_price DESC LIMIT 2,1) AS price_hd_date_3
            FROM shipment_detail RIGHT JOIN shipment ON shipment.id_shipment = shipment_detail.id_shipment WHERE shipment_detail.customer = "0000004103" AND shipment.awb_number = "77381471"