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