Database Error

[22-Aug-2025 14:45:41 UTC] WordPress database error Column ‘bounce’ in field list is ambiguous for query SELECT COUNT(DISTINCT CASE WHEN bounce = 0 THEN statistics.uid END) as visitors, COALESCE( SUM( CASE WHEN bounce = 0 THEN 1 ELSE 0 END ), 0) as pageviews, COUNT( DISTINCT CASE WHEN bounce = 0 THEN statistics.session_id END ) as sessions, COALESCE( COUNT(DISTINCT CASE WHEN bounce = 0 AND statistics.first_time_visit = 1 THEN statistics.uid END),0) as first_time_visitors, COALESCE( AVG( CASE WHEN bounce = 0 THEN statistics.time_on_page END ), 0 ) as avg_time_on_page, ROUND(SUM(session_bounces.bounce) / COUNT(DISTINCT statistics.session_id) * 100, 2) as bounce_rate FROM wpaa_burst_statistics AS statistics LEFT JOIN (

                                      SELECT 

                                        session_id,

                                        CASE WHEN COUNT(*) = 1 THEN 1 ELSE 0 END AS bounce

                                      FROM wpaa_burst_statistics

                                      WHERE time > 1755723601 AND time < 1755810000

                                      GROUP BY session_id

                                    ) AS session_bounces ON statistics.session_id = session_bounces.session_id  WHERE statistics.time > 1755723601 AND statistics.time < 1755810000      made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, Burst\Admin\App\App->get_data, Burst\Admin\Statistics\Statistics->get_compare_data, Burst\Admin\Statistics\Statistics->get_base_data, Burst\Admin\Statistics\Statistics->execute_data_query, Burst\Admin\Statistics\Statistics->get_data