SELECT * FROM products p LEFT JOIN pthem t ON p.no=t.pno WHERE quantity > '0' and display like '1___' ORDER BY view + p_value desc

               

입금계좌안내

고객행복센터

(0개)