select * from FOX_HaoMa Where yn<2 and Lei=1 and ClassId=21 and TaoCan=100 and HaoDuan=178 and Jiage=8 and cint(right(title,2))=cint(mid(title,len(title)-4,2)) and cint(mid(title,len(title)-2,1))<> Cint(right(title,1)) and cint(mid(title,len(title)-1,1))= Cint(right(title,1)) order by Title desc目前网站没有此类型号码,号码在不断更新,请您关注!