SELECT   m_idx, m_code, g_code, m_class, m_name, m_id, m_updateday,
                    (SELECT   TOP 1 c_point
                     FROM      u030054.el_check
                     WHERE   m_idx = u030054.EL_member.m_idx AND c_point <> NULL
                     ORDER BY c_idx DESC) AS m_point,
                    (SELECT   TOP 1 c_step
                     FROM      u030054.el_check
                     WHERE   m_idx = u030054.EL_member.m_idx
                     ORDER BY c_check_day DESC) AS c_step,
                    (SELECT   TOP 1 c_month
                     FROM      u030054.el_check
                     WHERE   m_idx = u030054.EL_member.m_idx
                     ORDER BY c_check_day DESC) AS c_month,
                    (SELECT   TOP 1 c_time
                     FROM      u030054.el_check
                     WHERE   m_idx = u030054.EL_member.m_idx
                     ORDER BY c_idx DESC) AS c_time,
                    (SELECT   TOP 1 c_check_day
                     FROM      u030054.el_check
                     WHERE   m_idx = u030054.EL_member.m_idx
                     ORDER BY c_check_day DESC) AS c_check_day, m_academy,
                m_consent
FROM      u030054.EL_member