PRODUCTS
Infors HT
쉐이커 및 바이오리액터
SELECT A.idx, A.p_name, A.memo2, A.p_image, A.cat_code, A.cat_no, A.etc_1, B.re_name, B.width, B.height FROM tbl_product A LEFT JOIN tbl_product_files B ON A.idx=B.b_idx WHERE main_show='Y' and A.cat_code like '1/%' group by A.idx order by A.sort_num DESC, A.idx DESC limit 20
Faster S.r.l.
생물안전작업대 (BSC)
SELECT A.idx, A.p_name, A.memo2, A.p_image, A.cat_code, A.cat_no, A.etc_1, B.re_name, B.width, B.height FROM tbl_product A LEFT JOIN tbl_product_files B ON A.idx=B.b_idx WHERE main_show='Y' and A.cat_code like '12/%' group by A.idx order by A.sort_num DESC, A.idx DESC limit 20
Liebherr
냉장고 및 냉동고
SELECT A.idx, A.p_name, A.memo2, A.p_image, A.cat_code, A.cat_no, A.etc_1, B.re_name, B.width, B.height FROM tbl_product A LEFT JOIN tbl_product_files B ON A.idx=B.b_idx WHERE main_show='Y' and A.cat_code like '13/%' group by A.idx order by A.sort_num DESC, A.idx DESC limit 20
Ecosafe
안전 캐비닛