select * from order_list_c_back,orderd,product,hassou,customer
where
ol_uid = o_uid
and ol_p_id = p_id
and o_h_id = h_id
and h_c_id = c_id
and ol_hassou_f = '0'
and ol_hassou_date = (SELECT ol_hassou_date FROM order_list_c_back WHERE ol_hassou_date >= now() ORDER BY order_list_c_back.ol_hassou_date ASC limit 1)
榊（管理）