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.siryou_flg,h.url,h.sign_date,h.pricesystem,h.tel,h.address,h.address2,h.access,h.hospital_id,h.hospital_name,h.pref_id from school_hospital as h left join school_group_list as g on(h.gr_id=g.gr_id) where h.view_flg='t' ) as hoge,school_operation as o where o.hospital_id=hoge.hospital_id and o.ope17='t' order by hoge.pricesystem desc,hoge.sign_date asc,hoge.hospital_name asc offset 0 limit 20
PostgreSQL Error: 1 (ERROR: column o.ope17 does not exist at character 394)
Session halted.