select *, ( SELECT st_name from g5_store WHERE st_id = t1.store_id) AS st_name from g5_procedure_goods t1 where 1=1 and t1.pr_status = '1' AND t1.ca_id IN ( SELECT ca_id FROM g5_procedure_category WHERE ca_category = '2' AND ca_status = '1')AND t1.store_id = 'all' and pr_rank = '1' and pr_status = '1' and pr_use_vn = 1 ORDER BY t1.pr_order ascasd
Total (Exc. tax) ₩2,188,000

예약이 완료되었습니다.