select A.goods_id as goods_id , A.goods_code as goods_code , A.cate_id as cate_id , A.goods_name_1 as goods_name_1 , A.goods_name_2 as goods_name_2 , A.goods_name_3 as goods_name_3 , A.goods_name_4 as goods_name_4 , A.goods_name_5 as goods_name_5 , A.sort_no as sort_no , A.keijyou as keijyou , A.jikahoukou as jikahoukou , A.jisokumitudo as jisokumitudo , A.kyuchakuryoku as kyuchakuryoku , A.jyuryou as jyuryou , A.nagasa as nagasa , A.haba as haba , A.atumi as atumi , A.chokkei as chokkei , A.naikei as naikei , A.stock as stock , A.stock_min as stock_min , A.urikiri_flg as urikiri_flg , A.goods_code_kikaku as goods_code_kikaku , coalesce((B.price/100) , A.price) as price from (select * from goods_master where pub_flg = '1' and price != 0 ) as A left join (select goods_id , price , price_zeinuki from goods_price where enable_start_date <= '20190719232735' and enable_end_date >= '20190719232735' and num_min <= 1 and num_max >= 1) as B on A.goods_id = B.goods_id order by chokkeiÉderkey=1560994928 asc limit 30 offset 0 DB Error: no such field