select a.ct_id, a.it_id, a.it_name, a.ct_price, a.ct_point, a.ct_qty, a.ct_status, a.ct_send_cost, a.it_sc_type, b.ca_id, b.ca_id2, b.ca_id3, b.pt_it, b.pt_msg1, b.pt_msg2, b.pt_msg3 from g5_shop_cart a left join g5_shop_item b on ( a.it_id = b.it_id ) where a.od_id = '2024041707083120' group by a.it_id order by a.ct_id