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