SELECT travelname,salestitle,fitdm,travelclass,travelday,travelgono,travelgo.travelcode,travelmas.travelcode,travelmas.travelname,travelgosdate,travelgoout,goodcontent,travelgoname,travelb2cmoney1,travelb2cmoney5,travelb2cmoney14,travelb2bmoney1,travelb2bmoney5,travelb2bmoney14,goplane,comeplane,showfull,okcount,resultcount,mark FROM travelmas,travelgo WHERE travelgo.travelcode=travelmas.travelcode and travelgo.showfull='N' and travelmas.salesitem='4' and travelgo.okcount > travelgo.resultcount and travelgo.tdeadline = '1' and travelgo.okcount > '0' and travelgo.travelcode <> '' group by travelcode order by travelday