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