On assetvs.com we run a programmatic SEO site comparing investment returns across 16 countries and 5 asset classes (stocks, bonds, real estate, bills, gold). The site has 3,655 URLs in the sitemap. Last week we discovered that 2,232 of them — every currency-pair page — were silently 404ing . This is the story of how one missing table turned a third of our site dark, and how a single World Bank endpoint brought it all back online in an afternoon. The architecture (quick recap) assetvs uses the same virtual-routing pattern we've written about before on the network : no wp_posts , just custom tables and rewrite rules. The relevant tables are: Table Rows Purpose wp_ir_countries 16 G7 + EU + ANZ + JP, ISO codes wp_ir_assets 5 stocks/bonds/real-estate/bills/gold wp_ir_annual_returns 3,955 nominal returns, country × asset × year wp_ir_inflation 976 for real-return calculation wp_ir_comparisons 100 full-period asset-vs-asset summaries wp_ir_exchange_rates 0 → 976 currency pair history That last row is the punchline.…