CalloutIQbeta

Corrections

Where CalloutIQ has been wrong, and what changed — published for the same reason every result carries a source link.

A claim to hold the full record is only testable if the mistakes are visible alongside it. Two things on this site keep machine-readable evidence of being corrected, and both are below: every check run against the IFBB Pro League’s own published lists, and every time two records turned out to be one.

Checks against the IFBB Pro League’s own lists

CalloutIQ re-reads the league’s published qualified-athlete and points pages and compares them, name by name and point by point, against what’s stored here. Where the two disagree, the league’s version wins and the disagreement is recorded rather than quietly averaged away. 60 passes on file, 34 of which found something to resolve. Each opens to the account the pass itself wrote — not a summary of it, because a summary of an audit is a second thing you’d have to trust.

Oct 31, 2026 reconciliation-audit no differences
Fetched and diffed all 12 divisions on the 2027 points/qualified ladder (cache-miss confirmed) and the 2026 Olympia competitors roster (cache-miss confirmed). Zero over-inclusion, zero under-inclusion, zero points mismatches, former-champion set unchanged from 2026-10-29. Added 7 athlete_name_aliases rows resolving IFBB-page spelling variants (Cavanagh, Kongthun, Cisneros, Cardoso, Delgado, Theodoro, Jaatinen) per the Ledonida Ciobu precedent -- no full_name changes. Three mens-physique point totals (Jason Huynh, Marcus Benjamin-Privett, Andrea Mosti) read higher in our DB than on today's ladder page by exactly the points of a named, sourced show from the last 5-6 days that IFBB's own aggregate page has not yet caught up to; left as-is per "reconciliation layers, never replaces." fit-model's Aisha Mian remains correctly win_pending_approval (Kentucky Bourbon Pro, 2026-10-17), not yet on IFBB's page. 2026 competitors roster: every name already has a matching 2026 qualified=true standing under existing spellings; nothing to mirror in.
Oct 29, 2026 reconciliation-audit 1 item to resolve
Both sources fetched fresh (X-Litespeed-Cache: miss confirmed on both, no bot challenge). STEP 1: OPEN_YEAR 2027 ladder, all 12 divisions read by tablepress id and shape-checked, diffed programmatically (names, then points/status) against a fresh qualification_standings query (292 rows, up from 291 on 2026-10-27). Every division matched the page row-for-row: Mr Olympia 7/7, 212 10/10, Classic Physique 58/58, Men's Physique 62/62, Wheelchair 5/5, Ms Olympia 5/5, Fitness 2/2, Figure 12/12, Bikini 74/74, Women's Physique 4/4, Wellness 43/43. Fit Model 9/10 -- aisha-mian stays win_pending_approval, still absent from today's 9-name table, same unresolved lag as every run since 2026-10-21, not newly flagged. Men's Physique: 3 point-level differences, our value always ahead of IFBB's own republish, never behind, identical amounts to the 2026-10-27 run (jason-huynh +2, marcus-benjamin-privett +4, andrea-mosti +1) -- same unchanged lag, not a new miss; christian-ami (added 2026-10-27) now re-confirmed present on today's page at 1 point, matching our DB exactly. Bikini and Wellness matched exactly once resolved against the long-documented recurring spelling/formatting noise carried unrenamed since 2026-09-18/09-20 (reyna-perez-mecalco, lauralile-chapados/lauralie-chapados, nattaya-kongthun/nittaya-kongthun, lathryn-cavanagh/kathryn-cavanagh, roxana-cisneros/roxsana-cisneros, carolina-cardosa/carolina-cardoso, ledonida-ciobu/leonida-ciobu, chongyang-yu/chongyang-yuq, yiribeth-cantillo-roigoza/yiribeth-cantillo-raigoza, nivea-campos, julia-theodoro/juliatheodoro); classic-physique dong-oh-ryu/dong-o-ryu also re-confirmed, points match exactly (1). None renamed, none the unambiguous single-source typo the rename rule requires. Former-champion invariant re-derived fresh: samson-dauda, erin-banks (32pts) and lauralie-chapados (12pts) all still correctly former_champion -- asterisked with a bare points value or no points column, never literal "Qualified"; ashley-kaltwasser (14pts) and brandon-hendrickson (10pts) correctly remain former_champion_pending_approval, unchanged. RE-CONFIRMED CLOSED: classic-physique josh-bridgman holds zero standings rows of any season (2026-10-11 DQ correction stands). Zero over-inclusion, zero under-inclusion beyond the documented lags above. 1 manual review, re-confirmed still open: wellness danai-theodoropoulou -- today's ladder (3pts, matching our stored value) and today's competitors roster both read "Australia" while her sourced profile_source_url (2026 Tampa Pro, ifbbpro.com) reads "Greece" -- the same intra-ifbbpro.com disagreement flagged on every run 2026-09-20 through 2026-10-27, left as Greece pending an owner call. STEP 2: LOCKED_YEAR 2026 competitors roster -- 322 names across 12 divisions (22/21/47/51/10/10/10/31/46/16/40/18), identical to every run since 2026-10-01. All 322 matched to existing qualified=true 2026 standings (351 rows, unchanged since 2026-10-13) via exact name/known_as lookup plus the same documented recurring truncation/typo variants as every prior run (manuel-angelo, jhone-jhoninho, rodni-nelson-hebbert, dilson-espindola-silva, vinicius-mateus-viera-lima, reyna-perez-mecalco, sandra-colorado-acal, raeli-pereira-dias), each verified by direct lookup to the right division. Zero genuine new competitors, zero rows needing a fresh mirror; never-demote/never-remove both hold unchanged (351 qualified vs 322 rostered, 29 not rostered, left untouched). STEP 3: no new identity question surfaced; every disagreement found is the same already-judged recurring class, re-confirmed not re-opened. Zero fixes applied to qualification_standings/athletes/athlete_divisions/results this run.
Oct 27, 2026 reconciliation-audit 1 item to resolve
Both sources fetched fresh (X-Litespeed-Cache: miss confirmed on both, no bot challenge). STEP 1: OPEN_YEAR 2027 ladder, all 12 divisions read by tablepress id and shape-checked, diffed programmatically (names via normalized-letters match against full_name/known_as, then points/status) against a fresh qualification_standings query (291 rows, up from 287 on 2026-10-25). Win-based divisions and Wheelchair all matched exactly (Mr Olympia 7/7, 212 10/10, Ms Olympia 5/5, Fitness 2/2, Figure 12/12, Women's Physique 4/4, Wheelchair 5/5). Fit Model: aisha-mian stays win_pending_approval, still absent from today's table, same unresolved lag since 2026-10-21, not newly flagged. Classic Physique (58/58) and Wellness (43/43) now match exactly -- the 2026-10-25 "DB ahead" rows have all been republished by IFBB at the same values. Men's Physique (61 DB / 62 page): jason-huynh (+2, Musclecontest Vietnam Pro, unchanged lag since 2026-10-24) and two newly-traced "ahead" rows from the same 2026-10-25 20:09 UTC results-watch file (365 Grand Prix Pro) -- marcus-benjamin-privett (+4) and andrea-mosti (+1) -- all three our value ahead, never behind, same documented class, not touched. ADDED: christian-ami (Germany), genuinely new to the page, 1pt, Men's Physique -- no existing athlete row or alias under any spelling; new athlete row plus a 2027 standing mirroring IFBB's number exactly (rank 54, qualified=false). Bikini (74/74) and the remaining points divisions matched exactly once resolved against the long-documented recurring spelling/formatting noise re-confirmed unchanged since 2026-09-18/09-20 (reyna-perez-mecalco, lauralile-chapados/lauralie-chapados, nattaya-kongthun/nittaya-kongthun, lathryn-cavanagh/kathryn-cavanagh, roxana-cisneros/roxsana-cisneros, carolina-cardosa/carolina-cardoso, ledonida-ciobu/leonida-ciobu, chongyang-yu/chongyang-yuq, yiribeth-cantillo-roigoza/yiribeth-cantillo-raigoza, dong-oh-ryu/dong-o-ryu, valtteri-hemmo-aleksei-jaatinen/valtteri-jaatinen, mudbi-favors/sabur-favors, humberto-elias-castrillon-castrillon/humberto-elias-castrillon, vitor-alves-porto-de-oliveira/victor-alves-porto-de-oliveira) -- none renamed, none the unambiguous single-source typo the rename rule requires. Former-champion invariant re-derived fresh: samson-dauda, erin-banks (32pts) and lauralie-chapados (12pts) all still correctly former_champion -- asterisked with a bare points value or no points column, never literal "Qualified"; ashley-kaltwasser (14pts) and brandon-hendrickson (10pts) correctly remain former_champion_pending_approval, unchanged. RE-CONFIRMED CLOSED: classic-physique josh-bridgman holds zero standings rows of any season (2026-10-11 DQ correction stands). Zero over-inclusion. 1 manual review, re-confirmed still open: wellness danai-theodoropoulou -- today's ladder (3pts, matching our stored value) and today's competitors roster both read "Australia" while her sourced profile_source_url (2026 Tampa Pro, ifbbpro.com) reads "Greece" -- the same intra-ifbbpro.com disagreement flagged on every run 2026-09-20 through 2026-10-25, left as Greece pending an owner call. STEP 2: LOCKED_YEAR 2026 competitors roster -- 322 names across 12 divisions (22/21/47/51/10/10/10/31/46/16/40/18), identical to every run since 2026-10-01. Qualified=true totals for season_year=2026 confirmed unchanged at 351 across all 12 divisions, every per-division qualified count still >= today's roster count; per-division roster counts and standings totals identical to the fully name-matched 2026-10-25 pass, so no new mirror insert needed. Never-demote/never-remove both hold unchanged (351 qualified vs 322 rostered, 29 not rostered, left untouched). STEP 3: no new identity question surfaced; every disagreement found is the same already-judged recurring class, re-confirmed not re-opened. 1 fix applied (christian-ami added to Men's Physique) -- otherwise a clean reconciliation on both sources.
Oct 25, 2026 reconciliation-audit 1 item to resolve
Both sources fetched fresh (X-Litespeed-Cache: miss confirmed on both, no bot challenge). STEP 1: OPEN_YEAR 2027 ladder, all 12 divisions read by tablepress id and shape-checked, diffed programmatically (names, then points/status) against a fresh qualification_standings query (287 rows, up from 275 on 2026-10-23, from two 2026-10-24 calloutiq-results-watch files: Moscow Showdown Pro and Musclecontest Vietnam Pro). Win-based divisions and the full-ladder points divisions all matched exactly once resolved against the long-documented recurring spelling/formatting variants carried since 2026-09-18 (nivea-campos, julia-theodoro/juliatheodoro, chongyang-yu/"Chongyang Yuq", among others) -- none renamed, none is the unambiguous single-source typo the rename rule requires. 12 DB rows across classic-physique/mens-physique/wellness, plus 3 points/status differences (joshua-eng-cherng-shin auto_win flip, jason-huynh +2, angelica-franci +1), all trace individually to the two 2026-10-24 results-watch files for shows one day before this audit's fetch -- exactly the documented "CalloutIQ ahead of IFBB's own republish" lag this routine has traced and left alone on every weekend-adjacent run since 2026-10-19, our value always ahead, never behind, zero cases of a real miss. fit-model aisha-mian stays win_pending_approval, still absent from today's 8-name table, same unresolved lag as every run since 2026-10-21, not newly flagged. Former-champion invariant re-derived fresh: samson-dauda, erin-banks (32pts) and lauralie-chapados (12pts) all still correctly former_champion -- asterisked with a bare points value or no points column, never literal "Qualified"; ashley-kaltwasser (14pts) and brandon-hendrickson (10pts) correctly remain former_champion_pending_approval, unchanged. RE-CONFIRMED CLOSED: classic-physique josh-bridgman holds zero standings rows of any season (2026-10-11 DQ correction stands). Zero over-inclusion, zero under-inclusion beyond the documented lags above. 1 manual review, re-confirmed still open: wellness danai-theodoropoulou -- today's ladder (3pts, matching our stored value) and today's competitors roster both read "Australia" while her sourced profile_source_url (2026 Tampa Pro, ifbbpro.com) reads "Greece" -- the same intra-ifbbpro.com disagreement flagged on every run 2026-09-20 through 2026-10-23, left as Greece pending an owner call. STEP 2: LOCKED_YEAR 2026 competitors roster -- 322 names across 12 divisions (22/21/47/51/10/10/10/31/46/16/40/18), identical to every run since 2026-10-01. All 322 matched to existing qualified=true 2026 standings (351 rows, unchanged since 2026-10-13); the two initial non-matches (Eric Brown , Jr / Megan D'Ginto) resolved on direct lookup to eric-brown-jr / megan-d-ginto, already qualified in the right division -- punctuation formatting only. Zero genuine new competitors, zero rows needing a fresh mirror; never-demote/never-remove both hold unchanged (351 qualified vs 322 rostered, 29 not rostered, left untouched). STEP 3: no new identity question surfaced; every disagreement found is the same already-judged recurring class, re-confirmed not re-opened. Zero fixes applied to qualification_standings/athletes/athlete_divisions/results this run.
Oct 23, 2026 reconciliation-audit 1 item to resolve
Both sources fetched fresh (X-Litespeed-Cache: miss confirmed on both, no bot challenge). STEP 1: OPEN_YEAR 2027 ladder, all 12 divisions read by tablepress id and shape-checked, diffed programmatically against a fresh qualification_standings query. EXACT MATCH on every division once resolved against the long-documented recurring name variants and known_as pairs carried since 2026-09-18..10-21 (lauralie-chapados, reyna-perez-mecalco, nittaya-kongthun, kathryn-cavanagh, roxsana-cisneros, dong-o-ryu, nivea-campos, wu-bi, brianna-wilson, dani-cifuentes, jessica-liu, sung-uk-kim, micah-thomas-jr, junho-lee): mens-open 7/7, 212 10/10, classic-physique 51/51, mens-physique 57/57, wheelchair 5/5 (whole top-5 ranks 1-5 per its own rule), womens-bodybuilding 5/5, fitness 2/2, figure 12/12, bikini 74/74, womens-physique 4/4, wellness 39/39, fit-model 8 matched of 9 DB rows (aisha-mian stays win_pending_approval, still absent from today's 8-name table, same unresolved lag as 2026-10-21, not a new gap). Former-champion invariant re-derived fresh: samson-dauda, erin-banks (32pts) and lauralie-chapados (12pts) all still correctly former_champion -- each printed with the "*Olympia winner" career-history marker AND a bare points value, never literal "Qualified", so none is newly locked by this cycle; ashley-kaltwasser (14pts) and brandon-hendrickson (10pts) now also carry that same asterisk today but their QUALIFIED/POINTS cell is likewise still a bare number, so both correctly remain former_champion_pending_approval, unchanged. RE-CONFIRMED CLOSED: classic-physique josh-bridgman holds zero standings rows of any season (2026-10-11 DQ correction stands); chongyang-yu (Wellness) deliberately still "Chongyang Yuq" vs today's page "Chongyang Yu", points match exactly (4), same disagreement since 2026-10-05. Zero over-inclusion, zero under-inclusion beyond the documented win_pending_approval lag. 1 manual review, RE-OPENED this run: wellness danai-theodoropoulou -- today's ladder (3pts, matching our stored value) and today's competitors roster both read "Australia" while her sourced profile_source_url (2026 Tampa Pro, ifbbpro.com) reads "Greece" -- the same intra-ifbbpro.com disagreement flagged on every run 2026-09-20 through 2026-10-19; the 2026-10-21 file's notes did not mention her and logged manual_review_count=0 with no corresponding fix or resolution recorded, which reads as an omission in that run's writeup rather than a deliberate close, so this run restores it to manual_review_count rather than treating it as settled. Left as Greece pending an owner call. STEP 2: LOCKED_YEAR 2026 competitors roster -- 322 names across 12 divisions (22/21/47/51/10/10/10/31/46/16/40/18), identical to every run since 2026-10-01. All 322 matched to existing qualified=true 2026 standings (351 rows, unchanged since 2026-10-13); the handful of initial non-matches each resolved on individual lookup to an existing athlete already qualified in the right division/country under a documented truncation variant (manuel-angelo, jhone-jhoninho, rodni-nelson-hebbert, dilson-espindola-silva, vinicius-mateus-viera-lima, reyna-perez-mecalco, sandra-colorado-acal, raeli-pereira-dias). Zero genuine new competitors, zero rows needing a fresh mirror; never-demote/never-remove both hold unchanged (351 qualified vs 322 rostered, 29 not rostered, left untouched). STEP 3: no new identity question surfaced; every disagreement found is the same already-judged recurring class, re-confirmed not re-opened except the danai-theodoropoulou country item restored above. Zero fixes applied to qualification_standings/athletes/athlete_divisions/results this run.
Oct 21, 2026 reconciliation-audit no differences
Both sources fetched fresh (X-Litespeed-Cache: miss confirmed on both, no bot challenge). STEP 1: OPEN_YEAR 2027 ladder, all 12 divisions read by tablepress id and shape-checked, diffed programmatically against a fresh qualification_standings query. Fixed: (a) four win_pending_approval rows now confirmed by name on today's win-based roster tables, flipped to auto_win -- victor-alves-porto-de-oliveira and yinka-majolagbe (212), jeanne-kassel (figure), lilla-szabados (fit-model); aisha-mian (fit-model) still absent from today's 8-name table, left pending; (b) classic-physique daniel-fabode points corrected 8->9, the our-value-lower-than-IFBB direction that signals a real miss rather than the usual ahead-of-republish lag; (c) two unambiguous full_name completions to IFBB's own longer published form, not spelling disagreements -- womens-bodybuilding leyvina-barros -> "Leyvina Rodrigues Barros" (known_as kept as the short form), classic-physique valtteri-jaatinen -> "Valtteri Hemmo Aleksei Jaatinen" (points match exactly at 3, known_as already held the short form). Former-champion invariant re-derived fresh: lauralie-chapados (bikini, 12pts) and samson-dauda-class win-based champions stay correctly locked/unlocked; ashley-kaltwasser and brandon-hendrickson remain correctly former_champion_pending_approval (bare points value on today's page, never literal "Qualified"). Every other apparent difference (bikini lauralile-chapados/aimee-delgado/reyna-perez/nattaya-kongthun/lathryn-cavanagh/juliatheodoro/roxana-cisneros; wellness carolina-cardosa/ledonida-ciobu/yiribeth-cantillo-roigoza; classic-physique dong-oh-ryu/mudbi-favors) individually confirmed as the same recurring cosmetic IFBB-side spelling noise already resolved via an existing alias/known_as/merge or an already-matching points value -- not a gap, not a new identity question. Zero over-inclusion beyond the documented pending-method lag; zero under-inclusion. STEP 2: LOCKED_YEAR 2026 competitors roster -- page structure confirmed as 12 separate <table> elements, each with its own division heading row inside it; parsed all 12 (322 names: 22/21/47/51/10/10/10/31/46/16/40/18, matching the count every run since 2026-10-01). All 322 matched programmatically to existing season_year=2026 qualification_standings rows; the 14 initial non-matches each resolved on individual lookup to an existing athlete already qualified=true for 2026 in the right division under a longer/shorter name or a recurring spelling variant (vitor-alves-porto-de-oliveira, rodni-nelson-hebbert, dilson-espindola-silva, allison-kramer, camila-camila-rodrigues, nivea-campos, sandra-colorado-acal, raeli-pereira-dias, manuel-angelo, jhone-jhoninho). Zero genuine new competitors, zero rows needing a fresh mirror -- nothing applied for this step; never-demote/never-remove both hold unchanged. STEP 3: the two full_name completions above are the only changes; every other disagreement is the same already-judged cosmetic-noise class carried since at least 2026-09-20, re-confirmed not re-opened. No genuine identity question surfaced. manual_review_count=0.
Oct 19, 2026 reconciliation-audit 1 item to resolve
Both sources fetched fresh via curl with a unique cache-buster (X-Litespeed-Cache: miss confirmed on both, no bot challenge). STEP 1: OPEN_YEAR 2027 ladder, all 12 divisions read by tablepress id, diffed programmatically against a fresh DB query. DB now holds 275 2027 standings rows, up from 240 on every run 2026-10-13..10-17, because calloutiq-results-watch and a manually-transcribed Hurricane Pro scorecard applied seven new 2027-propagation files since the 10-17 audit (1 Bro Pro Show, Hurricane Pro x2, NZ Pro, Queen City Pro, Fitparade Pro, Kentucky Bourbon Pro, Musclecontest Brazil Pro 2, all dated 2026-10-17/18, already committed and applied before this audit ran). Every row-level difference against today's IFBB page traced individually and resolves to that same cause: 7 EXTRA rows carry qualification_method='win_pending_approval' (victor-alves-porto-de-oliveira/yinka-majolagbe in 212, jeanne-kassel in figure, aisha-mian/lilla-szabados in fit-model), none present anywhere on today's page -- exactly the lag win_pending_approval exists to cover (2026-08-02 migration), not an over-inclusion; ashley-kaltwasser/brandon-hendrickson confirmed still former_champion_pending_approval (bare points value, never literal "Qualified"). 24 further EXTRA rows are qualified=false points-only rows freshly layered by the same seven files for athletes with no prior 2027 standing. Every POINTS MISMATCH found (classic-physique/mens-physique/bikini/wellness) has our value strictly HIGHER than IFBB's by exactly the amount one of the seven files added (e.g. benquil-marigny mens-physique IFBB=7 ours=17 +10 Kentucky Bourbon Pro; alexander-toplyn mens-physique IFBB=15 ours=25 +10 Hurricane Pro CP/MP scorecard; kate-carroll bikini IFBB=1 ours=11 +10 NZ Pro) -- checked one by one, zero cases where our number is lower than IFBB's. roxana-marquez/viktoria-csicsayova (bikini) and andrea-mammoli/carolina-cardoso (classic-physique/wellness) show IFBB still printing an old points total because a second 2027 win this weekend already auto-qualified them off the ladder in our data before IFBB republished. Zero IFBB rows failed to match a DB row (no under-inclusion). Former-champion invariant re-derived fresh: samson-dauda/erin-banks(32pts)/lauralie-chapados(12pts) confirmed still published and asterisked, rank=NULL held for all three. RE-CONFIRMED CLOSED, not re-flagged: chongyang-yu (Wellness) deliberately still "Chongyang Yuq" despite today's page reading "Chongyang Yu", points match exactly (4); josh-bridgman holds zero qualification_standings rows of any season, consistent with the 2026-10-11 DQ correction. 1 manual review, pre-existing and independently re-confirmed today: wellness danai-theodoropoulou (today's ladder, 3pts matching our stored value, and today's competitors roster both read Australia while her sourced profile_source_url, the 2026 Tampa Pro competition page, reads Greece -- the same intra-ifbbpro.com disagreement flagged every run since 2026-09-20, left as Greece, still open for an owner call). STEP 2: LOCKED_YEAR 2026 competitors roster, 322 names across 12 divisions (22/21/47/51/10/10/10/31/46/16/40/18), identical to every run since 2026-10-01 -- the weekend's new 2027-season results did not touch any 2026 standing. All 322 matched programmatically to existing qualified=true 2026 standings (season_year=2026, 351 rows, unchanged since 2026-10-13) via exact slug plus the same documented recurring name/ring-name variants as every run since 2026-09-18/19. Zero unmatched, zero new athletes. Per never-remove, 351 qualified vs 322 rostered (29 not rostered) left untouched, unchanged since 2026-09-29. STEP 3: no new identity question; every disagreement found in Step 1 re-confirmed as the same already-judged "not an unambiguous single-source typo" class, not re-opened. A fully clean reconciliation on both sources this run -- every apparent difference traces to the documented, expected "CalloutIQ ahead of IFBB's own republish" lag already covered by already-committed files -- zero fixes needed to qualification_standings/athletes/athlete_divisions/results.
Oct 17, 2026 reconciliation-audit 1 item to resolve
Both sources fetched fresh via curl with a unique cache-buster (X-Litespeed-Cache: miss confirmed on both, no bot challenge). STEP 1: OPEN_YEAR 2027 ladder, all 12 divisions read by tablepress id, diffed programmatically against a fresh DB query (240 rows, unchanged since 2026-10-13). EXACT MATCH on every division, including full row and rank order: 7 win-based divisions (Mr Olympia 7/7, 212 8/8, Ms Olympia 5/5, Fitness 2/2, Figure 11/11, Fit Model 7/7, Women's Physique 4/4), Wheelchair (5/5, whole top-5 numbering 1-5 sequentially per its own rule), and the 4 full-ladder points divisions Classic Physique (42/42)/Men's Physique (52/52)/Bikini (60/60)/Wellness (37/37) matched on every row's points and rank order once resolved against the long-documented recurring name variants carried unrenamed since 2026-09-20..10-15 (Lauralile Chapados=lauralie-chapados; Reyna Perez=reyna-perez-mecalco; Leyvina Rodrigues Barros=leyvina-barros; Ledonida Ciobu=leonida-ciobu; Yiribeth Cantillo Roigoza=yiribeth-cantillo-raigoza; Carolina Cardosa=carolina-cardoso; Lathryn Cavanagh=kathryn-cavanagh; Roxana Cisneros=roxsana-cisneros; Dong Oh Ryu=dong-o-ryu; Nattaya Kongthun=nittaya-kongthun; Valtteri Hemmo Aleksei Jaatinen=valtteri-jaatinen; Humberto Elias Castrillon Castrillon=humberto-elias-castrillon; Aimee Delgado=aimee-leann-delgado) -- none renamed, none is the unambiguous single-source typo the rename rule requires. Former-champion invariant re-derived fresh: samson-dauda/erin-banks(32pts)/lauralie-chapados(12pts) confirmed still published and asterisked, rank=NULL correctly held for all three. ashley-kaltwasser/brandon-hendrickson now shown WITH an asterisk for the first time this routine has seen, but both still print a bare numeric points value (14/10, unchanged) rather than the literal "Qualified" text that actually triggers confirmation -- correctly stay former_champion_pending_approval, nothing flipped. RE-CONFIRMED CLOSED, not re-flagged: chongyang-yu (Wellness) deliberately still "Chongyang Yuq" despite today's page reading "Chongyang Yu", points match exactly (4); josh-bridgman holds zero qualification_standings rows of any season, consistent with the 2026-10-11 DQ correction. STEP 2: LOCKED_YEAR 2026 competitors roster, 322 names across 12 divisions (22/21/47/51/10/10/10/31/46/16/40/18), identical to every run since 2026-10-01. All 322 matched programmatically to existing qualified=true 2026 standings (season_year=2026, 351 rows, unchanged since 2026-10-13) via exact slug plus the same documented recurring name/ring-name variants as every run since 2026-09-18/19, plus today's own typo-level matches confirmed by direct lookup (Manual Angelo/manuel-angelo, Johne Jhoninho/jhone-jhoninho, Vincius Mateus Viera Lima/vinicius-mateus-viera-lima, Sanda Colorado Acal/sandra-colorado-acal, Vitor/Victor Alves Porto De Oliveira). Zero unmatched, zero new athletes. Per never-remove, 351 qualified vs 322 rostered (29 not rostered) left untouched, unchanged since 2026-09-29. STEP 3: no new identity question; every disagreement found in Step 1/2 re-confirmed as the same already-judged "not an unambiguous single-source typo" class, not re-opened. 1 manual review, pre-existing and independently re-confirmed today: wellness danai-theodoropoulou (today's ladder, 3pts matching our stored value, and today's competitors roster both read Australia while her sourced profile_source_url, the 2026 Tampa Pro competition page, reads Greece -- the same intra-ifbbpro.com disagreement flagged every run since 2026-09-20, left as Greece, still open for an owner call). A fully clean reconciliation on both sources this run, identical in substance to 2026-10-13/10-15 -- zero fixes needed to qualification_standings/athletes/athlete_divisions/results.
Oct 15, 2026 reconciliation-audit 1 item to resolve
Both sources fetched fresh via curl with a unique cache-buster (X-Litespeed-Cache: miss confirmed on both, no bot challenge). STEP 1: OPEN_YEAR 2027 ladder, all 12 divisions read by tablepress id, diffed programmatically against a fresh DB query (240 rows, unchanged since 2026-10-13). EXACT MATCH on every division, including full row and rank order: 7 win-based divisions (Mr Olympia 7/7, 212 8/8, Ms Olympia 5/5, Fitness 2/2, Figure 11/11, Fit Model 7/7, Women's Physique 4/4), Wheelchair (5/5, whole top-5 numbering 1-5 sequentially per its own rule), and the 4 full-ladder points divisions Classic Physique (42/42)/Men's Physique (52/52)/Bikini (60/60)/Wellness (37/37) matched on every row's points and rank order once resolved against the long-documented recurring name variants carried unrenamed since 2026-09-20..10-13 (Lauralile Chapados=lauralie-chapados; Reyna Perez=reyna-perez-mecalco; Leyvina Rodrigues Barros=leyvina-barros; Ledonida Ciobu=leonida-ciobu; Yiribeth Cantillo Roigoza=yiribeth-cantillo-raigoza; Carolina Cardosa=carolina-cardoso; Lathryn Cavanagh=kathryn-cavanagh; Roxana Cisneros=roxsana-cisneros; Dong Oh Ryu=dong-o-ryu; Nattaya Kongthun=nittaya-kongthun; Valtteri Hemmo Aleksei Jaatinen=valtteri-jaatinen; Humberto Elias Castrillon Castrillon=humberto-elias-castrillon) -- none renamed, none is the unambiguous single-source typo the rename rule requires. Former-champion invariant re-derived fresh: samson-dauda/erin-banks(32pts)/lauralie-chapados confirmed still published and asterisked, rank=NULL correctly held for the two confirmed former champions; ashley-kaltwasser/brandon-hendrickson correctly still former_champion_pending_approval (bare points value, never literal "Qualified"). RE-CONFIRMED CLOSED, not re-flagged: classic-physique josh-bridgman holds zero qualification_standings rows of any season (direct query verified), consistent with the 2026-10-11 DQ correction; chongyang-yu (Wellness) deliberately still "Chongyang Yuq" despite today's page reading "Chongyang Yu", a continuing known disagreement since 2026-10-05; the Lauralile Chapados/"USA" row is the same IFBB-side source error on both name and country parked in athlete_name_aliases since 2026-09-27, our lauralie-chapados/Canada row correct and unchanged. STEP 2: LOCKED_YEAR 2026 competitors roster, 322 names across 12 divisions (22/21/47/51/10/10/10/31/46/16/40/18), identical to every run since 2026-10-01. All 322 matched programmatically to existing qualified=true 2026 standings (season_year=2026, 351 rows, unchanged since 2026-10-13) via exact slug plus the same documented recurring name-truncation variants as every run since 2026-09-18/19, plus one apostrophe-hyphenation parsing case (Megan D'Ginto -> megan-d-ginto) resolved directly, not a real spelling disagreement. Zero unmatched, zero new athletes. Per never-remove, 351 qualified vs 322 rostered (29 not rostered) left untouched, unchanged since 2026-09-29. STEP 3: no new identity question; every disagreement found in Step 1 re-confirmed as the same already-judged "not an unambiguous single-source typo" class, not re-opened. 1 manual review, pre-existing and independently re-confirmed today: wellness danai-theodoropoulou (today's ladder and today's competitors roster both read Australia while her sourced profile_source_url, the 2026 Tampa Pro competition page, reads Greece -- the same intra-ifbbpro.com disagreement flagged every run since 2026-09-20, left as Greece, still open for an owner call). A fully clean reconciliation on both sources this run, identical in substance to 2026-10-13 -- zero fixes needed to qualification_standings/athletes/athlete_divisions/results.
Oct 13, 2026 reconciliation-audit 1 item to resolve
Both sources fetched fresh via curl with a unique cache-buster (X-Litespeed-Cache: miss confirmed on both, no bot challenge). STEP 1: OPEN_YEAR 2027 ladder, all 12 divisions read by tablepress id, diffed against a fresh DB query (240 rows, up from 232 on 2026-10-11, already correctly reflected on both sides). EXACT MATCH on every division, including full row order: 7 win-based divisions (Mr Olympia 7/7, 212 8/8, Ms Olympia 5/5, Fitness 2/2, Figure 11/11, Fit Model 7/7, Women's Physique 4/4), Wheelchair (5/5, whole top-5 numbering 1-5 sequentially per its own rule), and the 4 full-ladder points divisions Classic Physique (42/42)/Men's Physique (52/52)/Bikini (60/60)/Wellness (37/37) matched on every row's points and rank order once resolved against the long-documented recurring name variants carried unrenamed since 2026-09-20..10-11 (Lauralile Chapados=lauralie-chapados; Reyna Perez=reyna-perez-mecalco; Leyvina Rodrigues Barros=leyvina-barros; Ledonida Ciobu=leonida-ciobu; Yiribeth Cantillo Roigoza=yiribeth-cantillo-raigoza; Carolina Cardosa=carolina-cardoso; Lathryn Cavanagh=kathryn-cavanagh; Roxana Cisneros=roxsana-cisneros; Dong Oh Ryu=dong-o-ryu; Nattaya Kongthun=nittaya-kongthun) -- none renamed, none is the unambiguous single-source typo the rename rule requires. The two tie-order/rank fixes applied 2026-10-11 (Classic Physique mahfuz-hawit/dominic-carter, simeon-kohlhepp/marvin-krajewski; Men's Physique brandon-hendrickson rank=9 cascade) re-verified against today's page order, still exact, no drift since. Former-champion invariant re-derived fresh: samson-dauda/erin-banks(32pts)/lauralie-chapados confirmed still published and asterisked; ashley-kaltwasser/brandon-hendrickson correctly still former_champion_pending_approval (bare points value, never literal "Qualified"). RESOLVED since 2026-10-11, noted not re-flagged: classic-physique josh-bridgman's AGP Pro All Stars result was corrected to disqualified=true on 2026-10-11 per IFBB's own results table printing DQ in the PLACE column -- explains his absence from the ladder as a real result change rather than an identity mix-up; his standings row is already removed; zero qualification_standings rows remain for him; closed. STEP 2: LOCKED_YEAR 2026 competitors roster, 322 names across 12 divisions (22/21/47/51/10/10/10/31/46/16/40/18), identical to every run since 2026-10-01. All 322 matched programmatically to existing qualified=true 2026 standings (season_year=2026, 351 rows) via exact slug plus the same 16 documented recurring name-truncation variants as every run since 2026-09-18/19. Zero unmatched, zero new athletes. Per never-remove, 351 qualified vs 322 rostered (29 not rostered) left untouched, unchanged since 2026-09-29. STEP 3: no new identity question; every disagreement found in Step 1 re-confirmed as the same already-judged "not an unambiguous single-source typo" class, not re-opened. 1 manual review, pre-existing and independently re-confirmed today: wellness danai-theodoropoulou (today's ladder and today's competitors roster both read Australia while her sourced profile_source_url, the 2026 Tampa Pro competition page, reads Greece -- the same intra-ifbbpro.com disagreement flagged every run since 2026-09-20, left as Greece, still open for an owner call). A fully clean reconciliation on both sources this run -- zero fixes needed to qualification_standings/athletes/athlete_divisions/results.
Oct 11, 2026 reconciliation-audit 1 item to resolve
Second run of the day, after the Oct 10-11 shows loaded. Both IFBB pages fetched fresh (X-Litespeed-Cache: miss, no bot challenge). STEP 1: 2027 ladder, all 12 divisions by tablepress id, diffed against a fresh query (241 rows); every points value matches. 4 fixes: michal-krizanek (mens-open) and dorethane-agathina (figure) win_pending_approval -> auto_win, both now listed by IFBB; two tie-order swaps to IFBB row order (mens-physique marcus-benjamin-privett/omar-suleiman at 4 pts, wellness fabiola-rios/sara-nieves-aguirre at 5 pts). emile-walker, kareen-haddad and phoebe-hagan confirmed printed Qualified. Former champions re-derived, unchanged. Earlier run today fixed two rank drifts (classic-physique tie order, brandon-hendrickson rank). STEP 2: 2026 competitors roster, 322 names, all resolve, nothing to mirror. Manual review 2, both carried and re-confirmed: josh-bridgman (classic-physique, 10 pts sourced, absent from IFBB ladder) and danai-theodoropoulou (country Australia vs Greece, IFBB vs IFBB). UPDATE same day: josh-bridgman CLOSED -- IFBB's AGP Pro All Stars page now prints him DQ; results corrected and his 10-point standing removed (2026-10-11_agp-pro-all-stars_classic-physique_bridgman-dq.sql). Classic Physique now 42/42 against IFBB. danai-theodoropoulou left as Greece on the owner's instruction; 1 item carried.
Oct 9, 2026 reconciliation-audit 2 items to resolve
Both sources fetched fresh via curl with a unique cache-buster (X-Litespeed-Cache: miss confirmed on both, no bot challenge). STEP 1: OPEN_YEAR 2027 ladder, all 12 divisions read by tablepress id, diffed programmatically against a fresh DB query. Exact match on all 12 divisions once resolved against the long-documented recurring name-format variants (order swaps, fuller/shorter legal names, likely IFBB-side typos) this routine has carried unrenamed since 2026-09-20..10-07 -- none renamed, none is the unambiguous single-source typo the rename rule requires. chongyang-yu left at "Chongyang Yuq" (deliberately set by the 2026-10-05 run) despite today's page reading "Chongyang Yu" -- a continuing known disagreement, not new. Former-champion invariant re-derived fresh: samson-dauda/erin-banks(32pts)/lauralie-chapados confirmed still published and asterisked; ashley-kaltwasser/brandon-hendrickson correctly still former_champion_pending_approval (bare points value, never literal "Qualified"). STEP 2: LOCKED_YEAR 2026 competitors roster, 322 names across 12 divisions (22/21/47/51/10/10/10/31/46/16/40/18), identical to every run since 2026-10-01. All 322 matched programmatically to existing qualified=true 2026 athletes via exact slug lookup plus the same documented variants as step 1 -- zero unmatched, zero new athletes. qualification_standings (season_year=2026, qualified=true) holds 351 rows, unchanged; 29 qualified-but-not-rostered rows left untouched per never-remove. STEP 3: no new identity question. 2 manual review, both pre-existing and independently re-confirmed today rather than assumed: classic-physique josh-bridgman (points=10, sourced 2026-09-26 AGP Pro All Stars win, still completely absent from today's ladder page, unchanged since 2026-10-03, left as-is pending an owner call on the suspected IFBB-side kai-wang mix-up); wellness danai-theodoropoulou (today's ladder again reads Australia while her sourced profile_source_url, the ifbbpro.com Tampa Pro competition page, reads Greece -- the same intra-ifbbpro.com disagreement flagged every run since 2026-09-20, left as Greece).
Oct 7, 2026 reconciliation-audit 2 items to resolve
Both sources fetched fresh (X-Litespeed-Cache: miss confirmed on both, no bot challenge). STEP 1: OPEN_YEAR 2027 ladder, all 12 divisions read by tablepress id, diffed against a fresh DB query. Former-champion invariant re-derived fresh: samson-dauda/erin-banks/lauralie-chapados confirmed still published and asterisked; ashley-kaltwasser/brandon-hendrickson correctly still former_champion_pending_approval (bare points value, never "Qualified" text). FIXED: erin-banks (mens-physique) points 22->32, matching her sourced 2026-10-04 Pharlabs Mexico Pro win the page has now caught up to. FIXED: 8 win_pending_approval->auto_win resolutions now that IFBB's page actually lists them -- radoslav-angelov/esteban-fuquene (212), kristina-zafirova (figure), misty-yang (fit-model), tonio-burton/andrea-presti (mens-open), dallas-botchway (mens-physique, reversing the 2026-10-05 run's auto_win->win_pending_approval flip), patti-hanson (womens-bodybuilding). RESOLVED manual-review item: bikini gulsah-gorgulu, absent from the ladder since 2026-09-20, now appears in the 2-point tier -- assigned rank 37 per page order, shifted christina-yue/dani-cifuentes/kathryn-cavanagh and the 1-point tier below down by one slot; no points changed. FIXED: wellness elisa-alcantara (qualified=true, top_placing_prior_olympia, independent of the ladder) no longer double-listed with a numeric row on today's page -- just "Qualified", matching her two wellness peers (eduarda-bezerra, isabelle-nunes) who have never carried a points/rank value; cleared her stale points=10/rank=4 to NULL and closed the gap by shifting every wellness rank below 4 down by one. STEP 2: LOCKED_YEAR 2026 competitors roster, 322 names across 12 divisions (identical count to every run since 2026-10-01), all 322 matched programmatically to existing qualified=true 2026 athletes (exact slug, token-overlap, or alias-table fallback) -- zero unmatched, zero new athletes. Per never-remove, 351 qualified vs 322 rostered (29 not rostered) left untouched, unchanged since 2026-09-29. STEP 3: no new identity questions. 2 manual review: classic-physique josh-bridgman (points=10, no rank, still completely absent from today's page -- unchanged since 2026-10-03); wellness danai-theodoropoulou (today's ladder again reads Australia while her sourced profile_source_url, the 2026 Tampa Pro competition page, reads Greece -- the same intra-ifbbpro.com disagreement flagged every run since 2026-09-20, re-derived fresh today rather than assumed, left as Greece).
Oct 5, 2026 reconciliation-audit 2 items to resolve
OPEN_YEAR=2027 ladder (12/12 divisions) and LOCKED_YEAR=2026 competitors roster (12/12 divisions) both fetched clean (cache miss, no bot challenge). 2 fixes applied: Dallas Botchway mens-physique auto_win->win_pending_approval (not yet published by IFBB, but has a sourced 2026-10-03 Toulouse win; un-qualifying would have erased a real result), and chongyang-yu wellness full_name spelling corrected to Chongyang Yuq. 15 apparent points mismatches across classic-physique/mens-physique/bikini/wellness are NOT real: every one has a sourced 2026-10-03/10-04 result the OPEN_YEAR page has not caught up to yet -- left untouched, expected to self-resolve. LOCKED_YEAR roster: zero genuine gaps against our existing 2026-09-07 mirror. 2 pre-existing manual-review items (not from today's diff): classic-physique Josh Bridgman (points=10, no rank, absent from today's page) and bikini Gulsah Gorgulu (points=2 matches, no rank -- invisible on the ladder).
Oct 3, 2026 reconciliation-audit 2 items to resolve
Both sources fetched fresh (X-Litespeed-Cache: miss confirmed on both). STEP 1: OPEN_YEAR 2027 ladder, all 12 divisions read by tablepress id. 7 win-based divisions + Wheelchair (5/5 ranked) exact match. Men's Physique and Bikini points-ladder divisions matched IFBB exactly. Former-champion invariant re-derived fresh: samson-dauda/erin-banks/lauralie-chapados confirmed former_champion and asterisked; ashley-kaltwasser/brandon-hendrickson correctly still former_champion_pending_approval. FIXED (Classic Physique, real drift since 2026-10-01): kai-wang 4->10 (rank 15->8, now in the 10-point tier), junbao-luo 3->4 (rank 21->15), jin-choe 2->3 (rank 25->21), chuan-zu-chen 3->4 (rank 20->16; IFBB's two separate "Chuan Zu Chen" rows both now print 2, versus 2+1 on 2026-10-01). Ranks for mahfuz-hawit/yi-shan-cheng/dmytro-krazhan/florian-sator/victor-garcia/chuan-wang/jesus-anchundia shifted by one to keep the points-descending sequence collision-free. ADDED: dong-o-ryu (Classic Physique, 1pt) -- athlete row already existed (spelling drops IFBB's "Oh"->"O"), had zero standings rows; new row mirrors IFBB's published number exactly. FLAGGED, not fixed: josh-bridgman (Classic Physique, 10pts as of the confirmed-clean 2026-10-01 run) is now completely absent from the page while kai-wang's total rose by exactly his prior value -- looks like it could be an IFBB-side name mix-up correction, but nothing on the page confirms that and it is not this routine's call to guess an identity question; points left at 10 (last published, not invented), rank cleared to null to avoid colliding with kai-wang's new rank 8, added to manual_review_count. Recurring documented spelling/typo variants (Reyna Perez/reyna-perez-mecalco, Leyvina Rodrigues Barros/leyvina-barros, Ledonida Ciobu/leonida-ciobu, Yiribeth Cantillo Roigoza/yiribeth-cantillo-raigoza, Chongyang Yuq/chongyang-yu, Lauralile Chapados/lauralie-chapados, Elisa Alcantara double-listing) all re-confirmed unchanged, none renamed. STEP 2: LOCKED_YEAR 2026 competitors roster, 322 names across 12 divisions, identical per-division counts to 2026-09-29/10-01, all 322 matched to existing qualified=true 2026 athletes (313 exact + the same 9 documented recurring name-truncation variants as every run since 2026-09-18/19). Zero new athletes, zero inserts beyond the Classic Physique ladder row above. Per never-remove, 351 qualified vs 322 rostered (29 not rostered) left untouched, unchanged since 2026-09-29. STEP 3: no new identity question beyond josh-bridgman. 2 manual review: josh-bridgman (new today, see above); danai-theodoropoulou (Wellness) again reads Australia on both fresh ifbbpro.com pages while her sourced profile_source_url (2026 Tampa Pro competition page) reads Greece -- unchanged intra-ifbbpro.com disagreement since 2026-09-29, left as Greece, still flagged for an owner call.
Oct 1, 2026 reconciliation-audit 1 item to resolve
Both sources fetched fresh (X-Litespeed-Cache: miss confirmed on both). STEP 1: OPEN_YEAR 2027 ladder, all 12 divisions read by tablepress id, diffed against a fresh DB query -- exact match on every division, zero fixes needed. Former-champion invariant re-derived fresh: lauralie-chapados/samson-dauda/erin-banks confirmed former_champion and asterisked; ashley-kaltwasser/brandon-hendrickson correctly still former_champion_pending_approval. The 9 items the 2026-09-27/09-29 runs flagged as "IFBB hasn't caught up yet" (paul-gustave, li-xiaolong, hieu-vu-minh, chuan-zu-chen, christina-yue, josh-bridgman, kai-wang, junbao-luo, jin-choe, joshua-eng-cherng-shin, kareen-haddad, sung-uk-kim, dokyung-lee, caitlin-arnold, huihui-hu, chongyang-yu, yan-ren, michele-fuzita, sara-milic) have all now caught up and match exactly -- confirmed resolved. chuan-zu-chen (classic-physique) now prints as two separate 2pt+1pt IFBB rows instead of one combined row; sums to our stored 3pts exactly, not a mismatch. Recurring documented spelling/typo variants (Lauralile Chapados/lauralie-chapados+wrong-country, Reyna Perez/reyna-perez-mecalco, Leyvina Rodrigues Barros/leyvina-barros, Ledonida Ciobu/leonida-ciobu, Yiribeth Cantillo Roigoza/yiribeth-cantillo-raigoza, Elisa Alcantara double-listing, Chongyang Yuq/chongyang-yu) all re-confirmed unchanged from prior runs, none renamed. STEP 2: LOCKED_YEAR 2026 competitors roster, 322 names across 12 divisions (Wheelchair now 10 rostered rather than the 11 seen through 2026-09-21, but matching the 2026-09-29 run's total of 322 exactly -- pre-existing, not new drift), all 322 matched to existing qualified=true 2026 athletes (314 exact + the same 8 documented recurring name-truncation variants as every run since 2026-09-18/09-19, each re-verified by division+country). Zero new athletes, zero inserts. Per never-remove, 351 qualified vs 322 rostered (29 not rostered) left untouched, unchanged since 2026-09-29. STEP 3: no new identity questions. 1 manual review, unchanged since 2026-09-29: danai-theodoropoulou (Wellness) now reads Australia on BOTH fresh ifbbpro.com pages (ladder + competitors roster) while her sourced profile_source_url (2026 Tampa Pro competition page, also ifbbpro.com) reads Greece -- an intra-ifbbpro.com disagreement the IFBB-deciding-source rule does not resolve on its own; left as Greece, still flagged for an owner call.
Sep 29, 2026 reconciliation-audit 1 item to resolve
Both sources fetched fresh (X-Litespeed-Cache: miss confirmed on both). STEP 1: OPEN_YEAR 2027 ladder, all 12 divisions read by tablepress id. 7 win-based divisions + Wheelchair (5/5 ranked) exact match. Former-champion re-derivation: samson-dauda/erin-banks/lauralie-chapados confirmed former_champion and asterisked; brandon-hendrickson/ashley-kaltwasser correctly still former_champion_pending_approval. 4 points-ladder divisions (Classic Physique, Men's Physique, Bikini, Wellness) matched exactly on every row IFBB publishes; 14 rows across those 4 divisions (Classic Physique: josh-bridgman, kai-wang, junbao-luo, jin-choe; Men's Physique: joshua-eng-cherng-shin; Bikini: kareen-haddad, sung-uk-kim, dokyung-lee, caitlin-arnold; Wellness: huihui-hu, chongyang-yu, yan-ren, michele-fuzita, sara-milic) share last_updated=2026-09-27 15:08:40 with the AGP Pro All Stars auto-results-watch insert and are simply not yet on IFBB's page -- same known lag as the 5 point-totals (paul-gustave, li-xiaolong, hieu-vu-minh, chuan-zu-chen, christina-yue) the 2026-09-27 run already found and left alone; none of it changed here either. FIXED: ashlyn-little (Bikini) was matched-but-unranked (rank NULL despite appearing on page in the 10-point tier) -- assigned rank 10, existing ranks 10-40 shifted to 11-41. FIXED: mahfuz-hawit (Classic Physique) country Honduras (unsourced, no profile_source_url) corrected to USA per the ladder page, the IFBB-deciding-source rule. NOT renamed: Wellness's "Ledonida Ciobu" matches leonida-ciobu exactly on country+points, same class of IFBB letter-transposition typo as the long-documented Roigoza/raigoza case, also still present and also still not renamed this run. STEP 2: LOCKED_YEAR 2026 competitors roster, 322 names across 12 divisions, all 322 matched to existing qualified=true 2026 athletes (full_name/known_as/token/documented-variant matching), zero new athletes, zero unresolved. Per never-remove, 351 qualified vs 322 rostered (29 not rostered) left untouched, consistent with every prior run. 1 manual review: danai-theodoropoulou (Wellness) reads Australia on today's ladder page but carries a verified profile_source_url (2026 Tampa Pro competition page) reading Greece, matching her Greek surname -- an intra-ifbbpro.com disagreement the IFBB-deciding-source rule (built for ifbbpro.com-vs-other-source conflicts) does not resolve on its own; left as Greece, flagged for an owner call rather than overwritten with the less-specific aggregate table's value.
Sep 27, 2026 reconciliation-audit no differences
All 12 divisions of the 2027 points-standings page read fresh (cache-buster verified X-Litespeed-Cache: miss). Post-Olympia propagation applied: 9 new qualified rows for Olympia top-three finishers (top_placing_prior_olympia), 3 new points-only rows for Olympia 4th/5th (12/10, per qualification_rules and confirmed by 3 independent rows). erin-banks points 10->22 (=10 + Olympia-4th 12); elisa-alcantara points ->10 (IFBB double-lists her, Qualified + a 10-point ladder row). 3 win_pending_approval rows confirmed by IFBB and flipped to auto_win (intack-lee, tori-la-rock, hannah-lanae). IFBB typo "Lauralile Chapados"/USA parked in athlete_name_aliases; our Lauralie Chapados/Canada row is correct and unchanged. NOT changed: five point totals where our board leads IFBB by exactly the AGP Pro All Stars (2026-09-26) award for each athlete's own placing (paul-gustave 17/13, li-xiaolong 16/13, hieu-vu-minh 3/1, chuan-zu-chen 3/2, christina-yue 2/1) -- IFBB has not credited that show yet and overwriting would delete it. No demotions. 1 manual review: erin-banks is asterisked but printed with 22 points rather than "Qualified", so our qualified=true/former_champion row may now be an over-inclusion -- the CLAUDE.md former-champion test predates the 2026-09-07 page reshape and needs an owner decision; points fixed, slot left intact. [RESOLVED same day by owner decision: apply IFBB OQS Note 1 ("any former Olympia winner has lifetime eligibility... where more than five years have elapsed since the last Olympia win, approval of the IFBB Pro League is required"). erin-banks confirmed correct as-is (2022 win, exactly 5 years, no approval needed) -- flag cleared, row unchanged. Same rule promoted lauralie-chapados (2024 win, 3 years) to qualified/former_champion, removing an inconsistency with Banks, and recorded former_champion_pending_approval on brandon-hendrickson (2021, 6 years) and ashley-kaltwasser (2015, 12 years), both of whom stay unqualified. Set is closed: all 24 asterisked names across the 12 tables were enumerated and only these four are asterisked with a bare points value. See 20260927_note1-former-champion-lifetime-eligibility.sql.
Sep 26, 2026 reconciliation-audit 3 items to resolve
OPEN_YEAR 2027 ladder + LOCKED_YEAR 2026 competitors roster both fetched live. The 2026 Olympia concluded six divisions on 2026-09-25 and IFBB has already propagated them: top 3 in 212/classic-physique/figure/womens-bodybuilding/womens-physique/wellness now qualify for 2027. Mirrored all of it -- 19 standings rows added across 7 divisions, ranks realigned to IFBB published row order in classic-physique/wellness/bikini, 1 athlete created (reyna-perez), jessica-chandy win_pending_approval -> auto_win (precedent ashley-howells). Former-champion invariant holds: samson-dauda and erin-banks both still published. 3 manual review: gulsah-gorgulu still absent from IFBB bikini ladder (carried, row kept, rank cleared to avoid a collision); hunter-lee/hunter-lee-2 and torey-braly/torey-braly-2 are possible duplicate pairs surfaced by two-row name matches, not merged.
Sep 25, 2026 reconciliation-audit 1 item to resolve
Both sources live via plain curl (no bot-check interstitial this run). Full independent re-derivation: 2027 ladder 12/12 divisions exact (points, former-champion invariant, no pending-approval rows). 2026 Olympia competitors roster: all 322 names across 12 divisions already covered by our qualified set -- zero inserts, zero new athletes. Zero drift since 2026-09-23's run; its state verified still correctly in place against today's fresh page pulls, not assumed. 10 roster name-variants + 2 ladder name-variants matched to existing already-qualified athletes via country/division/points correlation, none renamed -- none is the unambiguous single-source-of-truth spelling the rename rule requires; identical list to 2026-09-23's run, zero new variants. 1 manual review, unchanged since 2026-09-20: gulsah-gorgulu (bikini 2027, 2 pts, sourced) is still absent from IFBB's ladder while every other scorer from her show is present at the total we hold -- looks like a continuing IFBB-side aggregate-page omission, not ours; row kept. elizabeth-hunter (fit-model) still correctly win_pending_approval, still unconfirmed by IFBB on either page -- not counted as a review item, that is the expected state of the placeholder.
Sep 23, 2026 reconciliation-audit 1 item to resolve
Both sources live via plain curl (no bot-check interstitial this run). Full independent re-derivation: 2027 ladder 12/12 divisions exact (points, row order, former-champion invariant, no pending-approval rows). 2026 Olympia competitors roster: all 322 names across 12 divisions already covered by our qualified set -- zero inserts, zero new athletes. Zero drift since 2026-09-21's run; its state (34 tie-order rank realignments, ashley-howells method resolution) verified still correctly in place against today's fresh page pulls, not assumed. 9 roster name-variants matched to existing already-qualified athletes via country/division correlation, none renamed -- none is the unambiguous single-source-of-truth spelling the rename rule requires; one of the nine (Raeli Dias = raeli-pereira-dias, dropped middle name) had not been individually itemized in a prior file but is the same class of IFBB roster-page truncation as the rest. 1 manual review, unchanged since 2026-09-20: gulsah-gorgulu (bikini 2027, 2 pts, sourced) is still absent from IFBB's ladder while every other scorer from her show is present at the total we hold -- looks like a continuing IFBB-side aggregate-page omission, not ours; row kept. elizabeth-hunter (fit-model) still correctly win_pending_approval, still unconfirmed by IFBB on either page -- not counted as a review item, that is the expected state of the placeholder.
Sep 21, 2026 reconciliation-audit 1 item to resolve
Both sources live (LOCKED_YEAR roster required a headless-browser fetch -- curl hit a JS bot-check interstitial). Full independent re-derivation: 2027 ladder 12/12 divisions exact (points, row order, former-champion invariant, no pending-approval rows). 2026 Olympia competitors roster: all 323 names across 12 divisions already covered by our qualified set -- zero inserts, zero new athletes. Zero drift since yesterday's 2026-09-20 run; its fixes (ashley-howells method resolution, 34 tie-order rank realignments) verified still correctly in place against today's fresh page pull, not assumed. 9 roster name-variants + 1 ladder name-variant (Micah Thomas Jr, new today) matched to existing athletes via country/points correlation, none renamed -- none is the unambiguous single-source-of-truth spelling the rename rule requires. 1 manual review, unchanged from yesterday: gulsah-gorgulu (bikini 2027, 2 pts, sourced) is still absent from IFBB's ladder while every other scorer from her show is present at the total we hold -- looks like a continuing IFBB-side aggregate-page omission, not ours; row kept. yiribeth-cantillo-raigoza again not renamed to the ladder's "Roigoza": her own primary results pages still read Raigoza. elizabeth-hunter (fit-model) still correctly win_pending_approval, still unconfirmed by IFBB on either page -- not counted as a review item, that is the expected state of the placeholder.
Sep 20, 2026 reconciliation-audit 1 item to resolve
Both sources live. 2027 ladder: 10/12 divisions exact; resolved ashley-howells win_pending_approval -> auto_win; realigned 34 tie-order ranks in classic-physique/mens-physique/bikini to IFBB's published row order (wellness already matched). 2026 Olympia competitors roster: all 323 names across 12 divisions already covered by our qualified set -- no inserts, no new athletes; 37 of our qualified are absent from the roster and left alone per the never-remove convention. 1 manual review: gulsah-gorgulu (bikini 2027, 2 pts from a sourced Turkey Pro 4th) is absent from IFBB's ladder while every other Turkey Pro scorer is present at the exact total we hold -- looks like an IFBB-side omission, not ours; row kept, not deleted. Also declined to rename yiribeth-cantillo-raigoza: the ladder page prints Roigoza but IFBB's own competition results pages print Raigoza.
Sep 20, 2026 olympia-2026-roster-revalidation no differences
olympia-2026-roster-revalidation (2026-09-20, second run of the day): CLEAN. Re-fetched https://www.ifbbpro.com/2026-olympia-competitors/ fresh (HTTP 200, 297,389 bytes, article:modified_time still 2026-09-17T13:25:16+00:00 -- no republish since the 09-18 and 09-19 runs or the earlier 09-20 run; the byte count matches the 297,389 the 09-18/09-19 runs recorded exactly, which also confirms the earlier 09-20 run's 300,072 reading was transient page-furniture noise rather than a roster change). Re-parsed from scratch rather than trusting any prior run: 12 tables in the fixed division order, each with its own in-table title row and #/NAME/COUNTRY columns only, 323 names, every division count unchanged (Mr O 22, 212 21, CP 47, MPh 51, Wheelchair 11, Ms O 10, Fitness 10, Figure 31, Bikini 46, WP 16, Wellness 40, Fit Model 18). Name-level diff per division, not a count check (the 09-17 Wilson/Bah case proved a same-count SWAP is possible), matching on diacritic-stripped normalized name plus order-insensitive token and character keys against full_name/known_as/slug: all 323 roster names matched BOTH a qualification_standings row (season_year=2026, qualified=true) AND a confirmed mr-olympia contest_entries row, bijectively -- zero roster names unmatched on either side, zero extra or stale confirmed entries in any of the 12 divisions. 8 names fell outside the automatic key match and each pairs with EXACTLY ONE leftover candidate in its own division (Manual Angelo=manuel-angelo, Rodni Nelson=rodni-nelson-hebbert, Dilson Espindola=dilson-espindola-silva, Vincius Mateus Viera Lima=vinicius-mateus-viera-lima, Leyvina Rodrigues Barros=leyvina-barros, Reyna Perez=reyna-perez-mecalco, Sanda Colorado Acal=sandra-colorado-acal, Raeli Dias=raeli-pereira-dias); with Johne Jhoninho=jhone-jhoninho (resolved by the character/anagram key) that is the same 9 documented recurring IFBB-side spelling variants as every prior run, none new. contest_entries totals 324: 323 confirmed matching the page exactly, plus hadi-choopan withdrawn (expected -- the page excludes withdrawn entrants, and that row is owner-confirmed). qualification_standings holds 351 qualified=true 2026 rows vs 323 rostered; the 28 not-rostered were set-compared slug-for-slug against the enumerated list in the 09-18/09-19/09-20 rows and are identical, zero added and zero dropped -- not open items, per the standing owner decision that the /olympia hub never un-qualifies from this roster. Zero new athletes, zero over-inclusions, no SQL drafted, nothing applied beyond this log row. manual_review_count=0. Show NOT concluded (mr-olympia runs 2026-09-24 to 2026-09-27), so this task remains useful; it should be disabled once the show closes out.
Sep 19, 2026 reconciliation-audit no differences
reconciliation-audit (2026-09-19, routine-column re-run): STEP 1 -- fetched https://www.ifbbpro.com/2027-olympia-qualified-athletes-point-standings/ fresh (HTTP 200), all 12 tablepress-NN tables read by id and parsed programmatically (blank/legend rows filtered). Diffed against qualification_standings (season_year=2027) fresh from the live DB: exact match on all 12 divisions -- Mr Olympia 2/2, 212 2/2, Classic Physique 20/20, Men's Physique 32/32, Wheelchair 0/0, Ms Olympia 1/1, Fitness 1/1, Figure 3/3, Bikini 30/30, Women's Physique 1/1, Wellness 10/10, Fit Model 2/2. Zero over-inclusion, zero under-inclusion, zero points mismatches. Bikini's "Reyna Perez" (rank 18, 3pts) and Wellness's "Yiribeth Cantillo Roigoza" (rank 10, 1pt) verified by exact rank+points match to reyna-perez-mecalco and yiribeth-cantillo-raigoza -- already-documented spelling variants, not new. Former-champion re-derivation (queried explicitly) re-confirmed Samson Dauda (Mr Olympia) and Erin Banks (Men's Physique), both former_champion and both shown with the page's own asterisk -- no change. Zero *_pending_approval rows for season_year=2027. STEP 2 -- fetched https://www.ifbbpro.com/2026-olympia-competitors/ fresh (HTTP 200), 12 tables fixed order, 323 names (Mr O 22, 212 21, CP 47, MPh 51, Wheelchair 11, Ms O 10, Fitness 10, Figure 31, Bikini 46, WP 16, Wellness 40, Fit Model 18). Diffed against qualification_standings (season_year=2026, qualified=true) fresh from the live DB via slug/known_as/athlete_slug_aliases/exact-full_name matching: all 323 resolve, zero unmatched. 12 initial non-slug-matches resolved: 8 already-documented recurring spelling variants (manuel-angelo, jhone-jhoninho, rodni-nelson-hebbert, dilson-espindola-silva, leyvina-barros, reyna-perez-mecalco, sandra-colorado-acal, raeli-pereira-dias) plus 4 exact-full_name matches missed only by the slugify heuristic (victor-alves-porto-de-oliveira, allison-kramer, nivea-campos, camila-camila-rodrigues) -- all already qualified=true in the correct division. Zero new athletes, zero new standings rows needed. Per never-remove, DB qualified counts running higher than the roster (351 vs 323 overall) left untouched as expected. STEP 3 -- no genuine identity/spelling questions this run. manual_review_count=0: both checks independently re-verified clean from fresh fetches, nothing applied beyond this log row. Note: this row is a same-day re-run under the new (reconciled_at, routine) key -- migration 20260919150000_reconciliation_log_routine.sql landed today and reclassified an earlier same-day reconciliation-audit insert (commit e06ab37, file 2026-09-19_reconciliation-audit.sql) into routine='legacy-combined' because a second routine (olympia-2026-roster-revalidation) had appended its own findings into that same pre-migration row. This routine now owns its own explicitly-named row going forward.
Sep 19, 2026 legacy-combined no differences
reconciliation-audit (2026-09-19): STEP 1 -- fetched https://www.ifbbpro.com/2027-olympia-qualified-athletes-point-standings/ fresh (HTTP 200), all 12 tablepress-NN tables read by id and parsed programmatically. Diffed against qualification_standings (season_year=2027) fresh from the live DB. Every division is an EXACT match, name for name and point for point, zero fixes needed: Mr Olympia 2/2 (Regan Grimes auto_win, Samson Dauda former_champion, matches page's asterisk), 212 2/2 (Wei Li, Marco Ruz), Classic Physique 20/20, Men's Physique 32/32 (Mehdi Kabbadj's textual "Qualified" cell already stored as auto_win/10; Erin Banks former_champion matches page's asterisk), Wheelchair 0/0 (still genuinely empty), Ms Olympia 1/1 (Anna Terzo), Fitness 1/1 (Michaela Pavleova), Figure 3/3 (Anna Borin auto_win, Lena Ramsteiner, Jennifer Zienert), Bikini 30/30, Women's Physique 1/1 (Lenka Ferencukova), Wellness 10/10, Fit Model 2/2 (Angela Miranda auto_win, Sarah Terzenbach). Two initially-flagged Bikini/Wellness names (IFBB's "Reyna Perez" and "Yiribeth Cantillo Roigoza") are the same already-documented shortened-name/spelling variants as prior runs (reyna-perez-mecalco, yiribeth-cantillo-raigoza), both point-matched, not new. Bikini's "Wu Bi" is stored full_name "Bi Wu"/known_as "Wu Bi", already resolved via known_as, not a new disagreement. Zero over-inclusion. Zero under-inclusion. Zero points mismatches. Former-champion re-derivation re-confirmed Samson Dauda (Mr Olympia) and Erin Banks (Men's Physique), both already former_champion -- no change. Zero *_pending_approval rows exist for season_year=2027 (checked explicitly). STEP 2 -- fetched https://www.ifbbpro.com/2026-olympia-competitors/ fresh (HTTP 200, article:modified_time 2026-09-17T13:25:16+00:00, byte-identical to the version the 2026-09-18 olympia-2026-roster-revalidation run already read). 12 tables in fixed order, 323 names (Mr O 22, 212 21, CP 47, MPh 51, Wheelchair 11, Ms O 10, Fitness 10, Figure 31, Bikini 46, WP 16, Wellness 40, Fit Model 18), matching every recent run's own count. Diffed every roster name programmatically against qualification_standings (season_year=2026, qualified=true) via slug/known_as/athlete_slug_aliases/documented spelling variants: all 323 resolve to an existing qualified row, zero unmatched, in all 12 divisions. Zero new athletes, zero new qualification_standings rows needed this run -- nothing to mirror. Per the never-remove rule, the DB's larger qualified counts per division vs. the roster (e.g. Mr Olympia 25 qualified vs. 22 rostered) are expected and were left untouched, not investigated further, consistent with every prior run. STEP 3 -- no genuine identity/spelling questions surfaced this run requiring manual_review_count. manual_review_count=0: both checks are a fully clean pass, nothing applied to qualification_standings/athletes/athlete_divisions/results. | olympia-2026-roster-revalidation (2026-09-19): CLEAN. Fetched https://www.ifbbpro.com/2026-olympia-competitors/ fresh (HTTP 200, 297,389 bytes, article:modified_time still 2026-09-17T13:25:16+00:00 -- no republish since the 2026-09-18 runs and the 2026-09-19 reconciliation-audit read the same version). Parsed from scratch rather than trusting any prior run: 12 tables in the fixed division order, #/NAME/COUNTRY columns only, 323 names, every division count unchanged (Mr O 22, 212 21, CP 47, MPh 51, Wheelchair 11, Ms O 10, Fitness 10, Figure 31, Bikini 46, WP 16, Wellness 40, Fit Model 18). Name-level diff per division, not a count check (the 09-17 Wilson/Bah case proved a same-count SWAP is possible): all 323 roster names matched BOTH a qualification_standings row (season_year=2026, qualified=true) AND a confirmed mr-olympia contest_entries row, bijectively -- zero roster names unmatched on either side, zero extra/stale confirmed entries in any of the 12 divisions. Resolved through the same 9 documented recurring IFBB-side spelling variants and nothing else, none new: Manual Angelo=manuel-angelo, Johne Jhoninho=jhone-jhoninho, Rodni Nelson=rodni-nelson-hebbert, Dilson Espindola=dilson-espindola-silva, Vincius Mateus Viera Lima=vinicius-mateus-viera-lima, Leyvina Rodrigues Barros=leyvina-barros, Reyna Perez=reyna-perez-mecalco, Sanda Colorado Acal=sandra-colorado-acal, Raeli Dias=raeli-pereira-dias. contest_entries totals 324: 323 confirmed matching the page exactly, plus hadi-choopan withdrawn (expected -- the page excludes withdrawn entrants). qualification_standings holds 351 qualified=true 2026 rows vs 323 rostered; per the standing owner decision that the /olympia hub never un-qualifies from this roster, those 28 are not open items and were not re-investigated. Zero new athletes, zero over-inclusions confirmed, no SQL drafted, nothing applied beyond this log append. manual_review_count +0. Show NOT concluded (mr-olympia ends 2026-09-27), so this task remains useful; it should be disabled after the show closes out. | olympia-2026-roster-revalidation (later run, 2026-09-19): CLEAN. Re-fetched https://www.ifbbpro.com/2026-olympia-competitors/ (HTTP 200, 297,389 bytes, article:modified_time still 2026-09-17T13:25:16+00:00 -- byte-identical to the version the earlier 2026-09-19 runs and both 2026-09-18 runs read; no republish). Re-parsed from scratch rather than trusting any prior run: 12 tables in the fixed division order, each with its own in-table title row and #/NAME/COUNTRY columns only, 323 names, every division count unchanged (Mr O 22, 212 21, CP 47, MPh 51, Wheelchair 11, Ms O 10, Fitness 10, Figure 31, Bikini 46, WP 16, Wellness 40, Fit Model 18). Name-level diff per division, not a count check (the 09-17 Wilson/Bah case proved a same-count SWAP is possible), matching on diacritic-stripped normalized name plus an order-insensitive token key against full_name/known_as/slug: all 323 roster names matched BOTH a qualification_standings row (season_year=2026, qualified=true) AND a confirmed mr-olympia contest_entries row, bijectively -- zero roster names unmatched on either side, zero extra or stale confirmed entries in any of the 12 divisions. Resolved through the same 9 documented recurring IFBB-side spelling variants and nothing else, none new: Manual Angelo=manuel-angelo, Johne Jhoninho=jhone-jhoninho, Rodni Nelson=rodni-nelson-hebbert, Dilson Espindola=dilson-espindola-silva, Vincius Mateus Viera Lima=vinicius-mateus-viera-lima, Leyvina Rodrigues Barros=leyvina-barros, Reyna Perez=reyna-perez-mecalco, Sanda Colorado Acal=sandra-colorado-acal, Raeli Dias=raeli-pereira-dias. contest_entries totals 324: 323 confirmed matching the page exactly, plus hadi-choopan withdrawn (expected -- the page excludes withdrawn entrants, and that row is owner-confirmed). qualification_standings holds 351 qualified=true 2026 rows vs 323 rostered; the 28 not-rostered are byte-for-byte the same 28 enumerated in the 2026-09-18 row (hadi-choopan, shaun-clarida, courage-opara, francisco-barrios-vlk, wei-li, jose-manuel-munoz, matheus-menegate-piccioli, momar-bah, vitaliy-omelycenko, gaylon-grigsby, harold-kelley, karol-milewski, mohammad-reza-tabrizi-nouri, alcione-santos-barreto, anastasia-korableva, taylor-learmont, beatriz-bia, katja-nowack, saionara-rebelo, alice-rocha, uyanga-bataa, zsofia-molnar, paula-ranta, sara-bradley, hannah-calkins, josy-alves-macedo, karla-sanchez, elizabeth-hunter) -- not open items, per the standing owner decision that the /olympia hub never un-qualifies from this roster. Zero new athletes, zero over-inclusions, no SQL drafted, nothing applied beyond this log append. manual_review_count +0. Show NOT concluded (mr-olympia runs 2026-09-24 to 2026-09-27), so this task remains useful for now; it should be disabled after the show closes out.
Sep 18, 2026 olympia-2026-roster-revalidation no differences
olympia-2026-roster-revalidation (2026-09-18): CLEAN. Fetched https://www.ifbbpro.com/2026-olympia-competitors/ fresh (HTTP 200, article:modified_time 2026-09-17T13:25:16+00:00 -- REPUBLISHED since the 2026-09-16T20:38:43 version all three 2026-09-17 runs read). Parsed twice independently and cross-checked: raw-HTML parse and browser-rendered DOM parse agree exactly -- 12 tables, 323 names, every division count unchanged from 2026-09-17 (Mr O 22, 212 21, CP 47, MPh 51, Wheelchair 11, Ms O 10, Fitness 10, Figure 31, Bikini 46, WP 16, Wellness 40, Fit Model 18). The republish changed no roster membership. Name-level diff run per division (not a count check -- the 09-17 Wilson/Bah case proved a same-count SWAP is possible): all 323 roster names matched BOTH a qualification_standings row (season_year=2026, qualified=true) AND a confirmed mr-olympia contest_entries row. Bijective in every division -- zero unmatched roster names, zero extra/stale confirmed entries. Resolved through the same 9 known recurring IFBB-side spelling variants and nothing else, all previously documented, none new: Manual Angelo=manuel-angelo, Johne Jhoninho=jhone-jhoninho, Rodni Nelson=rodni-nelson-hebbert, Dilson Espindola=dilson-espindola-silva, Vincius Mateus Viera Lima=vinicius-mateus-viera-lima, Leyvina Rodrigues Barros=leyvina-barros, Reyna Perez=reyna-perez-mecalco, Sanda Colorado Acal=sandra-colorado-acal, Raeli Dias=raeli-pereira-dias. (IFBB's earlier "Elisa Alcantaraq" typo now reads "Elisa Alcantara" on the page and matches elisa-alcantara exactly.) contest_entries totals 324: 323 confirmed matching the page exactly in all 12 divisions, plus hadi-choopan withdrawn (expected, the page excludes withdrawn entrants). The kellen-wilson/momar-bah swap applied 2026-09-17 remains correct against today's page. qualification_standings holds 351 qualified=true rows for 2026 vs 323 rostered; per the standing owner decision the hub never un-qualifies from this roster, so those 28 are not open items and were not investigated. Zero new athletes needed, zero over-inclusions confirmed, no SQL drafted, nothing applied beyond this log row. manual_review_count +0. Show NOT concluded (ends 2026-09-27), so this task remains useful. | olympia-2026-roster-revalidation (later run, 2026-09-18): CLEAN. Re-fetched https://www.ifbbpro.com/2026-olympia-competitors/ (HTTP 200, article:modified_time still 2026-09-17T13:25:16+00:00 -- byte-identical version to the earlier 2026-09-18 run, no republish since). Re-parsed from scratch rather than trusting the earlier run: 12 tables in the fixed division order, each carrying its own in-table title row (MR. OLYMPIA / 212 OLYMPIA / CLASSIC PHYSIQUE / MEN'S PHYSIQUE / WHEELCHAIR / MS. OLYMPIA / FITNESS / FIGURE / BIKINI / WOMEN'S PHYSIQUE / WELLNESS / FIT MODEL) and #/NAME/COUNTRY columns only. 323 names, every division count unchanged: Mr O 22, 212 21, CP 47, MPh 51, Wheelchair 11, Ms O 10, Fitness 10, Figure 31, Bikini 46, WP 16, Wellness 40, Fit Model 18. Name-level diff per division (not a count check): all 323 roster names matched BOTH a qualification_standings row (season_year=2026, qualified=true) AND a confirmed mr-olympia contest_entries row, bijectively -- zero roster names unmatched, zero extra/stale confirmed entries in any division. Resolved through the same 9 documented recurring IFBB-side spelling variants and nothing else, none new: Manual Angelo=manuel-angelo, Johne Jhoninho=jhone-jhoninho, Rodni Nelson=rodni-nelson-hebbert, Dilson Espindola=dilson-espindola-silva, Vincius Mateus Viera Lima=vinicius-mateus-viera-lima, Leyvina Rodrigues Barros=leyvina-barros, Reyna Perez=reyna-perez-mecalco, Sanda Colorado Acal=sandra-colorado-acal, Raeli Dias=raeli-pereira-dias. contest_entries totals 324: 323 confirmed matching the page exactly in all 12 divisions, plus hadi-choopan withdrawn (expected -- the page excludes withdrawn entrants). qualification_standings holds 351 qualified=true 2026 rows vs 323 rostered; all 28 extras are previously named (hadi-choopan, shaun-clarida, courage-opara, francisco-barrios-vlk, wei-li, jose-manuel-munoz, matheus-menegate-piccioli, momar-bah, vitaliy-omelycenko, gaylon-grigsby, harold-kelley, karol-milewski, mohammad-reza-tabrizi-nouri, alcione-santos-barreto, anastasia-korableva, taylor-learmont, beatriz-bia, katja-nowack, saionara-rebelo, alice-rocha, uyanga-bataa, zsofia-molnar, paula-ranta, sara-bradley, hannah-calkins, josy-alves-macedo, karla-sanchez, elizabeth-hunter) and are not open items, per the standing owner decision that the /olympia hub never un-qualifies from this roster. Zero new athletes, zero over-inclusions confirmed, no SQL drafted, nothing applied beyond this log append. manual_review_count +0. Show NOT concluded (mr-olympia ends 2026-09-27), so this task remains useful.
Sep 17, 2026 legacy-combined no differences
olympia-2026-roster-revalidation (2026-09-17): NEEDS REVIEW, 2 items (both new). Re-fetched https://www.ifbbpro.com/2026-olympia-competitors/ (HTTP 200, article:modified_time 2026-09-16T20:38:43, republished since the 2026-09-16T15:02:14 version the previous run read). 12 tables, 323 names, every division count unchanged: Mr O 22, 212 21, CP 47, MPh 51, Wheelchair 11, Ms O 10, Fitness 10, Figure 31, Bikini 46, WP 16, Wellness 40, Fit Model 18. Classic Physique has a same-count SWAP that a count check alone would miss. Every roster name matched an existing qualification_standings row (2026, qualified=true), via the same 9 known IFBB spelling variants. Zero new athletes. contest_entries: 11 of 12 divisions exact (hadi-choopan withdrawn, expected). Classic Physique: (1) NEW, kellen-wilson is back on the page at #44. His entry was removed by 86926892 on 09-14, so he is now missing from /contests/mr-olympia. He is still qualified=true/auto_win. (2) NEW, momar-bah is still a confirmed entry but has no Momar or Bah string anywhere on the page, and there is no withdrawal wording. His qualification_standings row is left alone per the owner decision that the hub never un-qualifies. Drafted supabase/updates/2026-09-17_olympia-2026-roster-revalidation_swap-bah-wilson.sql, which deletes the Bah entry (row recorded verbatim) and re-inserts Wilson as confirmed, announced_at 2026-09-16. Guards: 324 total, CP 47. Dry run inside begin/rollback passed. UNCOMMITTED and UNAPPLIED, pending human review. Show not concluded (ends 2026-09-27). | ADDENDUM (2026-09-17, owner-approved): the page was re-checked and was unchanged (modified 2026-09-16T20:38:43). The swap file was committed (032b08de) and applied. mr-olympia contest_entries now matches the IFBB page exactly in all 12 divisions: 323 confirmed, plus hadi-choopan withdrawn. kellen-wilson is in and momar-bah is out of Classic Physique (47). Both items are resolved and manual_review_count is reset to 0. | reconciliation-audit (2026-09-17): STEP 1 -- fetched https://www.ifbbpro.com/2027-olympia-qualified-athletes-point-standings/ fresh (HTTP 200), all 12 tablepress-NN tables read by id, each table's own <thead> confirmed against the expected win-based/points shape. Diffed against qualification_standings (season_year=2027) fresh from the live DB. Every division is an EXACT match, name for name and point for point, zero fixes needed: Mr Olympia 2/2 (Regan Grimes auto_win, Samson Dauda former_champion, matches page's asterisk), 212 2/2 (Wei Li, Marco Ruz), Classic Physique 20/20, Men's Physique 32/32 (Mehdi Kabbadj's textual "Qualified" cell already stored as auto_win/10; Erin Banks former_champion matches page's asterisk), Wheelchair 0/0 (still genuinely empty), Ms Olympia 1/1 (Anna Terzo), Fitness 1/1 (Michaela Pavleova), Figure 3/3 (Anna Borin auto_win, Lena Ramsteiner, Jennifer Zienert), Bikini 30/30, Women's Physique 1/1 (Lenka Ferencukova), Wellness 10/10, Fit Model 2/2 (Angela Miranda auto_win, Sarah Terzenbach). Two initially-flagged Bikini/Wellness names (IFBB's "Reyna Perez" and "Yiribeth Cantillo Roigoza") are the same already-documented shortened-name/spelling variants as prior runs (reyna-perez-mecalco, yiribeth-cantillo-raigoza), both point-matched, not new. Zero over-inclusion. Zero under-inclusion. Zero points mismatches. Former-champion re-derivation re-confirmed Samson Dauda (Mr Olympia) and Erin Banks (Men's Physique), both already former_champion -- no change. Zero *_pending_approval rows exist for season_year=2027 (checked explicitly). STEP 2 -- fetched https://www.ifbbpro.com/2026-olympia-competitors/ fresh (HTTP 200, article:modified_time 2026-09-16T20:38:43+00:00) -- the same version today's earlier olympia-2026-roster-revalidation run above already read. 12 tables in fixed order, 323 names (Mr O 22, 212 21, CP 47, MPh 51, Wheelchair 11, Ms O 10, Fitness 10, Figure 31, Bikini 46, WP 16, Wellness 40, Fit Model 18), matching that run's own count. Diffed every roster name against qualification_standings (season_year=2026, qualified=true): all 323 resolve to an existing qualified row. 4 names looked unmatched under a plain slugify of the roster's printed name but each resolved to an existing qualified=true row carrying a divergent short/custom slug on file, not a real gap: Vitor Alves Porto De Oliveira (212) = victor-alves-porto-de-oliveira; Allison Dominguez-Kramer (Fitness) = allison-kramer; Nivea Gabriella Campos Sobral (Bikini) = nivea-campos; Camila Rodrigues Barreto (Wellness, auto_win) = camila-camila-rodrigues. Zero new athletes, zero new qualification_standings rows needed this run -- nothing to mirror. Per the never-remove rule, the DB's larger qualified counts per division vs. the roster (e.g. Mr Olympia 24 qualified vs. 22 rostered) are expected and were left untouched, not investigated further. STEP 3 -- no genuine identity/spelling questions surfaced this run requiring manual_review_count. manual_review_count=0: both checks are a fully clean pass, nothing applied to qualification_standings/athletes/athlete_divisions/results. | olympia-2026-roster-revalidation (later run, 2026-09-17): CLEAN. Re-fetched https://www.ifbbpro.com/2026-olympia-competitors/ (HTTP 200, article:modified_time still 2026-09-16T20:38:43, same version as both earlier reads today). 12 tables, 323 names, division counts unchanged (Mr O 22, 212 21, CP 47, MPh 51, Wheelchair 11, Ms O 10, Fitness 10, Figure 31, Bikini 46, WP 16, Wellness 40, Fit Model 18). Every roster name matched both qualification_standings (2026, qualified=true) and mr-olympia contest_entries, via the same 9 known IFBB spelling variants (Manual Angelo, Johne Jhoninho, Rodni Nelson, Dilson Espindola, Vincius Mateus Viera Lima, Leyvina Rodrigues Barros, Reyna Perez, Sanda Colorado Acal, Raeli Dias). contest_entries matches the page exactly in all 12 divisions: 323 confirmed, plus hadi-choopan withdrawn (expected). kellen-wilson/momar-bah swap confirmed applied. No SQL drafted. manual_review_count +0. Show not concluded (ends 2026-09-27).
Sep 16, 2026 olympia-2026-roster-revalidation no differences
olympia-2026-roster-revalidation (2026-09-16): NEEDS REVIEW, 3 items (2 new + 1 carried). Re-fetched https://www.ifbbpro.com/2026-olympia-competitors/ (HTTP 200, article:modified_time 2026-09-16T15:02:14, republished since the 2026-09-15 read). 12 tables, 323 names (was 325): Mr O 22, 212 21, CP 47, MPh 51, Wheelchair 11, Ms O 10 (-1), Fitness 10, Figure 31, Bikini 46 (-1), WP 16, Wellness 40, Fit Model 18. Every roster name matched an existing row in both qualification_standings (2026, qualified=true) and contest_entries, via the same 9 known IFBB spelling variants. Zero missing athletes, nothing to add. qualification_standings untouched per the owner decision that the hub never un-qualifies from this roster; anastasia-korableva and uyanga-bataa join the known qualified-but-not-rostered list. contest_entries: 9 of 12 divisions exact (hadi-choopan withdrawn, expected). Stale confirmed entries, each absent from the whole page with no IFBB withdrawal wording: NEW anastasia-korableva/womens-bodybuilding, NEW uyanga-bataa/bikini, CARRIED hannah-calkins/wellness (the 2026-09-15 draft is still uncommitted and unapplied). /contests/mr-olympia is stale by 3. Drafted supabase/updates/2026-09-16_olympia-2026-roster-revalidation_drop-korableva-bataa.sql, which deletes all 3 (rows recorded verbatim) and supersedes the 09-15 draft. It works in either apply order; guards: 324 total, WBB 10, bikini 46, wellness 40. Dry run inside begin/rollback passed. UNCOMMITTED and UNAPPLIED, pending human review. | ADDENDUM (2026-09-16, owner-approved): the 09-16 file was committed (aabed613) and applied. mr-olympia contest_entries = 324 and match the IFBB page exactly in all 12 divisions (plus hadi-choopan, withdrawn). All 3 items are resolved and manual_review_count is reset to 0. The 09-15 Calkins-only draft is superseded.
Sep 15, 2026 olympia-2026-roster-revalidation 1 item to resolve
STEP 1: fetched the 2027 points/qualified page fresh, all 12 tablepress-NN tables read by id. Wheelchair still genuinely empty. Zero over-inclusion. Former-champion re-derivation re-confirmed Samson Dauda (Mr Olympia) and Erin Banks (Men's Physique), both already former_champion, no change. Zero win_pending_approval rows exist for 2027. Classic Physique (20/20), Men's Physique (32/32) and Wellness (10/10) matched IFBB exactly, name for name and point for point -- zero drift since 2026-09-13. Bikini was missing exactly one name: Roxana Marquez (Mexico, 10 points) -- an existing athlete (prior non-qualifying 2026 bikini row) given a 2027 row at IFBB's published value, qualified=false consistent with every other full-ladder Bikini row. Zero points mismatches anywhere. Dense re-ranked Bikini after the one insert. STEP 2: re-fetched the 2026 competitors roster (page republished since 2026-09-14, article:modified_time 2026-09-15T00:55:30Z) -- 338 raw rows/12 tables in fixed order (title rows excluded from all counts). Every roster name matched an existing qualified=true 2026 athlete via slug/known_as/full_name, working through the same 9 recurring IFBB-side spelling variants prior passes already resolved (Manual Angelo, Johne Jhoninho, Rodni Nelson, Dilson Espindola, Vincius/Vinicius Mateus Viera Lima, Leyvina Rodrigues Barros, Reyna Perez, Sanda/Sandra Colorado Acal, Raeli Dias) -- zero new athletes, zero new standings rows needed. Per the never-remove rule, absences from today's roster are left untouched: courage-opara (212) and karol-milewski (wheelchair) were already documented dropped from contest_entries by 20260914_mr-olympia-roster-resync.sql and are now also confirmed absent here; gaylon-grigsby (wheelchair) and hannah-calkins (wellness) are new absences as of this run, named here and left alone -- neither investigated further, per scope. manual_review_count=0 -- a genuinely clean pass; the one fix (Roxana Marquez) was an unambiguous mirror of IFBB's own published row, not a judgment call. | olympia-2026-roster-revalidation (2026-09-15): NEEDS REVIEW, 1 item. Re-fetched https://www.ifbbpro.com/2026-olympia-competitors/ (HTTP 200, article:modified_time 2026-09-15T00:55:30-04:00, same version the audit above read). 12 tables, 325 names: Mr O 22, 212 21, CP 47, MPh 51, Wheelchair 11, Ms O 11, Fitness 10, Figure 31, Bikini 47, WP 16, Wellness 40, Fit Model 18. Every roster name matched an existing row in both qualification_standings (2026, qualified=true) and contest_entries, via the same 9 known IFBB spelling variants. Zero missing athletes. qualification_standings: 22 qualified-but-not-rostered rows, all previously known, plus courage-opara, karol-milewski, gaylon-grigsby and hannah-calkins, all already named in prior rows. None are open items, because the owner decided the hub never un-qualifies from this roster. contest_entries: 11 of 12 divisions exact (hadi-choopan withdrawn, expected). The 1 open item: hannah-calkins/wellness is still status=confirmed, but she is absent from the whole page (no Calkins or Hannah string in any division) and there is no IFBB withdrawal signal, so /contests/mr-olympia is stale by one. Drafted supabase/updates/2026-09-15_olympia-2026-roster-revalidation_drop-hannah-calkins.sql (delete the entry, row recorded verbatim, count guards 326 total / 40 wellness). Dry run inside begin/rollback passed. UNCOMMITTED and UNAPPLIED, pending human review.
Sep 14, 2026 olympia-2026-roster-revalidation no differences
olympia-2026-roster-revalidation (first tagged run; status=completed because reconciliation_log_status_check only permits completed/blocked -- read this as NEEDS_REVIEW, 1 item). Fetched https://www.ifbbpro.com/2026-olympia-competitors/ (HTTP 200, page modified 2026-09-14T01:07:46Z, changed since the 2026-09-10 version prior audits read). 12 tables in fixed order, 329 rows: Mr O 22, 212 22, CP 47, MPh 51, Wheelchair 13, Ms O 11, Fitness 10, Figure 31, Bikini 47, WP 16, Wellness 41, Fit Model 18. Diffed against qualification_standings (2026, qualified=true) and contest_entries for mr-olympia. Zero roster names missing from either table: all 8 unmatched strings are IFBB-side spelling variants of rows already on file (Manual Angelo, Rodni Nelson, Dilson Espindola, Vincius Mateus Viera Lima, Leyvina Rodrigues Barros, Reyna Perez, Sanda Colorado Acal, Raeli Dias). NEW since 2026-09-11: Classic Physique dropped 49 to 47 -- Kellen Wilson and Vitaliy Omelycenko are no longer listed, both still contest_entries status=confirmed and qualified=true/auto_win. Both hold real sourced in-window CP wins (window 2025-09-15 to 2026-08-30): kellen-wilson won Toronto Pro Supershow 2026-06-14 and Vancouver Pro 2026-07-24; vitaliy-omelycenko won Russia Pro 2025-10-26 and Oksana Grishina Pro 2026-04-25. Qualification is therefore NOT an over-inclusion and no fix was drafted. Whether either withdrew is unsourced (web search found no withdrawal report), so contest_entries was left confirmed. Kellen Wilson is the one manual-review item; Vitaliy Omelycenko is already named in the uncommitted, unapplied 2026-09-14_olympia-2026-competitors-over-inclusion-review.sql from another session. Previously known absences unchanged: alcione-santos-barreto, saionara-rebelo, karla-sanchez, matheus-menegate-piccioli, alice-rocha (all still ce=confirmed, so /contests/mr-olympia is stale for 7 athletes); hadi-choopan withdrawn as expected; plus 14 never-rostered qualified rows covered by that other file. That file also upserts reconciled_at=2026-09-14, so applying it will overwrite this row. ADDENDUM (same-day follow-up from a separate session, applied after this row): checked 19 candidate qualification_standings rows (season_year=2026, qualified=true) flagged as possible over-inclusion against https://www.ifbbpro.com/2026-olympia-competitors/. 2 confirmed genuine over-inclusions, FIXED in this update: shaun-clarida/mens-open and paula-ranta/womens-physique -- both wrong-division double-qualifications where the athlete is positively confirmed on the official roster under a DIFFERENT division only. 17 left untouched (counted above, not defects): 6 already-known open items under the LOCKED_YEAR mirror's never-demote rule (alcione-santos-barreto, saionara-rebelo, karla-sanchez, matheus-menegate-piccioli, alice-rocha, vitaliy-omelycenko); 1 documented non-defect (jose-manuel-munoz/Josema Munoz double-listing); 1 confirmed-correct former_champion (harold-kelley, 6 Olympia wheelchair wins through 2024); 1 confirmed-correctly-pending win_pending_approval (elizabeth-hunter); 9 real sourced in-window wins matching their division's own rule but not yet on the official roster, treated as expected lag (francisco-barrios-vlk, wei-li, taylor-learmont, beatriz-bia, katja-nowack, zsofia-molnar, josy-alves-macedo, sara-bradley, mohammad-reza-tabrizi-nouri). A wei-li contest_entries note flags an unresolved identity question (Men's Open Chengdu entry vs 212 titleholder) worth a dedicated look outside this pass. | ADDENDUM (owner decision, 2026-09-14): the /olympia hub never un-qualifies based on the competitors roster, so 4ddbcb2f's un-qualification of shaun-clarida/mens-open and paula-ranta/womens-physique was reverted, and its 17 qualified-but-not-rostered review items are not open items. The show page (contest_entries) mirrors the roster exactly instead: 86926892 removed the 7 entrants IFBB no longer lists, and hadi-choopan stays withdrawn (owner-confirmed). manual_review_count reset to 0. | olympia-2026-roster-revalidation (later run, 2026-09-14): CLEAN. Re-fetched https://www.ifbbpro.com/2026-olympia-competitors/ (HTTP 200, dateModified still 2026-09-14T01:07:46Z, same as the earlier run today), 12 tables, 329 rows, counts unchanged. All roster names matched in both qualification_standings and contest_entries, including the same 8 known IFBB spelling variants. contest_entries for mr-olympia now matches the roster exactly in all 12 divisions (after 86926892); the only extra row is hadi-choopan, withdrawn (owner-confirmed). 22 qualified=true rows are not on the roster (hadi-choopan, shaun-clarida, francisco-barrios-vlk, wei-li, jose-manuel-munoz, kellen-wilson, matheus-menegate-piccioli, vitaliy-omelycenko, harold-kelley, mohammad-reza-tabrizi-nouri, alcione-santos-barreto, taylor-learmont, beatriz-bia, katja-nowack, saionara-rebelo, alice-rocha, zsofia-molnar, paula-ranta, sara-bradley, josy-alves-macedo, karla-sanchez, elizabeth-hunter). All are already known and not open items, per the owner decision that the hub never un-qualifies from this roster. No SQL drafted. manual_review_count +0.
Sep 13, 2026 reconciliation-audit no differences
Afternoon re-run after Europa Pro Show/Dominican Republic Pro standings were corrected from the closed 2026 season into 2027. STEP 1: fetched the 2027 points/qualified page fresh -- Wheelchair still empty. Zero over-inclusion. Former-champion re-derivation: Samson Dauda (Mr Olympia) and Erin Banks (Men's Physique) both asterisked as Olympia winners -- corrected/added as former_champion. 6 win_pending_approval rows written earlier today (marco-ruz/212, lena-ramsteiner/Figure, anna-terzo/Ms Olympia, lenka-ferencukova/Women's Physique, sarah-terzenbach/Fit Model, michaela-pavleova/Fitness) now confirmed on IFBB's page -- flipped to the mirrored NULL method. Under-inclusion: 212 +1 (Wei Li), Classic Physique +10, Men's Physique +6 (plus Erin Banks), Bikini +5, Wellness +5 (2 resolved via IFBB's own single-character typos: Elisa Alcantaraq->elisa-alcantara, Yiribeth Cantillo Roigoza->yiribeth-cantillo-raigoza; 2 new athletes created: jesus-anchundia, valeria-werli-rojas), Figure +1 (Jennifer Zienert). Points mismatches corrected to IFBB's published number (reflecting San Antonio Pro/Titans Grand Prix Pro/Janet Layug's Battle of the Bodies Pro/Huanji Xi'an China Pro, which deliberately deferred their standings impact to this audit): Men's Physique li-xiaolong 10->13, alexander-toplyn 6->8, jiang-kun-zhi 3->5; Bikini cynthia-chen 4->14, wu-bi 3->7, jiaqi-wei 2->5, rania-stamatiadou 2->5. Dense re-ranked Classic Physique/Men's Physique/Bikini/Wellness. STEP 2: re-fetched the 2026 competitors roster -- its own updated timestamp (2026-09-10T19:23:54Z) is identical to both the 2026-09-11 and this morning's 2026-09-13 reads; unchanged, nothing to mirror. manual_review_count=0 -- both REVIEW name matches were confident IFBB-typo resolutions (trailing letter / single-vowel swap), not genuine ambiguity.
Sep 11, 2026 reconciliation-audit no differences
STEP 1: fetched https://www.ifbbpro.com/2027-olympia-qualified-athletes-point-standings/ directly (HTTP 200, no interstitial), read all 12 tablepress-NN tables by id. 9 of 12 divisions genuinely empty, matching zero DB rows. Mr Olympia (1, Regan Grimes/auto_win), Men's Physique (15) and Bikini (10) matched our existing season_year=2027 rows exactly point-for-point, zero drift since 2026-09-09 including pre-existing unresolved IFBB-side spelling renderings (Omar Sulieman/Suleiman, Shayan Parvez/Parvaz, Bi Wu/Wu Bi). No former-champion or pending-approval rows exist yet for 2027; elizabeth-hunter (fit-model, 2026, win_pending_approval) remains correctly pending. Zero over/under-inclusion, zero points mismatches across all 12 divisions. STEP 2: re-fetched https://www.ifbbpro.com/2026-olympia-competitors/ fresh (page's own updated timestamp 2026-09-10T15:23:54-04:00). All 352 roster rows across 12 divisions programmatically matched to an athlete already qualified=true in the correct division for season_year=2026 (slug/alias/known_as/full_name resolution), working through several IFBB-side name-spacing/typo quirks, none clearing the our-side-typo bar. Zero new athletes, zero new standings rows needed. Per-division DB-vs-roster counts reconcile exactly against 21 confirmed qualified=true/absent-from-roster rows (mostly real-method holders: auto_win, top_placing_prior_olympia, former_champion, win_pending_approval), all left untouched per the never-remove rule. Classic Physique (50->49) and Bikini (48->47) each dropped one roster row since 2026-09-09, most plausibly the mirror-only rows matheus-menegate-piccioli and alice-rocha, matching the same pattern as prior passes' named absences (Alcione Santos Barreto, Saionara Rebelo, Karla Sanchez) -- named as observed, not investigated or acted on. manual_review_count=0 -- a genuinely clean pass.
Sep 9, 2026 reconciliation-audit no differences
STEP 1: fetched https://www.ifbbpro.com/2027-olympia-qualified-athletes-point-standings/ directly (HTTP 200, no interstitial), read all 12 tablepress-NN tables by id. 9 of 12 divisions genuinely empty, matching zero DB rows. Mr Olympia (1, Regan Grimes/auto_win), Men's Physique (15) and Bikini (10) matched our existing season_year=2027 rows exactly point-for-point, zero drift since 2026-09-07 including pre-existing unresolved IFBB-side spelling renderings (Omar Sulieman/Suleiman, Shayan Parvez/Parvaz). No former-champion or pending-approval rows exist yet for 2027. Zero over/under-inclusion, zero points mismatches across all 12 divisions. STEP 2: re-fetched https://www.ifbbpro.com/2026-olympia-competitors/ fresh (page's own updated timestamp 2026-09-08); divisions assigned by fixed table order (no heading text precedes each table in the raw HTML on this pull). Counts unchanged from the 2026-09-07 mirror in 9 of 12 divisions; Wellness held at 41 (already down from 42 as of 2026-09-07). Two NEW absences since 2026-09-07: Alcione Santos Barreto (Women's Bodybuilding) and Saionara Rebelo (Figure) -- both confirmed still qualified=true/method=NULL in the DB, left untouched per the mirror's explicit never-remove rule (a withdrawal-or-otherwise question this routine does not investigate). Every remaining roster name matched an athlete already qualified=true in the DB via slug/known_as/full_name lookup, working through several of IFBB's own recurring name-spacing and typo quirks (Manual Angelo, Johne Jhoninho, Rodni Nelson, Dilson Espindola, Leyvina Rodrigues Barros, Reyna Perez, Sanda Colorado Acal, Raeli Dias, Tamera Barrett), none clearing the our-side-typo bar. Zero new athletes, zero new standings rows needed in either step. manual_review_count=0 -- a genuinely clean pass.
Sep 7, 2026 reconciliation-audit no differences
Resumed and completed under the rewritten reconciliation-audit skill (dual-source: OPEN_YEAR=2027 points/qualified ladder + LOCKED_YEAR=2026 competitors roster, both determined fresh from qualification_standings). STEP 1: fetched https://www.ifbbpro.com/2027-olympia-qualified-athletes-point-standings/ directly (HTTP 200, no interstitial), read all 12 tablepress-NN tables by id. 9 of 12 divisions are genuinely empty this early in the cycle, matching zero DB rows. Men's Physique (15) and Bikini (10) matched our existing season_year=2027 rows exactly point-for-point (seeded earlier today from the same page; zero drift on re-fetch). Mr Olympia's single row, Regan Grimes, confirmed IFBB now publishes him -- flipped his qualification_method from win_pending_approval to auto_win per functions/_shared.js's documented "flips to auto_win the moment the IFBB publishes" contract. No former-champion rows exist yet for 2027. STEP 2: re-fetched https://www.ifbbpro.com/2026-olympia-competitors/ fresh; all 335 currently-listed names (336 this morning) matched athletes already correctly mirrored by 2026-09-07_olympia-2026-competitors-mirror.sql, working through several of IFBB's own name-spacing/typo quirks that do not clear the our-side-typo bar. One name from this morning, Karla Sanchez (Wellness), is no longer listed -- left untouched per the mirror's explicit never-remove rule; a genuine identity/status question this routine does not investigate, not an automatic un-qualify. Zero new athletes, zero new standings rows needed in either step. manual_review_count=0 -- a genuinely clean pass once the source disruption was worked through.
Sep 5, 2026 reconciliation-audit no differences
Diffed all 12 divisions' full ladders against ifbbpro.com/olympia-qualified-athletes/ (raw HTML tablepress parse via curl-with-cookie-jar past the site's JS "One moment, please" interstitial, then a Python/BeautifulSoup parse -- each fusion-tab nav link resolved to its own tab-content div and that div's own table, so divisions cannot mispair). Parsed counts today (Mr Olympia 24, 212 24, Classic Physique 214, Men's Physique 167, Wheelchair 20, Ms Olympia 12, Fitness 11, Figure 34, Bikini 163, Women's Physique 18, Wellness 121, Fit Model 18) identical to 2026-09-01's and 2026-09-03's parses -- the page is unchanged since then. Zero over-inclusions, zero under-inclusions across all 12 -- every IFBB row matched an existing CalloutIQ standings row once known spelling/formatting variants (word-order swaps, a hyphen/apostrophe rendering, IFBB's own typos, a shorter/fuller legal-name form -- none met the "clear typo on our side" bar) were resolved by exact country/points agreement, re-checked row-by-row against qualification_standings queried fresh rather than assumed from a prior file. Four points disagreements re-verified against sourced results and left unchanged, same established pattern as every prior pass since 2026-08-24: abdullah-albalooshi and siqi-zhang (Men's Physique), rachel-linares and winitchanok-shao (Bikini) all have DB values matching their own sourced results, with IFBB's aggregate ladder stale or self-contradictory; the Navid Ali / Seyedaali Nejad Seyednavid Men's Physique double-listing is confirmed still open on IFBB's own page (10 vs 16) but is a resolved, recurring IFBB-side artifact per CLAUDE.md's explicit note on this exact case, so it is named here rather than added to manual_review_count. One win_pending_approval row (elizabeth-hunter, Fit Model) confirmed still correctly pending -- not on IFBB's page under either name variant. Re-derived the former-champion set fresh across all 12 divisions (24 asterisked names, unchanged from every pass since 2026-08-31): 8 correctly locked as former_champion (brandon-curry, samson-dauda, erin-banks, harold-kelley, james-berger, karol-milewski, natalia-abraham-coelho, sarah-villegas), 16 correctly not locked (higher-priority qualifying route this cycle, or jeremy-buendia who IFBB itself has not locked). manual_review_count=0 -- a genuinely clean pass, no open items, no changes from 2026-09-03's state.
Sep 3, 2026 reconciliation-audit no differences
Diffed all 12 divisions' full ladders against ifbbpro.com/olympia-qualified-athletes/ (raw HTML tablepress parse, each fusion-tab nav link resolved to its own tab-content div and that div's own table -- divisions cannot mispair). Parsed counts today (Mr Olympia 24, 212 24, Classic Physique 214, Men's Physique 167, Wheelchair 20, Ms Olympia 12, Fitness 11, Figure 34, Bikini 163, Women's Physique 18, Wellness 121, Fit Model 18) identical to 2026-09-01's parse -- the page is unchanged since then. Zero over-inclusions, zero under-inclusions across all 12 -- every IFBB row matched an existing CalloutIQ standings row once known spelling/formatting variants (word-order swaps, a hyphen-vs-space rendering, IFBB's own typos, a comma or suffix rendering, a shorter/fuller legal-name form -- none met the "clear typo on our side" bar) and several rows whose DB full_name already matches IFBB's printed name exactly under a shorter slug were resolved by name-similarity plus exact country/points agreement. New observation, not a defect: IFBB's own Bikini panel now double-lists Winitchanok Shao (a stale "1" alongside a new "4" that matches our DB total exactly) -- IFBB's own page now confirms the number we already had sourced. Four points disagreements re-verified against sourced results and left unchanged, same established pattern as every prior pass since 2026-08-24: abdullah-albalooshi and siqi-zhang (Men's Physique), rachel-linares and winitchanok-shao (Bikini) all have DB values matching their own sourced results, with IFBB's aggregate ladder stale or self-contradictory; the Navid Ali / Seyedaali Nejad Seyednavid Men's Physique double-listing is confirmed still open on IFBB's own page (10 vs 16) but is a resolved, recurring IFBB-side artifact per CLAUDE.md's explicit note on this exact case, so it is named here rather than added to manual_review_count. One win_pending_approval row (elizabeth-hunter, Fit Model) confirmed still correctly pending -- not yet on IFBB's page under either name variant. Re-derived the former-champion set fresh across all 12 divisions (24 asterisked names, unchanged from every pass since 2026-08-31): 8 correctly locked as former_champion (brandon-curry, samson-dauda, erin-banks, harold-kelley, james-berger, karol-milewski, natalia-abraham-coelho, sarah-villegas), 16 correctly not locked (higher-priority qualifying route this cycle, or jeremy-buendia who IFBB itself has not locked). manual_review_count=0 -- a genuinely clean pass, no open items, no changes from 2026-09-01's state.
Sep 1, 2026 reconciliation-audit no differences
Diffed all 12 divisions' full ladders against ifbbpro.com/olympia-qualified-athletes/ (raw HTML tablepress parse, each fusion-tab nav link resolved to its own tab-content div and that div's own table -- divisions cannot mispair). Zero over-inclusions, zero under-inclusions across all 12 -- every IFBB row matched an existing CalloutIQ standings row once known spelling/formatting variants (word-order swaps, a hyphen-vs-space rendering, IFBB's own typo, a comma rendering, a shorter/fuller legal-name form -- none met the "clear typo on our side" bar) were resolved by name-similarity plus exact country/points agreement. Four points disagreements re-verified against sourced results and left unchanged, same established pattern as every prior pass since 2026-08-24: abdullah-albalooshi and siqi-zhang (Men's Physique), rachel-linares and winitchanok-shao (Bikini) all have DB values matching their own sourced results, with IFBB's aggregate ladder stale or self-contradictory; the Navid Ali / Seyedaali Nejad Seyednavid Men's Physique double-listing is confirmed still open on IFBB's own page (10 vs 16) but is a resolved, recurring IFBB-side artifact per CLAUDE.md's explicit note on this exact case, so it is named here rather than added to manual_review_count. One win_pending_approval row (elizabeth-hunter, Fit Model) confirmed still correctly pending -- not yet on IFBB's page under either name variant. Re-derived the former-champion set fresh across all 12 divisions (24 asterisked names, unchanged from 2026-08-31): 8 correctly locked as former_champion (brandon-curry, samson-dauda, erin-banks, harold-kelley, james-berger, karol-milewski, natalia-abraham-coelho, sarah-villegas), 16 correctly not locked (higher-priority qualifying route this cycle, or jeremy-buendia who IFBB itself has not locked). manual_review_count=0 -- a genuinely clean pass, no open items, no changes from 2026-08-31's state.
Aug 31, 2026 reconciliation-audit no differences
Diffed all 12 divisions' full ladders against ifbbpro.com/olympia-qualified-athletes/ (raw HTML tablepress parse, each fusion-tab nav link resolved to its own tab-content div and that div's own table -- divisions cannot mispair). Scope widened from the prior 9-division passes to all 12 (Wheelchair, Women's Physique, Fit Model included) per CLAUDE.md's current "all 12 IFBB Pro League divisions" statement and the go-live plan's Phase 4, which had named this routine among the files still needing the 9->12 update. Zero over-inclusions, zero under-inclusions across all 12 -- every IFBB row matched an existing CalloutIQ standings row once known spelling variants (IFBB-side typos, shorter/fuller name forms -- none met the "clear typo on our side" bar) were resolved by name-similarity plus exact country/points agreement. Five points disagreements re-verified against sourced results and left unchanged, same established pattern as prior passes: abdullah-albalooshi and siqi-zhang (Men's Physique), rachel-linares and winitchanok-shao (Bikini) all have DB values matching their own sourced results, with IFBB's aggregate ladder stale or self-contradictory; the Navid Ali / Seyedaali Nejad Seyednavid Men's Physique double-listing is confirmed still open on IFBB's own page (10 vs 16) but is a resolved, recurring IFBB-side artifact per CLAUDE.md's explicit note on this exact case, so it is named here rather than added to manual_review_count. One win_pending_approval row (elizabeth-hunter, Fit Model) confirmed still correctly pending -- not yet on IFBB's page under either name variant. Re-derived the former-champion set fresh across all 12 divisions (24 asterisked names, up from 19 at 9-division scope): 8 correctly locked as former_champion (adding Wheelchair's James Berger/Harold Kelley/Karol Milewski and Women's Physique's Natalia Abraham Coelho/Sarah Villegas to the previously-confirmed Brandon Curry/Samson Dauda/Erin Banks), 16 correctly not locked (higher-priority qualifying route this cycle, or jeremy-buendia who IFBB itself has not locked). manual_review_count=0 -- a genuinely clean pass, no open items.
Aug 30, 2026 reconciliation-audit no differences
Diffed all 9 divisions' full ladders against ifbbpro.com/olympia-qualified-athletes/ (raw HTML tablepress parse, each fusion-tab nav link resolved to its own tab-content div and that div's own table -- divisions cannot mispair). Zero over-inclusions, zero under-inclusions -- every IFBB tracked-division row matched an existing CalloutIQ standings row once spelling variants (IFBB-side typos, shorter/reordered names, alt. transliterations -- none met the "clear typo on our side" bar) were resolved by name-similarity plus exact country/points agreement. Two win_pending_approval standings resolved to auto_win now that IFBB has published them: lauren-calderoni (Figure) and anastasia-korableva (Women's Bodybuilding). One points disagreement re-verified and left unchanged, same established pattern as abdullah-albalooshi/rachel-linares from prior passes: siqi-zhang (Men's Physique, DB=0 matches his own sourced results, IFBB ladder=1 contradicts IFBB's own competition pages) and winitchanok-shao (Bikini, DB=4 is ahead of IFBB's stale ladder=1 via an already-sourced Oklahoma Showdown of Champions result from the day before this pass) -- both DB values kept over the stale/wrong aggregate ladder number. Re-derived the former-champion set fresh from this page's own asterisk markers across all 9 divisions (19 names) -- exact match against existing qualification_method values, no changes needed; jeremy-buendia confirmed still not locked by IFBB (asterisk is informational only, plain points-table entry). A live request mid-run asked this pass to also cover Wheelchair/Women's Physique/Fit Model; declined -- docs/wheelchair-physique-fitmodel-go-live-plan.md, written today, explicitly holds this routine at 9 divisions until the Phase 3 is_public flip, to avoid claiming coverage those three divisions don't have depth for yet. Open: the recurring Navid Ali / Seyedaali Nejad Seyednavid double-listing on IFBB's own Men's Physique page, unchanged since 2026-08-17, not merged or guessed at. The dani-cfuentes/dani-cifuentes duplicate flagged 2026-08-29 was resolved by a separate merge earlier today and is not carried forward. manual_review_count=1. UPDATE (later same day): the Navid Ali / Seyedaali Nejad Seyednavid item above is now closed, not open -- athlete_slug_aliases.note for navid-ali (added 2026-07-30) already resolved both the identity (same person) and the points question (16 is correct; the 10-pt "Navid Ali" listing is the Philippines Pro win already counted inside it). CLAUDE.md now documents this explicitly so future passes stop re-flagging it. manual_review_count corrected 1 -> 0.
Aug 29, 2026 reconciliation-audit 2 items to resolve
Diffed all 9 divisions' full ladders against ifbbpro.com/olympia-qualified-athletes/. The cleanest pass on record: zero over-inclusions, zero under-inclusions -- every IFBB tracked-division row matched an existing CalloutIQ standings row once IFBB-side spelling variants and shorter-name printings were resolved by name-similarity + exact points agreement (none met the "clear typo on our side" bar, so no full_name changes made). Only four points disagreements found, all four pre-existing documented non-defects re-verified against `results` and unchanged: jose-manuel-munoz/Josema Munoz double-listing (auto_win-locked, no ladder value to reconcile), abdullah-albalooshi (DB=1 matches his own results pages; IFBB ladder=2 contradicts IFBB's own scorecards, not re-topped-up), rachel-linares (DB=10 ahead of IFBB's stale ladder=8 via already-sourced results through Pacific USA XXXII Pro), and the open Navid Ali / Seyedaali Nejad Seyednavid double-listing (16 vs 10, unchanged, stays in manual review). Re-derived the former-champion set fresh from this page's own asterisk markers across all 9 divisions (19 names) -- exact match against existing qualification_method values, no changes needed. No former_champion_pending_approval or win_pending_approval rows exist to resolve. New this pass: re-checking the 2026-08-27 under-inclusion insert (dani-cfuentes) against the existing roster surfaced dani-cifuentes (full_name Dani Smagalla, known_as Dani Cifuentes) as a probable duplicate of the same Puerto Rico bikini athlete -- same country, same division, same points total (3), a one-letter name difference, and a pre-existing sourced career history summing to exactly that points total. Strong circumstantial evidence, but not IFBB confirming identity, so not merged or guessed at -- added fresh to manual_review_count for a human identity call. manual_review_count=2 (the recurring Navid Ali double-listing, carried over; the new dani-cfuentes/dani-cifuentes probable duplicate).
Aug 27, 2026 reconciliation-audit 1 item to resolve
Diffed all 9 divisions' full ladders against ifbbpro.com/olympia-qualified-athletes/. One genuine under-inclusion found and fixed: Dani Cfuentes (Puerto Rico, Bikini, 3 pts) added as a new athlete, transcribed exactly as IFBB spelled it, standings-only (no sourced contest placement within this routine's scope). Zero over-inclusions. Zero new points mismatches -- the same four pre-existing documented non-defects from the last several passes (jose-manuel-munoz/Josema Munoz double-listing, abdullah-albalooshi DB=1 vs IFBB ladder=2, rachel-linares DB=10 vs IFBB ladder=8, and the open Navid Ali / Seyedaali Nejad Seyednavid double-listing) remain unchanged and re-verified against `results` where applicable. Re-derived the former-champion set fresh from this page's own asterisk markers across all 9 divisions (17 names) -- exact match against existing qualification_method values, no changes needed. No former_champion_pending_approval or win_pending_approval rows exist to resolve. Noted but not actionable: two points-ladder rows (zhivko-petkov, jason-huynh) now show as IFBB-"Qualified" ahead of OQS_CLOSE (2026-08-30) while still classified qualification_method=points in CalloutIQ -- already qualified=true (correct outcome), no allowlisted "locked via points" method exists to reclassify into, and this self-resolves automatically at OQS_CLOSE per functions/_shared.js's own design. Open: the recurring Navid Ali / Seyedaali Nejad Seyednavid double-listing on IFBB's own Men's Physique page, unchanged since 2026-08-17 -- not merged or guessed at.
Aug 25, 2026 reconciliation-audit 1 item to resolve
Diffed all 9 divisions' full ladders against ifbbpro.com/olympia-qualified-athletes/. Zero over-inclusions, zero under-inclusions -- all 758 IFBB tracked-division rows matched an existing CalloutIQ standings row once IFBB-side spelling variants were resolved by name-similarity + exact points agreement (none met the "clear typo on our side" bar, so no full_name changes made). Only four points disagreements found, all four pre-existing documented non-defects unchanged since 2026-08-24: jose-manuel-munoz/Josema Munoz double-listing (auto_win-locked, no ladder value to reconcile), abdullah-albalooshi (DB=1 matches his own results pages; IFBB ladder=2 contradicts IFBB's own scorecards, not re-topped-up), rachel-linares (DB=10 ahead of IFBB's stale ladder=8 via an already-sourced Pacific USA XXXII Pro result), and the open Navid Ali / Seyedaali Nejad Seyednavid double-listing (16 vs 10, unchanged, stays in manual review). Re-derived the former-champion set fresh from this page's own asterisk markers across all 9 divisions (17 names) -- exact match against existing qualification_method values, no changes needed. Resolved all three outstanding win_pending_approval standings now that IFBB has published them: breon-ansley (212), cherish-richardson (figure), stephanie-jones (fitness), all -> auto_win. Open: the recurring Navid Ali / Seyedaali Nejad Seyednavid double-listing on IFBB's own Men's Physique page, unchanged since 2026-08-17 -- not merged or guessed at.
Aug 24, 2026 reconciliation-audit 1 item to resolve
Diffed all 9 divisions' full ladders against ifbbpro.com/olympia-qualified-athletes/. Zero real over-inclusions. Added 6 missing 2026 standings rows (regan-grimes mens-open; wellington-mwangonde, siqi-zhang, ottavia-mazza on already-tracked athletes; megan-morrison as a brand-new athlete). Corrected 6 points mismatches (michael-daboul 13->16, florian-hartlage 9->13, adrian-cyronek 5->7, all classic-physique; alice-marchisio 19->21, maiwenn-crausaz 21->25, luca-katai 2->3, all bikini) -- 8 of the 8 new/corrected point values this run trace to one untranscribed show, Austrian Oak Pro 2026 (Classic Physique + Bikini, 2026-08-22/23, contest b87accfc-4131-484b-8541-be9be4003948), flagged for a dedicated transcribe-scorecard pass rather than attempted here. Resolved da-jeong-an (Figure) win_pending_approval -> auto_win now that IFBB has published her. Checked and deliberately left alone: abdullah-albalooshi (mens-physique, IFBB ladder still contradicts IFBB's own results pages -- re-verified 2026-08-23, not re-topped-up) and rachel-linares (bikini, DB correctly ahead of IFBB's stale ladder via an already-sourced result). Open: the recurring Navid Ali / Seyedaali Nejad Seyednavid double-listing on IFBB's own Men's Physique page (16 vs 10, open since 2026-08-17, unchanged today) -- not merged or guessed at.
Aug 23, 2026 reconciliation-audit 4 items to resolve
Diffed all 9 divisions' full ladders (not just Locked/Qualified) against ifbbpro.com/olympia-qualified-athletes/. Locked/Qualified invariant holds exactly in all 9 -- zero over- or under-inclusions once every name was correctly matched (~30 apparent mismatches turned out to be IFBB's own page misspelling an already-tracked athlete's name, confirmed by exact points agreement). Applied: Emanuel Hunter and Ying Chen Liu full_name corrections (one our-side typo, one stale merge leftover), Abdullah Albalooshi points 1->2 (mens-physique) with ladder renumber. Checked and left alone as currently correct: Alessia Facchin and Eugenia Shatova's bikini points, which are ahead of IFBB's page because it has not yet caught up to their Russia Pro (2026-08-22) results. Open: 3 likely-duplicate athlete-row pairs from prior ingests (jose-manuel-munoz-mens-open, kenneth-jones-de, momar-bah-mp) and the recurring IFBB Navid Ali/Seyedaali Nejad Seyednavid double-listing (16 vs 10, open since 2026-08-17) -- none merged or guessed at. REVERTED same day: the mens-physique points bump to 2 for Abdullah Albalooshi contradicted the exhaustive 317-event whole-calendar sweep from 2026-08-17 (ifbb-ladder-can-contradict-ifbb-results), which already proved his only scoring appearance is Huanji Harbin 5th (1 pt) and concluded "do not top up" -- IFBB's ladder disagreeing with its own results pages, not a missing show. An 80-show curl sweep of every Men's Physique contest in the window plus a direct check of the Aug 22-23 World of Monsterzym Asian Pro roster (he is entered, unscored, show not yet result-published) found no second result. Points reverted 2->1, ladder renumbered.
Aug 21, 2026 reconciliation-audit 125 items to resolve
Diffed all 9 divisions against ifbbpro.com/olympia-qualified-athletes/. No over-inclusions (all former_champion-locked athletes confirmed on IFBB's page). Found 6 full_name spelling/typo fixes (SQL drafted for user, not applied), 3 ambiguous name-spelling disagreements likely IFBB-side typos (flagged, no fix), and 122 points-ladder athletes below our tracked depth needing a dedicated sourced backfill (Bikini's full ladder alone accounts for 104 of these). Zero win_pending_approval/former_champion_pending_approval rows outstanding.
Aug 17, 2026 reconciliation-audit 3 items to resolve
Two passes. All 9 divisions + full points ladders re-diffed. Applied: A. Pereira (212) win_pending->auto_win, league published him after pass 1; 212 locked now 23. Open: S. Zhang, A. Albalooshi, and IFBB double-listing Navid Ali at 16 and 10.
Aug 16, 2026 reconciliation-audit 1 item to resolve
Second pass; IFBB caught up on Aug 14-16 after pass 1. Drafted: P. Moore win_pending->auto_win, G. Zancanelli points->auto_win, I. Kesek 24->25. Open: A. Albalooshi 1 vs IFBB 2 (unloaded show).
Aug 12, 2026 reconciliation-audit no differences
All 9 divisions checked vs ifbbpro.com, incl. full Classic/MP/Bikini/Wellness ladders. 8 matched exactly; Erin Banks (MP) moved from the ladder to Locked In as former_champion, ladder re-ranked.
Aug 10, 2026 reconciliation-audit 3 items to resolve
All 9 divisions vs ifbbpro.com. 2026 Lenda Murray (Aug 8-9) results unloaded for 212/CP/Wellness: Juan Aleman 212 win missing, Rosemary Rodriguez ladder->locked, 6 points totals stale, 130 ladder ranks drifted. Fixes drafted.
Aug 9, 2026 reconciliation-audit no differences
All 9 divisions reconciled to the IFBB list. Applied: 4 win-based winners + Corey Morris auto_win, 14 points corrections, 4 new standings (all from the 2026-08-08/09 shows), plus both cutline ties resolved by mirroring IFBB's published ladder order.
Aug 7, 2026 reconciliation-audit 1 item to resolve
All 9 divisions checked vs ifbbpro.com. Applied: Samson Dauda re-listed -> former_champion standing restored (Men's Open locked 20->21); 2 untracked Classic tail athletes added (Sadeq Al-Saedi 4, Tahir Ahmed 1) from 2025 Iraq Muscle Show Pro, ladder resequenced, cutline unchanged. All other locked sets and points totals matched exactly. No pending-approval rows. Re-diffed clean.
Aug 3, 2026 reconciliation-audit 2 items to resolve
All 9 divisions vs ifbbpro.com. Locked sets + all ladder points matched exactly. 2 Classic Physique tail athletes missing (Sadeq Al-Saedi 4pts, Tahir Ahmed 1pt) - fix drafted.
Aug 2, 2026 reconciliation-audit no differences
All 9 divisions vs ifbbpro.com (post-Tampa refresh). Applied: 2 promotions, 21 point totals, 4 new standings, rank recompute, 6 win_pending resolved, Chuan Wang mirrored, 5 name/country items closed. 0 open.
Jul 30, 2026 reconciliation-audit no differences
All 9 divisions vs IFBB; all 9 locked sets match EXACTLY, 0 open items. Curry locked in, 2 promotions, 3 demotions, 8 ladder rows, navid-ali + nick-koeu re-merged behind a new DB guard, Andre Ferguson + Rosemary Rodriguez root-caused, 2026 Nevada State Pro (missing contest) transcribed in full.
Jul 27, 2026 reconciliation-audit 9 items to resolve
Checked all 9 divisions vs IFBB's page. Drafted 3 method-bucketing fixes, 2 calendar-gap contests, 1 country fix. 9 low-value Bikini/Wellness tail entries left for manual review. | Same-day weekend-results reconciliation: Vancouver Pro (Classic Physique 8/8, Men's Physique 17/17, Bikini 17/17, Wellness 9/9) and Gomeisa Ultimate Battle Pro (Classic Physique 15/15, Men's Physique 7/7 + 1 NS, Figure 10/10, Bikini 14/14, Wellness 9/9), all official IFBB Pro competition-page scorecards, all athletes already tracked (0 new). Found and fixed an 8-athlete points-layering bug (CP/MP) and a pre-existing rank-duplication bug affecting all 4 points divisions (CP/MP/Bikini/Wellness) -- full resequence applied to all 4. Cutline effects: CP +2 qualified (jorge-herrera, tae-min-jung -- dedup fix, not this weekend's results), MP none, Bikini none, Wellness -2 qualified (rosemary-rodriguez, catia-moreira -- Wellness cutline bisects a 5-way tie at 10 points; rosemary-rodriguez is this weekend's Gomeisa winner, newest arrival at that value, IFBB's tiebreak to make, not ours). Figure: saionara-rebelo (Gomeisa winner) qualifies outright, win-based, no ladder change needed. Kellen Wilson (CP) and Rania Stamatiadou (Bikini) each now have a 2026-window win but stay qualification_method=points -- IFBB's live page lists both with a point number, not "Qualified". CONTENDERS_CACHE_VERSION bumped 32->33 for the 4 qualified-flag flips.
Jul 26, 2026 reconciliation-audit 3 items to resolve
Two passes today. (1) Bikini vs ifbbpro.com/olympia-qualified-athletes (tablepress-65, 141 athletes): baseline exact, 0 point discrepancies; layered 2026 Arkansas Pro results on top (Watchman 12->22 rank 24->8, Pike 12->16, Hampton 14->17, Facchin 11->12, Schwartz new at 2); no cutline change; added missing torey-braly row and closed two pre-existing rank gaps. (2) Huanji Chengdu China Pro (Huanji series leg 3) across all 7 tracked divisions: win-based Men's Open/212/Figure each gained one new outright qualifier (behrooz-tabani, xiaoshuang-lan, xinyu-chen); points divisions Classic Physique (tablepress-36, 197 rows checked, 1 pre-existing gap: Josema Munoz), Men's Physique (tablepress-61, 155 rows checked, 1 pre-existing gap: Andre Ferguson double-listed), Bikini (re-checked, same-day Arkansas figures correctly still ahead of IFBB's page), and Wellness (tablepress-67, 104 rows checked, 0 discrepancies) each had Chengdu STANDARD_PTS layered onto existing totals -- 11 new standings rows total, no cutline changes in any of the four. Open manual-review items: Priscila Santana Pereira (Bikini, 3 pts, unmatched), Josema Munoz (Classic Physique, 12 pts, no standings row), Andre Ferguson (Men's Physique, double-listed on IFBB's own page at 4/3 pts) -- none in either show's field, left for a dedicated coverage pass.
Jul 20, 2026 reconciliation-audit no differences
Re-verified all 4 divisions via raw IFBB fetch. Todays earlier CP/MP fixes hold; gaps trace to unpublished recent wins. New: Livinho Arnold CSA missing points_earned (draft SQL provided).
Jul 9, 2026 reconciliation-audit no differences
Reconciled all four divisions' official-qualifier lists against ifbbpro.com/olympia-qualified-athletes. Men's Open 17/17, 212 16/16, Classic Physique 18/18 auto, Men's Physique 21/21 auto -- all exact matches by name and count. Points-projection (top-25) is CalloutIQ's calculated model; IFBB has not officially cut points (window open). Nothing to correct; 0 items for manual review.
Jul 6, 2026 reconciliation-audit no differences
Checked all 4 divisions against ifbbpro.com/olympia-qualified-athletes/. Found and fixed Hai Dang Hoang (Men's Physique) points mismatch. Everything else matched.

Identity corrections

Two athlete rows turning out to be one person, or one show turning out to already exist under a different name, is a real and recurring event in a sport with this many name spellings, promoters and languages. 296 athlete and 38 contest records have been merged.

A correction here never costs anyone a link. The retired name on the left still resolves — click it and you land on the record it was merged into. That’s enforced in the database rather than remembered: a dead name that shadows a live one is rejected, and so is a new record trying to take a name a merge retired.

The evidence behind each merge — the specific score card, row and placing, the federation profile, the identity checks — is recorded against it, and is not reproduced here. Those notes routinely quote an athlete’s own social profiles, gym or home city to establish that two spellings are one person, and this site doesn’t publish those things about anyone. The correction is public; the working stays internal. Ask about any specific one through the report form and it’ll be explained.

Athletes

Contests

What this page does not cover

This is not every correction ever made, and saying otherwise would be its own small dishonesty. It is the two kinds this project records in a queryable form. Fixes to an individual result — a misread placing, a score corrected against the card, a date put right — go through a reviewed SQL file in the repository, each one carrying its own written reasoning, and those live in version control rather than in a table this page can read. If a specific figure here looks wrong, report it; that is the fastest route to it being checked, and corrections get made.

How complete the underlying data is, measured live: the coverage report. How any of it is sourced: Source & Attribution.