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