SELECT T_SHN.*, m_cik.cik_idd, m_cik.cik_nam, m_cik.cik_cih_kbn, m_syu.syu_nam, m_syu2.syu_nam as syu_nam2 FROM t_shn AS T_SHN LEFT JOIN m_cik ON T_SHN.shn_jus_001 = m_cik.cik_idd LEFT JOIN m_syu ON T_SHN.shn_syu = m_syu.syu_idd LEFT JOIN m_syu m_syu2 ON T_SHN.shn_syu2 = m_syu2.syu_idd WHERE T_SHN.shn_del_flg is NULL AND T_SHN.shn_ksi_flg = '1' AND T_SHN.shn_fea_002） = '1' ORDER BY T_SHN.shn_jus_001, T_SHN.shn_nam_frg USING ~<~ OFFSET 0 LIMIT 20