DateTime:2026/6/15 10:24:04
ExtMessage:购物店列表查询sql1:
             SELECT * from (  SELECT A.NewCombinationNum,GROUP_CONCAT(A.TCID) AS TCIDS, MIN(A.StartDate) as StartDate,MAX(A.DMCNum) as DMCNum
            FROM
            (
            		SELECT tabA.*,B.StartCityId,B.LineteamId,B.DayNum,B.LineId,
            		(CASE WHEN  LENGTH(IFNULL(tabA.CombinationNum,''))=0 THEN tabA.TCNUM 
            					ELSE  tabA.CombinationNum END
            		) AS NewCombinationNum,B.Title
            		FROM rb_travel_price AS tabA LEFT JOIN rb_travel_config as B on tabA.ConfigID=B.ID
                         LEFT JOIN rb_leader_schedule as C ON tabA.TCID=C.TCID AND C.Status=0  
            		WHERE 1=1 AND tabA.TCState=3  AND tabA.Status IN(1,2,5)  AND tabA.RB_Group_Id=2  AND tabA.StartDate>='2026-6-15 00:00:00'  AND tabA.TCState  in(1,3)  
            ) AS A 
            GROUP BY A.NewCombinationNum ) as B  ORDER BY B.StartDate asc 
            

DateTime:2026/6/15 10:24:12
ExtMessage:购物店列表查询sql1:
             SELECT * from (  SELECT A.NewCombinationNum,GROUP_CONCAT(A.TCID) AS TCIDS, MIN(A.StartDate) as StartDate,MAX(A.DMCNum) as DMCNum
            FROM
            (
            		SELECT tabA.*,B.StartCityId,B.LineteamId,B.DayNum,B.LineId,
            		(CASE WHEN  LENGTH(IFNULL(tabA.CombinationNum,''))=0 THEN tabA.TCNUM 
            					ELSE  tabA.CombinationNum END
            		) AS NewCombinationNum,B.Title
            		FROM rb_travel_price AS tabA LEFT JOIN rb_travel_config as B on tabA.ConfigID=B.ID
                         LEFT JOIN rb_leader_schedule as C ON tabA.TCID=C.TCID AND C.Status=0    INNER JOIN (SELECT TCID from RB_Travel_Price_Shop_Details where  (
(IFNULL(CompanyCommission, 0)  !=0 and(CompanyCommissionFrId IS  NULL or CompanyCommissionFrId = '' or CompanyCommissionFrId = '0'))
or(IFNULL(GuideCommission, 0)  !=0 and(GuideCommissionFrId IS  NULL or GuideCommissionFrId = '' or GuideCommissionFrId = '0'))
)
  
GROUP BY tcid) as sd on sd.TCID=tabA.TCID 
            		WHERE 1=1 AND tabA.TCState=3  AND tabA.Status IN(1,2,5)  AND tabA.RB_Group_Id=2  AND tabA.StartDate>='2025-06-01 00:00:00'  AND tabA.TCState  in(1,3)  
            ) AS A 
            GROUP BY A.NewCombinationNum ) as B  ORDER BY B.StartDate asc 
            

DateTime:2026/6/15 10:24:14
ExtMessage:购物店列表查询sql1:
             SELECT * from (  SELECT A.NewCombinationNum,GROUP_CONCAT(A.TCID) AS TCIDS, MIN(A.StartDate) as StartDate,MAX(A.DMCNum) as DMCNum
            FROM
            (
            		SELECT tabA.*,B.StartCityId,B.LineteamId,B.DayNum,B.LineId,
            		(CASE WHEN  LENGTH(IFNULL(tabA.CombinationNum,''))=0 THEN tabA.TCNUM 
            					ELSE  tabA.CombinationNum END
            		) AS NewCombinationNum,B.Title
            		FROM rb_travel_price AS tabA LEFT JOIN rb_travel_config as B on tabA.ConfigID=B.ID
                         LEFT JOIN rb_leader_schedule as C ON tabA.TCID=C.TCID AND C.Status=0  
            		WHERE 1=1 AND tabA.TCState=3  AND tabA.Status IN(1,2,5)  AND tabA.RB_Group_Id=2  AND tabA.StartDate>='2025-06-01 00:00:00'  AND tabA.TCState  in(1,3)  
            ) AS A 
            GROUP BY A.NewCombinationNum ) as B  ORDER BY B.StartDate asc 
            

DateTime:2026/6/15 10:24:20
ExtMessage:购物店列表查询sql1:
             SELECT * from (  SELECT A.NewCombinationNum,GROUP_CONCAT(A.TCID) AS TCIDS, MIN(A.StartDate) as StartDate,MAX(A.DMCNum) as DMCNum
            FROM
            (
            		SELECT tabA.*,B.StartCityId,B.LineteamId,B.DayNum,B.LineId,
            		(CASE WHEN  LENGTH(IFNULL(tabA.CombinationNum,''))=0 THEN tabA.TCNUM 
            					ELSE  tabA.CombinationNum END
            		) AS NewCombinationNum,B.Title
            		FROM rb_travel_price AS tabA LEFT JOIN rb_travel_config as B on tabA.ConfigID=B.ID
                         LEFT JOIN rb_leader_schedule as C ON tabA.TCID=C.TCID AND C.Status=0  
            		WHERE 1=1 AND tabA.TCState=3  AND tabA.Status IN(1,2,5)  AND tabA.RB_Group_Id=2  AND tabA.StartDate>='2025-06-01 00:00:00'  AND tabA.TCState  in(1,3)  
            ) AS A 
            GROUP BY A.NewCombinationNum ) as B  ORDER BY B.StartDate asc 
            

DateTime:2026/6/15 10:24:22
ExtMessage:购物店列表查询sql1:
             SELECT * from (  SELECT A.NewCombinationNum,GROUP_CONCAT(A.TCID) AS TCIDS, MIN(A.StartDate) as StartDate,MAX(A.DMCNum) as DMCNum
            FROM
            (
            		SELECT tabA.*,B.StartCityId,B.LineteamId,B.DayNum,B.LineId,
            		(CASE WHEN  LENGTH(IFNULL(tabA.CombinationNum,''))=0 THEN tabA.TCNUM 
            					ELSE  tabA.CombinationNum END
            		) AS NewCombinationNum,B.Title
            		FROM rb_travel_price AS tabA LEFT JOIN rb_travel_config as B on tabA.ConfigID=B.ID
                         LEFT JOIN rb_leader_schedule as C ON tabA.TCID=C.TCID AND C.Status=0  
            		WHERE 1=1 AND tabA.TCState=3  AND tabA.Status IN(1,2,5)  AND tabA.RB_Group_Id=2  AND tabA.StartDate>='2025-06-01 00:00:00'  AND tabA.TCState  in(1,3)  
            ) AS A 
            GROUP BY A.NewCombinationNum ) as B  ORDER BY B.StartDate asc 
            

DateTime:2026/6/15 10:24:23
ExtMessage:购物店列表查询sql1:
             SELECT * from (  SELECT A.NewCombinationNum,GROUP_CONCAT(A.TCID) AS TCIDS, MIN(A.StartDate) as StartDate,MAX(A.DMCNum) as DMCNum
            FROM
            (
            		SELECT tabA.*,B.StartCityId,B.LineteamId,B.DayNum,B.LineId,
            		(CASE WHEN  LENGTH(IFNULL(tabA.CombinationNum,''))=0 THEN tabA.TCNUM 
            					ELSE  tabA.CombinationNum END
            		) AS NewCombinationNum,B.Title
            		FROM rb_travel_price AS tabA LEFT JOIN rb_travel_config as B on tabA.ConfigID=B.ID
                         LEFT JOIN rb_leader_schedule as C ON tabA.TCID=C.TCID AND C.Status=0  
            		WHERE 1=1 AND tabA.TCState=3  AND tabA.Status IN(1,2,5)  AND tabA.RB_Group_Id=2  AND tabA.StartDate>='2025-06-01 00:00:00'  AND tabA.TCState  in(1,3)  
            ) AS A 
            GROUP BY A.NewCombinationNum ) as B  ORDER BY B.StartDate asc 
            

DateTime:2026/6/15 10:24:27
ExtMessage:购物店列表查询sql1:
             SELECT * from (  SELECT A.NewCombinationNum,GROUP_CONCAT(A.TCID) AS TCIDS, MIN(A.StartDate) as StartDate,MAX(A.DMCNum) as DMCNum
            FROM
            (
            		SELECT tabA.*,B.StartCityId,B.LineteamId,B.DayNum,B.LineId,
            		(CASE WHEN  LENGTH(IFNULL(tabA.CombinationNum,''))=0 THEN tabA.TCNUM 
            					ELSE  tabA.CombinationNum END
            		) AS NewCombinationNum,B.Title
            		FROM rb_travel_price AS tabA LEFT JOIN rb_travel_config as B on tabA.ConfigID=B.ID
                         LEFT JOIN rb_leader_schedule as C ON tabA.TCID=C.TCID AND C.Status=0  
            		WHERE 1=1 AND tabA.TCState=3  AND tabA.Status IN(1,2,5)  AND tabA.RB_Group_Id=2  AND tabA.StartDate>='2025-06-01 00:00:00'  AND tabA.DMCNum like'%Test222222%'  AND tabA.TCState  in(1,3)  
            ) AS A 
            GROUP BY A.NewCombinationNum ) as B  ORDER BY B.StartDate asc 
            

DateTime:2026/6/15 10:25:15
ExtMessage:购物店列表查询sql1:
             SELECT * from (  SELECT A.NewCombinationNum,GROUP_CONCAT(A.TCID) AS TCIDS, MIN(A.StartDate) as StartDate,MAX(A.DMCNum) as DMCNum
            FROM
            (
            		SELECT tabA.*,B.StartCityId,B.LineteamId,B.DayNum,B.LineId,
            		(CASE WHEN  LENGTH(IFNULL(tabA.CombinationNum,''))=0 THEN tabA.TCNUM 
            					ELSE  tabA.CombinationNum END
            		) AS NewCombinationNum,B.Title
            		FROM rb_travel_price AS tabA LEFT JOIN rb_travel_config as B on tabA.ConfigID=B.ID
                         LEFT JOIN rb_leader_schedule as C ON tabA.TCID=C.TCID AND C.Status=0  
            		WHERE 1=1 AND tabA.TCState=3  AND tabA.Status IN(1,2,5)  AND tabA.RB_Group_Id=2  AND tabA.StartDate>='2026-6-15 00:00:00'  AND tabA.TCState  in(1,3)  
            ) AS A 
            GROUP BY A.NewCombinationNum ) as B  ORDER BY B.StartDate asc 
            

DateTime:2026/6/15 10:25:21
ExtMessage:购物店列表查询sql1:
             SELECT * from (  SELECT A.NewCombinationNum,GROUP_CONCAT(A.TCID) AS TCIDS, MIN(A.StartDate) as StartDate,MAX(A.DMCNum) as DMCNum
            FROM
            (
            		SELECT tabA.*,B.StartCityId,B.LineteamId,B.DayNum,B.LineId,
            		(CASE WHEN  LENGTH(IFNULL(tabA.CombinationNum,''))=0 THEN tabA.TCNUM 
            					ELSE  tabA.CombinationNum END
            		) AS NewCombinationNum,B.Title
            		FROM rb_travel_price AS tabA LEFT JOIN rb_travel_config as B on tabA.ConfigID=B.ID
                         LEFT JOIN rb_leader_schedule as C ON tabA.TCID=C.TCID AND C.Status=0  
            		WHERE 1=1 AND tabA.TCState=3  AND tabA.Status IN(1,2,5)  AND tabA.RB_Group_Id=2  AND tabA.StartDate>='2025-06-01 00:00:00'  AND tabA.DMCNum like'%Test222222%'  AND tabA.TCState  in(1,3)  
            ) AS A 
            GROUP BY A.NewCombinationNum ) as B  ORDER BY B.StartDate asc 
            

DateTime:2026/6/15 10:25:46
ExtMessage:购物店列表查询sql1:
             SELECT * from (  SELECT A.NewCombinationNum,GROUP_CONCAT(A.TCID) AS TCIDS, MIN(A.StartDate) as StartDate,MAX(A.DMCNum) as DMCNum
            FROM
            (
            		SELECT tabA.*,B.StartCityId,B.LineteamId,B.DayNum,B.LineId,
            		(CASE WHEN  LENGTH(IFNULL(tabA.CombinationNum,''))=0 THEN tabA.TCNUM 
            					ELSE  tabA.CombinationNum END
            		) AS NewCombinationNum,B.Title
            		FROM rb_travel_price AS tabA LEFT JOIN rb_travel_config as B on tabA.ConfigID=B.ID
                         LEFT JOIN rb_leader_schedule as C ON tabA.TCID=C.TCID AND C.Status=0  
            		WHERE 1=1 AND tabA.TCState=3  AND tabA.Status IN(1,2,5)  AND tabA.RB_Group_Id=2  AND tabA.StartDate>='2025-06-01 00:00:00'  AND tabA.TCState  in(1,3)  
            ) AS A 
            GROUP BY A.NewCombinationNum ) as B  ORDER BY B.StartDate asc 
            

DateTime:2026/6/15 10:25:48
ExtMessage:购物店列表查询sql1:
             SELECT * from (  SELECT A.NewCombinationNum,GROUP_CONCAT(A.TCID) AS TCIDS, MIN(A.StartDate) as StartDate,MAX(A.DMCNum) as DMCNum
            FROM
            (
            		SELECT tabA.*,B.StartCityId,B.LineteamId,B.DayNum,B.LineId,
            		(CASE WHEN  LENGTH(IFNULL(tabA.CombinationNum,''))=0 THEN tabA.TCNUM 
            					ELSE  tabA.CombinationNum END
            		) AS NewCombinationNum,B.Title
            		FROM rb_travel_price AS tabA LEFT JOIN rb_travel_config as B on tabA.ConfigID=B.ID
                         LEFT JOIN rb_leader_schedule as C ON tabA.TCID=C.TCID AND C.Status=0  
            		WHERE 1=1 AND tabA.TCState=3  AND tabA.Status IN(1,2,5)  AND tabA.RB_Group_Id=2  AND tabA.StartDate>='2025-06-01 00:00:00'  AND tabA.TCState  in(1,3)  
            ) AS A 
            GROUP BY A.NewCombinationNum ) as B  ORDER BY B.StartDate asc 
            

DateTime:2026/6/15 10:25:49
ExtMessage:购物店列表查询sql1:
             SELECT * from (  SELECT A.NewCombinationNum,GROUP_CONCAT(A.TCID) AS TCIDS, MIN(A.StartDate) as StartDate,MAX(A.DMCNum) as DMCNum
            FROM
            (
            		SELECT tabA.*,B.StartCityId,B.LineteamId,B.DayNum,B.LineId,
            		(CASE WHEN  LENGTH(IFNULL(tabA.CombinationNum,''))=0 THEN tabA.TCNUM 
            					ELSE  tabA.CombinationNum END
            		) AS NewCombinationNum,B.Title
            		FROM rb_travel_price AS tabA LEFT JOIN rb_travel_config as B on tabA.ConfigID=B.ID
                         LEFT JOIN rb_leader_schedule as C ON tabA.TCID=C.TCID AND C.Status=0  
            		WHERE 1=1 AND tabA.TCState=3  AND tabA.Status IN(1,2,5)  AND tabA.RB_Group_Id=2  AND tabA.StartDate>='2025-06-01 00:00:00'  AND tabA.TCState  in(1,3)  
            ) AS A 
            GROUP BY A.NewCombinationNum ) as B  ORDER BY B.StartDate asc 
            

DateTime:2026/6/15 10:25:50
ExtMessage:购物店列表查询sql1:
             SELECT * from (  SELECT A.NewCombinationNum,GROUP_CONCAT(A.TCID) AS TCIDS, MIN(A.StartDate) as StartDate,MAX(A.DMCNum) as DMCNum
            FROM
            (
            		SELECT tabA.*,B.StartCityId,B.LineteamId,B.DayNum,B.LineId,
            		(CASE WHEN  LENGTH(IFNULL(tabA.CombinationNum,''))=0 THEN tabA.TCNUM 
            					ELSE  tabA.CombinationNum END
            		) AS NewCombinationNum,B.Title
            		FROM rb_travel_price AS tabA LEFT JOIN rb_travel_config as B on tabA.ConfigID=B.ID
                         LEFT JOIN rb_leader_schedule as C ON tabA.TCID=C.TCID AND C.Status=0  
            		WHERE 1=1 AND tabA.TCState=3  AND tabA.Status IN(1,2,5)  AND tabA.RB_Group_Id=2  AND tabA.StartDate>='2025-06-01 00:00:00'  AND tabA.TCState  in(1,3)  
            ) AS A 
            GROUP BY A.NewCombinationNum ) as B  ORDER BY B.StartDate asc 
            

DateTime:2026/6/15 10:25:57
ExtMessage:购物店列表查询sql1:
             SELECT * from (  SELECT A.NewCombinationNum,GROUP_CONCAT(A.TCID) AS TCIDS, MIN(A.StartDate) as StartDate,MAX(A.DMCNum) as DMCNum
            FROM
            (
            		SELECT tabA.*,B.StartCityId,B.LineteamId,B.DayNum,B.LineId,
            		(CASE WHEN  LENGTH(IFNULL(tabA.CombinationNum,''))=0 THEN tabA.TCNUM 
            					ELSE  tabA.CombinationNum END
            		) AS NewCombinationNum,B.Title
            		FROM rb_travel_price AS tabA LEFT JOIN rb_travel_config as B on tabA.ConfigID=B.ID
                         LEFT JOIN rb_leader_schedule as C ON tabA.TCID=C.TCID AND C.Status=0  
            		WHERE 1=1 AND tabA.TCState=3  AND tabA.Status IN(1,2,5)  AND tabA.RB_Group_Id=2  AND tabA.StartDate>='2025-06-01 00:00:00'  AND tabA.DMCNum like'%Test222222%'  AND tabA.TCState  in(1,3)  
            ) AS A 
            GROUP BY A.NewCombinationNum ) as B  ORDER BY B.StartDate asc 
            

DateTime:2026/6/15 10:27:31
ExtMessage:购物店列表查询sql1:
             SELECT * from (  SELECT A.NewCombinationNum,GROUP_CONCAT(A.TCID) AS TCIDS, MIN(A.StartDate) as StartDate,MAX(A.DMCNum) as DMCNum
            FROM
            (
            		SELECT tabA.*,B.StartCityId,B.LineteamId,B.DayNum,B.LineId,
            		(CASE WHEN  LENGTH(IFNULL(tabA.CombinationNum,''))=0 THEN tabA.TCNUM 
            					ELSE  tabA.CombinationNum END
            		) AS NewCombinationNum,B.Title
            		FROM rb_travel_price AS tabA LEFT JOIN rb_travel_config as B on tabA.ConfigID=B.ID
                         LEFT JOIN rb_leader_schedule as C ON tabA.TCID=C.TCID AND C.Status=0  
            		WHERE 1=1 AND tabA.TCState=3  AND tabA.Status IN(1,2,5)  AND tabA.RB_Group_Id=2  AND tabA.StartDate>='2025-06-01 00:00:00'  AND tabA.DMCNum like'%Test222222%'  AND tabA.TCState  in(1,3)  
            ) AS A 
            GROUP BY A.NewCombinationNum ) as B  ORDER BY B.StartDate asc 
            

DateTime:2026/6/15 10:28:00
ExtMessage:购物店列表查询sql1:
             SELECT * from (  SELECT A.NewCombinationNum,GROUP_CONCAT(A.TCID) AS TCIDS, MIN(A.StartDate) as StartDate,MAX(A.DMCNum) as DMCNum
            FROM
            (
            		SELECT tabA.*,B.StartCityId,B.LineteamId,B.DayNum,B.LineId,
            		(CASE WHEN  LENGTH(IFNULL(tabA.CombinationNum,''))=0 THEN tabA.TCNUM 
            					ELSE  tabA.CombinationNum END
            		) AS NewCombinationNum,B.Title
            		FROM rb_travel_price AS tabA LEFT JOIN rb_travel_config as B on tabA.ConfigID=B.ID
                         LEFT JOIN rb_leader_schedule as C ON tabA.TCID=C.TCID AND C.Status=0  
            		WHERE 1=1 AND tabA.TCState=3  AND tabA.Status IN(1,2,5)  AND tabA.RB_Group_Id=2  AND tabA.StartDate>='2025-06-01 00:00:00'  AND tabA.DMCNum like'%Test222222%'  AND tabA.TCState  in(1,3)  
            ) AS A 
            GROUP BY A.NewCombinationNum ) as B  ORDER BY B.StartDate asc 
            

DateTime:2026/6/15 10:31:24
ExtMessage:购物店列表查询sql1:
             SELECT * from (  SELECT A.NewCombinationNum,GROUP_CONCAT(A.TCID) AS TCIDS, MIN(A.StartDate) as StartDate,MAX(A.DMCNum) as DMCNum
            FROM
            (
            		SELECT tabA.*,B.StartCityId,B.LineteamId,B.DayNum,B.LineId,
            		(CASE WHEN  LENGTH(IFNULL(tabA.CombinationNum,''))=0 THEN tabA.TCNUM 
            					ELSE  tabA.CombinationNum END
            		) AS NewCombinationNum,B.Title
            		FROM rb_travel_price AS tabA LEFT JOIN rb_travel_config as B on tabA.ConfigID=B.ID
                         LEFT JOIN rb_leader_schedule as C ON tabA.TCID=C.TCID AND C.Status=0  
            		WHERE 1=1 AND tabA.TCState=3  AND tabA.Status IN(1,2,5)  AND tabA.RB_Group_Id=2  AND tabA.StartDate>='2025-06-01 00:00:00'  AND tabA.DMCNum like'%Test222222%'  AND tabA.TCState  in(1,3)  
            ) AS A 
            GROUP BY A.NewCombinationNum ) as B  ORDER BY B.StartDate asc 
            

DateTime:2026/6/15 10:33:57
ExtMessage:购物店列表查询sql1:
             SELECT * from (  SELECT A.NewCombinationNum,GROUP_CONCAT(A.TCID) AS TCIDS, MIN(A.StartDate) as StartDate,MAX(A.DMCNum) as DMCNum
            FROM
            (
            		SELECT tabA.*,B.StartCityId,B.LineteamId,B.DayNum,B.LineId,
            		(CASE WHEN  LENGTH(IFNULL(tabA.CombinationNum,''))=0 THEN tabA.TCNUM 
            					ELSE  tabA.CombinationNum END
            		) AS NewCombinationNum,B.Title
            		FROM rb_travel_price AS tabA LEFT JOIN rb_travel_config as B on tabA.ConfigID=B.ID
                         LEFT JOIN rb_leader_schedule as C ON tabA.TCID=C.TCID AND C.Status=0  
            		WHERE 1=1 AND tabA.TCState=3  AND tabA.Status IN(1,2,5)  AND tabA.RB_Group_Id=2  AND tabA.StartDate>='2026-6-15 00:00:00'  AND tabA.TCState  in(1,3)  
            ) AS A 
            GROUP BY A.NewCombinationNum ) as B  ORDER BY B.StartDate asc 
            

DateTime:2026/6/15 10:34:03
ExtMessage:购物店列表查询sql1:
             SELECT * from (  SELECT A.NewCombinationNum,GROUP_CONCAT(A.TCID) AS TCIDS, MIN(A.StartDate) as StartDate,MAX(A.DMCNum) as DMCNum
            FROM
            (
            		SELECT tabA.*,B.StartCityId,B.LineteamId,B.DayNum,B.LineId,
            		(CASE WHEN  LENGTH(IFNULL(tabA.CombinationNum,''))=0 THEN tabA.TCNUM 
            					ELSE  tabA.CombinationNum END
            		) AS NewCombinationNum,B.Title
            		FROM rb_travel_price AS tabA LEFT JOIN rb_travel_config as B on tabA.ConfigID=B.ID
                         LEFT JOIN rb_leader_schedule as C ON tabA.TCID=C.TCID AND C.Status=0  
            		WHERE 1=1 AND tabA.TCState=3  AND tabA.Status IN(1,2,5)  AND tabA.RB_Group_Id=2  AND tabA.StartDate>='2025-06-01 00:00:00'  AND tabA.TCState  in(1,3)  
            ) AS A 
            GROUP BY A.NewCombinationNum ) as B  ORDER BY B.StartDate asc 
            

DateTime:2026/6/15 10:34:05
ExtMessage:购物店列表查询sql1:
             SELECT * from (  SELECT A.NewCombinationNum,GROUP_CONCAT(A.TCID) AS TCIDS, MIN(A.StartDate) as StartDate,MAX(A.DMCNum) as DMCNum
            FROM
            (
            		SELECT tabA.*,B.StartCityId,B.LineteamId,B.DayNum,B.LineId,
            		(CASE WHEN  LENGTH(IFNULL(tabA.CombinationNum,''))=0 THEN tabA.TCNUM 
            					ELSE  tabA.CombinationNum END
            		) AS NewCombinationNum,B.Title
            		FROM rb_travel_price AS tabA LEFT JOIN rb_travel_config as B on tabA.ConfigID=B.ID
                         LEFT JOIN rb_leader_schedule as C ON tabA.TCID=C.TCID AND C.Status=0  
            		WHERE 1=1 AND tabA.TCState=3  AND tabA.Status IN(1,2,5)  AND tabA.RB_Group_Id=2  AND tabA.StartDate>='2025-06-01 00:00:00'  AND tabA.TCState  in(1,3)  
            ) AS A 
            GROUP BY A.NewCombinationNum ) as B  ORDER BY B.StartDate asc 
            

DateTime:2026/6/15 10:34:07
ExtMessage:购物店列表查询sql1:
             SELECT * from (  SELECT A.NewCombinationNum,GROUP_CONCAT(A.TCID) AS TCIDS, MIN(A.StartDate) as StartDate,MAX(A.DMCNum) as DMCNum
            FROM
            (
            		SELECT tabA.*,B.StartCityId,B.LineteamId,B.DayNum,B.LineId,
            		(CASE WHEN  LENGTH(IFNULL(tabA.CombinationNum,''))=0 THEN tabA.TCNUM 
            					ELSE  tabA.CombinationNum END
            		) AS NewCombinationNum,B.Title
            		FROM rb_travel_price AS tabA LEFT JOIN rb_travel_config as B on tabA.ConfigID=B.ID
                         LEFT JOIN rb_leader_schedule as C ON tabA.TCID=C.TCID AND C.Status=0  
            		WHERE 1=1 AND tabA.TCState=3  AND tabA.Status IN(1,2,5)  AND tabA.RB_Group_Id=2  AND tabA.StartDate>='2025-06-01 00:00:00'  AND tabA.TCState  in(1,3)  
            ) AS A 
            GROUP BY A.NewCombinationNum ) as B  ORDER BY B.StartDate asc 
            

DateTime:2026/6/15 10:34:20
ExtMessage:购物店列表查询sql1:
             SELECT * from (  SELECT A.NewCombinationNum,GROUP_CONCAT(A.TCID) AS TCIDS, MIN(A.StartDate) as StartDate,MAX(A.DMCNum) as DMCNum
            FROM
            (
            		SELECT tabA.*,B.StartCityId,B.LineteamId,B.DayNum,B.LineId,
            		(CASE WHEN  LENGTH(IFNULL(tabA.CombinationNum,''))=0 THEN tabA.TCNUM 
            					ELSE  tabA.CombinationNum END
            		) AS NewCombinationNum,B.Title
            		FROM rb_travel_price AS tabA LEFT JOIN rb_travel_config as B on tabA.ConfigID=B.ID
                         LEFT JOIN rb_leader_schedule as C ON tabA.TCID=C.TCID AND C.Status=0  
            		WHERE 1=1 AND tabA.TCState=3  AND tabA.Status IN(1,2,5)  AND tabA.RB_Group_Id=2  AND tabA.StartDate>='2025-06-01 00:00:00'  AND tabA.TCState  in(1,3)  
            ) AS A 
            GROUP BY A.NewCombinationNum ) as B  ORDER BY B.StartDate asc