Eight providers, one staging index: the rule that powers every game ID
A walk through how Evolution, JILI, PG SOFT and the rest of the studios line up under a single ID-keyed planner.
Eight providers power the YONO Arcade yonogamesarcade games. The staging index joins every lobby tile to its provider by the game_id field, then attaches a thumbnail and a kind label from the planner. Here is the rule that keeps the index clean.
The ID-keyed join
The planner stores one row per game, keyed on the game_id. yonogamesarcade games data carries the same game_id, the provider_name and the subject_uuid. The join is a simple inner join on game_id; rows that exist in yonogamesarcade games but not in the planner are flagged, and rows that exist in the planner but not in yonogamesarcade games are likewise flagged. Neither is silently dropped.
Why this matters
Provider counts change. Studios add titles, retire titles, sometimes split a single title into two variants. The staging index does not trust a count that comes from a marketing card - it counts the rows that survive the join. When the public count matches the staging count, the index is healthy.
The breakdown
Evolution contributes 373 titles, mostly live-dealer lobbies and First Person tables. JILI adds 231 arcade-games, wheel, fishing, dice and andar bahar titles. PG SOFT contributes 152 mobile slots. Fachai adds 75 Asian-themed slots and fishing games. Pragmatic Play contributes 70 slots and live-dealer tables. YellowBat adds 58 bingo titles. KOOLBET contributes 11 arcade-games titles. Originals rounds out yonogamesarcade games with three house-developed releases.
What an ID collision looks like
Two different providers can publish games with identical display names - Mines and 7up7down are common examples. The join does not care about display names. Each row has its own numeric ID, and the join keys on that. Two rows with the same name but different IDs survive the join as two distinct yonogamesarcade games entries.
What comes next
When a provider publishes a new title, the staging pipeline picks it up on the next capture and adds the row. When a provider retires a title, the row stays in the staging index - the detail page reflects the published status, the live state is owned by the install.
About this story. Sourced from the YONO Arcade Games staging index and verified against the public sponsor snapshot dated 2026-08-17. Editorial decisions and conclusions are our own; figures are not extrapolated beyond the snapshot.