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.sign_date,h.direct_link_flg,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 mb_hospital as h left join mb_group_list as g on(h.gr_id=g.gr_id) where h.view_flg='t' and pref_id='word' order by case1 desc,h.pricesystem desc,h.sign_date asc,h.hospital_name asc offset 0 limit 20) as hoge,mb_operation as o where hoge.hospital_id=o.hospital_id and ope102='t' order by pricesystem desc,sign_date asc
PostgreSQL Error: 1 (ERROR: invalid input syntax for type integer: "word" LINE 1: ...h.gr_id=g.gr_id) where h.view_flg='t' and pref_id='word' ord... ^)
Session halted.