id, name, uri, type, rate, org_id, ip_address, model, device_sn, reg_user, reg_password, alias, video_cap_id, device_status_id, group_id, CREATED_OGN_ID, CREATED_OGN_NAME, CREATED_DEPT_ID, CREATED_DEPT_NAME, CREATED_USER_ID, CREATED_USER_NAME, CREATED_DATE, SEQUENCE, VERSION, TENANT_ID_, TER_TYPE_,CALL_MODE_,CONTACT_NAME_,TELEPHONE_NAME_,EMAIL_,MEMO,STATUS_,VIDEO_FORMAT_, DUAL_VIDEO_FORMAT_,UDIO_TYPE_,MUTE_,SILENT_,MAX_VOLUME_,MIC_STATE_,IS_IN_CONF_,TERMINAL_ID_ SELECT ex.id as id,meet.START_TIME_ as startTime,meet.END_TIME_ as endTime FROM biz_meeting meet inner JOIN biz_meeting_place par on meet.ID_=par.MEETING_ID_ join biz_site_param_ex ex on par.PLACE_ID_=ex.id where meet.MEETING_STATUS_='2'