• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    公众号
登陆 注册

两种方法实现mysql分组计数，范围汇总

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

第一种:常规操作

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;

第二种：真香函数

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 '旅行社自建团号',
 `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 '旅行社名称',
 `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 '审批旅游局名称',
 `line_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '线路名称',
 `business_type` tinyint(4) NOT NULL COMMENT '业务类型：1出境游 2国内游 4出境免审核 5赴俄游 6入境接待 7国内接待 8港澳游组团 9赴台游组团 10 金马澎组团 11 边境旅游 12两江游 13周边游',
 `exit_type` tinyint(4) NOT NULL COMMENT '出境类型：1出境游 2港澳游 3赴台游',
 `group_type` tinyint(4) NOT NULL COMMENT '国内游／入境接待／国内接待团队类型：1自组自接 2包机 3专列 4其他',
 `departure_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '出发班次',
 `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 '出境／出发／接团 日期',
 `entry_date` date NOT NULL COMMENT '入境／返回／送团 日期',
 `exit_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '出境／出发／接团 时间',
 `entry_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '入境／返回／送团 时间',
 `departure_province` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '出发省份',
 `departure_city` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '出发城市',
 `departure_city_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '出发城市编码',
 `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:飞机，2:火车，3:轮船，4:汽车，5:其他，6.陆路',
 `days` tinyint(4) NOT NULL COMMENT '游玩天数',
 `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 '领队／导游姓名',
 `guide_card` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '领队／导游证号',
 `guide_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '领队／导游手机号',
 `guide_valid_time` date NULL DEFAULT NULL COMMENT '领队／导游证有效期',
 `guide_agency` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '领队／导游所属旅行社',
 `state` tinyint(4) NOT NULL DEFAULT 0 COMMENT '团队状态：1待提交 2已提交／已审核 3审核不通过 4审核通过 7待取消 8取消 9已出团／已接待 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 '目的地国家',
 `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 '来源／渠道：0页面 -1excel导入 其他对外接口录入',
 `created_at` datetime(0) NOT NULL COMMENT '创建时间',
 `updated_at` datetime(0) NOT NULL COMMENT '更新时间',
 `deleted_at` datetime(0) NULL DEFAULT NULL COMMENT '删除时间',
 `version` int(11) NOT NULL DEFAULT 0,
 `receive_group_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接待团号',
 `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 '接待旅行社名称',
 `fleet_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '车队ID',
 `fleet` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车队',
 `plate_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车牌号',
 `fleet_seat_number` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '座位数',
 `fleet_employment_no` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '从业资格证号',
 `fleet_transport_no` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '运输证号',
 `fleet_transport_scope` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '运营范围',
 `driver_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '司机姓名',
 `driver_phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '司机电话',
 `driver_card_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '司机身份证',
 `hotel_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '酒店名称',
 `hotel_contact` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '酒店联系人',
 `hotel_phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '酒店联系电话',
 `total_room_charge` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '房费总金额',
 `unique_group_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '团队唯一编号',
 `departure_continent` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '出发／客源大洲',
 `departure_county` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出发／客源国家',
 `applicant_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申请人姓名',
 `applicant_phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申请人电话',
 `area_code` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '旅行社所在区域代码',
 `company_type` int(2) NOT NULL DEFAULT 1 COMMENT '旅行社类型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 '到达俄方日期',
 `russia_exit_date` date NULL DEFAULT NULL COMMENT '离开俄方日期',
 `order_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '订单号',
 `policy_no` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '保单号',
 `receive_company_contact` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '组团社联系人',
 `receive_company_phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '组团社联系电话',
 `remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '拼团及备注',
 `flag` int(2) NOT NULL DEFAULT 0 COMMENT '标识 0标准 1金马澎',
 `order_state` int(2) NULL DEFAULT 0 COMMENT '保险单状态：0未投保，1已投保',
 `tourist_count` int(11) NOT NULL DEFAULT 0 COMMENT '游客人数',
 `guide_count` int(11) NOT NULL DEFAULT 0 COMMENT '导游人数',
 `total_count` int(11) NOT NULL DEFAULT 0 COMMENT '游客+导游人数',
 `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 '全陪手机',
 `tw_leader_no` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '赴台领队证号',
 `special_flag` tinyint(4) NOT NULL DEFAULT 0 COMMENT '团队子类型：1横琴专用',
 `car_brand` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '包车车辆品牌型号',
 `car_model` int(2) NULL DEFAULT NULL COMMENT '包车车辆类型： 1大型客车 2中型客车 3小型客车',
 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', '重庆洲际国际旅行社有限责任公司', '500000', '重庆市旅游局', '00002', 2, 1, 4, '12301', '12013', '上海浦东国际机场', '上海外高桥口岸', '2', '289', '2020-06-16', '2020-06-27', '18:31', '18:31', '上海市', '上海市', '', '', '', '2', 1, ' 10 NOS Reiseservice GmbH', '3118', '驱蚊器翁', '顾见copy', 'OQ37481A', '13800150228', '2020-04-17', '重庆洲际国际旅行社有限责任公司', 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', '重庆洲际国际旅行社有限责任公司', '', '', '两江游组团', 1, 1, 4, '12301', '12013', '上海浦东国际机场', '上海外高桥口岸', '2', '289', '2020-06-15', '2020-06-26', '18:31', '18:31', '上海市', '上海市', '', '', '', '2', 1, ' 10 NOS Reiseservice GmbH', '3118', '12312321321321', '顾见copy', 'OQ37481A', '13800150228', '2020-04-17', '重庆洲际国际旅行社有限责任公司', 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', '重庆洲际国际旅行社有限责任公司', '500000', '重庆市旅游局', '两江游组团', 1, 1, 4, '12301', '12013', '上海浦东国际机场', '上海外高桥口岸', '2', '289', '2020-06-15', '2020-06-26', '18:31', '18:31', '上海市', '上海市', '', '', '', '2', 1, ' 10 NOS Reiseservice GmbH', '3118', '驱蚊器翁', '顾见copy', 'OQ37481A', '13800150228', '2020-04-17', '重庆洲际国际旅行社有限责任公司', 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', '重庆洲际国际旅行社有限责任公司', '500000', '重庆市旅游局', '两江游组团1', 1, 1, 4, '12301', '12013', '上海浦东国际机场', '上海外高桥口岸', '2', '289', '2020-06-15', '2020-06-26', '18:31', '18:31', '上海市', '上海市', '', '', '', '2', 1, ' 10 NOS Reiseservice GmbH', '3118', '驱蚊器翁', '顾见copy', 'OQ37481A', '13800150228', '2020-04-17', '重庆洲际国际旅行社有限责任公司', 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', '重庆洲际国际旅行社有限责任公司', '500000', '重庆市旅游局', '两江游组团', 8, 2, 4, '12301', '1', '舟山群岛国际邮轮港', '舟山群岛国际邮轮港', '142', '142', '2020-06-16', '2020-06-19', '19:25', '19:26', '浙江省', '杭州市', '', '', '', '3', 1, '三通旅运（香港）有限公司', '7662', '123213213123', '顾见copy', 'OQ37481A', '13800150228', '2020-04-17', '重庆洲际国际旅行社有限责任公司', 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', '重庆洲际国际旅行社有限责任公司', '500000', '重庆市旅游局', '赴台游组团', 9, 3, 4, '12301', '12013', '舟山群岛国际邮轮港', '遵义新舟国际机场', '142', '261', '2020-06-16', '2020-06-26', '19:29', '19:29', '浙江省', '杭州湾新区', '', '', '', '1', 3, '台灣西敏旅行社', '874', '请问驱蚊器翁无群二', '', '', '', 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', '重庆洲际国际旅行社有限责任公司', '', '', '国内游', 2, 0, 1, '12301', '12013', NULL, NULL, NULL, NULL, '2020-06-15', '2020-06-18', '19:37', '19:37', '浙江省', '杭州市', '', '', '', '2', 1, '博华（厦门）国际旅行社有限公司1', '', '奥术大师多撒多', '', '', '', 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, '', '', '', '', '收打萨达萨达', 0, NULL, 1, 1, 2, NULL, NULL, NULL, '', 0, '2', 2);
INSERT INTO `tour_group` VALUES (5264936, 'qwertyu', '34132', '重庆洲际国际旅行社有限责任公司', '', '', '入境游接待', 6, 0, 2, '', '', NULL, NULL, NULL, NULL, '2020-06-16', '2020-06-17', '19:45', '19:45', NULL, '', '', '', '', '', 1, '博华（厦门）国际旅行社有限公司1', '', '', '', '', '', NULL, NULL, 9, NULL, '', '', '', '', '2020-06-16 19:47:27', '2020-06-16 19:47:43', NULL, 0, '002233', NULL, '组团社', NULL, '12301', '02131', '', '', '', '', '李四', '13200010011', '201230211', NULL, NULL, NULL, NULL, 'RJ158PUC1L40', '0123', NULL, '17300000203', '17300000203', '500112', 1, '', '', '', '', NULL, NULL, '', '', '组团社联系人', '13211112222', '驱蚊器翁', 0, NULL, 1, 1, 2, NULL, NULL, NULL, '', 0, '2', NULL);
INSERT INTO `tour_group` VALUES (5264937, 'C2020062802', '34132', '重庆洲际国际旅行社有限责任公司', '500000', '重庆市旅游局', '名称一泰国游', 1, 1, 4, 'A465465D', 'SA789', '重庆江北国际机场', '重庆江北国际机场', '76', '76', '2020-06-28', '2020-06-29', '04:00', '19:00', '重庆市', '重庆市', '', '普吉岛', '222', '1', 2, '上海春秋国旅美国分公司', '1985', '乘车', '顾见copy', 'OQ37481A', '13800150228', '2020-04-17', '重庆洲际国际旅行社有限责任公司', 2, NULL, '', '普吉岛', '泰国', '', '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', '重庆洲际国际旅行社有限责任公司', '500000', '重庆市旅游局', '重庆去澳门', 8, 2, 4, '766EEE', 'FD244', '重庆江北国际机场', '重庆江北国际机场', '76', '76', '2020-06-17', '2020-06-28', '09:00', '22:00', '重庆市', '重庆市', '', '', '', '1', 1, '(株）重元旅遊', '8151', '重庆出发', '顾见copy01', 'OQ37481A', '13800150228', '2020-11-01', '重庆洲际国际旅行社有限责任公司', 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', '重庆洲际国际旅行社有限责任公司', '500000', '重庆市旅游局', '出境游组团', 1, 1, 4, '12301', '12013', '上海浦东国际机场', '上海虹桥国际机场', '2', '3', '2020-06-17', '2020-06-19', '09:33', '09:33', '上海市', '上海市', '', '', '', '2', 2, '上海春秋国旅美国分公司', '1985', '委屈二群翁群翁无', '顾见copy', 'OQ37481A', '13800150228', '2020-04-17', '重庆洲际国际旅行社有限责任公司', 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', '重庆洲际国际旅行社有限责任公司', '500000', '重庆市旅游局', '出境游组团', 1, 1, 4, '12301', '12013', '上海浦东国际机场', '上海外高桥口岸', '2', '289', '2020-06-14', '2020-06-25', '18:31', '18:31', '上海市', '上海市', '', '', '', '2', 1, ' 10 NOS Reiseservice GmbH', '3118', '驱蚊器翁', '顾见copy', 'OQ37481A', '13800150228', '2020-04-17', '重庆洲际国际旅行社有限责任公司', 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', '重庆洲际国际旅行社有限责任公司', '500000', '重庆市旅游局', '一泰国游', 1, 1, 4, 'A12132', 'J454645', '重庆江北国际机场', '重庆江北国际机场', '76', '76', '2020-06-19', '2020-06-20', '06:00', '21:00', '重庆市', '重庆市', '', '', '', '1', 2, '上海春秋国旅美国分公司', '1985', '重庆上车', '顾见copy', 'OQ37481A', '13800150228', '2020-04-17', '重庆洲际国际旅行社有限责任公司', 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, '', '', '', '', '领队顾见', 0, NULL, 3, 2, 5, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264942, 'C2020061703', '34132', '重庆洲际国际旅行社有限责任公司', '', '', '二泰国游', 1, 1, 4, 'A12132', 'J454645', '重庆江北国际机场', '重庆江北国际机场', '76', '76', '2020-06-16', '2020-06-17', '06:00', '21:00', '重庆市', '重庆市', '', '', '', '1', 2, '上海春秋国旅美国分公司', '1985', '重庆上车', '顾见copy', 'OQ37481A', '13800150228', '2020-04-17', '重庆洲际国际旅行社有限责任公司', 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, '', '', '', '', '领队顾见', 0, NULL, 1, 2, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264943, 'C2020061704', '34132', '重庆洲际国际旅行社有限责任公司', '', '', '三泰国游', 1, 1, 4, 'A12132', 'J454645', '重庆江北国际机场', '上海浦东国际机场', '76', '2', '2020-06-14', '2020-06-17', '06:00', '21:00', '重庆市', '重庆市', '', '', '', '1', 4, '上海春秋国旅美国分公司', '1985', '重庆上车', '顾见copy', 'OQ37481A', '13800150228', '2020-04-17', '重庆洲际国际旅行社有限责任公司', 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, '', '', '', '', '领队顾见', 0, NULL, 1, 4, 5, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264944, 'KL100527-20200520', '34132', '重庆洲际国际旅行社有限责任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '', '', '', '', '230', '145', '2020-05-19', '2020-05-20', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明乐途旅行社有限公司', '', '00000', '李靖', '12014', '13888292920', '2020-05-21', '昆明市导游协会', 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', '拼团', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264945, 'KL100527-202005201', '34132', '重庆洲际国际旅行社有限责任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '', '', '', '', '230', '145', '2020-05-19', '2020-05-20', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明乐途旅行社有限公司', '', '00000', '李靖', '12014', '13888292920', '2020-05-21', '昆明市导游协会', 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', '拼团', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264946, 'KL100527-2020052', '34132', '重庆洲际国际旅行社有限责任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '', '', '', '', '230', '145', '2020-05-19', '2020-05-20', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明乐途旅行社有限公司', '', '00000', '李靖', '12014', '13888292920', '2020-05-21', '昆明市导游协会', 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', '拼团', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264947, 'KL100527-202005', '34132', '重庆洲际国际旅行社有限责任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '', '', '', '', '230', '145', '2020-05-19', '2020-05-20', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明乐途旅行社有限公司', '', '00000', '李靖', '12014', '13888292920', '2020-05-21', '昆明市导游协会', 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', '拼团', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264948, 'KL100527-2020000', '34132', '重庆洲际国际旅行社有限责任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '', '', '', '', '230', '145', '2020-05-19', '2020-05-20', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明乐途旅行社有限公司', '', '00000', '魏芳', '430422199106205225', '13211112222', '2020-05-21', '昆明市导游协会', 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', '拼团', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264949, 'KL100527-20200000', '34132', '重庆洲际国际旅行社有限责任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '', '', '', '', '230', '145', '2020-05-19', '2020-05-20', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明乐途旅行社有限公司', '', '00000', '魏芳', '430422199106205225', '13211112222', '2020-05-21', '昆明市导游协会', 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', '拼团', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264954, 'KL100527-202000000', '34132', '重庆洲际国际旅行社有限责任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '12301', '12013', '上海浦东国际机场', '杭州萧山国际机场', '2', '5', '2020-05-18', '2020-05-19', '00:00', '00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明乐途旅行社有限公司', '', '00000', '魏芳', '430422199106205225', '13211112222', '2020-05-21', '昆明市导游协会', 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', '拼团', 0, 0, 0, 3, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264956, '10010vvv', '34132', '重庆洲际国际旅行社有限责任公司', '', '', '两江游组团', 1, 1, 4, '12301', '12013', '杭州萧山国际机场', '杭州萧山国际机场', '5', '5', '2020-06-18', '2020-06-30', '09:47', '09:47', '上海市', '上海市', '', '', '', '6', 1, '\"China-Man\" Touristik und Handels GmbH', '3119', '奥术大师多所', '顾见copy', 'OQ37481A', '13800150228', '2020-04-17', '重庆洲际国际旅行社有限责任公司', 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', '重庆洲际国际旅行社有限责任公司', '500000', '重庆市旅游局', '一香港游', 8, 2, 4, 'A12132', 'J454645', '重庆江北国际机场', '上海浦东国际机场', '76', '2', '2020-06-20', '2020-06-20', '03:00', '23:00', '重庆市', '重庆市', '', '', '', '2', 1, '三通旅运（香港）有限公司', '7662', '逛公园1和2', '石子卿copy', 'BV11958A', '18600000002', '2020-04-17', '重庆洲际国际旅行社有限责任公司', 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', '重庆洲际国际旅行社有限责任公司', '', '', '周边游', 13, 0, 2, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-19', '13:00', '22:00', '重庆市', '重庆市', '', '', '', '4', 1, '中国国旅', '', '对方观看哈大家', '', '', '', NULL, NULL, 1, NULL, '', '', '', '', '2020-06-18 10:00:38', '2020-06-19 14:09:52', NULL, 0, NULL, NULL, NULL, NULL, '123', '123', '', '', '', '', '上海悠扬国际旅行社有限公司', '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', '重庆洲际国际旅行社有限责任公司', '', '', '周边游', 13, 0, 2, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-18', '13:00', '22:00', '重庆市', '重庆市', '', '', '', '4', 1, '中国国旅', '', '对方观看哈大家', '', '', '', NULL, NULL, 9, NULL, '', '', '', '', '2020-06-18 10:01:00', '2020-06-18 15:42:15', NULL, 0, NULL, NULL, NULL, NULL, '123', '123', '', '', '', '', '上海悠扬国际旅行社有限公司', '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', '重庆洲际国际旅行社有限责任公司', '', '', '周边游', 13, 0, 2, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-18', '13:00', '22:00', '重庆市', '重庆市', '', '', '', '4', 1, '中国国旅', '', '对方观看哈大家', '', '', '', 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', '', '', '', '', '上海悠扬国际旅行社有限公司', '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', '重庆洲际国际旅行社有限责任公司', '', '', '周边游', 13, 0, 2, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-18', '13:00', '22:00', '重庆市', '重庆市', '', '', '', '4', 1, '中国国旅', '', '对方观看哈大家', '', '', '', NULL, NULL, 9, NULL, '', '', '', '', '2020-06-18 10:20:39', '2020-06-18 10:22:11', NULL, 0, NULL, NULL, NULL, NULL, '123', '123', '', '', '', '', '上海悠扬国际旅行社有限公司', '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', '重庆洲际国际旅行社有限责任公司', '', '', '周边', 13, 0, 2, '123', '123', NULL, NULL, NULL, NULL, '2020-06-17', '2020-06-18', '10:28', '23:00', '北京市', '北京市', '', '', '', '4', 1, '中国国旅', '', '对法国队', '', '', '', 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', '重庆洲际国际旅行社有限责任公司', '500000', '重庆市旅游局', '一台湾游', 9, 3, 4, 'A12132', 'J454645', '上海虹桥国际机场', '上海浦东国际机场', '3', '2', '2020-06-18', '2020-06-19', '05:00', '22:00', '重庆市', '重庆市', '', '', '', '1', 2, '台灣運達旅行社', '8233', '重庆重庆重庆重庆重庆', '丁常梅copy', 'LVE7559A', '13800151470', '2020-02-24', '重庆洲际国际旅行社有限责任公司', 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', '重庆洲际国际旅行社有限责任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '', '', '', '', '230', '145', '2020-06-19', '2020-06-25', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明乐途旅行社有限公司', '', '00000', '李靖', '12014', '13888292920', '2020-05-21', '昆明市导游协会', 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', '拼团', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264982, 'KL100527-20200520-8888', '34132', '重庆洲际国际旅行社有限责任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '', '', '', '', '230', '145', '2020-06-19', '2020-06-25', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明乐途旅行社有限公司', '', '00000', '李靖', '12014', '13888292920', '2020-05-21', '昆明市导游协会', 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', '拼团', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5264984, 'KL100527-20200520-88866', '34132', '重庆洲际国际旅行社有限责任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '', '', '', '', '230', '145', '2020-06-19', '2020-06-25', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明乐途旅行社有限公司', '', '00000', '李靖', '12014', '13888292920', '2020-05-21', '昆明市导游协会', 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', '拼团', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265007, 'KL100527-20200520-88861', '34132', '重庆洲际国际旅行社有限责任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '12301', '12013', '杭州萧山国际机场', '杭州萧山国际机场', '5', '5', '2020-07-19', '2020-07-25', '00:00', '00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明乐途旅行社有限公司', '', '00000', '魏芳', '430422199106205225', '13211112222', '2020-05-21', '昆明市导游协会', 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', '拼团', 0, 0, 0, 3, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265010, 'KL100527-20200520-88868', '34132', '重庆洲际国际旅行社有限责任公司', '500000', '上海市政府', '澄江深度二日游', 8, 2, 1, '', '', '', '', '230', '145', '2020-08-19', '2020-08-25', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明乐途旅行社有限公司', '', '00000', '魏芳', '430422199106205225', '13211112222', '2020-05-21', '昆明市导游协会', 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', '拼团', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265012, 'KL100527-20200520-02', '34132', '重庆洲际国际旅行社有限责任公司', '500000', '重庆市旅游局', '澄江深度二日游', 8, 2, 1, '', '', '', '', '230', '145', '2020-07-12', '2020-07-18', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明乐途旅行社有限公司', '', '00000', '魏芳', '430422199106205225', '13211112222', '2020-05-21', '昆明市导游协会', 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', '拼团', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265016, '两江', '34132', '重庆洲际国际旅行社有限责任公司', '', '', '乌江', 12, 0, 1, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-18', '15:39', '23:00', '重庆市', '重庆市', '', '', '', '4', 1, '中国国旅', '', '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', '重庆洲际国际旅行社有限责任公司', '', '', '溧阳二日游', 2, 0, 3, '123', '123', NULL, NULL, NULL, NULL, '2020-06-17', '2020-06-18', '07:00', '07:00', '江苏省', '溧阳市', '', '', '', '4', 1, '中国国旅', '', '反对根深蒂固', '', '', '', 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', '重庆洲际国际旅行社有限责任公司', '124', '重庆市旅游局', '上海一日游', 7, 0, 2, '', '', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-19', '11:00', '06:07', '上海市', '上海市', '', '', '', '4', 2, '中国国旅', '', '', '', '', '', 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', '重庆洲际国际旅行社有限责任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '', '', '', '', '230', '145', '2020-05-19', '2020-05-20', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明乐途旅行社有限公司', '', '00000', '魏芳', '430422199106205225', '13211112222', '2020-05-21', '昆明市导游协会', 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', '拼团', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265023, 'KL100527-202001', '34132', '重庆洲际国际旅行社有限责任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '', '', '', '', '230', '145', '2020-05-19', '2020-05-20', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明乐途旅行社有限公司', '', '00000', '魏芳', '430422199106205225', '13211112222', '2020-05-21', '昆明市导游协会', 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', '拼团', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265024, 'KL100527-202251', '34132', '重庆洲际国际旅行社有限责任公司', '500000', '上海市政府', '澄江深度二日游', 1, 1, 1, '', '', '', '', '230', '145', '2020-05-19', '2020-05-20', '00:00:00', '00:00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明乐途旅行社有限公司', '', '00000', '魏芳', '430422199106205225', '13211112222', '2020-05-21', '昆明市导游协会', 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', '拼团', 0, 0, 5, 1, 6, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265025, 'KL100527-20261', '34132', '重庆洲际国际旅行社有限责任公司', '500000', '重庆市旅游局', '澄江深度二日游', 1, 1, 1, '2322332', 'weew', '北京首都国际机场', '北京首都国际机场', '4', '4', '2020-05-19', '2020-05-20', '00:00', '00:00', 'ffff', '昆明', '320100', '澄江2日', '', '5', 1, '昆明乐途旅行社有限公司', '', '00000', '魏芳3', '430422199106205225', '13211112222', '2020-05-21', '昆明市导游协会', 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', '拼团', 0, 0, 0, 3, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265028, '123011111', '34132', '重庆洲际国际旅行社有限责任公司', '', '', '两江游组团1', 12, 0, 1, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-26', '15:39', '23:00', '重庆市', '重庆市', '', '', '', '4', 1, '中国国旅', '', '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', '重庆洲际国际旅行社有限责任公司', '', '', '两江游组团1', 12, 0, 1, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-26', '15:39', '23:00', '重庆市', '重庆市', '', '', '', '4', 1, '中国国旅', '', '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', '重庆洲际国际旅行社有限责任公司', '', '', '两江游组团11', 12, 0, 1, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-26', '15:39', '23:00', '重庆市', '重庆市', '', '', '', '4', 1, '中国国旅', '', '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', '重庆洲际国际旅行社有限责任公司', '', '', '33', 12, 0, 1, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-26', '15:39', '23:00', '重庆市', '重庆市', '', '', '', '4', 1, '中国国旅', '', '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', '重庆洲际国际旅行社有限责任公司', '', '', '两江游组团111', 12, 0, 1, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-26', '15:39', '23:00', '重庆市', '重庆市', '', '', '', '4', 1, '中国国旅', '', '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', '重庆洲际国际旅行社有限责任公司', '', '', '两江游组团11', 12, 0, 1, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-26', '15:39', '23:00', '重庆市', '重庆市', '', '', '', '4', 1, '中国国旅', '', '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', '重庆洲际国际旅行社有限责任公司', '', '', '两江游组团12', 12, 0, 1, '123', '123', NULL, NULL, NULL, NULL, '2020-06-18', '2020-06-26', '15:39', '23:00', '重庆市', '重庆市', '', '', '', '4', 1, '中国国旅', '', '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', '重庆洲际国际旅行社有限责任公司', '', '', '两江游组团11', 12, 0, 1, '123', '123', NULL, NULL, NULL, NULL, '2020-06-27', '2020-06-29', '15:39', '23:00', '重庆市', '重庆市', '', '', '', '4', 1, '中国国旅', '', '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', '重庆洲际国际旅行社有限责任公司', '', '', '一出境游', 1, 1, 4, 'A12132', 'J454645', '重庆江北国际机场', '上海浦东国际机场', '76', '2', '2020-06-19', '2020-06-20', '06:00', '21:00', '重庆市', '重庆市', '', '', '', '1', 2, '上海春秋国旅美国分公司', '1985', '重庆上车', '顾见copy', 'OQ37481A', '13800150228', '2020-04-17', '重庆洲际国际旅行社有限责任公司', 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, '', '', '', '', '领队顾见', 0, NULL, 2, 2, 4, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265045, '10010ewqeqwe', '34132', '重庆洲际国际旅行社有限责任公司', '', '', '两江游组团qweqew', 1, 1, 4, 'A12132', 'J454645', '重庆江北国际机场', '上海浦东国际机场', '76', '2', '2020-06-19', '2020-06-20', '06:00', '21:00', '重庆市', '重庆市', '', '', '', '1', 2, 'Feizhong', '1985', '重庆上车', '顾见copy', 'OQ37481A', '13800150228', '2020-04-17', '重庆洲际国际旅行社有限责任公司', 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, '', '', '', '', '领队顾见', 0, NULL, 0, 2, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265063, '1231231231223', '34132', '重庆洲际国际旅行社有限责任公司', '', '', '12312321321', 1, 1, 4, 'A12132', 'J454645', '重庆江北国际机场', '上海浦东国际机场', '76', '2', '2020-08-01', '2020-08-03', '06:00', '21:00', '重庆市', '重庆市', '', '', '', '1', 2, '上海春秋国旅美国分公司', '1985', '重庆上车', '顾见copy01', 'OQ37481A', '13800150228', '2020-11-01', '重庆洲际国际旅行社有限责任公司', 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, '', '', '', '', '领队顾见', 0, NULL, 0, 2, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265064, '1231231', '34132', '重庆洲际国际旅行社有限责任公司', '', '', '两江游组团', 1, 1, 4, 'A12132', 'J454645', '重庆江北国际机场', '上海浦东国际机场', '76', '2', '2020-08-01', '2020-08-03', '06:00', '21:00', '重庆市', '重庆市', '', '', '', '1', 2, '上海春秋国旅美国分公司', '1985', '重庆上车', '顾见copy01', 'OQ37481A', '13800150228', '2020-11-01', '重庆洲际国际旅行社有限责任公司', 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, '', '', '', '', '领队顾见', 0, NULL, 0, 2, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265065, '123131123123', '34132', '重庆洲际国际旅行社有限责任公司', '', '', '1231312321', 1, 1, 4, 'A12132', 'J454645', '重庆江北国际机场', '上海浦东国际机场', '76', '2', '2020-08-01', '2020-08-03', '06:00', '21:00', '重庆市', '重庆市', '', '', '', '1', 2, '上海春秋国旅美国分公司', '1985', '重庆上车', '顾见copy01', 'OQ37481A', '13800150228', '2020-11-01', '重庆洲际国际旅行社有限责任公司', 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, '', '', '', '', '领队顾见', 0, NULL, 1, 2, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265067, 'C2020061902', '34132', '重庆洲际国际旅行社有限责任公司', '', '', '二出境游', 1, 1, 4, 'A12132', 'J454645', '重庆江北国际机场', '上海浦东国际机场', '76', '2', '2020-06-19', '2020-06-20', '06:00', '21:00', '重庆市', '重庆市', '', '', '', '1', 2, '上海春秋国旅美国分公司', '1985', '重庆上飞机', '顾见copy', 'OQ37481A', '13800150228', '2020-04-17', '重庆洲际国际旅行社有限责任公司', 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, '', '', '', '', '领队顾见', 0, NULL, 1, 2, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265068, '20200619211', '34132', '重庆洲际国际旅行社有限责任公司', '', '', '重庆一日游', 13, 0, 2, '123', '123', NULL, NULL, NULL, NULL, '2020-06-19', '2020-06-20', '13:00', '22:00', '重庆市', '重庆市', '', '', '', '4', 1, '中国国旅', '', '对方观看哈大家', '', '', '', NULL, NULL, 9, NULL, '', '', '', '', '2020-06-19 14:10:55', '2020-06-19 14:11:22', NULL, 0, NULL, NULL, NULL, NULL, '123', '123', '', '', '', '', '上海悠扬国际旅行社有限公司', '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', '重庆洲际国际旅行社有限责任公司', '500000', '重庆市旅游局', '三出境游', 1, 1, 4, 'A12132', 'J454645', '重庆江北国际机场', '上海浦东国际机场', '76', '2', '2020-06-19', '2020-06-20', '06:00', '21:00', '重庆市', '重庆市', '', '', '', '1', 2, '上海春秋国旅美国分公司', '1985', '重庆上飞机', '顾见copy', 'OQ37481A', '13800150228', '2020-04-17', '重庆洲际国际旅行社有限责任公司', 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, '', '', '', '', '领队顾见', 0, NULL, 3, 2, 5, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265087, 'C2020061904', '34132', '重庆洲际国际旅行社有限责任公司', '', '', '四出境游', 1, 1, 4, 'A12132', 'J454645', '重庆江北国际机场', '上海浦东国际机场', '76', '2', '2020-06-19', '2020-06-20', '06:00', '21:00', '重庆市', '重庆市', '', '', '', '1', 2, '上海春秋国旅美国分公司', '1985', '重庆上飞机', '顾见copy', 'OQ37481A', '13800150228', '2020-04-17', '重庆洲际国际旅行社有限责任公司', 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, '', '', '', '', '领队顾见', 0, NULL, 0, 2, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265088, 'C2020061905', '34132', '重庆洲际国际旅行社有限责任公司', '500000', '重庆市旅游局', '五出境游', 1, 1, 4, 'A12132', 'J454645', '重庆江北国际机场', '上海浦东国际机场', '76', '2', '2020-06-23', '2020-06-24', '11:00', '21:00', '重庆市', '重庆市', '', '', '', '1', 2, '上海春秋国旅美国分公司', '1985', '重庆上飞机', '顾见copy', 'OQ37481A', '13800150228', '2020-04-17', '重庆洲际国际旅行社有限责任公司', 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, '', '', '', '', '领队顾见', 0, NULL, 1, 2, 3, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265090, '国内接待06-19-14:35', '34132', '重庆洲际国际旅行社有限责任公司', '', '', '上海政务对接业务出境游网上申报3', 7, 0, 2, '', '', NULL, NULL, NULL, NULL, '2020-06-19', '2020-06-28', '00:06', '00:08', '江苏省', '南京市', '', '', '', '2', 1, '中国国内地接社', '', '', '', '', '', NULL, NULL, 1, NULL, '', '', '', '', '2020-06-19 15:22:33', '2020-06-22 13:41:00', NULL, 0, '0023', NULL, NULL, NULL, '测试车队', '苏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', '重庆洲际国际旅行社有限责任公司', '500000', '重庆市旅游局', '六出境游', 1, 1, 4, 'A12132', 'J454645', '重庆江北国际机场', '上海浦东国际机场', '76', '2', '2020-06-23', '2020-06-24', '11:00', '21:00', '重庆市', '重庆市', '', '', '', '1', 2, '上海春秋国旅美国分公司', '1985', '重庆上飞机', '顾见copy', 'OQ37481A', '13800150228', '2020-04-17', '重庆洲际国际旅行社有限责任公司', 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, '', '', '', '', '领队顾见', 0, NULL, 0, 2, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265092, 'C2020061907', '34132', '重庆洲际国际旅行社有限责任公司', '500000', '重庆市旅游局', '七出境游', 1, 1, 4, 'A12132', 'J454645', '重庆江北国际机场', '上海浦东国际机场', '76', '2', '2020-06-23', '2020-06-24', '11:00', '21:00', '重庆市', '重庆市', '', '', '', '1', 2, '上海春秋国旅美国分公司', '1985', '重庆上飞机', '顾见copy', 'OQ37481A', '13800150228', '2020-04-17', '重庆洲际国际旅行社有限责任公司', 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, '', '', '', '', '领队顾见', 0, NULL, 0, 2, 2, NULL, '', '', '', 0, NULL, NULL);
INSERT INTO `tour_group` VALUES (5265093, 'C2020061908', '34132', '重庆洲际国际旅行社有限责任公司', '500000', '重庆市旅游局', '八出境游', 1, 1, 4, 'A12132', 'J454645', '重庆江北国际机场', '上海浦东国际机场', '76', '2', '2020-06-23', '2020-06-24', '11:00', '21:00', '重庆市', '重庆市', '', '', '', '1', 2, '上海春秋国旅美国分公司', '1985', '重庆上飞机', '顾见copy01', 'OQ37481A', '13800150228', '2020-11-01', '重庆洲际国际旅行社有限责任公司', 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, NUL

鲜花
握手
雷人
路过
鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
More+
上一篇：
Centos环境下Postgresql 安装配置及环境变量配置技巧发布时间：2022-02-08
下一篇：
Oracle10g通过DBLink访问MySQL示例发布时间：2022-02-08
热门推荐
More+
热门话题
More+
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服（服务时间 9:00～18:00）

在线QQ客服
地址：深圳市南山区西丽大学城创智工业园
电邮：jeky_zhao#qq.com
移动电话：139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap