Database error: Invalid SQL: select * from (select g.gr_order,case when g.gr_order ISNULL then '0' ELSE g.gr_order end as case1,h.url,h.direct_link_flg,h.sign_date,h.pricesystem,h.holiday,h.ope_time,h.tel,h.address,h.address2,h.access,h.hospital_id,h.hospital_name,h.pref_id from esthe_hospital as h left join esthe_group_list as g on(h.gr_id=g.gr_id) where h.view_flg='t' and h.pref_id=1 ) as hoge,esthe_operation as o where o.hospital_id=hoge.hospital_id and o.ope146='t' order by hoge.pricesystem desc,hoge.sign_date asc,substr(hoge.pref_id,0,3),hoge.hospital_name asc offset 0 limit 20
PostgreSQL Error: 1 (ERROR: column o.ope146 does not exist at character 433)
Session halted.