SELECT p.*, s.current_close
        FROM wp_prediction_results p
        LEFT JOIN wp_stock_daily_update s
        ON p.uid COLLATE utf8mb4_general_ci = s.uid_d COLLATE utf8mb4_general_ci
        WHERE p.stock_status = 'active'
        AND p.plan_status != 'free'
        AND p.created_at >= '2026-04-12'
        AND p.created_at <= '2026-04-18 23:59:59'