成人性生交大片免费看视频r_亚洲综合极品香蕉久久网_在线视频免费观看一区_亚洲精品亚洲人成人网在线播放_国产精品毛片av_久久久久国产精品www_亚洲国产一区二区三区在线播_日韩一区二区三区四区区区_亚洲精品国产无套在线观_国产免费www

主頁(yè) > 知識(shí)庫(kù) > 兩種方法實(shí)現(xiàn)mysql分組計(jì)數(shù)，范圍匯總

兩種方法實(shí)現(xiàn)mysql分組計(jì)數(shù)，范圍匯總
熱門(mén)標(biāo)簽：南寧外呼系統(tǒng)招商 云南大數(shù)據(jù)外呼系統(tǒng) 上海市三維地圖標(biāo)注 機(jī)器人打電銷(xiāo)電話(huà) 博樂(lè)電銷(xiāo)機(jī)器人 鄭州網(wǎng)絡(luò)外呼系統(tǒng)價(jià)錢(qián) 電話(huà)機(jī)器人是電腦呼號(hào)嗎 怎么更改高德地圖標(biāo)注 400電話(huà)到哪辦理優(yōu)惠

第一種:常規(guī)操作

SELECT
  SUM(ddd) AS count_days,
  CASE
WHEN aa.days >= 1
AND aa.days  3 THEN
  '1-3'
WHEN aa.days >= 3
AND aa.days  5 THEN
  '5-3'
ELSE
  '5+'
END AS groupby_days
FROM
  (
    SELECT
      SUM(1) AS ddd,
      days
    FROM
      tour_group
    GROUP BY
      days
  ) AS aa
GROUP BY
  groupby_days;

第二種：真香函數(shù)

SELECT
  elt(
    INTERVAL (days, 1, 3, 5, 7, 10),
    "1-3",
    "3-5",
    "5-7",
    "7-10",
    "10+"
  ) AS region,
  count(*)
FROM
  tour_group
GROUP BY
  region;

SQL表如下

/*
 Navicat Premium Data Transfer

 Source Server     : 重慶
 Source Server Type  : MySQL
 Source Server Version : 50725
 Source Host      : staging-12301.mysql.rds.aliyuncs.com:3306
 Source Schema     : chongqing

 Target Server Type  : MySQL
 Target Server Version : 50725
 File Encoding     : 65001

 Date: 05/07/2020 22:18:09
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tour_group
-- ----------------------------
DROP TABLE IF EXISTS `tour_group`;
CREATE TABLE `tour_group` (
 `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
 `group_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '旅行社自建團(tuán)號(hào)',
 `company_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '旅行社id',
 `company_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '旅行社名稱(chēng)',
 `gov_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '審批旅游局area_code',
 `gov_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '審批旅游局名稱(chēng)',
 `line_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '線路名稱(chēng)',
 `business_type` tinyint(4) NOT NULL COMMENT '業(yè)務(wù)類(lèi)型：1出境游 2國(guó)內(nèi)游 4出境免審核 5赴俄游 6入境接待 7國(guó)內(nèi)接待 8港澳游組團(tuán) 9赴臺(tái)游組團(tuán) 10 金馬澎組團(tuán) 11 邊境旅游 12兩江游 13周邊游',
 `exit_type` tinyint(4) NOT NULL COMMENT '出境類(lèi)型：1出境游 2港澳游 3赴臺(tái)游',
 `group_type` tinyint(4) NOT NULL COMMENT '國(guó)內(nèi)游／入境接待／國(guó)內(nèi)接待團(tuán)隊(duì)類(lèi)型：1自組自接 2包機(jī) 3專(zhuān)列 4其他',
 `departure_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '出發(fā)班次',
 `return_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '返回班次',
 `exit_port` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出境口岸',
 `entry_port` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '入境口岸',
 `exit_port_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出境口岸編碼',
 `entry_port_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '入境口岸編碼',
 `exit_date` date NOT NULL COMMENT '出境／出發(fā)／接團(tuán) 日期',
 `entry_date` date NOT NULL COMMENT '入境／返回／送團(tuán) 日期',
 `exit_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '出境／出發(fā)／接團(tuán) 時(shí)間',
 `entry_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '入境／返回／送團(tuán) 時(shí)間',
 `departure_province` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '出發(fā)省份',
 `departure_city` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '出發(fā)城市',
 `departure_city_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '出發(fā)城市編碼',
 `arrival_city` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '目的地城市',
 `arrival_city_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '目的地城市編碼',
 `transportation` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '交通，1:飛機(jī)，2:火車(chē)，3:輪船，4:汽車(chē)，5:其他，6.陸路',
 `days` tinyint(4) NOT NULL COMMENT '游玩天數(shù)',
 `local_travel_agency` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
 `local_travel_agency_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '地接社編碼',
 `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '行程描述',
 `guide_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '領(lǐng)隊(duì)／導(dǎo)游姓名',
 `guide_card` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '領(lǐng)隊(duì)／導(dǎo)游證號(hào)',
 `guide_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '領(lǐng)隊(duì)／導(dǎo)游手機(jī)號(hào)',
 `guide_valid_time` date NULL DEFAULT NULL COMMENT '領(lǐng)隊(duì)／導(dǎo)游證有效期',
 `guide_agency` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '領(lǐng)隊(duì)／導(dǎo)游所屬旅行社',
 `state` tinyint(4) NOT NULL DEFAULT 0 COMMENT '團(tuán)隊(duì)狀態(tài)：1待提交 2已提交／已審核 3審核不通過(guò) 4審核通過(guò) 7待取消 8取消 9已出團(tuán)／已接待 10待支付 11已支付 12投保失敗',
 `record_date` datetime(0) NULL DEFAULT NULL,
 `transaction_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
 `arrival_county` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '目的地國(guó)家',
 `arrival_prov` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '目的地省份',
 `channel` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '來(lái)源／渠道：0頁(yè)面 -1excel導(dǎo)入 其他對(duì)外接口錄入',
 `created_at` datetime(0) NOT NULL COMMENT '創(chuàng)建時(shí)間',
 `updated_at` datetime(0) NOT NULL COMMENT '更新時(shí)間',
 `deleted_at` datetime(0) NULL DEFAULT NULL COMMENT '刪除時(shí)間',
 `version` int(11) NOT NULL DEFAULT 0,
 `receive_group_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接待團(tuán)號(hào)',
 `receive_company_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接待旅行社id',
 `receive_company_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接待旅行社名稱(chēng)',
 `fleet_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '車(chē)隊(duì)ID',
 `fleet` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '車(chē)隊(duì)',
 `plate_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '車(chē)牌號(hào)',
 `fleet_seat_number` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '座位數(shù)',
 `fleet_employment_no` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '從業(yè)資格證號(hào)',
 `fleet_transport_no` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '運(yùn)輸證號(hào)',
 `fleet_transport_scope` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '運(yùn)營(yíng)范圍',
 `driver_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '司機(jī)姓名',
 `driver_phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '司機(jī)電話(huà)',
 `driver_card_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '司機(jī)身份證',
 `hotel_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '酒店名稱(chēng)',
 `hotel_contact` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '酒店聯(lián)系人',
 `hotel_phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '酒店聯(lián)系電話(huà)',
 `total_room_charge` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '房費(fèi)總金額',
 `unique_group_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '團(tuán)隊(duì)唯一編號(hào)',
 `departure_continent` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '出發(fā)／客源大洲',
 `departure_county` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出發(fā)／客源國(guó)家',
 `applicant_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申請(qǐng)人姓名',
 `applicant_phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申請(qǐng)人電話(huà)',
 `area_code` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '旅行社所在區(qū)域代碼',
 `company_type` int(2) NOT NULL DEFAULT 1 COMMENT '旅行社類(lèi)型1主社 2分社',
 `russia_exit_port` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '赴俄出境口岸',
 `russia_entry_port` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '赴俄入境口岸',
 `russia_exit_port_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '赴俄出境口岸code',
 `russia_entry_port_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '赴俄入境口岸code',
 `russia_entry_date` date NULL DEFAULT NULL COMMENT '到達(dá)俄方日期',
 `russia_exit_date` date NULL DEFAULT NULL COMMENT '離開(kāi)俄方日期',
 `order_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '訂單號(hào)',
 `policy_no` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '保單號(hào)',
 `receive_company_contact` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '組團(tuán)社聯(lián)系人',
 `receive_company_phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '組團(tuán)社聯(lián)系電話(huà)',
 `remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '拼團(tuán)及備注',
 `flag` int(2) NOT NULL DEFAULT 0 COMMENT '標(biāo)識(shí) 0標(biāo)準(zhǔn) 1金馬澎',
 `order_state` int(2) NULL DEFAULT 0 COMMENT '保險(xiǎn)單狀態(tài)：0未投保，1已投保',
 `tourist_count` int(11) NOT NULL DEFAULT 0 COMMENT '游客人數(shù)',
 `guide_count` int(11) NOT NULL DEFAULT 0 COMMENT '導(dǎo)游人數(shù)',
 `total_count` int(11) NOT NULL DEFAULT 0 COMMENT '游客+導(dǎo)游人數(shù)',
 `catering_info` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '餐飲信息',
 `accompany_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '全陪姓名',
 `accompany_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '全陪手機(jī)',
 `tw_leader_no` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '赴臺(tái)領(lǐng)隊(duì)證號(hào)',
 `special_flag` tinyint(4) NOT NULL DEFAULT 0 COMMENT '團(tuán)隊(duì)子類(lèi)型：1橫琴專(zhuān)用',
 `car_brand` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '包車(chē)車(chē)輛品牌型號(hào)',
 `car_model` int(2) NULL DEFAULT NULL COMMENT '包車(chē)車(chē)輛類(lèi)型： 1大型客車(chē) 2中型客車(chē) 3小型客車(chē)',
 PRIMARY KEY (`id`) USING BTREE,
 UNIQUE INDEX `group_number_in_company`(`group_number`, `company_id`) USING BTREE,
 UNIQUE INDEX `unique_group_number`(`unique_group_number`) USING BTREE,
 INDEX `tour_group_idx1`(`updated_at`) USING BTREE,
 INDEX `idx3`(`exit_date`) USING BTREE,
 INDEX `idx4`(`entry_date`) USING BTREE,
 INDEX `tour_group_idx2`(`area_code`) USING BTREE,
 INDEX `idx5`(`business_type`, `state`, `area_code`) USING BTREE,
 INDEX `idx6`(`gov_id`, `business_type`, `state`) USING BTREE,
 INDEX `group_in_company`(`company_id`, `business_type`, `state`) USING BTREE,
 INDEX `idx8`(`guide_card`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5265283 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tour_group
-- ----------------------------
INSERT INTO `tour_group` VALUES (5264929, '10010', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '00002', 2, 1, 4, '12301', '12013', '上海浦東國(guó)際機(jī)場(chǎng)', '上海外高橋口岸', '2', '289', '2020-06-16', '2020-06-27', '18:31', '18:31', '上海市', '上海市', '', '', '', '2', 1, ' 10 NOS Reiseservice GmbH', '3118', '驅(qū)蚊器翁', '顧見(jiàn)copy', 'OQ37481A', '13800150228', '2020-04-17', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-16 18:32:04', '2020-06-30 18:16:14', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ79XATJ6C14', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 27, 1, 28, NULL, '', '', '', 0, NULL, 2);
INSERT INTO `tour_group` VALUES (5264930, '10010qww', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '兩江游組團(tuán)', 1, 1, 4, '12301', '12013', '上海浦東國(guó)際機(jī)場(chǎng)', '上海外高橋口岸', '2', '289', '2020-06-15', '2020-06-26', '18:31', '18:31', '上海市', '上海市', '', '', '', '2', 1, ' 10 NOS Reiseservice GmbH', '3118', '12312321321321', '顧見(jiàn)copy', 'OQ37481A', '13800150228', '2020-04-17', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-16 18:33:07', '2020-06-18 14:53:28', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ637646Q943', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 7, 1, 8, NULL, '', '', '', 0, NULL, 2);
INSERT INTO `tour_group` VALUES (5264931, '1230111', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '兩江游組團(tuán)', 1, 1, 4, '12301', '12013', '上海浦東國(guó)際機(jī)場(chǎng)', '上海外高橋口岸', '2', '289', '2020-06-15', '2020-06-26', '18:31', '18:31', '上海市', '上海市', '', '', '', '2', 1, ' 10 NOS Reiseservice GmbH', '3118', '驅(qū)蚊器翁', '顧見(jiàn)copy', 'OQ37481A', '13800150228', '2020-04-17', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 7, NULL, '', '', '', '', '2020-06-16 19:10:32', '2020-06-16 19:10:59', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ04DNS44U24', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 2, NULL, '', '', '', 0, NULL, 2);
INSERT INTO `tour_group` VALUES (5264932, '10010111', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '兩江游組團(tuán)1', 1, 1, 4, '12301', '12013', '上海浦東國(guó)際機(jī)場(chǎng)', '上海外高橋口岸', '2', '289', '2020-06-15', '2020-06-26', '18:31', '18:31', '上海市', '上海市', '', '', '', '2', 1, ' 10 NOS Reiseservice GmbH', '3118', '驅(qū)蚊器翁', '顧見(jiàn)copy', 'OQ37481A', '13800150228', '2020-04-17', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 8, NULL, '', '', '', '', '2020-06-16 19:15:55', '2020-06-16 19:16:22', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ267RGNBN35', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 2, NULL, '', '', '', 0, NULL, 2);
INSERT INTO `tour_group` VALUES (5264933, '12301111', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '兩江游組團(tuán)', 8, 2, 4, '12301', '1', '舟山群島國(guó)際郵輪港', '舟山群島國(guó)際郵輪港', '142', '142', '2020-06-16', '2020-06-19', '19:25', '19:26', '浙江省', '杭州市', '', '', '', '3', 1, '三通旅運(yùn)（香港）有限公司', '7662', '123213213123', '顧見(jiàn)copy', 'OQ37481A', '13800150228', '2020-04-17', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 9, NULL, '', '', '', '', '2020-06-16 19:26:32', '2020-06-16 19:27:06', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GA09AETNF922', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '123', 0, NULL, 2, 1, 3, NULL, '', '', '', 0, NULL, 2);
INSERT INTO `tour_group` VALUES (5264934, '12301112', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '赴臺(tái)游組團(tuán)', 9, 3, 4, '12301', '12013', '舟山群島國(guó)際郵輪港', '遵義新舟國(guó)際機(jī)場(chǎng)', '142', '261', '2020-06-16', '2020-06-26', '19:29', '19:29', '浙江省', '杭州灣新區(qū)', '', '', '', '1', 3, '臺(tái)灣西敏旅行社', '874', '請(qǐng)問(wèn)驅(qū)蚊器翁無(wú)群二', '', '', '', NULL, NULL, 3, NULL, '', '', '', '', '2020-06-16 19:32:50', '2020-06-16 19:33:17', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT75BW03B207', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '1111', 0, NULL, 2, 3, 5, NULL, '', '', '', 0, NULL, 2);
INSERT INTO `tour_group` VALUES (5264935, 'wertyuio', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '國(guó)內(nèi)游', 2, 0, 1, '12301', '12013', NULL, NULL, NULL, NULL, '2020-06-15', '2020-06-18', '19:37', '19:37', '浙江省', '杭州市', '', '', '', '2', 1, '博華（廈門(mén)）國(guó)際旅行社有限公司1', '', '奧術(shù)大師多撒多', '', '', '', NULL, NULL, 3, NULL, '', '', '', '', '2020-06-16 19:40:00', '2020-06-18 09:58:30', NULL, 0, NULL, NULL, NULL, NULL, '002', '002233', '', '', '', '', '張大大', '13200010011', '2012132124545144', NULL, NULL, NULL, NULL, 'GN8640X9QB45', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '收打薩達(dá)薩達(dá)', 0, NULL, 1, 1, 2, NULL, NULL, NULL, '', 0, '2', 2);
INSERT INTO `tour_group` VALUES (5264936, 'qwertyu', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '入境游接待', 6, 0, 2, '', '', NULL, NULL, NULL, NULL, '2020-06-16', '2020-06-17', '19:45', '19:45', NULL, '', '', '', '', '', 1, '博華（廈門(mén)）國(guó)際旅行社有限公司1', '', '', '', '', '', NULL, NULL, 9, NULL, '', '', '', '', '2020-06-16 19:47:27', '2020-06-16 19:47:43', NULL, 0, '002233', NULL, '組團(tuán)社', NULL, '12301', '02131', '', '', '', '', '李四', '13200010011', '201230211', NULL, NULL, NULL, NULL, 'RJ158PUC1L40', '0123', NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '組團(tuán)社聯(lián)系人', '13211112222', '驅(qū)蚊器翁', 0, NULL, 1, 1, 2, NULL, NULL, NULL, '', 0, '2', NULL);
INSERT INTO `tour_group` VALUES (5264937, 'C2020062802', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '名稱(chēng)一泰國(guó)游', 1, 1, 4, 'A465465D', 'SA789', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2020-06-28', '2020-06-29', '04:00', '19:00', '重慶市', '重慶市', '', '普吉島', '222', '1', 2, '上海春秋國(guó)旅美國(guó)分公司', '1985', '乘車(chē)', '顧見(jiàn)copy', 'OQ37481A', '13800150228', '2020-04-17', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 2, NULL, '', '普吉島', '泰國(guó)', '', '2020-06-17 09:01:32', '2020-06-28 09:42:32', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ75SQ45QM91', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '備注一二\n行程單信息', 0, NULL, 0, 2, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264938, 'GA2020031701', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '重慶去澳門(mén)', 8, 2, 4, '766EEE', 'FD244', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2020-06-17', '2020-06-28', '09:00', '22:00', '重慶市', '重慶市', '', '', '', '1', 1, '(株）重元旅遊', '8151', '重慶出發(fā)', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-17 09:05:53', '2020-06-23 13:46:04', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GA67AJKHSI42', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '重慶', 0, NULL, 0, 1, 1, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264939, 'qwetqwew', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '出境游組團(tuán)', 1, 1, 4, '12301', '12013', '上海浦東國(guó)際機(jī)場(chǎng)', '上海虹橋國(guó)際機(jī)場(chǎng)', '2', '3', '2020-06-17', '2020-06-19', '09:33', '09:33', '上海市', '上海市', '', '', '', '2', 2, '上海春秋國(guó)旅美國(guó)分公司', '1985', '委屈二群翁群翁無(wú)', '顧見(jiàn)copy', 'OQ37481A', '13800150228', '2020-04-17', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-17 09:34:24', '2020-06-17 09:35:11', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ02DYGXTS96', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '123321', 0, NULL, 2, 2, 4, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264940, 'qwet', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '出境游組團(tuán)', 1, 1, 4, '12301', '12013', '上海浦東國(guó)際機(jī)場(chǎng)', '上海外高橋口岸', '2', '289', '2020-06-14', '2020-06-25', '18:31', '18:31', '上海市', '上海市', '', '', '', '2', 1, ' 10 NOS Reiseservice GmbH', '3118', '驅(qū)蚊器翁', '顧見(jiàn)copy', 'OQ37481A', '13800150228', '2020-04-17', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 9, NULL, '', '', '', '', '2020-06-17 09:40:19', '2020-06-17 09:40:53', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ07VVENCA28', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264941, 'C2020061702', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '一泰國(guó)游', 1, 1, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2020-06-19', '2020-06-20', '06:00', '21:00', '重慶市', '重慶市', '', '', '', '1', 2, '上海春秋國(guó)旅美國(guó)分公司', '1985', '重慶上車(chē)', '顧見(jiàn)copy', 'OQ37481A', '13800150228', '2020-04-17', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 3, NULL, '', '', '', '', '2020-06-17 10:03:16', '2020-06-17 14:04:04', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ606VKSYR71', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '領(lǐng)隊(duì)顧見(jiàn)', 0, NULL, 3, 2, 5, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264942, 'C2020061703', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '二泰國(guó)游', 1, 1, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2020-06-16', '2020-06-17', '06:00', '21:00', '重慶市', '重慶市', '', '', '', '1', 2, '上海春秋國(guó)旅美國(guó)分公司', '1985', '重慶上車(chē)', '顧見(jiàn)copy', 'OQ37481A', '13800150228', '2020-04-17', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-17 10:09:43', '2020-06-18 09:40:17', '2020-06-22 16:26:46', 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ62WLK0SN45', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '領(lǐng)隊(duì)顧見(jiàn)', 0, NULL, 1, 2, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264943, 'C2020061704', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '三泰國(guó)游', 1, 1, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '上海浦東國(guó)際機(jī)場(chǎng)', '76', '2', '2020-06-14', '2020-06-17', '06:00', '21:00', '重慶市', '重慶市', '', '', '', '1', 4, '上海春秋國(guó)旅美國(guó)分公司', '1985', '重慶上車(chē)', '顧見(jiàn)copy', 'OQ37481A', '13800150228', '2020-04-17', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-17 10:58:24', '2020-06-17 16:17:40', '2020-06-22 16:26:46', 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ191LXFVA65', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '領(lǐng)隊(duì)顧見(jiàn)', 0, NULL, 1, 4, 5, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264944, 'KL100527-20200520', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '', '', '', '', '230', '145', '2020-05-19', '2020-05-20', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明樂(lè)途旅行社有限公司', '', '00000', '李靖', '12014', '13888292920', '2020-05-21', '昆明市導(dǎo)游協(xié)會(huì)', 1, '2020-05-20 08:00:00', '', '加拿大', '溫哥華', '唱游', '2020-06-17 19:26:31', '2020-06-17 19:26:31', '2020-06-22 16:26:46', 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ87VT8ODD57', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '1285', '1', '張三', '13200112200', '拼團(tuán)', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264945, 'KL100527-202005201', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '', '', '', '', '230', '145', '2020-05-19', '2020-05-20', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明樂(lè)途旅行社有限公司', '', '00000', '李靖', '12014', '13888292920', '2020-05-21', '昆明市導(dǎo)游協(xié)會(huì)', 1, '2020-05-20 08:00:00', '', '加拿大', '溫哥華', '唱游', '2020-06-17 19:26:42', '2020-06-17 19:26:42', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ38W2ZQIG44', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '1285', '1', '張三', '13200112200', '拼團(tuán)', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264946, 'KL100527-2020052', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '', '', '', '', '230', '145', '2020-05-19', '2020-05-20', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明樂(lè)途旅行社有限公司', '', '00000', '李靖', '12014', '13888292920', '2020-05-21', '昆明市導(dǎo)游協(xié)會(huì)', 1, '2020-05-20 08:00:00', '', '加拿大', '溫哥華', '唱游', '2020-06-17 19:27:29', '2020-06-17 19:27:29', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ12H5OPQ758', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '1285', '1', '張三', '13200112200', '拼團(tuán)', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264947, 'KL100527-202005', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '', '', '', '', '230', '145', '2020-05-19', '2020-05-20', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明樂(lè)途旅行社有限公司', '', '00000', '李靖', '12014', '13888292920', '2020-05-21', '昆明市導(dǎo)游協(xié)會(huì)', 1, '2020-05-20 08:00:00', '', '加拿大', '溫哥華', '唱游', '2020-06-17 19:30:23', '2020-06-17 19:30:23', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ91RKRHTT23', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '1285', '1', '張三', '13200112200', '拼團(tuán)', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264948, 'KL100527-2020000', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '', '', '', '', '230', '145', '2020-05-19', '2020-05-20', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明樂(lè)途旅行社有限公司', '', '00000', '魏芳', '430422199106205225', '13211112222', '2020-05-21', '昆明市導(dǎo)游協(xié)會(huì)', 1, '2020-05-20 08:00:00', '', '加拿大', '溫哥華', '唱游', '2020-06-17 19:36:27', '2020-06-17 19:36:27', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ107E60CT80', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '1285', '1', '張三', '13200112200', '拼團(tuán)', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264949, 'KL100527-20200000', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '', '', '', '', '230', '145', '2020-05-19', '2020-05-20', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明樂(lè)途旅行社有限公司', '', '00000', '魏芳', '430422199106205225', '13211112222', '2020-05-21', '昆明市導(dǎo)游協(xié)會(huì)', 1, '2020-05-20 08:00:00', '', '加拿大', '溫哥華', '唱游', '2020-06-17 19:56:17', '2020-06-17 19:56:17', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ62VU7QPA06', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '1285', '1', '張三', '13200112200', '拼團(tuán)', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264954, 'KL100527-202000000', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '12301', '12013', '上海浦東國(guó)際機(jī)場(chǎng)', '杭州蕭山國(guó)際機(jī)場(chǎng)', '2', '5', '2020-05-18', '2020-05-19', '00:00', '00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明樂(lè)途旅行社有限公司', '', '00000', '魏芳', '430422199106205225', '13211112222', '2020-05-21', '昆明市導(dǎo)游協(xié)會(huì)', 1, '2020-05-20 08:00:00', '', '加拿大', '溫哥華', '唱游', '2020-06-17 22:22:23', '2020-06-18 09:46:49', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ8681TI6E48', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '1285', '1', '張三', '13200112200', '拼團(tuán)', 0, 0, 0, 3, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264956, '10010vvv', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '兩江游組團(tuán)', 1, 1, 4, '12301', '12013', '杭州蕭山國(guó)際機(jī)場(chǎng)', '杭州蕭山國(guó)際機(jī)場(chǎng)', '5', '5', '2020-06-18', '2020-06-30', '09:47', '09:47', '上海市', '上海市', '', '', '', '6', 1, '\"China-Man\" Touristik und Handels GmbH', '3119', '奧術(shù)大師多所', '顧見(jiàn)copy', 'OQ37481A', '13800150228', '2020-04-17', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-18 09:48:03', '2020-06-18 09:48:03', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ60EC97KN84', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264961, 'GA2020061801', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '一香港游', 8, 2, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '上海浦東國(guó)際機(jī)場(chǎng)', '76', '2', '2020-06-20', '2020-06-20', '03:00', '23:00', '重慶市', '重慶市', '', '', '', '2', 1, '三通旅運(yùn)（香港）有限公司', '7662', '逛公園1和2', '石子卿copy', 'BV11958A', '18600000002', '2020-04-17', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 8, NULL, '', '', '', '', '2020-06-18 09:52:22', '2020-06-18 09:53:30', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GA9898E2JD55', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '石子卿20一日游', 0, NULL, 2, 1, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264963, '20200618', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '周邊游', 13, 0, 2, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-19', '13:00', '22:00', '重慶市', '重慶市', '', '', '', '4', 1, '中國(guó)國(guó)旅', '', '對(duì)方觀看哈大家', '', '', '', NULL, NULL, 1, NULL, '', '', '', '', '2020-06-18 10:00:38', '2020-06-19 14:09:52', NULL, 0, NULL, NULL, NULL, NULL, '123', '123', '', '', '', '', '上海悠揚(yáng)國(guó)際旅行社有限公司', '15001753471', NULL, NULL, NULL, NULL, NULL, 'BJ25AOD2OO54', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 1, 1, NULL, NULL, NULL, '', 0, '1', NULL);
INSERT INTO `tour_group` VALUES (5264964, '202006181001', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '周邊游', 13, 0, 2, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-18', '13:00', '22:00', '重慶市', '重慶市', '', '', '', '4', 1, '中國(guó)國(guó)旅', '', '對(duì)方觀看哈大家', '', '', '', NULL, NULL, 9, NULL, '', '', '', '', '2020-06-18 10:01:00', '2020-06-18 15:42:15', NULL, 0, NULL, NULL, NULL, NULL, '123', '123', '', '', '', '', '上海悠揚(yáng)國(guó)際旅行社有限公司', '15001753471', NULL, NULL, NULL, NULL, NULL, 'BJ7861N28T17', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 2, NULL, NULL, NULL, '', 0, '1', NULL);
INSERT INTO `tour_group` VALUES (5264965, '20200618100139', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '周邊游', 13, 0, 2, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-18', '13:00', '22:00', '重慶市', '重慶市', '', '', '', '4', 1, '中國(guó)國(guó)旅', '', '對(duì)方觀看哈大家', '', '', '', NULL, NULL, 1, NULL, '', '', '', '', '2020-06-18 10:01:24', '2020-06-18 10:01:24', '2020-06-18 11:17:45', 0, NULL, NULL, NULL, NULL, '123', '123', '', '', '', '', '上海悠揚(yáng)國(guó)際旅行社有限公司', '15001753471', NULL, NULL, NULL, NULL, NULL, 'BJ23NEOP0N22', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 1, 1, NULL, NULL, NULL, '', 0, '1', NULL);
INSERT INTO `tour_group` VALUES (5264966, '2020061810013', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '周邊游', 13, 0, 2, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-18', '13:00', '22:00', '重慶市', '重慶市', '', '', '', '4', 1, '中國(guó)國(guó)旅', '', '對(duì)方觀看哈大家', '', '', '', NULL, NULL, 9, NULL, '', '', '', '', '2020-06-18 10:20:39', '2020-06-18 10:22:11', NULL, 0, NULL, NULL, NULL, NULL, '123', '123', '', '', '', '', '上海悠揚(yáng)國(guó)際旅行社有限公司', '15001753471', NULL, NULL, NULL, NULL, NULL, 'BJ24LJU4OI10', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 2, NULL, NULL, NULL, '', 0, '1', NULL);
INSERT INTO `tour_group` VALUES (5264972, '202006181031', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '周邊', 13, 0, 2, '123', '123', NULL, NULL, NULL, NULL, '2020-06-17', '2020-06-18', '10:28', '23:00', '北京市', '北京市', '', '', '', '4', 1, '中國(guó)國(guó)旅', '', '對(duì)法國(guó)隊(duì)', '', '', '', NULL, NULL, 1, NULL, '', '', '', '', '2020-06-18 10:29:14', '2020-06-18 10:30:33', '2020-06-18 11:17:45', 0, NULL, NULL, NULL, NULL, '123', NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'BJ91H3YHAU75', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 1, 1, NULL, NULL, NULL, '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264979, 'F2020061801', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '一臺(tái)灣游', 9, 3, 4, 'A12132', 'J454645', '上海虹橋國(guó)際機(jī)場(chǎng)', '上海浦東國(guó)際機(jī)場(chǎng)', '3', '2', '2020-06-18', '2020-06-19', '05:00', '22:00', '重慶市', '重慶市', '', '', '', '1', 2, '臺(tái)灣運(yùn)達(dá)旅行社', '8233', '重慶重慶重慶重慶重慶', '丁常梅copy', 'LVE7559A', '13800151470', '2020-02-24', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 9, NULL, '', '', '', '', '2020-06-18 11:09:40', '2020-06-18 14:31:42', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT68LA18TT25', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '備', 0, NULL, 2, 2, 4, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264981, 'KL100527-20200520-05252', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '', '', '', '', '230', '145', '2020-06-19', '2020-06-25', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明樂(lè)途旅行社有限公司', '', '00000', '李靖', '12014', '13888292920', '2020-05-21', '昆明市導(dǎo)游協(xié)會(huì)', 1, '2020-05-20 08:00:00', '', '加拿大', '溫哥華', '唱游', '2020-06-18 11:29:37', '2020-06-18 11:29:37', '2020-06-18 15:31:07', 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ32U7TVLL15', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '1285', '1', '張三', '13200112200', '拼團(tuán)', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264982, 'KL100527-20200520-8888', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '', '', '', '', '230', '145', '2020-06-19', '2020-06-25', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明樂(lè)途旅行社有限公司', '', '00000', '李靖', '12014', '13888292920', '2020-05-21', '昆明市導(dǎo)游協(xié)會(huì)', 1, '2020-05-20 08:00:00', '', '加拿大', '溫哥華', '唱游', '2020-06-18 11:30:26', '2020-06-18 11:30:26', '2020-06-18 15:31:07', 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ07EH2VY967', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '1285', '1', '張三', '13200112200', '拼團(tuán)', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264984, 'KL100527-20200520-88866', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '', '', '', '', '230', '145', '2020-06-19', '2020-06-25', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明樂(lè)途旅行社有限公司', '', '00000', '李靖', '12014', '13888292920', '2020-05-21', '昆明市導(dǎo)游協(xié)會(huì)', 1, '2020-05-20 08:00:00', '', '加拿大', '溫哥華', '唱游', '2020-06-18 11:54:13', '2020-06-18 11:54:13', '2020-06-18 15:31:07', 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ36EDC6YH12', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '1285', '1', '張三', '13200112200', '拼團(tuán)', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265007, 'KL100527-20200520-88861', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '12301', '12013', '杭州蕭山國(guó)際機(jī)場(chǎng)', '杭州蕭山國(guó)際機(jī)場(chǎng)', '5', '5', '2020-07-19', '2020-07-25', '00:00', '00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明樂(lè)途旅行社有限公司', '', '00000', '魏芳', '430422199106205225', '13211112222', '2020-05-21', '昆明市導(dǎo)游協(xié)會(huì)', 1, '2020-05-20 08:00:00', '', '加拿大', '溫哥華', '唱游', '2020-06-18 14:29:59', '2020-06-18 15:30:48', '2020-06-18 15:31:07', 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ60B02IZO34', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '1285', '1', '張三', '13200112200', '拼團(tuán)', 0, 0, 0, 3, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265010, 'KL100527-20200520-88868', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '上海市政府', '澄江深度二日游', 8, 2, 1, '', '', '', '', '230', '145', '2020-08-19', '2020-08-25', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明樂(lè)途旅行社有限公司', '', '00000', '魏芳', '430422199106205225', '13211112222', '2020-05-21', '昆明市導(dǎo)游協(xié)會(huì)', 2, '2020-05-20 08:00:00', '', '加拿大', '溫哥華', '唱游', '2020-06-18 14:35:44', '2020-06-18 14:35:44', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GA75IGLH2498', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '1285', '1', '張三', '13200112200', '拼團(tuán)', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265012, 'KL100527-20200520-02', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '澄江深度二日游', 8, 2, 1, '', '', '', '', '230', '145', '2020-07-12', '2020-07-18', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明樂(lè)途旅行社有限公司', '', '00000', '魏芳', '430422199106205225', '13211112222', '2020-05-21', '昆明市導(dǎo)游協(xié)會(huì)', 4, '2020-05-20 08:00:00', '', '加拿大', '溫哥華', '唱游', '2020-06-18 14:37:09', '2020-06-18 14:37:09', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GA60OLX1P528', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '1285', '1', '張三', '13200112200', '拼團(tuán)', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265016, '兩江', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '烏江', 12, 0, 1, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-18', '15:39', '23:00', '重慶市', '重慶市', '', '', '', '4', 1, '中國(guó)國(guó)旅', '', '1', '', '', '', NULL, NULL, 9, NULL, '', '', '', '', '2020-06-18 15:39:02', '2020-06-18 15:39:28', NULL, 0, NULL, NULL, NULL, NULL, '123', '123', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'LJ81IQXXRE68', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 2, NULL, NULL, NULL, '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265019, '2020061815', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '溧陽(yáng)二日游', 2, 0, 3, '123', '123', NULL, NULL, NULL, NULL, '2020-06-17', '2020-06-18', '07:00', '07:00', '江蘇省', '溧陽(yáng)市', '', '', '', '4', 1, '中國(guó)國(guó)旅', '', '反對(duì)根深蒂固', '', '', '', NULL, NULL, 3, NULL, '', '', '', '', '2020-06-18 15:48:19', '2020-06-18 15:48:43', NULL, 0, NULL, NULL, NULL, NULL, '123', NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GN429ZAI0B24', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 2, NULL, NULL, NULL, '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265021, '202006181550', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '124', '重慶市旅游局', '上海一日游', 7, 0, 2, '', '', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-19', '11:00', '06:07', '上海市', '上海市', '', '', '', '4', 2, '中國(guó)國(guó)旅', '', '', '', '', '', NULL, NULL, 9, NULL, '', '', '', '', '2020-06-18 15:50:04', '2020-06-18 15:51:07', NULL, 0, '123321', NULL, NULL, NULL, '123', NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GD62TM7GKN45', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 2, 2, NULL, NULL, NULL, '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265022, 'KL100527-20200000001', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '', '', '', '', '230', '145', '2020-05-19', '2020-05-20', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明樂(lè)途旅行社有限公司', '', '00000', '魏芳', '430422199106205225', '13211112222', '2020-05-21', '昆明市導(dǎo)游協(xié)會(huì)', 1, '2020-05-20 08:00:00', '', '加拿大', '溫哥華', '唱游', '2020-06-18 15:50:09', '2020-06-18 15:50:09', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ253GY6ON88', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '1285', '1', '張三', '13200112200', '拼團(tuán)', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265023, 'KL100527-202001', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '', '', '', '', '230', '145', '2020-05-19', '2020-05-20', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明樂(lè)途旅行社有限公司', '', '00000', '魏芳', '430422199106205225', '13211112222', '2020-05-21', '昆明市導(dǎo)游協(xié)會(huì)', 1, '2020-05-20 08:00:00', '', '加拿大', '溫哥華', '唱游', '2020-06-18 15:50:26', '2020-06-18 15:50:26', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ542AXS7B51', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '1285', '1', '張三', '13200112200', '拼團(tuán)', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265024, 'KL100527-202251', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '', '', '', '', '230', '145', '2020-05-19', '2020-05-20', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明樂(lè)途旅行社有限公司', '', '00000', '魏芳', '430422199106205225', '13211112222', '2020-05-21', '昆明市導(dǎo)游協(xié)會(huì)', 1, '2020-05-20 08:00:00', '', '加拿大', '溫哥華', '唱游', '2020-06-18 15:52:43', '2020-06-18 15:52:43', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ63NI4AC741', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '1285', '1', '張三', '13200112200', '拼團(tuán)', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265025, 'KL100527-20261', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '澄江深度二日游', 1, 1, 1, '2322332', 'weew', '北京首都國(guó)際機(jī)場(chǎng)', '北京首都國(guó)際機(jī)場(chǎng)', '4', '4', '2020-05-19', '2020-05-20', '00:00', '00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明樂(lè)途旅行社有限公司', '', '00000', '魏芳3', '430422199106205225', '13211112222', '2020-05-21', '昆明市導(dǎo)游協(xié)會(huì)', 1, '2020-05-20 08:00:00', '', '加拿大', '溫哥華', '唱游', '2020-06-18 15:59:22', '2020-06-18 17:33:01', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ48A4QB6078', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '1285', '1', '張三', '13200112200', '拼團(tuán)', 0, 0, 0, 3, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265028, '123011111', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '兩江游組團(tuán)1', 12, 0, 1, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-26', '15:39', '23:00', '重慶市', '重慶市', '', '', '', '4', 1, '中國(guó)國(guó)旅', '', '1', '', '', '', NULL, NULL, 1, NULL, '', '', '', '', '2020-06-18 19:06:19', '2020-06-18 19:06:19', NULL, 0, NULL, NULL, NULL, NULL, '123', '123', '', '', '', '', 'qweq ', '13200010011', '12321312312', NULL, NULL, NULL, NULL, 'LJ78J593DR84', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 1, 1, NULL, NULL, NULL, '', 0, '1', NULL);
INSERT INTO `tour_group` VALUES (5265029, '12301111122', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '兩江游組團(tuán)1', 12, 0, 1, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-26', '15:39', '23:00', '重慶市', '重慶市', '', '', '', '4', 1, '中國(guó)國(guó)旅', '', '1', '', '', '', NULL, NULL, 1, NULL, '', '', '', '', '2020-06-18 19:06:54', '2020-06-18 19:06:54', NULL, 0, NULL, NULL, NULL, NULL, '123', '123', '', '', '', '', 'qweq ', '13200010011', '12321312312', NULL, NULL, NULL, NULL, 'LJ7574LEHS76', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 1, 1, NULL, NULL, NULL, '', 0, '1', NULL);
INSERT INTO `tour_group` VALUES (5265030, '1001011', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '兩江游組團(tuán)11', 12, 0, 1, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-26', '15:39', '23:00', '重慶市', '重慶市', '', '', '', '4', 1, '中國(guó)國(guó)旅', '', '1', '', '', '', NULL, NULL, 1, NULL, '', '', '', '', '2020-06-18 19:56:55', '2020-06-18 19:56:55', NULL, 0, NULL, NULL, NULL, NULL, '123', '123', '', '', '', '', 'qweq ', '13200010011', '12321312312', NULL, NULL, NULL, NULL, 'LJ46YQ4Q3921', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 1, 1, NULL, NULL, NULL, '', 0, '1', NULL);
INSERT INTO `tour_group` VALUES (5265031, '2322332333', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '33', 12, 0, 1, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-26', '15:39', '23:00', '重慶市', '重慶市', '', '', '', '4', 1, '中國(guó)國(guó)旅', '', '1', '', '', '', NULL, NULL, 1, NULL, '', '', '', '', '2020-06-18 19:58:59', '2020-06-18 19:58:59', NULL, 0, NULL, NULL, NULL, NULL, '123', '123', '', '', '', '', 'qweq ', '13200010011', '12321312312', NULL, NULL, NULL, NULL, 'LJ279N121C42', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 1, 1, NULL, NULL, NULL, '', 0, '1', NULL);
INSERT INTO `tour_group` VALUES (5265032, '1213123', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '兩江游組團(tuán)111', 12, 0, 1, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-26', '15:39', '23:00', '重慶市', '重慶市', '', '', '', '4', 1, '中國(guó)國(guó)旅', '', '1', '', '', '', NULL, NULL, 1, NULL, '', '', '', '', '2020-06-18 20:02:22', '2020-06-18 20:02:22', NULL, 0, NULL, NULL, NULL, NULL, '123', '123', '', '', '', '', 'qweq ', '13200010011', '12321312312', NULL, NULL, NULL, NULL, 'LJ223F86JR73', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 1, 1, NULL, NULL, NULL, '', 0, '1', NULL);
INSERT INTO `tour_group` VALUES (5265034, '100101011', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '兩江游組團(tuán)11', 12, 0, 1, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-26', '15:39', '23:00', '重慶市', '重慶市', '', '', '', '4', 1, '中國(guó)國(guó)旅', '', '1', '', '', '', NULL, NULL, 1, NULL, '', '', '', '', '2020-06-18 20:19:49', '2020-06-18 20:46:43', NULL, 0, NULL, NULL, NULL, NULL, '123', '123', '', '', '', '', 'qweq ', '13200010011', '12321312312', NULL, NULL, NULL, NULL, 'LJ24SQHU2I05', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 2, NULL, NULL, NULL, '', 0, '1', NULL);
INSERT INTO `tour_group` VALUES (5265039, '1001010110110', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '兩江游組團(tuán)12', 12, 0, 1, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-26', '15:39', '23:00', '重慶市', '重慶市', '', '', '', '4', 1, '中國(guó)國(guó)旅', '', '1', '', '', '', NULL, NULL, 1, NULL, '', '', '', '', '2020-06-18 20:33:42', '2020-06-23 14:37:35', NULL, 0, NULL, NULL, NULL, NULL, '123', '123', '', '', '', '', 'qweq ', '13200010011', '12321312312', NULL, NULL, NULL, NULL, 'LJ134S3PG341', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 2, NULL, '張', NULL, '', 0, '1', NULL);
INSERT INTO `tour_group` VALUES (5265041, '10010101101012', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '兩江游組團(tuán)11', 12, 0, 1, '123', '123', NULL, NULL, NULL, NULL, '2020-06-27', '2020-06-29', '15:39', '23:00', '重慶市', '重慶市', '', '', '', '4', 1, '中國(guó)國(guó)旅', '', '1', '', '', '', NULL, NULL, 9, NULL, '', '', '', '', '2020-06-18 20:34:34', '2020-06-22 21:41:17', NULL, 0, NULL, NULL, NULL, NULL, '123', '123', '', '', '', '', 'qweq ', '13200010011', '12321312312', NULL, NULL, NULL, NULL, 'LJ7009G2ZP21', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 3, 1, 4, NULL, NULL, NULL, '', 0, '1', NULL);
INSERT INTO `tour_group` VALUES (5265042, 'C2020061901', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '一出境游', 1, 1, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '上海浦東國(guó)際機(jī)場(chǎng)', '76', '2', '2020-06-19', '2020-06-20', '06:00', '21:00', '重慶市', '重慶市', '', '', '', '1', 2, '上海春秋國(guó)旅美國(guó)分公司', '1985', '重慶上車(chē)', '顧見(jiàn)copy', 'OQ37481A', '13800150228', '2020-04-17', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-19 09:37:41', '2020-06-19 13:58:36', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ38M2JGGW27', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '領(lǐng)隊(duì)顧見(jiàn)', 0, NULL, 2, 2, 4, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265045, '10010ewqeqwe', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '兩江游組團(tuán)qweqew', 1, 1, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '上海浦東國(guó)際機(jī)場(chǎng)', '76', '2', '2020-06-19', '2020-06-20', '06:00', '21:00', '重慶市', '重慶市', '', '', '', '1', 2, 'Feizhong', '1985', '重慶上車(chē)', '顧見(jiàn)copy', 'OQ37481A', '13800150228', '2020-04-17', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-19 09:52:22', '2020-06-19 10:22:25', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ71BF0JQL51', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '領(lǐng)隊(duì)顧見(jiàn)', 0, NULL, 0, 2, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265063, '1231231231223', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '12312321321', 1, 1, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '上海浦東國(guó)際機(jī)場(chǎng)', '76', '2', '2020-08-01', '2020-08-03', '06:00', '21:00', '重慶市', '重慶市', '', '', '', '1', 2, '上海春秋國(guó)旅美國(guó)分公司', '1985', '重慶上車(chē)', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-19 11:03:16', '2020-06-19 11:03:16', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ75RAQAQT11', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '領(lǐng)隊(duì)顧見(jiàn)', 0, NULL, 0, 2, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265064, '1231231', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '兩江游組團(tuán)', 1, 1, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '上海浦東國(guó)際機(jī)場(chǎng)', '76', '2', '2020-08-01', '2020-08-03', '06:00', '21:00', '重慶市', '重慶市', '', '', '', '1', 2, '上海春秋國(guó)旅美國(guó)分公司', '1985', '重慶上車(chē)', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-19 11:03:57', '2020-06-19 11:03:57', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ96V1ZOLQ48', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '領(lǐng)隊(duì)顧見(jiàn)', 0, NULL, 0, 2, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265065, '123131123123', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '1231312321', 1, 1, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '上海浦東國(guó)際機(jī)場(chǎng)', '76', '2', '2020-08-01', '2020-08-03', '06:00', '21:00', '重慶市', '重慶市', '', '', '', '1', 2, '上海春秋國(guó)旅美國(guó)分公司', '1985', '重慶上車(chē)', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-19 11:06:58', '2020-06-19 12:28:02', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ837NSDJC77', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '領(lǐng)隊(duì)顧見(jiàn)', 0, NULL, 1, 2, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265067, 'C2020061902', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '二出境游', 1, 1, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '上海浦東國(guó)際機(jī)場(chǎng)', '76', '2', '2020-06-19', '2020-06-20', '06:00', '21:00', '重慶市', '重慶市', '', '', '', '1', 2, '上海春秋國(guó)旅美國(guó)分公司', '1985', '重慶上飛機(jī)', '顧見(jiàn)copy', 'OQ37481A', '13800150228', '2020-04-17', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-19 14:09:06', '2020-06-19 14:25:39', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ5103PQ1P44', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '領(lǐng)隊(duì)顧見(jiàn)', 0, NULL, 1, 2, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265068, '20200619211', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '重慶一日游', 13, 0, 2, '123', '123', NULL, NULL, NULL, NULL, '2020-06-19', '2020-06-20', '13:00', '22:00', '重慶市', '重慶市', '', '', '', '4', 1, '中國(guó)國(guó)旅', '', '對(duì)方觀看哈大家', '', '', '', NULL, NULL, 9, NULL, '', '', '', '', '2020-06-19 14:10:55', '2020-06-19 14:11:22', NULL, 0, NULL, NULL, NULL, NULL, '123', '123', '', '', '', '', '上海悠揚(yáng)國(guó)際旅行社有限公司', '15001753471', NULL, NULL, NULL, NULL, NULL, 'BJ958EM8JK11', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 2, NULL, NULL, NULL, '', 0, '1', NULL);
INSERT INTO `tour_group` VALUES (5265079, 'C2020061903', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '三出境游', 1, 1, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '上海浦東國(guó)際機(jī)場(chǎng)', '76', '2', '2020-06-19', '2020-06-20', '06:00', '21:00', '重慶市', '重慶市', '', '', '', '1', 2, '上海春秋國(guó)旅美國(guó)分公司', '1985', '重慶上飛機(jī)', '顧見(jiàn)copy', 'OQ37481A', '13800150228', '2020-04-17', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-19 14:28:14', '2020-06-23 09:24:02', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ302JBBU717', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '領(lǐng)隊(duì)顧見(jiàn)', 0, NULL, 3, 2, 5, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265087, 'C2020061904', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '四出境游', 1, 1, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '上海浦東國(guó)際機(jī)場(chǎng)', '76', '2', '2020-06-19', '2020-06-20', '06:00', '21:00', '重慶市', '重慶市', '', '', '', '1', 2, '上海春秋國(guó)旅美國(guó)分公司', '1985', '重慶上飛機(jī)', '顧見(jiàn)copy', 'OQ37481A', '13800150228', '2020-04-17', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-19 14:48:04', '2020-06-19 14:48:04', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ196DUJC320', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '領(lǐng)隊(duì)顧見(jiàn)', 0, NULL, 0, 2, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265088, 'C2020061905', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '五出境游', 1, 1, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '上海浦東國(guó)際機(jī)場(chǎng)', '76', '2', '2020-06-23', '2020-06-24', '11:00', '21:00', '重慶市', '重慶市', '', '', '', '1', 2, '上海春秋國(guó)旅美國(guó)分公司', '1985', '重慶上飛機(jī)', '顧見(jiàn)copy', 'OQ37481A', '13800150228', '2020-04-17', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-19 15:05:49', '2020-06-19 15:27:34', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ4371HBS745', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '領(lǐng)隊(duì)顧見(jiàn)', 0, NULL, 1, 2, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265090, '國(guó)內(nèi)接待06-19-14:35', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '上海政務(wù)對(duì)接業(yè)務(wù)出境游網(wǎng)上申報(bào)3', 7, 0, 2, '', '', NULL, NULL, NULL, NULL, '2020-06-19', '2020-06-28', '00:06', '00:08', '江蘇省', '南京市', '', '', '', '2', 1, '中國(guó)國(guó)內(nèi)地接社', '', '', '', '', '', NULL, NULL, 1, NULL, '', '', '', '', '2020-06-19 15:22:33', '2020-06-22 13:41:00', NULL, 0, '0023', NULL, NULL, NULL, '測(cè)試車(chē)隊(duì)', '蘇D-123456', '', '', '', '', '小李', '13800000000', '320383283812832232', NULL, NULL, NULL, NULL, 'GD42RJPVZ945', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '備注信息', 0, NULL, 1, 1, 2, '餐飲信息', NULL, NULL, '', 0, '2', NULL);
INSERT INTO `tour_group` VALUES (5265091, 'C2020061906', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '六出境游', 1, 1, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '上海浦東國(guó)際機(jī)場(chǎng)', '76', '2', '2020-06-23', '2020-06-24', '11:00', '21:00', '重慶市', '重慶市', '', '', '', '1', 2, '上海春秋國(guó)旅美國(guó)分公司', '1985', '重慶上飛機(jī)', '顧見(jiàn)copy', 'OQ37481A', '13800150228', '2020-04-17', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-19 15:30:29', '2020-06-19 15:30:29', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ57K0U77U24', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '領(lǐng)隊(duì)顧見(jiàn)', 0, NULL, 0, 2, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265092, 'C2020061907', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '七出境游', 1, 1, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '上海浦東國(guó)際機(jī)場(chǎng)', '76', '2', '2020-06-23', '2020-06-24', '11:00', '21:00', '重慶市', '重慶市', '', '', '', '1', 2, '上海春秋國(guó)旅美國(guó)分公司', '1985', '重慶上飛機(jī)', '顧見(jiàn)copy', 'OQ37481A', '13800150228', '2020-04-17', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-19 15:31:44', '2020-06-19 15:31:44', '2020-06-22 16:26:46', 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ57N7NURM72', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '領(lǐng)隊(duì)顧見(jiàn)', 0, NULL, 0, 2, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265093, 'C2020061908', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '八出境游', 1, 1, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '上海浦東國(guó)際機(jī)場(chǎng)', '76', '2', '2020-06-23', '2020-06-24', '11:00', '21:00', '重慶市', '重慶市', '', '', '', '1', 2, '上海春秋國(guó)旅美國(guó)分公司', '1985', '重慶上飛機(jī)', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-19 15:44:37', '2020-06-22 16:51:30', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ98JWR4U121', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '領(lǐng)隊(duì)顧見(jiàn)', 0, NULL, 0, 2, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265094, 'C2020061909', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '九出境游', 1, 1, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '上海浦東國(guó)際機(jī)場(chǎng)', '76', '2', '2020-06-24', '2020-06-25', '11:00', '21:00', '重慶市', '重慶市', '', '', '', '1', 2, '上海春秋國(guó)旅美國(guó)分公司', '1985', '重慶上飛機(jī)', '顧見(jiàn)copy', 'OQ37481A', '13800150228', '2020-04-17', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 8, NULL, '', '', '', '', '2020-06-19 15:48:24', '2020-06-19 18:10:41', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ33WAZV6D02', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '領(lǐng)隊(duì)顧見(jiàn)', 0, NULL, 2, 2, 4, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265095, '12312321312321', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '1312312321', 7, 0, 2, '', '', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-19', '11:00', '06:07', '上海市', '上海市', '', '', '', '4', 2, '中國(guó)國(guó)旅', '', '', '', '', '', NULL, NULL, 1, NULL, '', '', '', '', '2020-06-19 15:51:10', '2020-06-22 09:41:03', NULL, 0, '123321', NULL, NULL, NULL, '123', NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GD078IZMQB03', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 2, 3, NULL, NULL, NULL, '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265096, '驅(qū)蚊器翁', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '惡趣味群二', 1, 1, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '上海浦東國(guó)際機(jī)場(chǎng)', '76', '2', '2020-06-23', '2020-06-24', '11:00', '21:00', '重慶市', '重慶市', '', '', '', '1', 2, '上海春秋國(guó)旅美國(guó)分公司', '1985', '重慶上飛機(jī)', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 3, NULL, '', '', '', '', '2020-06-19 15:52:54', '2020-06-22 09:00:25', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ77SFKGZN70', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '領(lǐng)隊(duì)顧見(jiàn)', 0, NULL, 1, 2, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265097, '2020061110', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '上海一日游', 2, 0, 3, '123', '123', NULL, NULL, NULL, NULL, '2020-06-19', '2020-06-20', '07:00', '13:00', '江蘇省', '南京市', '', '', '', '1', 1, '中國(guó)國(guó)旅', '', '分公司地方', '', '', '', NULL, NULL, 9, NULL, '', '', '', '', '2020-06-19 16:03:51', '2020-06-19 16:04:13', NULL, 0, NULL, NULL, NULL, NULL, '123', NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GN06ZZSCBA40', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 2, NULL, NULL, NULL, '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265098, '202006181500', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '上海一日游', 2, 0, 3, '123', '123', NULL, NULL, NULL, NULL, '2020-06-19', '2020-06-20', '07:00', '13:00', '江蘇省', '南京市', '', '', '', '6', 1, '中國(guó)國(guó)旅', '', '分公司地方', '', '', '', NULL, NULL, 1, NULL, '4286074', '', '', '', '2020-06-19 16:05:23', '2020-06-19 16:05:40', NULL, 0, NULL, NULL, NULL, NULL, '123', NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GN48L2GG4520', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 2, NULL, NULL, NULL, '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265099, '857857', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '上海一日游', 2, 0, 3, '123', '123', NULL, NULL, NULL, NULL, '2020-06-19', '2020-06-20', '07:00', '13:00', '江蘇省', '南京市', '', '', '', '6', 1, '中國(guó)國(guó)旅', '', '分公司地方', '', '', '', NULL, NULL, 3, NULL, '', '', '', '', '2020-06-19 16:55:19', '2020-06-19 16:55:39', NULL, 0, NULL, NULL, NULL, NULL, '123', NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GN528C3UKI24', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 2, NULL, NULL, NULL, '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265100, '8578578', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '345', 2, 0, 3, '123', '123', NULL, NULL, NULL, NULL, '2019-01-08', '2019-01-14', '07:00', '13:00', '江蘇省', '南京市', '', '鄂爾多斯市', '150600', '6', 1, '中國(guó)國(guó)旅', '', '分公司地方', '', '', '', NULL, NULL, 1, NULL, '', '', '內(nèi)蒙古自治區(qū)', '', '2020-06-19 16:58:51', '2020-06-30 16:51:03', NULL, 0, NULL, NULL, NULL, NULL, '123', NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GN20JF6K9W97', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 2, NULL, NULL, NULL, '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265101, '20200621', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '重慶一日游', 2, 0, 3, '123', '123', NULL, NULL, NULL, NULL, '2020-06-22', '2020-06-22', '07:00', '23:00', '四川省', '成都市', '', '', '', '4', 1, '中國(guó)國(guó)旅', '', '分公司地方感受但是風(fēng)格', '', '', '', NULL, NULL, 8, NULL, '', '', '', '', '2020-06-22 08:58:43', '2020-06-23 14:38:44', NULL, 0, NULL, NULL, NULL, NULL, '123', '123', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GN14JZBQ8T23', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 2, NULL, NULL, NULL, '', 0, '1', NULL);
INSERT INTO `tour_group` VALUES (5265102, 'C2020062201', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '出境2日游', 1, 1, 4, 'A122', 'J451', '上海浦東國(guó)際機(jī)場(chǎng)', '上海虹橋國(guó)際機(jī)場(chǎng)', '2', '3', '2020-06-24', '2020-06-28', '05:07', '23:12', '上海市', '上海市', '', '', '', '1', 5, '東新加坡六星旅游', '12447', '面貌如榴蓮殼的濱海藝術(shù)中心晚上有時(shí)會(huì)有免費(fèi)的戶(hù)外表演。\n·在魚(yú)尾獅公園不但能和大魚(yú)尾獅自拍，這里也是觀看濱海灣金沙酒店[Hotel Marina Bay Sands]的最佳景點(diǎn)。\n·蜂蜂若想看新加坡市區(qū)風(fēng)景，建議搭乘摩天輪，每圈循環(huán)約30分鐘。若想看夜景，也可以晚上回來(lái)乘搭，但是有可能會(huì)錯(cuò)過(guò)走過(guò)噴水表演。\n·在新加坡濱海灣花園，除了能夠觀看新加坡著名的超級(jí)樹(shù)[SuperTree]，也可以付費(fèi)上空中走廊(OCBC Skywalk)，或參觀云霧林[Cloud Forest]和花穹[Flower Dome]這兩個(gè)超大溫室。', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 2, NULL, '', '', '', '', '2020-06-22 09:01:21', '2020-06-22 16:47:22', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ01AJH9OX44', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '\n新加坡旅行的第一天，是環(huán)繞著新加坡最經(jīng)典的市區(qū)景點(diǎn)游玩。這一天推薦蜂蜂早起，以便更休閑的游玩。能夠看到的包括大名鼎鼎的金沙賭場(chǎng)娛樂(lè)城[Marina Bay Sands Casino]，魚(yú)尾獅公園[Merlion Park]，以及新加坡濱海灣花園[Gardens by the Bay]。整天是以行走的方式抵達(dá)全部的景點(diǎn)，但是由于景點(diǎn)都比較集中性，不會(huì)太消耗個(gè)人體力。', 0, NULL, 1, 5, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265103, '1231313', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '123312312331', 1, 1, 4, 'A122', 'J451', '上海浦東國(guó)際機(jī)場(chǎng)', '上海虹橋國(guó)際機(jī)場(chǎng)', '2', '3', '2020-06-24', '2020-06-28', '05:07', '23:12', '上海市', '上海市', '', '', '', '1', 5, '東新加坡六星旅游', '12447', '面貌如榴蓮殼的濱海藝術(shù)中心晚上有時(shí)會(huì)有免費(fèi)的戶(hù)外表演。\n·在魚(yú)尾獅公園不但能和大魚(yú)尾獅自拍，這里也是觀看濱海灣金沙酒店[Hotel Marina Bay Sands]的最佳景點(diǎn)。\n·蜂蜂若想看新加坡市區(qū)風(fēng)景，建議搭乘摩天輪，每圈循環(huán)約30分鐘。若想看夜景，也可以晚上回來(lái)乘搭，但是有可能會(huì)錯(cuò)過(guò)走過(guò)噴水表演。\n·在新加坡濱海灣花園，除了能夠觀看新加坡著名的超級(jí)樹(shù)[SuperTree]，也可以付費(fèi)上空中走廊(OCBC Skywalk)，或參觀云霧林[Cloud Forest]和花穹[Flower Dome]這兩個(gè)超大溫室。', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 3, NULL, '', '', '', '', '2020-06-22 09:24:45', '2020-06-23 11:28:15', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ20LZFOPT70', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '\n新加坡旅行的第一天，是環(huán)繞著新加坡最經(jīng)典的市區(qū)景點(diǎn)游玩。這一天推薦蜂蜂早起，以便更休閑的游玩。能夠看到的包括大名鼎鼎的金沙賭場(chǎng)娛樂(lè)城[Marina Bay Sands Casino]，魚(yú)尾獅公園[Merlion Park]，以及新加坡濱海灣花園[Gardens by the Bay]。整天是以行走的方式抵達(dá)全部的景點(diǎn)，但是由于景點(diǎn)都比較集中性，不會(huì)太消耗個(gè)人體力。', 0, NULL, 0, 5, 5, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265106, '1233123123', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '21412123', 7, 0, 2, '', '', NULL, NULL, NULL, NULL, '2020-06-22', '2020-06-26', '11:00', '06:07', '上海市', '上海市', '', '', '', '4', 2, '中國(guó)國(guó)旅', '', '', '', '', '', NULL, NULL, 1, NULL, '', '', '', '', '2020-06-22 09:43:18', '2020-06-22 09:43:47', NULL, 0, '123321', NULL, NULL, NULL, '123', '123123', '', '', '', '', '1231', '13200010011', '1234123142312134', NULL, NULL, NULL, NULL, 'GD71UDEJDB02', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 2, 3, NULL, NULL, NULL, '', 0, '2', NULL);
INSERT INTO `tour_group` VALUES (5265107, 'GA2020062201', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '香港澳門(mén)經(jīng)典3日游 ', 8, 2, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2020-06-22', '2020-06-24', '03:04', '21:03', '重慶市', '重慶市', '', '', '', '1', 3, '三通旅運(yùn)（香港）有限公司', '7662', '初到香港的第一天，行程可以安排得滿(mǎn)一些～今天依次打卡星光大道、尖沙咀，午后前往太平山頂，在這里可以眺望香港全景。太平山下山時(shí)會(huì)途徑“東方夏威夷”淺水灣。第一晚一定要留給維港，邊享用美食邊欣賞夜景～', '劉萍萍copy01', 'JSP5348A', '13800150487', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 9, NULL, '', '', '', '', '2020-06-22 09:47:07', '2020-06-22 09:48:01', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GA86XTNHDT61', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '香港\n初到香港的第一天，行程可以安排得滿(mǎn)一些～今天依次打卡星光大道、尖沙咀，午后前往太平山頂，在這里可以眺望香港全景。太平山下山時(shí)會(huì)途徑“東方夏威夷”淺水灣。第一晚一定要留給維港，邊享用美食邊欣賞夜景～', 0, NULL, 2, 3, 5, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265108, '12312313131233', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '1231231232131', 6, 0, 2, '', '', NULL, NULL, NULL, NULL, '2020-06-16', '2020-06-17', '19:45', '19:45', NULL, '', '', '', '', '', 1, '博華（廈門(mén)）國(guó)際旅行社有限公司1', '', '', '', '', '', NULL, NULL, 1, NULL, '', '', '', '', '2020-06-22 09:50:52', '2020-06-22 09:51:02', NULL, 0, '002233', NULL, '組團(tuán)社', NULL, '12301', '02131', '', '', '', '', '李四', '13200010011', '201230211', NULL, NULL, NULL, NULL, 'RJ41WH9ZMB17', '東南亞', '0123', '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '組團(tuán)社聯(lián)系人', '13211112222', '驅(qū)蚊器翁', 0, NULL, 1, 1, 2, NULL, NULL, NULL, '', 0, '2', NULL);
INSERT INTO `tour_group` VALUES (5265109, 'GA2020062202', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '香港澳3日游', 8, 2, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2020-06-22', '2020-06-24', '03:04', '21:03', '重慶市', '重慶市', '', '', '', '1', 3, '三通旅運(yùn)（香港）有限公司', '7662', '初到香港的第一天，行程可以安排得滿(mǎn)一些～今天依次打卡星光大道、尖沙咀，午后前往太平山頂，在這里可以眺望香港全景。太平山下山時(shí)會(huì)途徑“東方夏威夷”淺水灣。第一晚一定要留給維港，邊享用美食邊欣賞夜景～', '石子卿copy01', 'BV11958A', '18600000002', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-22 09:57:56', '2020-06-23 14:34:45', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GA57VFR85V81', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '香港\n初到香港的第一天，行程可以安排得滿(mǎn)一些～今天依次打卡星光大道、尖沙咀，午后前往太平山頂，在這里可以眺望香港全景。太平山下山時(shí)會(huì)途徑“東方夏威夷”淺水灣。第一晚一定要留給維港，邊享用美食邊欣賞夜景～', 0, NULL, 0, 3, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265110, 'dew2323', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '323232', 9, 3, 4, '12301', '12013', '舟山群島國(guó)際郵輪港', '遵義新舟國(guó)際機(jī)場(chǎng)', '142', '261', '2020-06-16', '2020-06-26', '19:29', '19:29', '浙江省', '杭州灣新區(qū)', '', '', '', '1', 3, '臺(tái)灣西敏旅行社', '874', '請(qǐng)問(wèn)驅(qū)蚊器翁無(wú)群二', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-22 10:03:03', '2020-06-22 10:03:46', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT808LSJLI05', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '1111', 0, NULL, 1, 3, 4, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265111, 'FT2020062201', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '臺(tái)北2日經(jīng)典線路', 9, 3, 4, 'A121322222', 'J454645333333', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2020-06-27', '2020-06-28', '05:00', '23:00', '重慶市', '重慶市', '', '', '', '1', 2, '臺(tái)灣運(yùn)達(dá)旅行社', '8233', '路線概覽\nD1龍山寺(1小時(shí)) → 西門(mén)町(2小時(shí)) → 西門(mén)紅樓(0.5小時(shí)) → 誠(chéng)品書(shū)店(西門(mén)町店)(1小時(shí)) → 臺(tái)北總統(tǒng)府(1小時(shí)) → 臺(tái)北101(3小時(shí)) → 臺(tái)北象山(3小時(shí))\n\nD2中正紀(jì)念堂(1小時(shí)) → 臺(tái)北士林官邸(1小時(shí)) → 臺(tái)北故宮博物院(3小時(shí)) → 寧夏夜市(2小時(shí))', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 2, NULL, '', '', '', '', '2020-06-22 10:03:18', '2020-06-22 10:06:40', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT6943K3BA24', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '每年5-6月份是臺(tái)北的梅雨季節(jié)；7-9月整個(gè)臺(tái)灣進(jìn)入臺(tái)風(fēng)季，雖然臺(tái)北市并不臨海，但可能會(huì)對(duì)航班等交通造成影響，建議根據(jù)天氣情況，錯(cuò)時(shí)出行。', 0, NULL, 2, 2, 4, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265112, '32233232', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '23323223', 9, 3, 4, '12301', '12013', '舟山群島國(guó)際郵輪港', '遵義新舟國(guó)際機(jī)場(chǎng)', '142', '261', '2020-06-16', '2020-06-26', '19:29', '19:29', '浙江省', '杭州灣新區(qū)', '', '', '', '1', 3, '臺(tái)灣西敏旅行社', '874', '請(qǐng)問(wèn)驅(qū)蚊器翁無(wú)群二', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-22 10:05:08', '2020-06-22 10:06:41', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT42Y3Z92X61', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '1111', 0, NULL, 1, 3, 4, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265113, '4434', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '4343344343', 9, 3, 4, '12301', '12013', '舟山群島國(guó)際郵輪港', '遵義新舟國(guó)際機(jī)場(chǎng)', '142', '261', '2020-06-16', '2020-06-26', '19:29', '19:29', '浙江省', '杭州灣新區(qū)', '', '', '', '1', 3, '臺(tái)灣西敏旅行社', '874', '請(qǐng)問(wèn)驅(qū)蚊器翁無(wú)群二', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-22 10:09:09', '2020-06-22 10:09:36', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT132NDDDW11', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '1111', 0, NULL, 1, 3, 4, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265114, '33', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '22', 9, 3, 4, '12301', '12013', '舟山群島國(guó)際郵輪港', '遵義新舟國(guó)際機(jī)場(chǎng)', '142', '261', '2020-06-16', '2020-06-26', '19:29', '19:29', '浙江省', '杭州灣新區(qū)', '', '', '', '1', 3, '臺(tái)灣西敏旅行社', '874', '請(qǐng)問(wèn)驅(qū)蚊器翁無(wú)群二', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-22 10:11:06', '2020-06-22 10:11:37', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT770G022B87', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '1111', 0, NULL, 1, 3, 4, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265115, '1', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '1', 9, 3, 4, '12301', '12013', '舟山群島國(guó)際郵輪港', '遵義新舟國(guó)際機(jī)場(chǎng)', '142', '261', '2020-06-16', '2020-06-26', '19:29', '19:29', '浙江省', '杭州灣新區(qū)', '', '', '', '1', 3, '臺(tái)灣西敏旅行社', '874', '請(qǐng)問(wèn)驅(qū)蚊器翁無(wú)群二', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-22 10:14:28', '2020-06-22 10:14:55', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT11XPILTO18', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '1111', 0, NULL, 1, 3, 4, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265116, '23223323', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '上海政務(wù)對(duì)接業(yè)務(wù)出境游網(wǎng)上申報(bào)3', 9, 3, 4, '12301', '12013', '舟山群島國(guó)際郵輪港', '遵義新舟國(guó)際機(jī)場(chǎng)', '142', '261', '2020-06-16', '2020-06-26', '19:29', '19:29', '浙江省', '杭州灣新區(qū)', '', '', '', '1', 3, '臺(tái)灣西敏旅行社', '874', '請(qǐng)問(wèn)驅(qū)蚊器翁無(wú)群二', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-22 10:15:47', '2020-06-22 10:16:19', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT01MF66MR54', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '1111', 0, NULL, 1, 3, 4, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265117, '33232323', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '23323323', 9, 3, 4, '12301', '12013', '舟山群島國(guó)際郵輪港', '遵義新舟國(guó)際機(jī)場(chǎng)', '142', '261', '2020-06-16', '2020-06-26', '19:29', '19:29', '浙江省', '杭州灣新區(qū)', '', '', '', '1', 3, '臺(tái)灣西敏旅行社', '874', '請(qǐng)問(wèn)驅(qū)蚊器翁無(wú)群二', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-22 10:21:22', '2020-06-22 10:21:51', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT421OBL1G31', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '1111', 0, NULL, 1, 3, 4, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265118, 'FT2020062202', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '經(jīng)典兩日游', 9, 3, 4, 'A121322222', 'J454645333333', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2020-06-22', '2020-06-23', '05:00', '23:00', '重慶市', '重慶市', '', '', '', '1', 2, '臺(tái)灣運(yùn)達(dá)旅行社', '8233', '路線概覽\nD1龍山寺(1小時(shí)) → 西門(mén)町(2小時(shí)) → 西門(mén)紅樓(0.5小時(shí)) → 誠(chéng)品書(shū)店(西門(mén)町店)(1小時(shí)) → 臺(tái)北總統(tǒng)府(1小時(shí)) → 臺(tái)北101(3小時(shí)) → 臺(tái)北象山(3小時(shí))\n\nD2中正紀(jì)念堂(1小時(shí)) → 臺(tái)北士林官邸(1小時(shí)) → 臺(tái)北故宮博物院(3小時(shí)) → 寧夏夜市(2小時(shí))', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 9, NULL, '', '', '', '', '2020-06-22 10:30:42', '2020-06-22 10:31:39', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT24FLH7M816', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '每年5-6月份是臺(tái)北的梅雨季節(jié)；7-9月整個(gè)臺(tái)灣進(jìn)入臺(tái)風(fēng)季，雖然臺(tái)北市并不臨海，但可能會(huì)對(duì)航班等交通造成影響，建議根據(jù)天氣情況，錯(cuò)時(shí)出行。', 0, NULL, 1, 2, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265119, '233232', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '23322323', 9, 3, 4, '12301', '12013', '舟山群島國(guó)際郵輪港', '遵義新舟國(guó)際機(jī)場(chǎng)', '142', '261', '2020-06-16', '2020-06-26', '19:29', '19:29', '浙江省', '杭州灣新區(qū)', '', '', '', '1', 3, '臺(tái)灣西敏旅行社', '874', '請(qǐng)問(wèn)驅(qū)蚊器翁無(wú)群二', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-22 10:56:07', '2020-06-22 10:56:07', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT995C4RZV95', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '1111', 0, NULL, 0, 3, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265123, '2332320000', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '23322323', 9, 3, 4, '12301', '12013', '舟山群島國(guó)際郵輪港', '遵義新舟國(guó)際機(jī)場(chǎng)', '142', '261', '2020-06-16', '2020-06-26', '19:29', '19:29', '浙江省', '杭州灣新區(qū)', '', '', '', '1', 3, '臺(tái)灣西敏旅行社', '874', '請(qǐng)問(wèn)驅(qū)蚊器翁無(wú)群二', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-22 11:12:07', '2020-06-22 11:12:07', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT72524VP598', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '1111', 0, NULL, 0, 3, 3, NULL, '', '', 'c22332', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265124, '233232000000000', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '23322323', 9, 3, 4, '12301', '12013', '舟山群島國(guó)際郵輪港', '遵義新舟國(guó)際機(jī)場(chǎng)', '142', '261', '2020-06-16', '2020-06-26', '19:29', '19:29', '浙江省', '杭州灣新區(qū)', '', '', '', '1', 3, '臺(tái)灣西敏旅行社', '874', '請(qǐng)問(wèn)驅(qū)蚊器翁無(wú)群二', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-22 11:16:45', '2020-06-22 11:16:45', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT57NZL17R08', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '1111', 0, NULL, 0, 3, 3, NULL, '', '', 'c22332', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265125, '2332320000000000000', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '23322323', 9, 3, 4, '12301', '12013', '舟山群島國(guó)際郵輪港', '遵義新舟國(guó)際機(jī)場(chǎng)', '142', '261', '2020-06-16', '2020-06-26', '19:29', '19:29', '浙江省', '杭州灣新區(qū)', '', '', '', '1', 3, '臺(tái)灣西敏旅行社', '874', '請(qǐng)問(wèn)驅(qū)蚊器翁無(wú)群二', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-22 11:20:29', '2020-06-22 11:20:29', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT26IZ7U9K11', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '1111', 0, NULL, 0, 3, 3, NULL, '', '', 'c22332', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265126, '233200', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '23322323', 9, 3, 4, '12301', '12013', '舟山群島國(guó)際郵輪港', '遵義新舟國(guó)際機(jī)場(chǎng)', '142', '261', '2020-06-16', '2020-06-26', '19:29', '19:29', '浙江省', '杭州灣新區(qū)', '', '', '', '1', 3, '臺(tái)灣西敏旅行社', '874', '請(qǐng)問(wèn)驅(qū)蚊器翁無(wú)群二', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-22 11:21:07', '2020-06-22 11:21:07', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT75ZKBLFJ52', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '1111', 0, NULL, 0, 3, 3, NULL, '', '', 'c22332', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265127, '23320000', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '23322323', 9, 3, 4, '12301', '12013', '舟山群島國(guó)際郵輪港', '遵義新舟國(guó)際機(jī)場(chǎng)', '142', '261', '2020-06-16', '2020-06-26', '19:29', '19:29', '浙江省', '杭州灣新區(qū)', '', '', '', '1', 3, '臺(tái)灣西敏旅行社', '874', '請(qǐng)問(wèn)驅(qū)蚊器翁無(wú)群二', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-22 11:24:14', '2020-06-22 11:24:14', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT02I3R83I85', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '1111', 0, NULL, 0, 3, 3, NULL, '', '', 'c22332', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265128, '2323333232', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '32323223232', 9, 3, 4, '12301', '12013', '舟山群島國(guó)際郵輪港', '遵義新舟國(guó)際機(jī)場(chǎng)', '142', '261', '2020-06-16', '2020-06-26', '19:29', '19:29', '浙江省', '杭州灣新區(qū)', '', '', '', '1', 3, '臺(tái)灣西敏旅行社', '874', '請(qǐng)問(wèn)驅(qū)蚊器翁無(wú)群二', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-22 11:32:48', '2020-06-22 11:32:48', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT66DHGBKE60', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '1111', 0, NULL, 0, 3, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265129, '11233333', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '211221', 9, 3, 4, '12301', '12013', '舟山群島國(guó)際郵輪港', '遵義新舟國(guó)際機(jī)場(chǎng)', '142', '261', '2020-06-16', '2020-06-26', '19:29', '19:29', '浙江省', '杭州灣新區(qū)', '', '', '', '1', 3, '臺(tái)灣西敏旅行社', '874', '請(qǐng)問(wèn)驅(qū)蚊器翁無(wú)群二', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-22 11:35:44', '2020-06-22 11:35:44', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT633VN7W422', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '1111', 0, NULL, 0, 3, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265130, '2332', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '2332', 9, 3, 4, '12301', '12013', '舟山群島國(guó)際郵輪港', '遵義新舟國(guó)際機(jī)場(chǎng)', '142', '261', '2020-06-16', '2020-06-26', '19:29', '19:29', '浙江省', '杭州灣新區(qū)', '', '', '', '1', 3, '臺(tái)灣西敏旅行社', '874', '請(qǐng)問(wèn)驅(qū)蚊器翁無(wú)群二', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-22 11:36:37', '2020-06-22 11:36:37', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT84XQ3UFZ55', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '1111', 0, NULL, 0, 3, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265131, '232', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '23323232', 9, 3, 4, '12301', '12013', '舟山群島國(guó)際郵輪港', '遵義新舟國(guó)際機(jī)場(chǎng)', '142', '261', '2020-06-16', '2020-06-26', '19:29', '19:29', '浙江省', '杭州灣新區(qū)', '', '', '', '1', 3, '臺(tái)灣西敏旅行社', '874', '請(qǐng)問(wèn)驅(qū)蚊器翁無(wú)群二', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-22 11:37:27', '2020-06-22 11:37:27', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT31VYBRMD06', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '1111', 0, NULL, 0, 3, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265132, '122', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '1212121', 9, 3, 4, '12301', '12013', '舟山群島國(guó)際郵輪港', '遵義新舟國(guó)際機(jī)場(chǎng)', '142', '261', '2020-06-16', '2020-06-26', '19:29', '19:29', '浙江省', '杭州灣新區(qū)', '', '', '', '1', 3, '臺(tái)灣西敏旅行社', '874', '請(qǐng)問(wèn)驅(qū)蚊器翁無(wú)群二', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-22 11:38:30', '2020-06-22 19:38:26', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT75A5F06P90', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '1111', 0, NULL, 0, 3, 3, NULL, '', '', '2222222', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265133, '12312313', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '213123213', 13, 0, 2, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-19', '13:00', '22:00', '重慶市', '重慶市', '', '重慶市區(qū)', '500100', '4', 1, '中國(guó)國(guó)旅', '', '對(duì)方觀看哈大家', '', '', '', NULL, NULL, 1, NULL, '', '', '重慶市', '', '2020-06-22 14:56:02', '2020-06-24 13:55:57', NULL, 0, NULL, NULL, NULL, NULL, '123', '123', '', '', '', '', '上海悠揚(yáng)國(guó)際旅行社有限公司', '15001753471', NULL, NULL, NULL, NULL, NULL, 'BJ35QJXCMN81', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 1, 1, NULL, NULL, NULL, '', 0, '1', NULL);
INSERT INTO `tour_group` VALUES (5265134, '領(lǐng)隊(duì)查0111', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '上海政務(wù)對(duì)接業(yè)務(wù)出境游網(wǎng)上申報(bào)3', 9, 3, 4, '2322332', 'weew', '連云港口岸', '寧波鑠口', '16', '21', '2020-06-17', '2020-06-27', '05:04', '03:05', '北京市', '北京市區(qū)', '', '', '', '2', 1, '(株)國(guó)際旅行社', '10552', '描述行程', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-22 19:41:06', '2020-06-22 19:49:12', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT79FP0DAJ20', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 1, 1, NULL, '', '', '32322332', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265135, '23223323額問(wèn)問(wèn)', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '上海政務(wù)對(duì)接業(yè)務(wù)出境游網(wǎng)上申報(bào)3', 9, 3, 4, '2322332', 'weew', '連云港口岸', '寧波鑠口', '16', '21', '2020-06-17', '2020-06-27', '05:04', '03:05', '北京市', '北京市區(qū)', '', '', '', '2', 1, '(株)國(guó)際旅行社', '10552', '描述行程', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-22 19:49:42', '2020-06-22 19:49:42', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT474BUX3495', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 1, 1, NULL, '', '', '32322332', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265136, '232332', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '222', 9, 3, 4, '2322332', 'weew', '連云港口岸', '寧波鑠口', '16', '21', '2020-06-17', '2020-06-27', '05:04', '03:05', '北京市', '北京市區(qū)', '', '', '', '2', 1, '(株)國(guó)際旅行社', '10552', '描述行程', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-22 19:51:47', '2020-06-22 19:51:47', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT07KR65MC54', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 1, 1, NULL, '', '', '32322332', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265137, '2121', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '22112', 9, 3, 4, '2322332', 'weew', '連云港口岸', '寧波鑠口', '16', '21', '2020-06-17', '2020-06-27', '05:04', '03:05', '北京市', '北京市區(qū)', '', '', '', '2', 1, '(株)國(guó)際旅行社', '10552', '描述行程', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-22 19:54:12', '2020-06-22 19:54:12', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT7582YZZY28', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 1, 1, NULL, '', '', '32322332', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265138, 'wwww', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', 'www', 9, 3, 4, '2322332', 'weew', '連云港口岸', '寧波鑠口', '16', '21', '2020-06-17', '2020-06-27', '05:04', '03:05', '北京市', '北京市區(qū)', '', '', '', '2', 1, '(株)國(guó)際旅行社', '10552', '描述行程', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-22 19:55:42', '2020-06-22 19:55:42', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT41UMAE3A03', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 1, 1, NULL, '', '', '32322332', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265139, 'xss', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', 'sds', 9, 3, 4, '2322332', 'weew', '連云港口岸', '寧波鑠口', '16', '21', '2020-06-17', '2020-06-27', '05:04', '03:05', '北京市', '北京市區(qū)', '', '', '', '2', 1, '(株)國(guó)際旅行社', '10552', '描述行程', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 3, NULL, '', '', '', '', '2020-06-22 19:58:25', '2020-06-22 21:25:38', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT38NZBVYE16', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 1, 1, NULL, '', '', '32322332', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265146, '12301111232131', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '兩江游組團(tuán)', 1, 1, 4, '12301', '12013', '上海浦東國(guó)際機(jī)場(chǎng)', '上海虹橋國(guó)際機(jī)場(chǎng)', '2', '3', '2021-11-01', '2021-11-02', '09:55', '09:55', '上海市', '上海市', '', '', '', '6', 1, '(株)JTB北海道', '11863', '其味無(wú)窮二群翁群二', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-23 09:56:22', '2020-06-23 10:02:55', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ984YFUCM03', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 1, 1, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265148, 'qweqweqweqw', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '其味無(wú)窮二無(wú)群', 1, 1, 4, 'u099', '1', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2021-11-01', '2021-11-02', '10:04', '10:04', '上海市', '上海市', '', '', '', '6', 1, '(有)日本トラベルＫＩＫＯ', '8176', '驅(qū)蚊器翁群翁群二無(wú)無(wú)群', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-23 10:04:50', '2020-06-23 10:04:50', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ66W1FKMJ21', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '驅(qū)蚊器翁群', 0, NULL, 1, 1, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265149, 'qweqweqweqw12121', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '其味無(wú)窮二無(wú)群', 1, 1, 4, 'u099', '1', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2021-11-01', '2021-11-02', '10:04', '10:04', '上海市', '上海市', '', '', '', '6', 1, '(有)日本トラベルＫＩＫＯ', '8176', '驅(qū)蚊器翁群翁群二無(wú)無(wú)群', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-23 10:07:17', '2020-06-23 11:02:11', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ75QFDPNM27', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '驅(qū)蚊器翁群', 0, NULL, 2, 1, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265154, 'FT2020062301', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '臺(tái)灣游2日', 9, 3, 4, 'A121322222', 'J454645333333', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2020-06-29', '2020-06-30', '05:00', '23:00', '重慶市', '重慶市', '', '', '', '1', 2, '臺(tái)灣運(yùn)達(dá)旅行社', '8233', '路線概覽\nD1龍山寺(1小時(shí)) → 西門(mén)町(2小時(shí)) → 西門(mén)紅樓(0.5小時(shí)) → 誠(chéng)品書(shū)店(西門(mén)町店)(1小時(shí)) → 臺(tái)北總統(tǒng)府(1小時(shí)) → 臺(tái)北101(3小時(shí)) → 臺(tái)北象山(3小時(shí))\n\nD2中正紀(jì)念堂(1小時(shí)) → 臺(tái)北士林官邸(1小時(shí)) → 臺(tái)北故宮博物院(3小時(shí)) → 寧夏夜市(2小時(shí))', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 2, NULL, '', '', '', '', '2020-06-23 10:20:46', '2020-06-23 10:25:54', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT43XEP58517', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '每年5-6月份是臺(tái)北的梅雨季節(jié)；7-9月整個(gè)臺(tái)灣進(jìn)入臺(tái)風(fēng)季，雖然臺(tái)北市并不臨海，但可能會(huì)對(duì)航班等交通造成影響，建議根據(jù)天氣情況，錯(cuò)時(shí)出行。', 0, NULL, 0, 2, 2, NULL, '', '', 'T－7489', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265155, 'FT2020062302', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '臺(tái)灣經(jīng)典2日游', 9, 3, 4, 'A121322222', 'J454645333333', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2020-06-29', '2020-06-30', '05:00', '23:00', '重慶市', '重慶市', '', '', '', '1', 2, '臺(tái)灣運(yùn)達(dá)旅行社', '8233', '路線概覽\nD1龍山寺(1小時(shí)) → 西門(mén)町(2小時(shí)) → 西門(mén)紅樓(0.5小時(shí)) → 誠(chéng)品書(shū)店(西門(mén)町店)(1小時(shí)) → 臺(tái)北總統(tǒng)府(1小時(shí)) → 臺(tái)北101(3小時(shí)) → 臺(tái)北象山(3小時(shí))\n\nD2中正紀(jì)念堂(1小時(shí)) → 臺(tái)北士林官邸(1小時(shí)) → 臺(tái)北故宮博物院(3小時(shí)) → 寧夏夜市(2小時(shí))', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 2, NULL, '', '', '', '', '2020-06-23 10:27:27', '2020-06-23 10:28:18', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT35YR805N38', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '每年5-6月份是臺(tái)北的梅雨季節(jié)；7-9月整個(gè)臺(tái)灣進(jìn)入臺(tái)風(fēng)季，雖然臺(tái)北市并不臨海，但可能會(huì)對(duì)航班等交通造成影響，建議根據(jù)天氣情況，錯(cuò)時(shí)出行。', 0, NULL, 1, 2, 3, NULL, '', '', 'T－7489', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265156, 'C2020062301', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '一1111泰國(guó)游', 1, 1, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '上海浦東國(guó)際機(jī)場(chǎng)', '76', '2', '2021-06-02', '2021-06-03', '11:00', '21:00', '重慶市', '重慶市', '', '', '', '1', 2, '上海春秋國(guó)旅美國(guó)分公司', '1985', '重慶上飛機(jī)', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-23 10:36:22', '2020-06-23 10:36:22', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ93UOGILC92', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '領(lǐng)隊(duì)顧見(jiàn)', 0, NULL, 0, 2, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265157, 'C2020062302', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '一泰國(guó)游111', 1, 1, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '上海浦東國(guó)際機(jī)場(chǎng)', '76', '2', '2021-11-11', '2021-11-12', '11:00', '21:00', '重慶市', '重慶市', '', '', '', '1', 2, '上海春秋國(guó)旅美國(guó)分公司', '1985', '重慶上飛機(jī)', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-23 10:39:01', '2020-06-23 10:39:01', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ845PB2RA85', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '領(lǐng)隊(duì)顧見(jiàn)', 0, NULL, 0, 2, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265158, 'qweqweqweqw121', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '其味無(wú)窮二無(wú)群', 1, 1, 4, 'u099', '1', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2021-11-01', '2021-11-02', '10:04', '10:04', '上海市', '上海市', '', '', '', '6', 1, '(有)日本トラベルＫＩＫＯ', '8176', '驅(qū)蚊器翁群翁群二無(wú)無(wú)群', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-23 10:53:08', '2020-06-23 10:59:42', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ97KSBYIV88', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '驅(qū)蚊器翁群', 0, NULL, 2, 1, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265160, '出境團(tuán)隊(duì)CE hi', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '上海政務(wù)對(duì)接業(yè)務(wù)出境游網(wǎng)上申報(bào)3', 1, 1, 4, '2322332', 'weew', '南京祿口國(guó)際機(jī)場(chǎng)', '南京祿口國(guó)際機(jī)場(chǎng)', '7', '7', '2020-06-23', '2020-06-27', '01:01', '05:05', '北京市', '北京市', '', '', '', '1', 1, '(有)南都観光社', '9296', '撒啊撒', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-23 11:42:41', '2020-06-23 11:42:41', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ5519I1ZO60', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265161, '1111', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', 'weqweqwewq', 1, 1, 4, 'u099', 'u990', '上海浦東國(guó)際機(jī)場(chǎng)', '上海浦東國(guó)際機(jī)場(chǎng)', '2', '2', '2020-06-23', '2020-06-25', '12:11', '12:12', '上海市', '上海市', '', '', '', '6', 1, '\nTARGET MOTIVATION DI TARGET TRAVEL S.R.L.', '12641', '阿斯頓撒大所多撒多', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-23 12:12:23', '2020-06-23 13:31:19', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ629M26K278', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 1, 1, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265165, '123123112313', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '12313123', 1, 1, 4, 'u099', 'u990', '上海浦東國(guó)際機(jī)場(chǎng)', '上海浦東國(guó)際機(jī)場(chǎng)', '2', '2', '2020-11-27', '2020-11-29', '12:11', '12:12', '上海市', '上海市', '', '', '', '6', 1, '\nTARGET MOTIVATION DI TARGET TRAVEL S.R.L.', '12641', '阿斯頓撒大所多撒多', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-23 13:32:02', '2020-06-23 13:32:02', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ48DMXU0U44', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 1, 1, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265167, 'asdadad', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '切爾奇二群翁群翁', 1, 1, 4, 'u099', '1', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2021-11-03', '2021-11-05', '10:04', '10:04', '上海市', '上海市', '', '', '', '6', 1, '(有)日本トラベルＫＩＫＯ', '8176', '驅(qū)蚊器翁群翁群二無(wú)無(wú)群', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-23 13:33:14', '2020-06-23 13:33:14', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ74MG8ICE17', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '驅(qū)蚊器翁群', 0, NULL, 0, 1, 1, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265170, 'zxczxczxc', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', 'asdadadad', 1, 1, 4, 'u099', '1', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2021-11-06', '2021-11-07', '10:04', '10:04', '上海市', '上海市', '', '', '', '6', 1, '(有)日本トラベルＫＩＫＯ', '8176', '驅(qū)蚊器翁群翁群二無(wú)無(wú)群', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-23 13:33:50', '2020-06-23 13:33:50', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ72A0WI1F43', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '驅(qū)蚊器翁群', 0, NULL, 0, 1, 1, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265178, '12312312313213', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '11231243123131', 9, 3, 4, '2322332', 'weew', '連云港口岸', '寧波鑠口', '16', '21', '2021-06-16', '2021-06-30', '05:04', '03:05', '北京市', '北京市區(qū)', '', '', '', '2', 1, '(株)國(guó)際旅行社', '10552', '描述行程', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-23 13:39:15', '2020-06-23 13:39:15', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT654NQK8945', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 1, 1, NULL, '', '', '32322332', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265182, '1231123123123', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '31231231321', 1, 1, 4, 'u099', '1', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2021-11-19', '2021-11-20', '10:04', '10:04', '上海市', '上海市', '', '', '', '6', 1, '(有)日本トラベルＫＩＫＯ', '8176', '驅(qū)蚊器翁群翁群二無(wú)無(wú)群', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 2, NULL, '', '', '', '', '2020-06-23 14:01:50', '2020-06-23 14:02:25', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ6423L0DT67', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '驅(qū)蚊器翁群', 0, NULL, 1, 1, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265183, 'HHUGHUF', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '港澳', 8, 2, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2021-11-11', '2021-11-20', '03:04', '21:03', '重慶市', '重慶市', '', '', '', '1', 3, '三通旅運(yùn)（香港）有限公司', '7662', '初到香港的第一天，行程可以安排得滿(mǎn)一些～今天依次打卡星光大道、尖沙咀，午后前往太平山頂，在這里可以眺望香港全景。太平山下山時(shí)會(huì)途徑“東方夏威夷”淺水灣。第一晚一定要留給維港，邊享用美食邊欣賞夜景～', '石子卿copy01', 'BV11958A', '18600000002', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-23 14:05:34', '2020-06-23 14:05:55', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GA28D6D9VW38', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '香港\n初到香港的第一天，行程可以安排得滿(mǎn)一些～今天依次打卡星光大道、尖沙咀，午后前往太平山頂，在這里可以眺望香港全景。太平山下山時(shí)會(huì)途徑“東方夏威夷”淺水灣。第一晚一定要留給維港，邊享用美食邊欣賞夜景～', 0, NULL, 1, 3, 4, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265184, 'C2020062303', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '一泰國(guó)游22', 1, 1, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2020-06-23', '2020-06-23', '04:00', '23:00', '重慶市', '重慶市', '', '', '', '1', 1, '上海旅游（香港）有限公司', '11333', '普', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 2, NULL, '', '', '', '', '2020-06-23 14:13:07', '2020-06-23 14:31:51', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ73NMLI4D18', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '1213備', 0, NULL, 0, 1, 1, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265186, 'C2020062304', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '一泰國(guó)游333', 1, 1, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2020-07-02', '2020-07-02', '04:00', '23:00', '重慶市', '重慶市', '', '', '', '1', 1, '上海旅游（香港）有限公司', '11333', '普', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '', '', '', '2020-06-23 14:20:08', '2020-06-23 14:44:08', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ59A4PW4W21', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '1213備', 0, NULL, 1, 1, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265187, 'C2020062305', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '二泰國(guó)游121', 1, 1, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2020-07-03', '2020-07-03', '04:00', '23:00', '重慶市', '重慶市', '', '上海', '124', '1', 1, '上海旅游（香港）有限公司', '11333', '普', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '中國(guó)', '中國(guó)', '', '2020-06-23 14:22:36', '2020-06-23 16:21:07', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ90SPJX1G00', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '1213備', 0, NULL, 0, 1, 1, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265188, 'abc543', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500112', '渝北區(qū)旅游局', '兩江游a兩江游a兩江游a兩江游a兩江游a兩江游a兩江游a兩江游a兩江游a兩江游a兩江游a兩江游a兩江', 12, 0, 3, '123', '123', NULL, NULL, NULL, NULL, '2020-06-23', '2020-06-23', '07:00', '20:00', '四川省', '成都市', '', '重慶市區(qū)', '500100', '4', 1, '中國(guó)國(guó)旅', '', '對(duì)法國(guó)隊(duì)是高大上是的發(fā)生的風(fēng)格', '', '', '', NULL, NULL, 9, NULL, '', '', '重慶市', '', '2020-06-23 14:28:31', '2020-06-24 14:51:13', NULL, 0, NULL, NULL, NULL, NULL, '123', '321', '', '', '', '', '上海悠揚(yáng)國(guó)際旅行社有限公司', '15001753471', '32032219093409888', NULL, NULL, NULL, NULL, 'LJ77K63JY372', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '出發(fā)', 0, NULL, 1, 1, 2, NULL, '胡一天', '15221550909', '', 0, '3', NULL);
INSERT INTO `tour_group` VALUES (5265189, '333', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '333', 7, 0, 2, '', '', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-19', '11:00', '06:07', '上海市', '上海市', '', '', '', '4', 2, '中國(guó)國(guó)旅', '', '', '', '', '', NULL, NULL, 1, NULL, '', '', '', '', '2020-06-23 14:48:07', '2020-06-23 14:51:50', NULL, 0, '123321', NULL, NULL, NULL, '123', NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GD39NFI15F34', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 2, 2, NULL, NULL, NULL, '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265191, '2020', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '重慶一日游', 7, 0, 2, '', '', NULL, NULL, NULL, NULL, '2020-06-21', '2020-06-22', '07:00', '07:00', '重慶市', '重慶市區(qū)', '', '', '', '5', 1, '中國(guó)國(guó)旅', '', '', '', '', '', NULL, NULL, 8, NULL, '', '', '', '', '2020-06-23 14:54:32', '2020-06-23 14:55:40', NULL, 0, '123321a', NULL, NULL, NULL, '123', '123321', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GD97O1NPXX61', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 2, 1, 3, NULL, NULL, NULL, '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265192, '2020A', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '李敏鎬一日游', 7, 0, 3, '', '', NULL, NULL, NULL, NULL, '2020-06-23', '2020-06-23', '07:00', '21:00', '河北省', '成安縣', '', '', '', '4', 1, '中國(guó)國(guó)旅', '', '', '', '', '', NULL, NULL, 1, NULL, '', '', '', '', '2020-06-23 15:38:31', '2020-06-30 20:10:42', NULL, 0, '1312', NULL, NULL, NULL, '123', '123', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GD533D9RXW78', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 3, 1, 4, NULL, NULL, NULL, '', 0, '2', NULL);
INSERT INTO `tour_group` VALUES (5265196, '2020吧', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '李鐘碩一日看', 7, 0, 3, '', '', NULL, NULL, NULL, NULL, '2020-06-23', '2020-06-23', '07:00', '21:00', '河北省', '成安縣', '', '', '', '4', 1, '中國(guó)國(guó)旅', '', '', '', '', '', NULL, NULL, 9, NULL, '', '', '', '', '2020-06-23 15:40:02', '2020-06-23 15:40:25', NULL, 0, '1312', NULL, NULL, NULL, '123', '123', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GD01RYENVG48', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 2, NULL, NULL, NULL, '', 0, '2', NULL);
INSERT INTO `tour_group` VALUES (5265199, 'C2020062306', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '俄羅斯g ', 1, 1, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2020-07-04', '2020-07-04', '04:00', '23:00', '重慶市', '重慶市', '', '上海', '124', '1', 1, '上海旅游（香港）有限公司', '11333', '普', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '中國(guó)', '中國(guó)', '', '2020-06-23 16:22:34', '2020-06-23 16:28:50', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ147RE9EH53', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '1213備', 0, NULL, 1, 1, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265201, 'FT2020062303', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', 'Cc臺(tái)灣', 9, 3, 4, 'A121322222', 'J454645333333', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2020-07-01', '2020-07-02', '05:00', '23:00', '重慶市', '重慶市', '', '臺(tái)北', '340', '1', 2, '臺(tái)灣運(yùn)達(dá)旅行社', '8233', '路線概覽\nD1龍山寺(1小時(shí)) → 西門(mén)町(2小時(shí)) → 西門(mén)紅樓(0.5小時(shí)) → 誠(chéng)品書(shū)店(西門(mén)町店)(1小時(shí)) → 臺(tái)北總統(tǒng)府(1小時(shí)) → 臺(tái)北101(3小時(shí)) → 臺(tái)北象山(3小時(shí))\n\nD2中正紀(jì)念堂(1小時(shí)) → 臺(tái)北士林官邸(1小時(shí)) → 臺(tái)北故宮博物院(3小時(shí)) → 寧夏夜市(2小時(shí))', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '臺(tái)北', '中國(guó)臺(tái)灣', '', '2020-06-23 16:25:17', '2020-06-29 10:53:42', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT38NOPNCL47', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '每年5-6月份是臺(tái)北的梅雨季節(jié)；7-9月整個(gè)臺(tái)灣進(jìn)入臺(tái)風(fēng)季，雖然臺(tái)北市并不臨海，但可能會(huì)對(duì)航班等交通造成影響，建議根據(jù)天氣情況，錯(cuò)時(shí)出行。', 0, NULL, 0, 2, 2, NULL, '', '', 'T－7489', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265202, 'GA2020062301', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500112', '渝北區(qū)旅游局', 'Cc港澳', 8, 2, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2020-06-26', '2020-06-28', '03:04', '21:03', '重慶市', '重慶市', '', '', '', '1', 3, '三通旅運(yùn)（香港）有限公司', '7662', '初到香港的第一天，行程可以安排得滿(mǎn)一些～今天依次打卡星光大道、尖沙咀，午后前往太平山頂，在這里可以眺望香港全景。太平山下山時(shí)會(huì)途徑“東方夏威夷”淺水灣。第一晚一定要留給維港，邊享用美食邊欣賞夜景～', '石子卿copy01', 'BV11958A', '18600000002', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 2, NULL, '', '', '', '', '2020-06-23 16:34:16', '2020-06-23 16:34:41', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GA57I2E3QQ34', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '香港\n初到香港的第一天，行程可以安排得滿(mǎn)一些～今天依次打卡星光大道、尖沙咀，午后前往太平山頂，在這里可以眺望香港全景。太平山下山時(shí)會(huì)途徑“東方夏威夷”淺水灣。第一晚一定要留給維港，邊享用美食邊欣賞夜景～', 0, NULL, 1, 3, 4, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265204, '測(cè)試新增', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '上海政務(wù)對(duì)接業(yè)務(wù)出境游網(wǎng)上申報(bào)3', 1, 1, 4, '北京', '北京', '北京首都國(guó)際機(jī)場(chǎng)', '北京首都國(guó)際機(jī)場(chǎng)', '4', '4', '2020-07-17', '2020-07-18', '02:03', '03:04', '北京市', '北京市區(qū)', '', '北京', '125', '6', 1, '(株)JTB北海道', '11863', '23332', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '中國(guó)', '中國(guó)', '', '2020-06-23 17:10:39', '2020-06-23 17:10:39', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ58DFYTFY50', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265208, '1231122211', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '123241212231', 1, 1, 4, '北京', '北京', '北京首都國(guó)際機(jī)場(chǎng)', '北京首都國(guó)際機(jī)場(chǎng)', '4', '4', '2021-07-15', '2021-08-06', '02:03', '03:04', '北京市', '北京市區(qū)', '', '東京', '586', '6', 1, '(株)JTB北海道', '11863', '23332', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '日本', '日本', '', '2020-06-24 10:40:42', '2020-06-30 15:13:23', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ10YS9NZ730', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 0, 0, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265209, 'C2020062401', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '曼谷芭提雅經(jīng)典五日游', 1, 1, 4, 'SSS323', 'SSS121', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2020-07-05', '2020-07-05', '06:00', '18:00', '重慶市', '重慶市', '', '曼谷', '215', '1', 1, '珍珠假期有限公司', '11509', '路線按景點(diǎn)熱度和位置來(lái)安排，5天時(shí)間不僅可以游玩曼谷、芭提雅知名景點(diǎn)，還可以在熱門(mén)商圈血拼購(gòu)物，讓自己滿(mǎn)載而歸。路線按景點(diǎn)熱度和位置來(lái)安排，5天時(shí)間不僅可以游玩曼谷、芭提雅知名景點(diǎn)，還可以在熱門(mén)商圈血拼購(gòu)物，讓自己滿(mǎn)載而歸。路線按景點(diǎn)熱度和位置來(lái)安排，5天時(shí)間不僅可以游玩曼谷、芭提雅知名景點(diǎn)，還可以在熱門(mén)商圈血拼購(gòu)物，讓自己滿(mǎn)載而歸。路線按景點(diǎn)熱度和位置來(lái)安排，5天時(shí)間不僅可以游玩曼谷、芭提雅知名景點(diǎn)，還可以在熱門(mén)商圈血拼購(gòu)物，讓自己滿(mǎn)載而歸。路線按景點(diǎn)熱度和位置來(lái)安排，5天時(shí)間不僅可以游玩曼谷、芭提雅知名景點(diǎn)，還可以在熱門(mén)商圈血拼購(gòu)物，讓自己滿(mǎn)載而歸。路線按景點(diǎn)熱度和位置來(lái)安排，5天時(shí)間不僅可以游玩曼谷、芭提雅知名景點(diǎn)，還可以在熱門(mén)商圈血拼購(gòu)物，讓自己滿(mǎn)載而歸。路線按景點(diǎn)熱度和位置來(lái)安排，5天時(shí)間不僅可以游玩曼谷、芭提雅知名景點(diǎn)，還可以在熱門(mén)商圈血拼購(gòu)物，讓自己滿(mǎn)載而歸。路線按景點(diǎn)熱度和位置來(lái)安排，5天時(shí)間不僅可以游玩曼谷、芭提雅知名景點(diǎn)，還可以在熱門(mén)商圈血拼購(gòu)物，讓自己滿(mǎn)載而歸。', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 7, NULL, '', '泰國(guó)', '泰國(guó)', '', '2020-06-24 14:41:03', '2020-06-24 14:41:33', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ48OLZNNF61', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '路線按景點(diǎn)熱度和位置來(lái)安排，5天時(shí)間不僅可以游玩曼谷、芭提雅知名景點(diǎn)，還可以在熱門(mén)商圈血拼購(gòu)物，讓自己滿(mǎn)載而歸。路線按景點(diǎn)熱度和位置來(lái)安排，5天時(shí)間不僅可以游玩曼谷、芭提雅知名景點(diǎn)，還可以在熱門(mén)商圈血拼購(gòu)物，讓自己滿(mǎn)載而歸。路線按景點(diǎn)熱度和位置來(lái)安排，5天時(shí)間不僅可以游玩曼谷、芭提雅知名景點(diǎn)，還可以在熱門(mén)商圈血拼購(gòu)物，讓自己滿(mǎn)載而歸。路線按景點(diǎn)熱度和位置來(lái)安排，5天時(shí)間不僅可以游玩曼谷、芭提雅知名景點(diǎn)，還可以在熱門(mén)商圈血拼購(gòu)物，讓自己滿(mǎn)載而歸。路線按景點(diǎn)熱度和位置來(lái)安排，5天時(shí)間不僅可以游玩曼谷、芭提雅知名景點(diǎn)，還可以在熱門(mén)商圈血拼購(gòu)物，讓自己滿(mǎn)載而歸。路線按景點(diǎn)熱度和位置來(lái)安排，5天時(shí)間不僅可以游玩曼谷、芭提雅知名景點(diǎn)，還可以在熱門(mén)商圈血拼購(gòu)物，讓自己滿(mǎn)載而歸。路線按景點(diǎn)熱度和位置來(lái)安排，5天時(shí)間不僅可以游玩曼谷、芭提雅知名景點(diǎn)，還可以在熱門(mén)商圈血拼購(gòu)物，讓自己滿(mǎn)載而歸。', 0, NULL, 2, 1, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265211, 'GA2020062401', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500112', '渝北區(qū)旅游局', 'Cc港澳Cc港澳Cc港澳', 8, 2, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2020-06-26', '2020-06-28', '03:04', '21:03', '重慶市', '重慶市', '', '香港', '748', '1', 3, '三通旅運(yùn)（香港）有限公司', '7662', '初到香港的第一天，行程可以安排得滿(mǎn)一些～今天依次打卡星光大道、尖沙咀，午后前往太平山頂，在這里可以眺望香港全景。太平山下山時(shí)會(huì)途徑“東方夏威夷”淺水灣。第一晚一定要留給維港，邊享用美食邊欣賞夜景～', '劉萍萍copy01', 'JSP5348A', '13800150487', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '香港', '中國(guó)香港', '', '2020-06-24 15:44:02', '2020-06-24 15:46:00', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GA315K2RXS34', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '香港\n初到香港的第一天，行程可以安排得滿(mǎn)一些～今天依次打卡星光大道、尖沙咀，午后前往太平山頂，在這里可以眺望香港全景。太平山下山時(shí)會(huì)途徑“東方夏威夷”淺水灣。第一晚一定要留給維港，邊享用美食邊欣賞夜景～', 0, NULL, 1, 3, 4, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265212, '鳳凰于飛更好', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '發(fā)過(guò)火鳳凰', 13, 0, 2, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-19', '13:00', '22:00', '重慶市', '重慶市', '', '重慶市區(qū)', '500100', '4', 1, '中國(guó)國(guó)旅', '', '對(duì)方觀看哈大家', '', '', '', NULL, NULL, 1, NULL, '', '', '重慶市', '', '2020-06-28 09:20:30', '2020-06-28 09:20:30', NULL, 0, NULL, NULL, NULL, NULL, '123', '123', '', '', '', '', '上海悠揚(yáng)國(guó)際旅行社有限公司', '15001753471', NULL, NULL, NULL, NULL, NULL, 'BJ597TCESZ18', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 1, 1, NULL, NULL, NULL, '', 0, '1', NULL);
INSERT INTO `tour_group` VALUES (5265215, 'C2020062801', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '童話(huà)鎮(zhèn)★斯里蘭卡平價(jià)輕奢樂(lè)享7日6晚純玩游', 1, 1, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2020-07-08', '2020-07-14', '06:00', '23:00', '重慶市', '重慶市', '', '加勒老城', '191', '1', 7, '(株）重元旅遊', '8151', '在行程游覽過(guò)程中，導(dǎo)游可能會(huì)向您推薦如下自費(fèi)項(xiàng)目，您可以根據(jù)您的自身情況，自愿選擇參加自己喜歡的自費(fèi)項(xiàng)目。', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 4, NULL, '', '斯里蘭卡', '斯里蘭卡', '', '2020-06-28 09:25:20', '2020-06-29 13:55:08', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ64G29VXB54', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '【產(chǎn)品優(yōu)勢(shì)】驢媽媽自營(yíng)，千人出游！品控至上，20人精致小團(tuán)，匠心打造！\n\n驚喜1：每位成人一張3G卡：1G流量；撥打中國(guó)地區(qū)電話(huà)！貼心好禮\n驚喜2：cooking class體驗(yàn)，在美麗的馬塔萊香料園，選擇喜歡的香料和食材，在當(dāng)?shù)乩蠋煹闹笇?dǎo)下通過(guò)自己的雙手做出當(dāng)?shù)氐拿朗常n驚喜3：如果您是蜜月，那么請(qǐng)告訴客服，我們將為您安排您的專(zhuān)屬蜜月布置，給您浪漫之旅！\n以下提供★表示住客網(wǎng)絡(luò)評(píng)分（住客網(wǎng)絡(luò)評(píng)分其信息僅供參考，不做合同依據(jù)），此線路參考住宿級(jí)別為：南部海濱酒店★★★★★，其他地區(qū)酒店★★★★。', 0, NULL, 0, 7, 7, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265218, 'C20200628', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '新馬泰五日游', 1, 1, 4, 'SZ2011', 'SZ2021', '深圳蛇口港口岸', '深圳皇崗口岸', '81', '82', '2020-02-04', '2020-02-12', '07:00', '20:00', '重慶市', '重慶市', '', '圣淘沙', '242', '1', 5, '洲際(香港)旅遊有限公司 ', '12403', '先去大山 再去大河', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 9, NULL, '', '新加坡', '新加坡', '', '2020-06-28 10:14:50', '2020-06-28 11:13:04', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ526YH82581', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '購(gòu)物團(tuán)', 0, NULL, 0, 5, 5, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265237, 'XG20200628', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '港澳了二零2', 8, 2, 4, 'A111', 'A222', '深圳蛇口港口岸', '深圳寶安國(guó)際機(jī)場(chǎng)', '81', '11', '2020-07-25', '2020-07-31', '00:00', '03:00', '重慶市', '重慶市', '', '香港', '748', '1', 1, '(株)JTB中國(guó)', '10346', '阿斯頓噶發(fā)', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '中國(guó)香港', '中國(guó)香港', '', '2020-06-28 14:25:29', '2020-06-28 14:25:29', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GA946XIKD611', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265238, 'XG202006282', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '啊多發(fā)點(diǎn)', 8, 2, 4, 'A111', 'A222', '深圳寶安國(guó)際機(jī)場(chǎng)', '深圳寶安國(guó)際機(jī)場(chǎng)', '11', '11', '2020-06-03', '2020-06-11', '01:00', '03:00', '廣東省', '深圳市', '', '香港', '748', '1', 1, '(株)JTB中國(guó)', '10346', '大風(fēng)歌哇', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '中國(guó)香港', '中國(guó)香港', '', '2020-06-28 14:26:46', '2020-06-29 12:42:24', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GA5377X1T104', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '阿迪斯發(fā)到付', 0, NULL, 0, 1, 1, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265240, 'TW202006282', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '臺(tái)灣深度游', 9, 3, 4, 'A111', 'A222', '深圳寶安國(guó)際機(jī)場(chǎng)', '深圳寶安國(guó)際機(jī)場(chǎng)', '11', '11', '2020-07-24', '2020-07-31', '02:02', '02:02', '重慶市', '重慶市', '', '高雄', '346', '1', 1, '中國(guó)(香港)卓越國(guó)旅國(guó)際旅行社有限公司', '11423', '啊v大v啊v', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '中國(guó)臺(tái)灣', '中國(guó)臺(tái)灣', '', '2020-06-28 14:50:09', '2020-06-28 14:50:14', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT333KTAYY00', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '的VS的', 0, NULL, 1, 1, 2, NULL, '', '', 'A1111', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265241, 'RJJD111', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '接待團(tuán)1', 6, 0, 1, '', '', NULL, NULL, NULL, NULL, '2020-07-01', '2020-07-05', '04:00', '04:04', NULL, '', '', '黃山市', '341000', '', 1, '重慶旅行社', '', '', '', '', '', NULL, NULL, 1, NULL, '', '', '安徽省', '', '2020-06-28 15:25:55', '2020-06-28 15:25:59', NULL, 0, '121212', NULL, '啊發(fā)發(fā)的', NULL, '大方地說(shuō)', 'A12333', '', '', '', '', '阿飛大', '18555555555555555釘釘', '呃33額我熱我熱', NULL, NULL, NULL, NULL, 'RJ60R7FZXG84', '菲律賓打發(fā)撒旦', NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '大幅度', '123第三個(gè)', '的撒發(fā)達(dá)發(fā)', 0, NULL, 0, 1, 1, NULL, NULL, NULL, '', 0, '1', NULL);
INSERT INTO `tour_group` VALUES (5265248, 'CJTD20200628', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '處境玩兒', 1, 1, 4, 'A111', 'A222', '深圳灣口岸', '深圳寶安國(guó)際機(jī)場(chǎng)', '83', '11', '2019-01-24', '2019-01-25', '06:00', '05:00', '重慶市', '重慶市', '', '甲米', '209', '1', 1, '中國(guó)旅行サービス㈱', '10292', '阿迪斯發(fā)', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 2, NULL, '', '泰國(guó)', '泰國(guó)', '', '2020-06-28 16:15:17', '2020-06-30 17:30:22', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ868QD4UZ54', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '愛(ài)上放大撒', 0, NULL, 2, 1, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265252, 'FT2020062901', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '臺(tái)灣環(huán)島經(jīng)典', 9, 3, 4, 'D222', 'D111', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2020-08-01', '2020-08-02', '02:00', '22:00', '重慶市', '重慶市', '', '臺(tái)北', '340', '1', 1, '臺(tái)灣西敏旅行社', '874', '到達(dá)臺(tái)中后需換乘高鐵前往高雄，車(chē)程1小時(shí)，價(jià)格790臺(tái)幣。', '丁常梅copy01', 'LVE7559A', '13800151470', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '中國(guó)臺(tái)灣', '中國(guó)臺(tái)灣', '', '2020-06-29 09:41:54', '2020-06-29 10:37:05', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FT34LCLWZJ81', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '包括了臺(tái)灣大部分重要城市和風(fēng)景區(qū)，能全面的了解一個(gè)真實(shí)的臺(tái)灣。', 0, NULL, 0, 1, 1, NULL, '', '', 'LLL－12', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265253, '20200629', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '和空間規(guī)劃', 13, 0, 2, '123', '123', NULL, NULL, NULL, NULL, '2020-06-29', '2020-06-29', '07:00', '22:00', '重慶市', '重慶市', '', '重慶市區(qū)', '500100', '4', 1, '中國(guó)國(guó)旅', '', '對(duì)方觀看哈大家', '', '', '', NULL, NULL, 9, NULL, '', '', '重慶市', '', '2020-06-29 09:49:45', '2020-06-29 09:50:09', NULL, 0, NULL, NULL, NULL, NULL, '123', '123', '', '', '', '', '上海悠揚(yáng)國(guó)際旅行社有限公司', '15001753471', NULL, NULL, NULL, NULL, NULL, 'BJ89UCN12G16', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 2, NULL, NULL, NULL, '', 0, '1', NULL);
INSERT INTO `tour_group` VALUES (5265255, 'GA2020062901', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', 'Cc港澳Cc港澳Cc港澳Cc港澳Cc港澳', 8, 2, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2020-07-01', '2020-07-03', '03:04', '21:03', '重慶市', '重慶市', '', '香港', '748', '1', 3, '三通旅運(yùn)（香港）有限公司', '7662', '初到香港的第一天，行程可以安排得滿(mǎn)一些～今天依次打卡星光大道、尖沙咀，午后前往太平山頂，在這里可以眺望香港全景。太平山下山時(shí)會(huì)途徑“東方夏威夷”淺水灣。第一晚一定要留給維港，邊享用美食邊欣賞夜景～', '石子卿copy01', 'BV11958A', '18600000002', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '香港', '中國(guó)香港', '', '2020-06-29 10:55:12', '2020-06-29 12:42:04', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GA456E3CPF68', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '香港\n初到香港的第一天，行程可以安排得滿(mǎn)一些～今天依次打卡星光大道、尖沙咀，午后前往太平山頂，在這里可以眺望香港全景。太平山下山時(shí)會(huì)途徑“東方夏威夷”淺水灣。第一晚一定要留給維港，邊享用美食邊欣賞夜景～', 0, NULL, 0, 3, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265256, '2020e2e2e', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', 'efsdf', 1, 1, 4, 'A111', 'A222', '深圳寶安國(guó)際機(jī)場(chǎng)', '深圳寶安國(guó)際機(jī)場(chǎng)', '11', '11', '2020-03-04', '2020-03-05', '02:00', '03:03', '重慶市', '重慶市', '', '皮皮島', '210', '1', 1, '(株)大地エージェンシー', '10475', '游覽泰國(guó)風(fēng)情', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 2, NULL, '', '泰國(guó)', '泰國(guó)', '', '2020-06-29 17:17:00', '2020-06-29 17:18:48', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ589HMBL345', NULL, NULL, '', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '阿凡達(dá)發(fā)大', 0, NULL, 2, 1, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265258, '123123111', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '2313123213123', 2, 0, 3, '123', '123', NULL, NULL, NULL, NULL, '2019-01-15', '2019-01-17', '07:00', '13:00', '江蘇省', '南京市', '', '鄂爾多斯市', '150600', '6', 1, '中國(guó)國(guó)旅', '', '分公司地方', '', '', '', NULL, NULL, 1, NULL, '', '', '內(nèi)蒙古自治區(qū)', '', '2020-06-30 16:52:06', '2020-06-30 18:15:16', NULL, 0, NULL, NULL, NULL, NULL, '123', NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GN069ELTDK75', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 2, 1, 3, NULL, NULL, NULL, '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265260, 'qwewqewqe', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '惡氣額為', 1, 1, 4, '北京', '北京', '北京首都國(guó)際機(jī)場(chǎng)', '北京首都國(guó)際機(jī)場(chǎng)', '4', '4', '2019-07-04', '2019-07-07', '02:03', '03:04', '北京市', '北京市區(qū)', '', '東京', '586', '5', 1, '(株)JTB北海道', '11863', '23332', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 9, NULL, '', '日本', '日本', '', '2020-06-30 18:20:37', '2020-06-30 18:21:29', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ397Q4Y3J91', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265262, 'adadas', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', 'addassda', 8, 2, 4, 'A12132', 'J454645', '重慶江北國(guó)際機(jī)場(chǎng)', '重慶江北國(guó)際機(jī)場(chǎng)', '76', '76', '2019-07-08', '2019-07-09', '03:04', '21:03', '重慶市', '重慶市', '', '香港', '748', '1', 3, '三通旅運(yùn)（香港）有限公司', '7662', '初到香港的第一天，行程可以安排得滿(mǎn)一些～今天依次打卡星光大道、尖沙咀，午后前往太平山頂，在這里可以眺望香港全景。太平山下山時(shí)會(huì)途徑“東方夏威夷”淺水灣。第一晚一定要留給維港，邊享用美食邊欣賞夜景～', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '香港', '中國(guó)香港', '', '2020-06-30 18:23:09', '2020-06-30 18:23:09', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GA90U06SZL57', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '香港\n初到香港的第一天，行程可以安排得滿(mǎn)一些～今天依次打卡星光大道、尖沙咀，午后前往太平山頂，在這里可以眺望香港全景。太平山下山時(shí)會(huì)途徑“東方夏威夷”淺水灣。第一晚一定要留給維港，邊享用美食邊欣賞夜景～', 0, NULL, 0, 1, 1, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265264, '123131312', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '兩江游組團(tuán)', 2, 0, 3, '123', '123', NULL, NULL, NULL, NULL, '2019-07-11', '2019-07-12', '07:00', '13:00', '江蘇省', '南京市', '', '鄂爾多斯市', '150600', '6', 1, '中國(guó)國(guó)旅', '', '分公司地方', '', '', '', NULL, NULL, 1, NULL, '', '', '內(nèi)蒙古自治區(qū)', '', '2020-06-30 18:24:11', '2020-06-30 18:24:11', NULL, 0, NULL, NULL, NULL, NULL, '123', NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GN04DZYLVW46', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 1, NULL, NULL, NULL, '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265265, 'QERTYUU', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '赴臺(tái)游組團(tuán)', 2, 0, 3, '123', '123', NULL, NULL, NULL, NULL, '2019-07-11', '2019-07-12', '07:00', '13:00', '江蘇省', '南京市', '', '鄂爾多斯市', '150600', '6', 1, '中國(guó)國(guó)旅', '', '分公司地方', '', '', '', NULL, NULL, 1, NULL, '', '', '內(nèi)蒙古自治區(qū)', '', '2020-06-30 18:24:47', '2020-06-30 18:25:41', NULL, 0, NULL, NULL, NULL, NULL, '123', NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GN85QRDT9O66', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 2, 1, 2, NULL, NULL, NULL, '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265268, '124565432', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '2345321', 2, 0, 3, '123', '123', NULL, NULL, NULL, NULL, '2019-07-13', '2019-07-14', '07:00', '13:00', '江蘇省', '南京市', '', '鄂爾多斯市', '150600', '6', 1, '中國(guó)國(guó)旅', '', '分公司地方', '', '', '', NULL, NULL, 1, NULL, '', '', '內(nèi)蒙古自治區(qū)', '', '2020-06-30 18:33:38', '2020-06-30 18:33:38', NULL, 0, NULL, NULL, NULL, NULL, '123', NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GN30ATMJO024', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 1, NULL, NULL, NULL, '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265270, '1245654321', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '2345321', 2, 0, 3, '123', '123', NULL, NULL, NULL, NULL, '2019-07-21', '2019-07-22', '07:00', '13:00', '江蘇省', '南京市', '', '鄂爾多斯市', '150600', '6', 1, '中國(guó)國(guó)旅', '', '分公司地方', '', '', '', NULL, NULL, 1, NULL, '', '', '內(nèi)蒙古自治區(qū)', '', '2020-06-30 18:52:40', '2020-06-30 18:52:40', NULL, 0, NULL, NULL, NULL, NULL, '123', NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GN33F3ESZV55', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 1, NULL, NULL, NULL, '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265271, '124565432123', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '2345321', 2, 0, 3, '123', '123', NULL, NULL, NULL, NULL, '2019-07-23', '2019-07-24', '07:00', '13:00', '江蘇省', '南京市', '', '鄂爾多斯市', '150600', '6', 1, '中國(guó)國(guó)旅', '', '分公司地方', '', '', '', NULL, NULL, 1, NULL, '', '', '內(nèi)蒙古自治區(qū)', '', '2020-06-30 19:02:13', '2020-06-30 19:02:13', NULL, 0, NULL, NULL, NULL, NULL, '123', NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GN15ZZ4D2X40', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 1, 1, NULL, NULL, NULL, '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265274, '1231231223', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '131313213', 1, 1, 4, '北京', '北京', '北京首都國(guó)際機(jī)場(chǎng)', '北京首都國(guó)際機(jī)場(chǎng)', '4', '4', '2019-07-17', '2019-07-18', '02:03', '03:04', '北京市', '北京市區(qū)', '', '東京', '586', '6', 1, '(株)JTB北海道', '11863', '23332', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '日本', '日本', '', '2020-06-30 19:51:29', '2020-06-30 19:51:29', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ27UOZPYN61', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 1, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265275, '123212313', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '123123123', 1, 1, 4, '北京', '北京', '北京首都國(guó)際機(jī)場(chǎng)', '北京首都國(guó)際機(jī)場(chǎng)', '4', '4', '2019-07-19', '2019-07-20', '02:03', '03:04', '北京市', '北京市區(qū)', '', '東京', '586', '6', 1, '(株)JTB北海道', '11863', '23332', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '日本', '日本', '', '2020-06-30 19:53:13', '2020-06-30 19:53:13', '2020-06-30 20:04:31', 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ10SI3DQ251', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 1, 1, 1, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265276, '1232123131', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '123123123', 1, 1, 4, '北京', '北京', '北京首都國(guó)際機(jī)場(chǎng)', '北京首都國(guó)際機(jī)場(chǎng)', '4', '4', '2019-07-21', '2019-07-22', '02:03', '03:04', '北京市', '北京市區(qū)', '', '東京', '586', '6', 1, '(株)JTB北海道', '11863', '23332', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '日本', '日本', '', '2020-06-30 19:56:07', '2020-06-30 19:56:07', '2020-06-30 20:04:31', 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ00U5TGA364', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 1, 1, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265278, '12312312312231', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '13123123123123', 1, 1, 4, '北京', '北京', '北京首都國(guó)際機(jī)場(chǎng)', '北京首都國(guó)際機(jī)場(chǎng)', '4', '4', '2019-07-23', '2019-07-24', '02:03', '03:04', '北京市', '北京市區(qū)', '', '東京', '586', '6', 1, '(株)JTB北海道', '11863', '23332', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '日本', '日本', '', '2020-06-30 20:04:10', '2020-06-30 20:04:10', '2020-06-30 20:04:31', 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ61M7MYYX45', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 1, 1, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265279, '123123313', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '', '', '1231231231231', 1, 1, 4, '北京', '北京', '北京首都國(guó)際機(jī)場(chǎng)', '北京首都國(guó)際機(jī)場(chǎng)', '4', '4', '2019-07-25', '2019-07-26', '02:03', '03:04', '北京市', '北京市區(qū)', '', '東京', '586', '6', 1, '(株)JTB北海道', '11863', '23332', '顧見(jiàn)copy01', 'OQ37481A', '13800150228', '2020-11-01', '重慶洲際國(guó)際旅行社有限責(zé)任公司', 1, NULL, '', '日本', '日本', '', '2020-06-30 20:04:53', '2020-06-30 20:04:53', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CJ79D4Z2IL95', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 1, 1, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265280, '1231321312231', '34132', '重慶洲際國(guó)際旅行社有限責(zé)任公司', '500000', '重慶市旅游局', '1312312313', 7, 0, 3, '', '', NULL, NULL, NULL, NULL, '2020-06-23', '2020-06-23', '07:00', '21:00', '河北省', '成安縣', '', '成都市', '510100', '4', 1, '中國(guó)國(guó)旅', '', '', '', '', '', NULL, NULL, 1, NULL, '', '', '四川省', '', '2020-06-30 20:08:01', '2020-06-30 20:10:30', NULL, 0, '1312', NULL, NULL, NULL, '123', '123', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GD53QIOBUD17', NULL, NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 0, 0, 0, NULL, NULL, NULL, '', 0, '2', NULL);
INSERT INTO `tour_group` VALUES (5265281, '20200702', '34127', '重慶黃金假期國(guó)際旅行社有限公司', '', '', '導(dǎo)游', 2, 0, 2, '123', '123', NULL, NULL, NULL, NULL, '2020-07-02', '2020-07-03', '07:00', '17:00', '四川省', '成都市', '', '成都市', '510100', '4', 1, '中國(guó)國(guó)旅', '', '發(fā)搞活動(dòng)覆蓋和地方發(fā)給對(duì)方過(guò)后', '', '', '', NULL, NULL, 1, NULL, '', '', '四川省', '', '2020-07-02 10:21:24', '2020-07-02 10:27:02', NULL, 0, NULL, NULL, NULL, NULL, '234242', '對(duì)方溝通的風(fēng)格', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'GN54DI376B75', NULL, NULL, '17300000198', '17300000198', '500112', 1, '', '', '', '', NULL, NULL, '', '', '', '', '', 0, NULL, 9, 1, 10, NULL, NULL, NULL, '', 0, NULL, NULL);

SET FOREIGN_KEY_CHECKS = 1;

以上就是兩種方法實(shí)現(xiàn)mysql分組計(jì)數(shù)，范圍匯總的詳細(xì)內(nèi)容，更多關(guān)于mysql分組計(jì)數(shù)，范圍匯總的資料請(qǐng)關(guān)注腳本之家其它相關(guān)文章！

您可能感興趣的文章:
  • 詳解mysql 獲取某個(gè)時(shí)間段每一天、每一個(gè)小時(shí)的統(tǒng)計(jì)數(shù)據(jù)
  • MySQL按時(shí)間統(tǒng)計(jì)數(shù)據(jù)的方法總結(jié)
  • mysql 獲取規(guī)定時(shí)間段內(nèi)的統(tǒng)計(jì)數(shù)據(jù)
  • MySQL中實(shí)現(xiàn)高性能高并發(fā)計(jì)數(shù)器方案（例如文章點(diǎn)擊數(shù)）
  • Mysql auto_increment 重新計(jì)數(shù)(讓id從1開(kāi)始)
  • 用PHP和MYSQL建立計(jì)數(shù)器過(guò)程詳解
  • Mysql按條件計(jì)數(shù)多種實(shí)現(xiàn)方法詳解

標(biāo)簽：益陽(yáng) 澳門(mén) 白銀 寧夏 定西 秦皇島 恩施 杭州

巨人網(wǎng)絡(luò)通訊聲明：本文標(biāo)題《兩種方法實(shí)現(xiàn)mysql分組計(jì)數(shù)，范圍匯總》，本文關(guān)鍵詞  兩種,方法,實(shí)現(xiàn),mysql,分組,；如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問(wèn)題，煩請(qǐng)?zhí)峁┫嚓P(guān)信息告之我們，我們將及時(shí)溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò)，涉及言論、版權(quán)與本站無(wú)關(guān)。
  • 相關(guān)文章
  • 下面列出與本文章《兩種方法實(shí)現(xiàn)mysql分組計(jì)數(shù)，范圍匯總》相關(guān)的同類(lèi)信息！
  • 本頁(yè)收集關(guān)于兩種方法實(shí)現(xiàn)mysql分組計(jì)數(shù)，范圍匯總的相關(guān)信息資訊供網(wǎng)民參考！
    • 推薦文章
    午夜写真片福利电影网| 国产亚洲一区在线| 成人在线电影网| 亚洲激情在线激情| 3atv在线一区二区三区| 天天综合中文字幕| 亚洲高清视频一区二区| 俺去亚洲欧洲欧美日韩| 成人夜色视频网站在线观看| 久久亚洲视频| 久久aimee| 天天摸天天操天天干| 国产麻豆视频网站| 亚洲不卡一区二区三区| 女人裸体免费网站| av资源网在线播放| 4k岛国日韩精品**专区| 韩国女主播一区二区| 国自产拍在线网站网址视频| 日韩免费成人| 国产xxxx在线观看| 国产精品视频专区| 日韩视频免费观看高清完整版| 欧美经典一区二区三区| 亚洲欧美清纯在线制服| 国产特黄在线| 在线播放亚洲精品| 女同久久另类69精品国产| 国产精品美女久久久久av福利| 无圣光视频在线观看| 黄色一级片av| 欧美日韩色综合| 欧美精品一区二区三区在线四季| 久久精品盗摄| 日韩av在线精品| 我要看一级黄色录像| 麻豆网站在线看| 国产xxx69麻豆国语对白| 一二三四视频免费观看在线看| 国产精品一区二区91| 色av性av丰满av| 国产日韩欧美精品电影三级在线| 国内精品久久久久久久果冻传媒| 欧美二区三区91| 亚洲精品久久久久久下一站| www.av91| 国产999精品久久久| 亚洲最快最全在线视频| 一级黄色片网站| av电影在线免费| 国产一区二区中文字幕| 日韩在线一区二区三区免费视频| 动漫精品一区二区三区| 中文字幕一区二区视频| 蜜桃av噜噜一区| 亚洲精品一区二区网址| 欧美777四色影| 国产视频精品网| 91超薄肉色丝袜交足高跟凉鞋| 国产盗摄xxxx视频xxx69| 91黄色在线观看| 唐朝av高清盛宴| 性感美女福利视频| 国产专区精品| 国产在线精品免费av| 国产午夜久久av| 国产白袜脚足j棉袜在线观看| 国产亚洲综合色| 亚洲三级免费观看| 日韩欧美一区视频| 久久九九国产| 日本午夜在线视频| 亚色视频在线观看| 黄色小视频在线免费观看| 精品一级视频| 今天免费高清在线观看国语| 北条麻妃在线观看视频| 欧美精品不卡| 日韩精品在线免费视频| 免费h视频网站| 国产乱子视频| 精品人妻午夜一区二区三区四区| free性中国hd国语露脸| 欧美视频第二页| 亚洲第一网站在线观看| 成人三级高清视频在线看| 久久久电影一区二区三区| 成人在线视频www| 天堂视频福利| 久色成人在线| 国产精品热视频| 精品久久久久久中文字幕2017| 一本一道精品欧美中文字幕| 免费在线视频一区二区| 美女尤物久久精品| 精品欧美色视频网站在线观看| 亚洲欧美一区二区久久| 欧美综合影院| 国产美女精彩久久| 免费在线观看日韩欧美| 特黄一区二区三区| 国产高清一区| 成人羞羞视频播放网站| 国产午夜精品久久久久久免费视| 清纯唯美亚洲色图| 污版网站在线观看| 国产高清视频在线播放| av在线播放资源| 欧美搞黄网站| 日本高清精品| 日本a级片视频| 国精品一区二区三区| 人妻无码中文久久久久专区| 在线观看美女av| 欧美激情亚洲精品| 伊人久久亚洲美女图片| 九九热这里只有| 久久免费的精品国产v∧| 日韩网站免费观看| 波多野结衣一区二区| 国产精品专区免费| 欧美18 19xxx| 91在线码无精品| fpee性欧美| 国产精品99精品久久免费| 97精品人妻一区二区三区| 色呦呦日韩精品| 国产欧美高清在线| 欧美日韩1234| 久久在线观看| 亚洲成人av免费看| 国产精品久久久精品四季影院| 国产精选久久| 在线麻豆国产传媒1国产免费| 成年女人免费毛片视频永久| 国产精品日日摸夜夜添夜夜av| 亚洲激情自拍视频| 亚洲一区二区视频在线| 成人嫩草影院| 99久久精品日本一区二区免费| 九九九九九九精品任你躁| 黄色在线视频网| 午夜精品区一区二区三| 9久久婷婷国产综合精品性色| 国产成人精品无码播放| 国产麻豆一区二区三区在线观看| 好看的av在线不卡观看| 色88888久久久久久影院| a'aaa级片在线观看| 久久国产柳州莫菁门| 特大巨黑人吊性xxx视频| 超碰这里只有精品| 在线观看亚洲免费视频| 91资源在线视频| 又色又爽又高潮免费视频国产| 久久黄色片视频| 色综合久久久久无码专区| 欧美极品另类| 夫妻性生活毛片| 欧美色图第二页| 欧美日韩在线精品一区二区三区激情综合| 亚洲少妇18p| 欧美激情自拍偷拍| 天天操人人干| 国产乱人伦偷精品视频免下载| 亚洲黄色成人网| 国产精品77777竹菊影视小说| 国产一级片免费观看| 在线天堂中文www官网| 国产成人精品一区二区三区| 日韩一区二区三区在线播放| 欧美电视剧在线看免费| 国产91九色视频| 精品免费视频一卡2卡三卡4卡不卡| 污网站在线观看视频| 国产区视频在线播放| 久久中文字幕一区二区| 日韩影片中文字幕| 青青草手机在线观看| 日韩欧美主播在线| 青青青青久久精品国产一百度| 国产一区一一区高清不卡| 男女性色大片免费观看一区二区| 丝袜视频国产在线播放| 国产寡妇色xxⅹ交肉视频| 久久久久久久久爱| 欧美日韩亚洲精品一区二区三区| 欧美一区二不卡视频| 午夜欧美巨大性欧美巨大| 日韩欧美一区二区久久婷婷| 中文人妻一区二区三区| 中文字幕成人一区| 丁香婷婷激情网| 美女黄页在线观看| 亚洲精品国产无套在线观| 亚洲a∨精品一区二区三区导航| 亚洲成人一二三| 久久国产精品毛片| 黄网站网址视频| 在线看的你懂得| 69日本xxxxxxxxx49| 91福利免费观看| 久久夜色精品国产欧美乱极品| 欧美videossex| 噜噜噜久久亚洲精品国产品麻豆| 热久久免费视频| 国产精品视频一区二区久久| 中文字幕av一区二区三区四区| 美国做受三级的视频播放| 人人影院免费大片| 日韩va亚洲va欧美va久久| 少妇太紧太爽又黄又硬又爽| 国产av 一区二区三区| 欧美亚洲国产日本| 超碰成人福利| 成人精品一区二区不卡视频| 在线国产一区二区| 裸体大乳女做爰69| 朝桐光av在线| 国产精品麻豆久久久| 欧美成人性色生活仑片| 欧美在线视频你懂得| 91麻豆免费看片| 黑人欧美xxxx| 欧美视频在线视频精品| 在线观看免费毛片| 色乱码一区二区三区网站| 日本乱人伦a精品| freexxx性亚洲精品| 人人九九精品| 中出一区二区| 精品人妻互换一区二区三区| 亚洲欧美日韩在线一区| 91精品国产调教在线观看| 亚洲日本无吗高清不卡| 亚洲国产国产亚洲一二三| 在线观影网站| 成人黄色影片在线| 538在线视频观看| 黄色av中文字幕| 国产天堂视频| 交视频在线观看国产| 久久国产99| 久久免费看毛片| 一区二区免费看| 91精品免费久久久久久久久| 草视频在线观看| a天堂在线观看| 中日韩免费视频中文字幕| 国产精品久久亚洲7777| 欧美日韩精品一区视频| 国户精品久久久久久久久久久不卡| 亚洲欧洲视频在线观看| 欧美精品v日韩精品v国产精品| 久久亚洲一区二区三区明星换脸| 中文国产成人精品| 欧美 亚欧 日韩视频在线| 久久www人成免费看片中文| 在线观看一级片| 人妻无码中文久久久久专区| 97理论电影| 中文字幕欧美专区| 少妇精品无码一区二区免费视频| 欧美日本视频在线| 人妻无码一区二区三区久久99| 国产精品1区在线| 欧美日韩网站| wwwxxx免费| 色激情天天射综合网| 大香伊人久久精品一区二区| 亚洲av毛片在线观看| 欧美性大战久久久久xxx| www久久com| 国产又黄又猛又粗又爽的视频| 国产精品美女久久久| 精品国产白色丝袜高跟鞋| 免费看黄色网| 久久理论电影| 国产aⅴ精品一区二区三区色成熟| 欧美精品国产精品日韩精品| 精品综合久久久久久97| 国产真实夫妇交换视频| 亚洲国产成人一区| 影音先锋人妻啪啪av资源网站| 中文字幕一区二区三区电影| 欧美日产国产成人免费图片| 日韩三级精品电影久久久| 青娱乐在线免费视频| 久久精品国产电影| 久久高清一区| 精品视频网站| 成年网站免费入口在线观看| 欧美亚洲另类制服自拍| 成人国产精品免费观看| 紧缚奴在线一区二区三区| 国产美女三级无套内谢| av综合电影网站| 日本不卡免费播放| 9l视频自拍蝌蚪9l视频| 91精品在线观| 91精品麻豆日日躁夜夜躁| 日本美女一区二区三区| 一区二区三区精品99久久| 午夜剧场免费在线观看| 日本人体一区二区| 色是在线视频| 国产精品青草久久| 久久久国际精品| 一区二区三区四区在线观看视频| 日日摸日日碰夜夜爽无码| www.一区二区三区.com| 亚洲人线精品午夜| 国产精品久久久久影视| 91麻豆.com| 成人免费一级片| 蜜桃麻豆av在线| 激情影院在线| 国产精品一区二区黑人巨大| 午夜精品久久久久| 日韩电影在线播放| 九色一区二区| 久久婷婷五月综合色国产香蕉| 国产chinesehd精品露脸| 在线免费日韩av| 成人免费视频网站在线看| 日本在线中文字幕一区二区三区| 国产成人精品优优av| 精品国产免费人成电影在线观看四季|