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