Drupal Association members fund grants that make connections all over the world.
Joins using 'extra' numeric fields that require 'Views substitutions' are broken after the fix to db_safe() method. Because the fix to db_safe() applies the numeric rule before query substitutions are applied to the whole sql statement, that happens later.
Attached a patch that applies 'Views substitutions' before db_safe() is invoked.
Patch is against 6.x-2.14, though the problem may affect other versions of Views.