D327.diff
No OneTemporary
Actions

Subscribers

None

File Metadata

	Index: branches/5.2.x/core/units/reviews/reviews_event_handler.php
	===================================================================
	--- branches/5.2.x/core/units/reviews/reviews_event_handler.php
	+++ branches/5.2.x/core/units/reviews/reviews_event_handler.php
	@@ -585,9 +585,12 @@
	$item_table = $this->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