Current candidates

clues.py

from sqlite3 import connect

db = connect('All Sets-2011-05-06.db')

# get a list of cards that have been in a core set
corecards = set([x[0] for x in db.execute("SELECT name FROM published WHERE expansion IN ('A', 'B', 'U', 'RV', '4E', '5E', '6E', '7E', '8ED', '9ED', '10E', 'M10', 'M11')")])

# get a list of cards from sets that maro worked on but didn't lead
maros = set([x[0] for x in db.execute("SELECT name FROM published WHERE expansion IN ('ST', 'EX', 'US', 'UL', 'MM', 'NE', 'PY', 'IN', 'PS', 'AP', 'TOR', 'JUD', 'DST', 'CHK', 'DIS', 'TSP', 'PLC', 'LRW', 'MOR', 'ALA', 'WWK', 'CSP')")])

# get a list of the "A" and "F" cards
af = set([x[0] for x in db.execute("SELECT name FROM published WHERE name LIKE '%A%' OR name LIKE '%F%' COLLATE NOCASE")])

candidates = list(maros - (af|corecards))

candidates.sort()

for x in candidates:
    print x

clues.txt

maro254 :

I have a Magic 2012 Twitter preview this Wednesday. It's the card Tom LaPille called "the most important reprint to Standard in Magic 2012".

Everyone seems to think it's Island. (Apparently I'm the Loki of Magic.) No, the card is a card that has never been in a core set before.

Clue #1: I was not the lead designer of the set the card first appeared in, but I was on the design team.

Clue #2: The initials of the man who's had jobs held by Buehler, Schneider & Johns do not appear in the name of the card.

maybe.txt

Belbe's Percher
Benthicore
Bewilder
Bind
Bitterblossom
Blightning
Blightsoil Druid
Blind Seer
Blinding Light
Blinkmoth Nexus
Blister Beetle
Blood Crypt
Blood Cultist
Blood Hound
Blood Knight
Blood Rites
Bloodthirsty Ogre
Blurred Mongoose
Body Double
Bog Down
Bog Hoodlums
Bog Serpent
Bog Smugglers
Bog Witch
Bone Shredder
Bone Splinters
Bonesplitter Sliver
Book Burning
Boom
Boom // Bust
Bottomless Pit
Bouncing Beebles
Bound
Bound // Determined
Breeding Pool
Bronze Bombshell
Bull Cerodon
Bull Rush
Bullwhip
Burgeoning
Burning Wish
Bust
Cenn's Heir
Chill to the Bone
Chimeric Egg
Churning Eddy
Clockspinning
Cloud Cover
Cloud Spirit
Cloudthresher
Coiling Woodworm
Comet Storm
Compulsion
Consume Strength
Consuming Vortex
Contempt
Controvert
Conviction
Convulsing Licid
Copper Gnomes
Corpse Connoisseur
Corpulent Corpse
Corrupted Zendikon
Corrupting Licid
Countryside Crusher
Credit Voucher
Crime
Crime // Punishment
Crosis, the Purger
Crosswinds
Cruel Deceiver
Crumbling Necropolis
Crusher Zendikon
Cunning
Cunning Wish
Cursed Ronin
Customs Depot
Cut the Tethers
Deepwood Drummer
Deepwood Elder
Deepwood Wolverine
Delirium Skeins
Deliver
Demon's Jester
Demonic Collusion
Desert
Despondency
Destructive Urge
Determined
Detritivore
Development
Devouring Greed
Devouring Strossus
Devout Witness
Dewdrop Spy
Dispel
Disperse
Disrupt
Disruptive Student
Divine Light
Divine Presence
Divining Witch
Do or Die
Douse
Dredge
Drelnoch
Drill-Skimmer
Drooling Ogre
Dross Golem
Drumhunter
Dueling Grounds
Duskrider Peregrine
Dust Bowl
Echoing Ruin
Echoing Truth
Eerie Procession
Electryte
Elven Rite
Elvish Eulogist
Elvish Herder
Ember Shot
Endless Wurm
Endoskeleton
Ends
Entropic Eidolon
Entropic Specter
Envelop
Ephemeron
Epic Proportions
Epic Struggle
Erithizon
Eron the Relentless
Error
Essence Sliver
Etherium Sculptor
Exclude
Exhume
Exotic Curse
Explore
Explosive Growth
Expunge
Extortion
Eyeblight's Ending
Gemhide Sliver
Gemini Engine
Gemstone Mine
Genesis
Geth's Grimoire
Ghitu Slinger
Ghostly Prison
Ghostly Wings
Gliding Licid
Glory
Goblin Medics
Goblin Rimerunner
Goblin Roughrider
Goblin Skycutter
Goblin Spy
Goblin Trenches
Goblin Welder
Godsire
Godtoucher
Golden Wish
Gone
Gorgon Recluse
Govern the Guildless
Greenseeker
Grim Monolith
Gristle Grinner
Grollub
Grotesque Hybrid
Groundswell
Guided Strike
Guile
Gurzigost
Gush
Gutless Ghoul
Gutwrencher Oni
He Who Hungers
Hedge Troll
Hedron Rover
Helium Squirter
Hell's Thunder
Hellkite Overlord
Hermetic Study
Hermit Druid
Heroes Remembered
Heroes' Reunion
Hickory Woodlot
Hidden Gibbons
Hidden Herd
Hidden Spider
Hide
Hide // Seek
Hinder
Hindering Light
Hit
Hit // Run
Hivestone
Hobble
Hold the Line
Hoodwink
Horizon Seed
Hostility
Howltooth Hollow
Humble
Hunt Down
Hunting Grounds
Hunting Wilds
Hurly-Burly
Hush
Hydromorph Gull
Hypergenesis
Hypnotic Cloud
Hypnox
Ice
Ichorid
Idyllic Tutor
Ignite Memories
Ignoble Soldier
Illusion
Implode
Indentured Djinn
Indrik Stomphowler
Ingot Chewer
Ink Dissolver
Insist
Insolence
Inspired Sprite
Intervene
Into the North
Invincible Hymn
Iron Will
Ironshell Beetle
Ixidron
Jester's Scepter
Jeweled Torque
Jilt
Jinxed Ring
Jokulmorder
Jotun Grunt
Jotun Owl Keeper
Journeyer's Kite
Joyous Respite
Jungle Shrine
Junkyo Bell
Kederekt Creeper
Keen Sense
Keldon Necropolis
Keldon Twilight
Kher Keep
Kill Switch
Kill-Suit Cultist
Kitsune Diviner
Kitsune Mystic
Knucklebone Witch
Kor Dirge
Kuro, Pitlord
Kyren Glider
Kyren Sniper
Kyren Toy
Ley Line
Lich's Mirror
Lich's Tomb
Lightbringer
Lightning Hounds
Lightning Serpent
Lightning Storm
Lightning Surge
Limited Resources
Living End
Living Wish
Lobotomy
Lodestone Golem
Looter il-Kor
Lost in Thought
Lotus Bloom
Lotus Blossom
Lull
Lunge
Lurking Evil
Lurking Skirge
Lush Growth
Meloku the Clouded Mirror
Meltdown
Memory Erosion
Mephitic Ooze
Merieke Ri Berit
Merrow Commerce
Merrow Reejerey
Merrow Witsniper
Meteor Storm
Metrognome
Midsummer Revel
Might Sliver
Mighty Emergence
Mind Peel
Mind Swords
Mindlock Orb
Mire's Toll
Mirozel
Mirri the Cursed
Mirrodin's Core
Mirror Entity
Misdirection
Misstep
Mistbind Clique
Mob Justice
Mogg Bombers
Molder
Monstrous Hound
Moonglove Winnower
Moonring Mirror
Morgue Thrull
Morningtide
Morphling
Mossdog
Mosstodon
Mosswort Bridge
Mourning
Mournwhelk
Muck Drubb
Mudbutton Torchrunner
Mulch
Murderous Spoils
Murmuring Bosk
Muse Vessel
Muzzle
Mycologist
Mycoloth
Myr Moonvessel
Mystic Melting
Necrogenesis
Necrotic Sliver
Needle Drop
Nesting Wurm
Nether Spirit
Nettlevine Blight
Nettling Curse
Neurok Prodigy
Nezumi Ronin
Night
Nightcreep
Nightwind Glider
Nihilistic Glee
Nine-Ringed Bo
No Mercy
Notorious Throng
Nourish
Null Brooch
Oblivion Ring
Odds
Odds // Ends
Oni Possession
Onyx Goblet
Opt
Order
Ore Gorger
Orim's Cure
Orim's Thunder
Orim's Touch
Otherworldly Journey
Outrider en-Kor
Overrule
Ovinize
Oxidize
Peer Through Depths
Peppersmoke
Pernicious Deed
Pestermite
Phthisis
Pilgrim's Eye
Pincer Spider
Pinecrest Ridge
Pious Kitsune
Pit Keeper
Plover Knights
Plunder
Pollen Remedy
Polluted Mire
Porphyry Nodes
Port Inspector
Portcullis
Poultice Sliver
Pouncing Wurm
Probe
Prohibit
Prophetic Bolt
Protective Bubble
Protective Sphere
Provoke
Psionic Sliver
Psychic Possession
Psychic Puppetry
Psychotic Episode
Pteron Ghost
Pull Under
Pulling Teeth
Pulmonic Sliver
Pulverize
Punishment
Puppet Conjurer
Puppet's Verdict
Pure
Pure // Simple
Purge
Purging Scythe
Purity
Putrid Imp
Pygmy Troll
Pyre Zombie
Quicksilver Behemoth
Quiet Purity
Quietus Spike
Quilled Sliver
Quirion Elves
Quirion Explorer
Quirion Sentinel
Reborn Hero
Rebound
Rebuild
Rebuking Ceremony
Reckless Ogre
Reckless Spite
Reckless Wurm
Reclusive Wight
Recoil
Redeem the Lost
Remote Isle
Rend Spirit
Renounce
Repulse
Rescind
Resize
Resounding Silence
Resounding Thunder
Restock
Retether
Return to Dust
Revered Elder
Reverent Silence
Rhys the Exiled
Ridged Kusite
Ringskipper
Riot Spikes
Rise
Rith's Grove
Roiling Horror
Ronom Hulk
Ronom Serpent
Ronom Unicorn
Root Greevil
Rootrunner
Rough
Rough // Tumble
Rouse
Rout
Ruby Leech
Ruin Ghost
Rumbling Crescendo
Run
Rupture
Rushing River
Rushwood Grove
Rusting Golem
Scourge Devil
Scouting Trek
Screeching Sliver
Scrib Nibblers
Scrivener
Scrounge
Scrying Sheets
Secluded Glen
Second Sight
Sedge Sliver
Seedtime
Seek
Seer's Vision
Sejiri Steppe
Selective Memory
Sensei's Divining Top
Serendib Sorcerer
Serene Sunset
Serpent Skin
Serum Powder
Seton's Scout
Shelldock Isle
Shimmering Grotto
Shinewend
Shrieking Mogg
Shriveling Rot
Shrouded Lore
Sicken
Sideswipe
Sidewinder Sliver
Sigil Blessing
Silk Net
Silkwing Scout
Silver Wyvern
Silvergill Douser
Simic Signet
Simoon
Simple
Sinew Sliver
Singe
Sinister Strength
Sivvi's Ruse
Skeletonize
Skill Borrower
Skittering Monstrosity
Skittering Skirge
Skizzik
Skred
Skulking Knight
Skullmulcher
Skullscorch
Skyscribing
Skyshroud Behemoth
Skyshroud Blessing
Skyshroud Cutter
Skyshroud Elite
Skyshroud Sentinel
Skyshroud Troopers
Sleeper's Guile
Sleeper's Robe
Sleeping Potion
Slingshot Goblin
Slinking Serpent
Sliptide Serpent
Slithermuse
Sliver Queen
Slow Motion
Sluggishness
Smite
Smoldering Spires
Smother
Somnophore
Songstitcher
Sonic Burst
Sonic Seizure
Soul Burn
Soul Collector
Soul Link
Soul Scourge
Soul Sculptor
Soul Spike
Soul's Might
Soulgorger Orgg
Soulscour
Soulsworn Jury
Specter's Shroud
Spell Burst
Spell Contortion
Spell Snip
Spellbinder
Spellshock
Spellstutter Sprite
Sphinx Sovereign
Spike Breeder
Spike Colony
Spike Rogue
Spike Soldier
Spike Tiller
Spike Worker
Spincrusher
Spined Sliver
Spinerock Knoll
Spinneret Sliver
Spire Golem
Spire Owl
Spirit Loop
Spirit en-Kor
Spiritmonger
Spite
Spitebellows
Spitting Sliver
Spitting Slug
Sporogenesis
Sprite Noble
Sprout
Squee's Revenge
Squeeze
Squelch
Squire
Stenchskipper
Sterling Grove
Stern Judge
Stern Proctor
Stingmoggie
Stingscourger
Stir the Pride
Stirring Wildwood
Stitch Together
Stormbind
Stormcloud Djinn
Strength in Numbers
Stronghold Biologist
Stronghold Overseer
Stronghold Zeppelin
Submerge
Subversion
Sudden Shock
Sudden Spoiling
Sudden Strength
Summon the School
Sun's Bounty
Sunder
Sunrise Sovereign
Sunscour
Sunseed Nurturer
Supply
Suppress
Surestrike Trident
Surging Might
Surging Sentinels
Surprise Deployment
Sutured Ghoul
Swelter
Swerve
Swirl the Mists
Sygg, River Guide
Symbiosis
Symbiotic Deployment
Synchronous Sliver
Tectonic Edge
Tek
Telekinetic Bonds
Telekinetic Sliver
Temper
Tempting Licid
Tethered Skirge
Tezzeret the Seeker
Thelonite Hermit
Thermopod
Thick-Skinned Goblin
Thieving Sprite
Think Twice
Thorntooth Witch
Thought Dissector
Thoughtbind
Thoughtseize
Thrive
Thrumming Stone
Thunder Totem
Ticking Gnomes
Tidehollow Sculler
Tidehollow Strix
Timber Protector
Timebender
Tinker
Tomb Hex
Tonic Peddler
Topple
Torch Song
Torchling
Torment
Tormod's Crypt
Tortured Existence
Toxic Stench
Trench Wurm
Tresserhorn Sinks
Tresserhorn Skyknight
Trickbind
Trinisphere
Tumble
Tunneler Wurm
Twinstrike
Umbilicus
Undermine
Unhinge
Unnerve
Urborg Skeleton
Urborg Uprising
Uyo, Silent Prophet
Vebulid
Vectis Silencers
Veiled Crocodile
Veiled Sentry
Veiled Serpent
Veiling Oddity
Vein Drinker
Vendilion Clique
Venomous Vines
Venser's Sliver
Vesper Ghoul
Vex
Vexing Sphinx
Victimize
Vigor
Vile Consumption
Vile Requiem
Violent Eruption
Viscid Lemures
Viseling
Vision Skeins
Vivid Creek
Vivid Grove
Void
Voidslime
Vorosh, the Hunter
Welkin Guide
Whetstone
Whip Silk
Whirlpool Rider
Whirlpool Whelm
Whirlwind
Wild Dogs
Wild Ricochet
Willbender
Wind Zendikon
Windbrisk Heights
Winding Wurm
Winnow
Wishmonger
Wit's End
Witch Engine
Witch Hunter
Withered Wretch
Wizened Cenn
Wonder
Woodripper
Workhorse
Worldly Counsel
Worn Powerstone
Zephid
Zephyr Net
Zo-Zu the Punisher
Zombie Musher