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