Index: branches/5.2.x/core/units/helpers/list_helper.php =================================================================== diff -u -N -r14782 -r14865 --- branches/5.2.x/core/units/helpers/list_helper.php (.../list_helper.php) (revision 14782) +++ branches/5.2.x/core/units/helpers/list_helper.php (.../list_helper.php) (revision 14865) @@ -1,6 +1,6 @@ addFilter('navigation_filter', $where_clause); // do extractCalculatedFields (transforms having into where), since we don't select fields from JOINed tables - $sql = str_replace('%1$s', $list->TableName, $list->extractCalculatedFields($list->GetSelectSQL())); + $sql = $list->extractCalculatedFields($list->GetSelectSQL(), 1, true); $list->removeFilter('navigation_filter'); $list->setOrderFields($order_fields_backup);