| Invalid SQL :
SELECT
gh.id,
gh.hospital_id,
gh.name,
gh.short_name,
gh.biz_no,
gh.ceo_name,
gh.tel,
gh.work_time,
gh.directions,
gh.directions_video,
gh.parking_guide,
gh.reservation_guide,
gh.reserv_memo_placeholder,
gh.address,
gh.address_detail,
gh.zipcode,
gh.usable,
gh.lang_cd,
gh.google_map,
gh.site_name,
gh.site_titlebar,
gh.meta_description,
gh.google_map,
gh.facebook_url,
gh.naver_blog_url,
gh.we_chat_url,
gh.whatsapp_url,
gh.instagram_url,
gh.line_url,
gh.kakao_pf_url,
gh.whats_app_url,
gh.created_at,
gh.seq,
h.name as origin_name,
h.code_name as origin_code_name,
h.contract_host
FROM
global_hospitals gh
LEFT OUTER JOIN hospitals h ON gh.hospital_id = h.user_id
WHERE
gh.deleted_at IS NULL
AND gh.usable = 'Y' AND gh.hospital_id = '2270' AND gh.lang_cd = 'mongolia'
ORDER BY
gh.seq ASC
|