Let me gather all the data I need simultaneously - first resolving the archetype and card IDs!
The Emrakul search returned "Hand of Emrakul" — I need to search for the right one. Let me fix that and run all the winrate correlation queries in parallel!
Let me fix the SQL syntax and run all queries properly:
The matches are returning but wins/losses are all 0 — the result field might not be 'W'/'L'. Let me check what values the result field actually holds:
Got it — WIN/LOSS/DRAW. Now let me re-run all 5 queries correctly in parallel:
Here's the full breakdown for Broodscale over the last 8 weeks (mirror matches excluded):
| Copies | W | L | WR% | Matches |
|---|---|---|---|---|
| 0 | 922 | 856 | 51.9% | 1,838 |
| 1 | 21 | 24 | 46.7% | 45 |
| 2 | 769 | 565 | 57.6% | 1,372 |
| 3 | 423 | 285 | 59.7% | 734 |
| 4 | 166 | 145 | 53.4% | 316 |
📈 Clear positive correlation at 2–3 copies (57–60% WR vs 52% baseline). The 1-copy builds underperform badly (46.7%), likely awkward one-ofs. 4 copies dips back down to 53.4%, suggesting 2–3 is the sweet spot.
| Copies | W | L | WR% | Matches |
|---|---|---|---|---|
| 1 | 10 | 11 | 47.6% | 22 |
| 2 | 124 | 150 | 45.3% | 280 |
| 3 | 1,096 | 949 | 53.6% | 2,117 |
| 4 | 1,071 | 765 | 58.3% | 1,886 |
📈 Strong positive correlation — more Emrakuls = better results. 4-copy builds hit 58.3% vs only 45.3% for 2-copy builds. The 3 copies standard (from archetype overview) seems to leave performance on the table!
| Copies | W | L | WR% | Matches |
|---|---|---|---|---|
| 0 | 2,300 | 1,869 | 55.2% | 4,297 |
| 1–2 | 1 | 6 | ~14% | 8 |
⛔ Marginal data — only 8 matches with any Thief of Existence in Broodscale. This card is almost entirely absent from the archetype. No meaningful correlation can be drawn.
| Copies | W | L | WR% | Matches |
|---|---|---|---|---|
| 0 | 330 | 308 | 51.7% | 654 |
| 1 | 1,808 | 1,424 | 55.9% | 3,337 |
| 2 | 163 | 143 | 53.3% | 314 |
📈 Mild positive signal — 1-copy builds outperform non-Caverns builds (+4.2 pp). 2-copy lists see diminishing returns. The 1-of inclusion looks correct.
| Configuration | W | L | WR% | Matches |
|---|---|---|---|---|
| Without Talisman | 1,925 | 1,622 | 54.3% | 3,660 |
| With Talisman | 376 | 253 | 59.8% | 645 |
📈 Strongest signal of all — Talisman of Resilience builds show a +5.5 pp winrate advantage (59.8% vs 54.3%), across a solid 645-match sample. This is a meaningful correlation worth investigating.
| Card | Verdict |
|---|---|
| Devourer of Destiny | ✅ 2–3 copies optimal |
| Emrakul, the Promised End | ✅ More is better; 4 is best |
| Thief of Existence | ❌ Too rare to evaluate |
| Gemstone Caverns | ✅ 1-of inclusion adds value |
| Talisman of Resilience | ✅ Strongest positive signal |
⚠️ Correlation ≠ causation — better players may gravitate toward certain builds, inflating results.
Sources: 132 tournaments (62% MTGO, 38% Melee) — Modern Challenge 96 · Modern Challenge 64 · ACUP Clasificatorio Arcanis