I'll help you find Tron entries with no basic lands since September 1st. Let me start by getting the Modern format ID and then query for these specific entries.
Let me fix the SQL syntax - SQLite uses LIKE instead of ILIKE for case-insensitive matching:
Here are the 214 Tron entries with no basic lands since September 1st:
Recent Notable Performances:
• nv_goblin - 6-0-0 (Sept 27) - Modern Challenge 64
• Josep Sanfeliu - 8-2-0 (Pro Tour EOE, Sept 26)
• Javier Dominguez - 7-3-0 (Pro Tour EOE, Sept 26)
• NiHaoDyLan - 7-3-0 (Pro Tour EOE, Sept 26)
• Odin2015 - 6-0-0 (Sept 25) - Modern Challenge 64
• e0068 - 7-1-0 (Sept 13) - Modern Challenge 32
Sample of Recent Entries:
• Micro - 2025-10-06 - Modern Challenge 32 - 2-2-4 - https://www.mtgo.com/decklist/modern-challenge-32-2025-10-0612818152
• derlumberzack - 2025-10-06 - Modern Challenge 32 - 0-3-0 - https://www.mtgo.com/decklist/modern-challenge-32-2025-10-0612818152
• Odin2015 - 2025-09-30 - Modern Challenge 32 - 5-2-0 - https://www.mtgo.com/decklist/modern-challenge-32-2025-09-3012816575
• Daking3603 - 2025-09-29 - Modern Challenge 32 - 5-2-0 - https://www.mtgo.com/decklist/modern-challenge-32-2025-09-2912816558
Key Observations:
Sources:
Data from 89 tournaments: 85% MTGO, 15% Melee events including Pro Tour Edge of Eternities and various PTQs/paper tournaments.