Skip to content

Instantly share code, notes, and snippets.

View estiens's full-sized avatar
💭
increasing technical debt

Eric Stiens estiens

💭
increasing technical debt
View GitHub Profile
@estiens
estiens / bandwagon_guide.md
Last active June 14, 2026 03:21
The Bandwagon Almanac: A Cheeky, Mostly-Affectionate Guide to Adopting a Second Team at the 2026 Men's World Cup

The Bandwagon Almanac

A Cheeky, Mostly-Affectionate Guide to Adopting a Second Team at the 2026 Men's World Cup

So your country didn't qualify, or your country qualified and you've already made peace with the heartbreak coming in the Round of 32, or you simply contain enough love for two. Good. This is the first 48-team World Cup, hosted across the US, Canada, and Mexico — FIFA crammed in sixteen extra teams since last time, so if this guide runs a little long, take it up with them, not me.

And if it seems like an unusual number of entries contain the phrase "miracle qualifier" or "first time in history" — well, yes. More teams means more history being made, which is lovely, and it also means more broadcast markets and more licensing fees, which is the actual reason. FIFA is the most corrupt governing body in professional sport and everyone knows it, including FIFA, who have simply decided that's fine.

A few ground rules. Adopting a team is not a marriage; it's a summer fling with a flag. You are al

@estiens
estiens / keybase.md
Created October 13, 2017 01:44
keybase proof

Keybase proof

I hereby claim:

  • I am estiens on github.
  • I am estiens (https://keybase.io/estiens) on keybase.
  • I have a public key ASA_2jFesdWj21LwoMjHfpFnM8j8tZREqQWfLLUmerg3fgo

To claim this, I am signing this object:

Keybase proof

I hereby claim:

  • I am estiens on github.
  • I am estiens (https://keybase.io/estiens) on keybase.
  • I have a public key whose fingerprint is FB56 72FA B9C8 775A 4068 70EA 63D2 0395 675F 8549

To claim this, I am signing this object:

*client.rb#loyalty_points*
SELECT Points, TimeStamp, RewardType, RewardTypeID, tblClientRewards.ExpirationDate, tblClientRewards.Returned, Clients.FirstName, Clients.LastName, Clients.ClientID, [Sales].SaleID, [VISIT DATA].ClassID, [VISIT DATA].ClassDate, NULL AS PurchaseID
FROM tblClientRewards
LEFT OUTER JOIN Clients
ON Clients.ClientID = tblClientRewards.RewardTypeID
AND tblClientRewards.RewardType = 'Referral'
LEFT OUTER JOIN [Sales]
ON [Sales].SaleID = tblClientRewards.RewardTypeID