INSERT IGNORE INTO `wp_st_order_item_meta` (`id`, `order_item_id`, `type`, `check_in`, `check_out`, `starttime`, `st_booking_post_type`, `st_booking_id`, `duration`, `adult_number`, `child_number`, `infant_number`, `discount`, `room_id`, `room_num_search`, `check_in_timestamp`, `check_out_timestamp`, `status`, `wc_order_id`, `user_id`, `partner_id`, `created`, `commission`, `total_order`, `origin_id`, `cancel_percent`, `cancel_refund`, `cancel_refund_status`, `return_id`, `raw_data`, `log_mail`, `room_origin`) VALUES
(1, 9574, 'normal_booking', '07/08/2019', '07/15/2019', NULL, 'st_hotel', 981, NULL, '1', '0', '0', NULL, '4590', '1', '1562544000', '1563148800', 'pending', 9574, 17, 1, '2019-06-22', '10', '1764', 981, NULL, NULL, NULL, NULL, '{\"item_price\":280,\"ori_price\":1764,\"check_in\":\"07\\/08\\/2019\",\"check_out\":\"07\\/15\\/2019\",\"room_num_search\":1,\"room_id\":4590,\"adult_number\":1,\"child_number\":0,\"extras\":{\"value\":{\"extra_adult\":\"0\",\"extra_children\":\"0\",\"extra_service\":\"0\"},\"price\":{\"extra_adult\":\"224\",\"extra_children\":\"196\",\"extra_service\":\"140\"},\"title\":{\"extra_adult\":\"Adult\",\"extra_children\":\"Children\",\"extra_service\":\"Vip services\"}},\"extra_price\":0,\"commission\":10,\"discount_rate\":10,\"guest_title\":false,\"guest_name\":false,\"st_booking_post_type\":\"st_hotel\",\"st_booking_id\":981,\"sharing\":\"\",\"duration_unit\":\"\",\"deposit_money\":{\"type\":\"\",\"amount\":\"\"},\"user_id\":\"17\"}', NULL, 4590),
(2, 9576, 'normal_booking', '07/05/2019', '07/12/2019', NULL, 'st_hotel', 981, NULL, '1', '0', '0', NULL, '4590', '1', '1562284800', '1562889600', 'pending', 9576, 22, 1, '2019-06-26', '10', '1764', 981, NULL, NULL, NULL, NULL, '{\"item_price\":280,\"ori_price\":1764,\"check_in\":\"07\\/05\\/2019\",\"check_out\":\"07\\/12\\/2019\",\"room_num_search\":1,\"room_id\":4590,\"adult_number\":1,\"child_number\":0,\"extras\":{\"value\":{\"extra_adult\":\"0\",\"extra_children\":\"0\",\"extra_service\":\"0\"},\"price\":{\"extra_adult\":\"224\",\"extra_children\":\"196\",\"extra_service\":\"140\"},\"title\":{\"extra_adult\":\"Adult\",\"extra_children\":\"Children\",\"extra_service\":\"Vip services\"}},\"extra_price\":0,\"commission\":10,\"discount_rate\":10,\"guest_title\":false,\"guest_name\":false,\"st_booking_post_type\":\"st_hotel\",\"st_booking_id\":981,\"sharing\":\"\",\"duration_unit\":\"\",\"deposit_money\":{\"type\":\"\",\"amount\":\"\"},\"user_id\":\"22\"}', NULL, 4590),
(3, 9635, 'normal_booking', '12/10/2019', '12/13/2019', NULL, 'st_cars', 9340, NULL, '0', '0', '0', NULL, NULL, NULL, '1575936000', '1576195200', 'pending', 9635, 1, 1, '2019-10-31', '10', '15', 9340, NULL, NULL, NULL, NULL, '{\"check_in\":\"12\\/10\\/2019\",\"check_out\":\"12\\/13\\/2019\",\"check_in_time\":\"12:00 AM\",\"check_out_time\":\"12:00 AM\",\"check_in_timestamp\":1575936000,\"check_out_timestamp\":1576195200,\"location_id\":1957,\"location_id_drop_off\":null,\"pick_up\":\"United States\",\"drop_off\":\"United States\",\"ori_price\":15,\"item_price\":5,\"sale_price\":15,\"numberday\":3,\"price_equipment\":0,\"data_equipment\":[],\"price_destination\":0,\"data_destination\":0,\"commission\":10,\"discount_rate\":0,\"type_car\":\"st_cars\",\"distance\":1,\"price_with_tax\":16.5,\"st_booking_post_type\":\"st_cars\",\"st_booking_id\":\"9340\",\"sharing\":\"\",\"duration_unit\":\"day\",\"deposit_money\":{\"type\":\"\",\"amount\":\"\"},\"user_id\":1}', NULL, NULL),
(4, 9651, 'normal_booking', '12/12/2019', '12/12/2019', '', 'st_tours', 8834, '8 hours', '1', '0', '0', NULL, NULL, NULL, '1576108800', '1576108800', 'pending', 9651, 137, 1, '2019-12-12', '10', '89', 8834, NULL, NULL, NULL, NULL, '{\"adult_price\":\"100\",\"child_price\":\"600\",\"infant_price\":\"500\",\"adult_number\":1,\"child_number\":0,\"infant_number\":0,\"starttime\":\"\",\"type_tour\":\"daily_tour\",\"price_type\":\"person\",\"extras\":[],\"extra_price\":0,\"guest_title\":false,\"guest_name\":false,\"package_hotel\":[],\"package_hotel_price\":0,\"package_activity\":[],\"package_activity_price\":0,\"package_car\":[],\"package_car_price\":0,\"package_flight\":[],\"package_flight_price\":0,\"check_in\":\"12\\/12\\/2019\",\"check_out\":\"12\\/12\\/2019\",\"ori_price\":89,\"commission\":10,\"data_price\":{\"adult_price\":100,\"child_price\":0,\"infant_price\":0,\"total_price\":100},\"discount_rate\":11,\"duration\":\"8 hours\",\"st_booking_post_type\":\"st_tours\",\"st_booking_id\":\"8834\",\"sharing\":\"\",\"duration_unit\":\"\",\"deposit_money\":{\"type\":\"\",\"amount\":\"\"},\"user_id\":\"137\"}', NULL, NULL);
