SELECT a.seq, a.img_name, a.brand_seq, a.name, a.price, a.sale_price, a.wholesale_price, a.isnew, a.issale, a.isbest, a.iscobuy, a.isplan, a.isseason, a.isevent, a.isweek, a.issns, a.outofstock, a.point, a.model, a.searchword, a.register, a.origine, a.option_3, c.name as brandname, a.hit FROM goods a, brand c WHERE a.brand_seq=c.seq and a.isuse = '1' AND a.cate1 = '123' AND a.cate2 = '372' AND a.cate3 = '18' AND a.brand_seq != '5' AND (a.memlevel is NULL || a.memlevel = '0' || a.memlevel = '') order by a.update_date desc LIMIT 0, 20