Index: branches/RC/core/units/reviews/reviews_config.php
===================================================================
diff -u -r8929 -r9373
--- branches/RC/core/units/reviews/reviews_config.php	(.../reviews_config.php)	(revision 8929)
+++ branches/RC/core/units/reviews/reviews_config.php	(.../reviews_config.php)	(revision 9373)
@@ -125,11 +125,13 @@
 					LEFT JOIN '.TABLE_PREFIX.'PortalUser pu ON pu.PortalUserId = %1$s.CreatedById',
 
 			'products'	=> 	'	SELECT %1$s.* %2$s
-								FROM %1$s, '.TABLE_PREFIX.'Products pr
+								FROM %1$s 
+								LEFT JOIN '.TABLE_PREFIX.'Products pr ON pr.ResourceId = %1$s.ItemId
 					 			LEFT JOIN '.TABLE_PREFIX.'PortalUser pu ON	pu.PortalUserId = %1$s.CreatedById',
 
 			'product'	=> 	'	SELECT %1$s.* %2$s
-								FROM %1$s, '.TABLE_PREFIX.'Products pr
+								FROM %1$s 
+								LEFT JOIN '.TABLE_PREFIX.'Products pr ON pr.ResourceId = %1$s.ItemId
 								LEFT JOIN '.TABLE_PREFIX.'PortalUser pu ON	pu.PortalUserId = %1$s.CreatedById',
 		),