(7).SELECT * 
             FROM gs_gakkou_top_info_nendo ,gs_gakkou_user_mt 
             WHERE (gs_gtop_preview_flag = '0') 
               AND (gs_gtop_gakkou_id = gs_gu_gakkou_id ) 
               AND (gs_gu_mukou_flag = '0') 
               AND (gs_gtop_gakkou_id in ()) 
               AND (gs_gtop_nendo >= '2024' ) 
               AND (gs_gtop_message_date <= '2024-06-29' ) 
               ORDER BY gs_gtop_message_date DESC,gs_gtop_koushin_timestamp DESC