Many pages break on multilingual on 4.7.18

4.7.18 has a regression due to this line added for CRM-20199 in CRM_Core_BAO_OptionGroup::getTitlesByNames:

$dao = CRM_Core_DAO::executeQuery("SELECT name, title FROM civicrm_option_group");

The real problem is in CRM-19093 though - the regex in CRM_Core_I18n_Schema::rewriteQuery is a little flawed.  The change in CRM-19093 causes a SQL statement that ends with a table name that needs translation to not be translated.

My regex-fu isn't solid enough to provide a real solution here - but the workaround is to to add a space after civicrm_option_group in the line I identified above.

Samuel Vanhove, can I assign this to you since you wrote the regex?  You can trigger this bug by going to the Search Builder page on a 4.7.18 multi-lingual install.