2025-12-07 12:38:32.588700 query starrocks: ((report_mediaqualityreportsummary_meetingstarttime >= date '2025-08-26') AND (report_mediaqualityreportsummary_meetingstarttime < date '2025-08-27'))
An error occurred: (mysql.connector.errors.ProgrammingError) 5202 (42000): Access denied; This sql is in blacklist, please contact your admin
[SQL: SELECT report_identifiers_clientcorrelationid,report_identifiers_commonidentityorgid,report_identifiers_commonidentityuserid,report_identifiers_correlationid,report_identifiers_csdmdeviceurl,report_identifiers_deviceid,report_identifiers_locusid,report_identifiers_locussessionid,report_identifiers_locusurl,report_identifiers_oauth2clientid,report_identifiers_sipsessionid_local,report_identifiers_sipsessionid_remote,report_identifiers_webclientdomain,report_identifiers_webexconferenceidstr,report_identifiers_webexsitename,report_identifiers_webexwebdomain,report_locussessiontype,report_mediaqualityreportsummary_audiocontentreport_rxcodec,report_mediaqualityreportsummary_audiocontentreport_transporttype,report_mediaqualityreportsummary_audiocontentreport_txbackgroundnoisereductionmodelast,report_mediaqualityreportsummary_audiocontentreport_txbackgroundnoisereductiontalkermodelast,report_mediaqualityreportsummary_audiocontentreport_txcodec,report_mediaqualityreportsummary_audiomainreport_rxcodec,report_mediaqualityreportsummary_audiomainreport_transporttype,report_mediaqualityreportsummary_audiomainreport_txbackgroundnoisereductionmodelast,report_mediaqualityreportsummary_audiomainreport_txbackgroundnoisereductiontalkermodelast,report_mediaqualityreportsummary_audiomainreport_txcodec,report_mediaqualityreportsummary_intervalendtimes,report_mediaqualityreportsummary_intervalmetadata_browsertype,report_mediaqualityreportsummary_intervalmetadata_browserversion,report_mediaqualityreportsummary_intervalmetadata_camerainfo_errorcode,report_mediaqualityreportsummary_intervalmetadata_camerainfo_information,report_mediaqualityreportsummary_intervalmetadata_camerainfo_name,report_mediaqualityreportsummary_intervalmetadata_clientcountrycode,report_mediaqualityreportsummary_intervalmetadata_clientprefix,report_mediaqualityreportsummary_intervalmetadata_clientroutedprefix,report_mediaqualityreportsummary_intervalmetadata_clienttype,report_mediaqualityreportsummary_intervalmetadata_clientversion,report_mediaqualityreportsummary_intervalmetadata_derivedsipclienttype,report_mediaqualityreportsummary_intervalmetadata_edgeinfo_alias,report_mediaqualityreportsummary_intervalmetadata_edgeinfo_labels,report_mediaqualityreportsummary_intervalmetadata_edgeinfo_privateip,report_mediaqualityreportsummary_intervalmetadata_edgeinfo_publicip,report_mediaqualityreportsummary_intervalmetadata_edgeinfo_version,report_mediaqualityreportsummary_intervalmetadata_hardwaretype,report_mediaqualityreportsummary_intervalmetadata_iniatacode,report_mediaqualityreportsummary_intervalmetadata_localip,report_mediaqualityreportsummary_intervalmetadata_localnetworkprefix,report_mediaqualityreportsummary_intervalmetadata_mediaenginesoftwareversion,report_mediaqualityreportsummary_intervalmetadata_medialabels,report_mediaqualityreportsummary_intervalmetadata_microphoneinfo_errorcode,report_mediaqualityreportsummary_intervalmetadata_microphoneinfo_information,report_mediaqualityreportsummary_intervalmetadata_microphoneinfo_name,report_mediaqualityreportsummary_intervalmetadata_networktype,report_mediaqualityreportsummary_intervalmetadata_ostype,report_mediaqualityreportsummary_intervalmetadata_osversion,report_mediaqualityreportsummary_intervalmetadata_outiatacode,report_mediaqualityreportsummary_intervalmetadata_peripherals,report_mediaqualityreportsummary_intervalmetadata_protocol,report_mediaqualityreportsummary_intervalmetadata_publicip,report_mediaqualityreportsummary_intervalmetadata_publicnetworkprefix,report_mediaqualityreportsummary_intervalmetadata_registrationmode,report_mediaqualityreportsummary_intervalmetadata_serveriatacode,report_mediaqualityreportsummary_intervalmetadata_serverip,report_mediaqualityreportsummary_intervalmetadata_servername,report_mediaqualityreportsummary_intervalmetadata_serverorggroup,report_mediaqualityreportsummary_intervalmetadata_serverpoolorgroup,report_mediaqualityreportsummary_intervalmetadata_serverregion,report_mediaqualityreportsummary_intervalmetadata_serverrole,report_mediaqualityreportsummary_intervalmetadata_servertype,report_mediaqualityreportsummary_intervalmetadata_serverversion,report_mediaqualityreportsummary_intervalmetadata_sharetype,report_mediaqualityreportsummary_intervalmetadata_speakerinfo_driver,report_mediaqualityreportsummary_intervalmetadata_speakerinfo_errorcode,report_mediaqualityreportsummary_intervalmetadata_speakerinfo_information,report_mediaqualityreportsummary_intervalmetadata_speakerinfo_name,report_mediaqualityreportsummary_intervalmetadata_subclienttype,report_mediaqualityreportsummary_intervalmetadata_upgradechannel,report_mediaqualityreportsummary_intervalmetadata_videodisplaymode,report_mediaqualityreportsummary_intervalmetadata_videolayouttype,report_mediaqualityreportsummary_intervalmetadata_videomeshclustername,report_mediaqualityreportsummary_intervalmetadata_videomeshservername,report_mediaqualityreportsummary_intervalmetadata_videorendertype,report_mediaqualityreportsummary_videocontentreport_rxcodec,report_mediaqualityreportsummary_videocontentreport_transporttype,report_mediaqualityreportsummary_videocontentreport_txcodec,report_mediaqualityreportsummary_videomainreport_rxcodec,report_mediaqualityreportsummary_videomainreport_transporttype,report_mediaqualityreportsummary_videomainreport_txcodec,report_name,reportid,reporttype,callend_outcome,callend_mediaoutcome,callend_failuretype,callend_device_devicetype,join_jointype,join_outcome,join_mediaoutcome,join_failuretype,join_locusdatacenter,join_clientinfo_clientlaunchmethod,join_mediafailuretype,sharer_failuretype,sharer_outcome,sharer_sharetype,sharee_failuretype,sharee_outcome,sharee_sharetype,role,sitetype,industry,join_issue,audio_issue,sharing_issue,video_issue,comments,_extrastring,_extranumber,major_client_version,surveytype,report_mediaqualityreportsummary_videomainreport_txbackgroundaugmentationtypelast,ucf_feature_name_list,mediadrop_audio_clientmediaerror_firstdroptime,mediadrop_share_audio_clientmediaerror_firstdroptime,mediadrop_share_clientmediaerror_firstdroptime,mediadrop_video_clientmediaerror_firstdroptime,nomedia_audio_clientmediaerror_mediafailuretype,nomedia_audio_clientmediaerror_rxerror,nomedia_audio_clientmediaerror_rxmoreerror,nomedia_audio_clientmediaerror_sessionconnecterrortype,nomedia_audio_clientmediaerror_txerror,nomedia_audio_clientmediaerror_txmoreerror,nomedia_audio_mediastatus_mediasuccess,nomedia_inlobby,nomedia_logincrosssite,nomedia_mediastatus_audiojointype,nomedia_meetsimple,nomedia_reconnect,nomedia_shareinstanceid,nomedia_share_audio_clientmediaerror_mediafailuretype,nomedia_share_audio_clientmediaerror_rxerror,nomedia_share_audio_clientmediaerror_rxmoreerror,nomedia_share_audio_clientmediaerror_sessionconnecterrortype,nomedia_share_audio_clientmediaerror_txerror,nomedia_share_audio_clientmediaerror_txmoreerror,nomedia_share_audio_mediastatus_mediasuccess,nomedia_share_clientmediaerror_mediafailuretype,nomedia_share_clientmediaerror_rxerror,nomedia_share_clientmediaerror_rxmoreerror,nomedia_share_clientmediaerror_sessionconnecterrortype,nomedia_share_clientmediaerror_txerror,nomedia_share_clientmediaerror_txmoreerror,nomedia_share_mediastatus_mediasuccess,nomedia_updatetype,nomedia_usertype,nomedia_video_clientmediaerror_mediafailuretype,nomedia_video_clientmediaerror_rxerror,nomedia_video_clientmediaerror_rxmoreerror,nomedia_video_clientmediaerror_sessionconnecterrortype,nomedia_video_clientmediaerror_txerror,nomedia_video_clientmediaerror_txmoreerror,nomedia_video_mediastatus_mediasuccess,join_crashinfo_crashtype,report_callingservicetype,csat_callingservicetype,report_mediaqualityreportsummary_intervalmetadata_cpuinfo_architecture,report_mediaqualityreportsummary_intervalmetadata_cpuinfo_description,report_serverlabels,csat_what_can_improve_translated,csatcc_classifier_output_tier1_label,csatcc_classifier_output_tier2_label,csatcc_classifier_mode,csatcc_classifier_categories_version,report_mediaqualityreportsummary_summaryreportdata_arrayfields,remote_clienttype,report_mediaqualityreportsummary_intervalmetadata_continentcode,report_identifiers_confluenceid,report_identifiers_trackingid,report_identifiers_venueid,report_identifiers_meetclustername,report_mediaqualityreportsummary_confluencemetrics_selectedcluster_reason,report_mediaqualityreportsummary_confluencemetrics_selectedcluster_serverorgid,report_mediaqualityreportsummary_confluencemetrics_selectedcluster_servergroupid,report_mediaqualityreportsummary_confluencemetrics_selectedcluster_transporttypes,report_mediaqualityreportsummary_confluencemetrics_usercluster_reason,report_mediaqualityreportsummary_confluencemetrics_usercluster_serverorgid,report_mediaqualityreportsummary_confluencemetrics_usercluster_servergroupid,report_mediaqualityreportsummary_confluencemetrics_usercluster_transporttypes,report_mediaqualityreportsummary_confluencemetrics_lowestlatencycluster_reason,report_mediaqualityreportsummary_confluencemetrics_lowestlatencycluster_serverorgid,report_mediaqualityreportsummary_confluencemetrics_lowestlatencycluster_servergroupid,report_mediaqualityreportsummary_confluencemetrics_lowestlatencycluster_transporttypes,report_mediaqualityreportsummary_confluencemetrics_skippedclusters,report_mediaqualityreportsummary_confluencemetrics_clientgeoipinfo_joinsignal_clientcountrycode,report_mediaqualityreportsummary_confluencemetrics_clientgeoipinfo_joinsignal_networkprefix,report_mediaqualityreportsummary_confluencemetrics_clientgeoipinfo_serverreflexive_clientcountrycode,report_mediaqualityreportsummary_confluencemetrics_clientgeoipinfo_joinsignal_geoinformation,report_mediaqualityreportsummary_confluencemetrics_clientgeoipinfo_serverreflexive_networkprefix,report_mediaqualityreportsummary_confluencemetrics_clientgeoipinfo_serverreflexive_geoinformation,report_mediaqualityreportsummary_confluencemetrics_clientgeoipinfo_discoverysignal_clientcountrycode,report_mediaqualityreportsummary_confluencemetrics_clientgeoipinfo_discoverysignal_networkprefix,report_mediaqualityreportsummary_confluencemetrics_clientgeoipinfo_discoverysignal_geoinformation,report_mediaqualityreportsummary_confluencemetrics_parameters_geohint,report_clientlabels,wxcsmq_report_audiomainreport_pathoptimization_pathoptimizationtype,wxcsmq_report_audiomainreport_pathoptimization_result_candidatetype,wxcsmq_report_audiomainreport_pathoptimization_result_reason,wxcsmq_report_audiomainreport_rxcodec,wxcsmq_report_audiomainreport_transporttype,wxcsmq_report_audiomainreport_txcodec,wxcsmq_report_identifiers_callid,wxcsmq_report_identifiers_commonidentityorgid,wxcsmq_report_identifiers_commonidentityuserid,wxcsmq_report_identifiers_correlationid,wxcsmq_report_identifiers_sipsessionid_local,wxcsmq_report_identifiers_sipsessionid_remote,wxcsmq_report_identifiers_wxcsite,wxcsmq_report_identifiers_wxcsitecountry,wxcsmq_report_intervalmetadata_calldirection,wxcsmq_report_intervalmetadata_calltype,wxcsmq_report_intervalmetadata_clienttype,wxcsmq_report_intervalmetadata_clientversion,wxcsmq_report_intervalmetadata_hardwaretype,wxcsmq_report_intervalmetadata_isvalidclientversion,wxcsmq_report_intervalmetadata_localip,wxcsmq_report_intervalmetadata_networktype,wxcsmq_report_intervalmetadata_ostype,wxcsmq_report_intervalmetadata_osversion,wxcsmq_report_intervalmetadata_publicip,wxcsmq_report_intervalmetadata_servername,wxcsmq_report_intervalmetadata_serverregion,wxcsmq_report_intervalmetadata_wxccallpath,wxcsmq_report_videomainreport_rxcodec,wxcsmq_report_videomainreport_transporttype,wxcsmq_report_videomainreport_txcodec,wxccdr_report_identifiers_callid,wxccdr_report_identifiers_commonidentityorgid,wxccdr_report_identifiers_commonidentityuserid,wxccdr_report_identifiers_correlationid,wxccdr_report_identifiers_sipsessionid_local,wxccdr_report_identifiers_sipsessionid_remote,wxccdr_report_identifiers_wxcdepartmentid,wxccdr_report_identifiers_wxcsite,wxccdr_report_identifiers_wxcsitecountry,wxccdr_report_identifiers_wxcsiteid,wxccdr_report_metadata_calldirection,wxccdr_report_metadata_calltype,wxccdr_report_metadata_clienttype,wxccdr_report_metadata_clientversion,wxccdr_report_metadata_hardwaretype,wxccdr_report_metadata_ostype,wxccdr_report_metadata_osversion,wxccdr_report_metadata_serveriatacode,wxccdr_report_metadata_servername,wxccdr_report_metadata_serverregion,wxccdr_report_metadata_serverversion,wxccdr_report_metadata_subclienttype,wxccdr_report_metadata_upgradechannel,wxccdr_report_metadata_wxccallpath,wxccdr_report_usagereport_callanswertime,wxccdr_report_usagereport_callstarttime,wxccdr_report_usagereport_calltransfertime,wxccdr_report_usagereport_countrycode,wxccdr_report_usagereport_hasaudio,wxccdr_report_usagereport_hasvideo,wxccdr_report_usagereport_inboundtrunk,wxccdr_report_usagereport_originalreason,wxccdr_report_usagereport_outboundtrunk,wxccdr_report_usagereport_pstnidentifier,wxccdr_report_usagereport_redirectedreason,wxccdr_report_usagereport_redirectingnumber,wxccdr_report_usagereport_relatedcallid,wxccdr_report_usagereport_relatedreason,wxccdr_report_usagereport_releasingparty,wxccdr_report_usagereport_remotecallid,wxccdr_report_usagereport_result_context,wxccdr_report_usagereport_result_outcome,wxccdr_report_usagereport_result_reason,wxccdr_report_usagereport_routegroup,wxccdr_report_usagereport_transferrelatedcallid,wxccdr_report_usagereport_usertype,wxcsmq_carrier,ip2geo_countrycode,ip2geo_state,ip2geo_city,ip2geo_carrierid,ip2geo_carrier,ip2geo_asn,ip2geo_timezone,ip2geo_org,report_webexsubservicetype,pstn_outcome,join_logintype,join_audiojointype,join_jointrigger,join_upgradechannel,join_usertype,join_updatetype,callinfo_calltype,org_industry,remote_medialabels,report_mediaqualityreportsummary_intervalmetadata_callling_remoteuserid,prejoin_outcome,prejoin_failed_failuretype,prejoin_skipped_failuretype,join_paireddevice_devicetype,sharer_paireddevice_devicetype,sharee_paireddevice_devicetype,csat_surveydetails,ucf_feature_name_list_initial,ucf_feature_name_list_notinitial,join_resultname,join_clientinfo_webexappversion,join_clienterror_rawerrormessage,join_clientmetadata_bwccalltype,join_clientmetadata_callorigin,join_clientmetadata_calltype,join_clientmetadata_endreason,join_clientmetadata_wxccallid,join_identifiers_sipsessionid_local,join_identifiers_sipsessionid_remote,bumetric_platform_info,bumetric_logical_processors,bumetric_startup_mode,bumetric_users_channel,bumetric_calltype,bumetric_staticperformancelevel,bumetric_vm_type,bumetric_pairedsessionid,report_mediaqualityreportsummary_confluencemetrics_calliopeeventlabels,join_clientlabels,report_mediaqualityreportsummary_intervalmetadata_dpcrecord,ucf_action_delayed,ucf_action_failed,ucf_action_failed_reason,ucfmetadata_feedbackid,ucfmetadata_catalog,ucfmetadata_subcatalog,ucfmetadata_crashprocess,ucfmetadata_crashtype,report_mediaqualityreportsummary_meetingjoininfo_meetingplatform,join_calldirection,report_mediaqualityreportsummary_intervalmetadata_localipversion,report_mediaqualityreportsummary_intervalmetadata_serveripversion,report_mediaqualityreportsummary_videocontentreport_txscreencapturemodelast,report_mediaqualityreportsummary_intervalmetadata_calltype,report_mediaqualityreportsummary_intervalmetadata_pstnaudiocalltype,report_mediaqualityreportsummary_intervalmetadata_pstncarrierinfo_cic,join_clienterror_mediadeviceerrors,join_clienterror_errordescription,report_mediaqualityreportsummary_confluencemetrics_clientreachability_vmnreachability,report_mediaqualityreportsummary_confluencemetrics_clientreachability_publicreachability,join_callend_sessiontypecategoryforsurvey,bumetric_extra_payload_product_mode,report_mediaqualityreportsummary_audiocontentreport_mediaerrorsummary_nomediatxerrortype,report_mediaqualityreportsummary_audiocontentreport_mediaerrorsummary_nomediarxerrortype,report_mediaqualityreportsummary_audiocontentreport_mediaerrorsummary_dropmediatxerrortype,report_mediaqualityreportsummary_audiocontentreport_mediaerrorsummary_dropmediarxerrortype,report_mediaqualityreportsummary_audiomainreport_mediaerrorsummary_nomediatxerrortype,report_mediaqualityreportsummary_audiomainreport_mediaerrorsummary_nomediarxerrortype,report_mediaqualityreportsummary_audiomainreport_mediaerrorsummary_dropmediatxerrortype,report_mediaqualityreportsummary_audiomainreport_mediaerrorsummary_dropmediarxerrortype,report_mediaqualityreportsummary_videocontentreport_mediaerrorsummary_nomediatxerrortype,report_mediaqualityreportsummary_videocontentreport_mediaerrorsummary_nomediarxerrortype,report_mediaqualityreportsummary_videocontentreport_mediaerrorsummary_dropmediatxerrortype,report_mediaqualityreportsummary_videocontentreport_mediaerrorsummary_dropmediarxerrortype,report_mediaqualityreportsummary_videomainreport_mediaerrorsummary_nomediatxerrortype,report_mediaqualityreportsummary_videomainreport_mediaerrorsummary_nomediarxerrortype,report_mediaqualityreportsummary_videomainreport_mediaerrorsummary_dropmediatxerrortype,report_mediaqualityreportsummary_videomainreport_mediaerrorsummary_dropmediarxerrortype,wxccdr_report_usagereport_pstnvendorname,report_mediaqualityreportsummary_videomainreport_rxdecodedviews,report_mediaqualityreportsummary_videocontentreport_rxdecodedviews,report_mediaqualityreportsummary_videomainreport_txtouchupmode,report_mediaqualityreportsummary_intervalmetadata_clientipcapability,report_identifiers_installationid,report_identifiers_idforendpointab,report_mediaqualityreportsummary_confluencemetrics_usedmediaserveralias,report_mediaqualityreportsummary_confluencemetrics_usedmediaservertype,report_mediaqualityreportsummary_confluencemetrics_usedmediaserviceserveralias,report_mediaqualityreportsummary_confluencemetrics_usedmediaserviceservertype,remote_clientlabels,remote_idforendpointab,report_mediaqualityreportsummary_intervalmetadataaggregates_networktypechange,report_mediaqualityreportsummary_audiomainreport_txafternetworkthreadjitterhistogram,report_mediaqualityreportsummary_audiomainreport_txbeforeoncapturedatajitterhistogram,report_mediaqualityreportsummary_audiomainreport_txafteroncapturedatajitterhistogram,report_mediaqualityreportsummary_audiomainreport_txbeforebufferandencodejitterhistogram,report_mediaqualityreportsummary_audiomainreport_txafterbufferandencodejitterhistogram,report_mediaqualityreportsummary_audiocontentreport_mediaerrorsummary_nomediatxerrorcode,report_mediaqualityreportsummary_audiocontentreport_mediaerrorsummary_nomediatxerrorcodeext1,report_mediaqualityreportsummary_audiocontentreport_mediaerrorsummary_nomediarxerrorcode,report_mediaqualityreportsummary_audiocontentreport_mediaerrorsummary_nomediarxerrorcodeext1,report_mediaqualityreportsummary_audiocontentreport_mediaerrorsummary_dropmediatxerrorcode,report_mediaqualityreportsummary_audiocontentreport_mediaerrorsummary_dropmediatxerrorcodeext1,report_mediaqualityreportsummary_audiocontentreport_mediaerrorsummary_dropmediarxerrorcode,report_mediaqualityreportsummary_audiocontentreport_mediaerrorsummary_dropmediarxerrorcodeext1,report_mediaqualityreportsummary_videocontentreport_mediaerrorsummary_nomediatxerrorcode,report_mediaqualityreportsummary_videocontentreport_mediaerrorsummary_nomediatxerrorcodeext1,report_mediaqualityreportsummary_videocontentreport_mediaerrorsummary_nomediarxerrorcode,report_mediaqualityreportsummary_videocontentreport_mediaerrorsummary_nomediarxerrorcodeext1,report_mediaqualityreportsummary_videocontentreport_mediaerrorsummary_dropmediatxerrorcode,report_mediaqualityreportsummary_videocontentreport_mediaerrorsummary_dropmediatxerrorcodeext1,report_mediaqualityreportsummary_videocontentreport_mediaerrorsummary_dropmediarxerrorcode,report_mediaqualityreportsummary_videocontentreport_mediaerrorsummary_dropmediarxerrorcodeext1,report_mediaqualityreportsummary_audiomainreport_mediaerrorsummary_nomediatxerrorcode,report_mediaqualityreportsummary_audiomainreport_mediaerrorsummary_nomediatxerrorcodeext1,report_mediaqualityreportsummary_audiomainreport_mediaerrorsummary_nomediarxerrorcode,report_mediaqualityreportsummary_audiomainreport_mediaerrorsummary_nomediarxerrorcodeext1,report_mediaqualityreportsummary_audiomainreport_mediaerrorsummary_dropmediatxerrorcode,report_mediaqualityreportsummary_audiomainreport_mediaerrorsummary_dropmediatxerrorcodeext1,report_mediaqualityreportsummary_audiomainreport_mediaerrorsummary_dropmediarxerrorcode,report_mediaqualityreportsummary_audiomainreport_mediaerrorsummary_dropmediarxerrorcodeext1,report_mediaqualityreportsummary_videomainreport_mediaerrorsummary_nomediatxerrorcode,report_mediaqualityreportsummary_videomainreport_mediaerrorsummary_nomediatxerrorcodeext1,report_mediaqualityreportsummary_videomainreport_mediaerrorsummary_nomediarxerrorcode,report_mediaqualityreportsummary_videomainreport_mediaerrorsummary_nomediarxerrorcodeext1,report_mediaqualityreportsummary_videomainreport_mediaerrorsummary_dropmediatxerrorcode,report_mediaqualityreportsummary_videomainreport_mediaerrorsummary_dropmediatxerrorcodeext1,report_mediaqualityreportsummary_videomainreport_mediaerrorsummary_dropmediarxerrorcode,report_mediaqualityreportsummary_videomainreport_mediaerrorsummary_dropmediarxerrorcodeext1,join_sessiontypecategory,report_mediaqualityreportsummary_intervalmetadata_clientversionstatus,report_mediaqualityreportsummary_audiomainreport_audiocaptureplaybackcallbacklostduration_playback_suberrorcodeforrestart,report_mediaqualityreportsummary_audiomainreport_audiocaptureplaybackcallbacklostduration_capture_suberrorcodeforrestart,report_mediaqualityreportsummary_intervalmetadata_microphoneinfo_suberrorcode,report_mediaqualityreportsummary_intervalmetadata_speakerinfo_suberrorcode,report_mediaqualityreportsummary_audiomainreport_rxinitialcellulartype,report_mediaqualityreportsummary_audiomainreport_txinitialcellulartype,report_mediaqualityreportsummary_audiomainreport_rxfinalcellulartype,report_mediaqualityreportsummary_audiomainreport_txfinalcellulartype,report_mediaqualityreportsummary_videomainreport_rxinitialcellulartype,report_mediaqualityreportsummary_videomainreport_txinitialcellulartype,report_mediaqualityreportsummary_videomainreport_rxfinalcellulartype,report_mediaqualityreportsummary_videomainreport_txfinalcellulartype,report_mediaqualityreportsummary_intervalmetadata_camerainfo_status,report_mediaqualityreportsummary_intervalmetadata_microphoneinfo_status,report_mediaqualityreportsummary_intervalmetadata_speakerinfo_status,report_mediaqualityreportsummary_intervalmetadata_upgradechannel_lower,report_passthroughmqsreportdata
FROM iceberg.prod.participant_mqsr_nps_ca_aggr_join
WHERE ((report_mediaqualityreportsummary_meetingstarttime >= date '2025-08-26') AND (report_mediaqualityreportsummary_meetingstarttime < date '2025-08-27'))
AND ((((report_isTest != 'true' OR report_isTest IS NULL)
AND (report_mediaQualityReportSummary_intervalMetadata_clientType = 'TEAMS_CLIENT') 
AND (report_identifiers_locusId IS NOT NULL)
AND (report_callingServiceType = 'LOCUS' OR report_callingServiceType IS NULL))AND ((stars_score IS NOT NULL) AND (surveytype = 'locus-post-meeting-survey'))))
AND ((stars_score <= 3))
LIMIT 100;]