Index: branches/5.2.x/core/units/reviews/reviews_event_handler.php =================================================================== diff -u -N -r16692 -r16749 --- branches/5.2.x/core/units/reviews/reviews_event_handler.php (.../reviews_event_handler.php) (revision 16692) +++ branches/5.2.x/core/units/reviews/reviews_event_handler.php (.../reviews_event_handler.php) (revision 16749) @@ -1,6 +1,6 @@ Application->getUnitOption($regs[1], 'TableName'); $ci_table = $this->Application->getUnitOption('ci', 'TableName'); + /** @var array $list_sqls */ $list_sqls = $this->Application->getUnitOption($event->Prefix, 'ListSQLs'); - $list_sqls[''] .= ' LEFT JOIN '.$item_table.' item_table ON item_table.ResourceId = %1$s.ItemId'; - $list_sqls[''] .= ' LEFT JOIN '.$ci_table.' ci ON item_table.ResourceId = ci.ItemResourceId AND ci.PrimaryCat = 1'; + $list_sqls[''] .= PHP_EOL . 'LEFT JOIN ' . $item_table . ' item_table + ON item_table.ResourceId = %1$s.ItemId'; + $list_sqls[''] .= PHP_EOL . 'LEFT JOIN ' . $ci_table . ' ci + ON item_table.ResourceId = ci.ItemResourceId AND ci.PrimaryCat = 1'; $this->Application->setUnitOption($event->Prefix, 'ListSQLs', $list_sqls); // 2. add calculated field