Affinity Maindeck Configuration Performance Comparison

I'll analyze the different Affinity configurations over the last 4 weeks. Let me start by getting the card IDs and Affinity archetype info.

Let me search for "Weaponize the Monsters" more directly and query the database for the performance splits:

Let me search for the correct card name and check what's in the database:

Perfect! Now let me rerun the analysis with the correct card ID:

Now let me get matchup data for the top two configurations (Both MB and Rebuke only):

Let me adjust the query to check matchup data properly:

Let me check if match data exists for Affinity entries:

Good, match data exists. Let me fix the matchup query:

Let me lower the threshold and check what matchups we have:

Let me check if there's an issue with the match data structure:

I see - results are "WIN", "LOSS", "DRAW" not 'W', 'L', 'D'. Let me fix the matchup query:

Perfect! Now let me calculate confidence intervals for the overall winrates. For a 95% confidence interval with binomial proportion, I'll use Wilson score interval:

The Wilson score confidence interval calculation isn't working correctly in SQLite. Let me use a simpler approach with standard error: