DateTime:2026/6/4 17:51:56
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-4 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/4 17:52:01
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/4 17:52: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>='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/4 17:52: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/4 17:52: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/4 17:52: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/4 17:53:38
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-4 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/4 17:53:39
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-4 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/4 17:53:44
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/4 17:53: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>='2026-6-4 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/4 17:53:54
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-4 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/4 17:53:59
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/4 17:54: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>='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/4 17:54: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/4 17:55:30
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/4 17:55:32
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/4 17:55:32
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/4 18:08: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>='2026-6-4 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/4 18:34:11
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-4 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/4 18:34: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>='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/4 18:34:19
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/4 18: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 
            

DateTime:2026/6/4 18:34: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.TCState  in(1,3)  
            ) AS A 
            GROUP BY A.NewCombinationNum ) as B  ORDER BY B.StartDate asc 
            

DateTime:2026/6/4 18:34: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    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/4 18:34:51
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-4 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/4 18:34:56
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/4 18:35: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>='2026-6-4 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/4 18:35:11
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/4 18:36: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    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/4 18:39:55
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/4 18:39:58
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