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