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,
a.ct_select
from g5_shop_cart a
left join g5_shop_item b on ( a.it_id = b.it_id )
where a.mb_id = '' and a.od_id = '' order by a.ct_id