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 = '72' and pr_rank = '1' and pr_status = '1' and pr_use_en = 1 ORDER BY t1.pr_order ascasd
Total (Exc. tax) ₩2,188,000

예약이 완료되었습니다.