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 = '21'AND t1.store_id = 'all' and pr_rank = '1' and pr_status = '1' and pr_use_jp = 1 ORDER BY t1.pr_order ascasd