Index: core/units/reviews/reviews_event_handler.php =================================================================== --- core/units/reviews/reviews_event_handler.php +++ core/units/reviews/reviews_event_handler.php @@ -583,11 +583,13 @@ // 1. add join to items table (for "Structure & Data" -> "Reviews" section) $item_table = $this->Application->getUnitOption($regs[1], 'TableName'); + $item_table_on = 'item_table.ResourceId = %1$s.ItemId'; $ci_table = $this->Application->getUnitOption('ci', 'TableName'); + $ci_table_on = 'item_table.ResourceId = ci.ItemResourceId AND ci.PrimaryCat = 1'; $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_on; + $list_sqls[''] .= PHP_EOL . ' LEFT JOIN ' . $ci_table . ' ci ON ' . $ci_table_on; $this->Application->setUnitOption($event->Prefix, 'ListSQLs', $list_sqls); // 2. add calculated field @@ -633,4 +635,4 @@ $parent_prefix = $event->Application->getUnitOption($event->Prefix, 'ParentPrefix'); $event->SetRedirectParam('pass', 'm,' . $event->getPrefixSpecial() . ',' . $parent_prefix); } - } \ No newline at end of file + }