DateTime:2026/6/8 17:51: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>='2026-6-8 00:00:00'  AND tabA.TCState  in(1,3)  
            ) AS A 
            GROUP BY A.NewCombinationNum ) as B  ORDER BY B.StartDate asc