file : /home/intranet_v4/public_html/product/view.html (76 line)
SELECT *
								,( SELECT shop_name FROM member WHERE number = product.agent_num) shop_name 
								,( SELECT left(mem_code,2) FROM member WHERE number = product.agent_num) member_code 
								,DATE_FORMAT(reg_date,'%Y-%m-%d') as indate
								,h_hit, h_sell_cnt, h_m_sell_cnt
								,if(prod_odr<1 or prod_odr is null,100000,prod_odr) as product_order
								 FROM product LEFT JOIN product_hits ON h_prod_number = product.number AND product_hits.h_agent_num = product.agent_num AND openmarket = 'Y'  WHERE (product.number = '37618')