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