123123SELECT travelname,travelname2,travelname3,travelmas.travelpic,travelmas.salestitle,travelmas.promotion_text1,travelmas.promotion_text2,travelmas.promotion_type1,travelmas.promotion_valid1e,travelmas.promotion_valid1s,travelmas.promotion_valid2e,travelmas.promotion_valid2s,travelmas.promotion_type2,travelgo.travelcode,travelgo.travelgosdate,travelgo.tdeadline,travelgo.travelgoout,travelgo.showfull,travelgo.okcount,travelgo.resultcount,travelgo.fakecount,travelgo.countryid,travelgo.travelb2cmoney1,travelgo.travelb2cmoney5,substr(travelgono,2,1) as twoNo FROM travelmas,travelgo WHERE travelgo.travelcode=travelmas.travelcode and travelgo.travelgosdate > date_sub(curdate(),interval -4 day) and travelgo.tdeadline='1' and travelgo.b2conline='1' and travelmas.ttype='1' and ((travelmas.promotion_type1='2' and travelmas.promotion_valid1e >= '2025-06-17' and travelmas.promotion_valid1s <= '2025-06-17') or (travelmas.promotion_type2='2' and travelmas.promotion_valid2e >= '2025-06-17' and travelmas.promotion_valid2s <= '2025-06-17')) and travelgo.showfull='N' and travelgo.okcount > travelgo.resultcount+travelgo.fakecount group by travelcode order by FIND_IN_SET(twoNo,'G,T,M,P,R,F,D,N,K,C,H,V,S,E,X'),min(travelb2cmoney1),min(travelb2cmoney5)