SELECT s3_uri
FROM cmxi_prediction_artifacts
WHERE fixture_id = :fid AND run_kind = :rk
LIMIT 1
{"rk":"posttoss","fid":69646}cmxi_db
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)
{"rk":"posttoss","fid":69646,"ipt":true}cmxi_db
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
{"fid":69646}cmxi_db
SELECT captain_actual_pts
FROM cmxi_validation_runs
WHERE fixture_id = :fid AND run_kind = 'posttoss'
ORDER BY run_at DESC
LIMIT 1
{"fid":69646}cmxi_db
SELECT top11_recall
FROM cmxi_validation_runs
WHERE fixture_id = :fid AND run_kind = 'posttoss'
ORDER BY run_at DESC
LIMIT 1
{"fid":69646}cmxi_dbSELECT players_count FROM cmxi_prediction_artifacts WHERE fixture_id = :fid AND run_kind = :rk LIMIT 1
{"rk":"posttoss","fid":69646}cmxi_db
SELECT s3_uri
FROM cmxi_prediction_artifacts
WHERE fixture_id = :fid AND run_kind = :rk
LIMIT 1
{"rk":"posttoss","fid":69646}cmxi_db