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