SELECT * FROM products p LEFT JOIN pthem t ON p.no=t.pno WHERE quantity > '0' and catcode regexp '^08' and brand<>'스타' UNION SELECT * FROM products p LEFT JOIN pthem t ON p.no=t.pno WHERE quantity > '0' and catcode2 regexp '^08' and brand<>'스타' ORDER BY view + p_value desc

               

입금계좌안내

고객행복센터

(0개)