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 biyou_hospital as h left join biyou_group_list as g on(h.gr_id=g.gr_id) where h.view_flg='t' ) as hoge,biyou_operation as o where o.hospital_id=hoge.hospital_id and o.ope25='t' order by hoge.pricesystem desc,hoge.sign_date asc,substr(cast(hoge.pref_id as text),0,3),hoge.hospital_name asc offset 0 limit 20
PostgreSQL Error: 1 (ERROR: column o.ope25 does not exist at character 417)
Session halted.