Modern Challenge Deck Match Records Query

To get full match records for a specific deck in a Modern challenge, you would use the query_database() tool with a SQL query that joins the relevant tables. Here's how:

Approach

1. Identify the tournament - You'll need the tournament ID or name
2. Find the deck entry - Use player name or archetype to locate the specific entry
3. Query the matches - Join matches, tournament_entries, and archetypes tables

Example SQL Query

SELECT 
    t.name as tournament_name,
    t.date,
    p.handle as player,
    a.name as archetype,
    te.wins,
    te.losses,
    te.draws,
    te.rank,
    m.result,
    m.mirror,
    opp_a.name as opponent_archetype,
    opp_p.handle as opponent
FROM tournament_entries te
JOIN tournaments t ON te.tournament_id = t.id
JOIN players p ON te.player_id = p.id
JOIN archetypes a ON te.archetype_id = a.id
JOIN matches m ON te.id = m.entry_id
JOIN tournament_entries opp_te ON m.opponent_entry_id = opp_te.id
JOIN archetypes opp_a ON opp_te.archetype_id = opp_a.id
JOIN players opp_p ON opp_te.player_id = opp_p.id
WHERE t.name LIKE '%Modern Challenge%'
  AND t.date >= '2025-10-01'
  AND p.handle = 'PlayerName'
ORDER BY m.id

What You Can Get

• Match-by-match results (Win/Loss/Draw)
• Opponent archetypes for each round
• Mirror match indicators
• Final tournament standing (rank)
• Overall W/L/D record

Do you have a specific Modern Challenge or player in mind? I can pull the actual data for you if you provide:

• Tournament date or name
• Player name, OR
• Archetype (if you want all decks of that type)