没有合适的资源?快使用搜索试试~ 我知道了~
首页两种方法实现mysql分组计数,范围汇总
第一种:常规操作 SELECT SUM(ddd) AS count_days, CASE WHEN aa.days >= 1 AND aa.days < 3>= 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 g
资源详情
资源评论
资源推荐
两种方法实现两种方法实现mysql分组计数,范围汇总分组计数,范围汇总
第一种:常规操作
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,
剩余20页未读,继续阅读
weixin_38557727
- 粉丝: 5
- 资源: 907
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- RTL8188FU-Linux-v5.7.4.2-36687.20200602.tar(20765).gz
- c++校园超市商品信息管理系统课程设计说明书(含源代码) (2).pdf
- 建筑供配电系统相关课件.pptx
- 企业管理规章制度及管理模式.doc
- vb打开摄像头.doc
- 云计算-可信计算中认证协议改进方案.pdf
- [详细完整版]单片机编程4.ppt
- c语言常用算法.pdf
- c++经典程序代码大全.pdf
- 单片机数字时钟资料.doc
- 11项目管理前沿1.0.pptx
- 基于ssm的“魅力”繁峙宣传网站的设计与实现论文.doc
- 智慧交通综合解决方案.pptx
- 建筑防潮设计-PowerPointPresentati.pptx
- SPC统计过程控制程序.pptx
- SPC统计方法基础知识.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0