#36

        SELECT s3_uri
          FROM cmxi_prediction_artifacts
         WHERE fixture_id = :fid AND run_kind = :rk
         LIMIT 1
    

        WITH posted AS (
            SELECT player_ids, captain_id, vc_id
              FROM cmxi_squads
             WHERE match_id = :fid
               AND is_post_toss = :ipt
               AND mode = 'GL'
               AND team_number = 1
             LIMIT 1
        )
        SELECT SUM(
            COALESCE(pr.actual_pts, 0) * CASE
                WHEN pr.player_id::int = posted.captain_id THEN 2.0
                WHEN pr.player_id::int = posted.vc_id      THEN 1.5
                ELSE 1.0
            END
        )::numeric(10, 2) AS actual
          FROM posted
          JOIN cmxi_prediction_player_rows pr
            ON pr.fixture_id = :fid
           AND pr.run_kind = :rk
           AND pr.player_id::int = ANY(posted.player_ids)
    

        SELECT best_squad_number, best_squad_mode
          FROM cmxi_validation_runs
         WHERE fixture_id = :fid AND run_kind = 'posttoss'
         ORDER BY run_at DESC
         LIMIT 1
    

        SELECT captain_actual_pts
          FROM cmxi_validation_runs
         WHERE fixture_id = :fid AND run_kind = 'posttoss'
         ORDER BY run_at DESC
         LIMIT 1
    

        SELECT top11_recall
          FROM cmxi_validation_runs
         WHERE fixture_id = :fid AND run_kind = 'posttoss'
         ORDER BY run_at DESC
         LIMIT 1
    

SELECT players_count FROM cmxi_prediction_artifacts WHERE fixture_id = :fid AND run_kind = :rk LIMIT 1

        SELECT s3_uri
          FROM cmxi_prediction_artifacts
         WHERE fixture_id = :fid AND run_kind = :rk
         LIMIT 1