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

               

입금계좌안내

고객행복센터

(0개)