Index: branches/5.2.x/units/products/products_config.php
===================================================================
diff -u -N -r15468 -r15560
--- branches/5.2.x/units/products/products_config.php	(.../products_config.php)	(revision 15468)
+++ branches/5.2.x/units/products/products_config.php	(.../products_config.php)	(revision 15560)
@@ -1,6 +1,6 @@
 <?php
 /**
-* @version	$Id: products_config.php 15468 2012-07-23 17:08:07Z alex $
+* @version	$Id: products_config.php 15560 2012-10-09 16:04:33Z alex $
 * @package	In-Commerce
 * @copyright	Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
 * @license	Commercial License
@@ -509,10 +509,8 @@
 			            	'type' => 'int',
 			            	'formatter' => 'kLEFTFormatter',
 			            	'options' => Array (USER_ROOT => 'root', USER_GUEST => 'Guest'),
-			            	'left_sql' => 'SELECT %s FROM ' . TABLE_PREFIX . 'Users
-			            					WHERE `%s` = \'%s\'',
-			            	'left_key_field' => 'PortalUserId',
-			            	'left_title_field' => 'Username',
+			            	'left_sql' => 'SELECT %s FROM ' . TABLE_PREFIX . 'Users WHERE %s',
+			            	'left_key_field' => 'PortalUserId', 'left_title_field' => USER_TITLE_FIELD,
 							'error_msgs' => Array ('invalid_option' => '!la_error_UserNotFound!'),
 			            	'sample_value' => 'Guest', 'required' => 1, 'default' => NULL,
 						),
@@ -548,13 +546,13 @@
         				'ProcessingData'		=>	Array ('type' => 'string', 'default' => null),
 
 						'ShippingLimitation'	=>	Array ('type' => 'string', 'default' => NULL),
-						'AssignedCoupon'	=>
-								Array ('type' => 'int', 'not_null' => 1, 'default' => 0,
-											'formatter' => 'kLEFTFormatter',
-											'options' => Array (0 => 'None'),
-											'left_sql' => 'SELECT %s FROM '.TABLE_PREFIX.'ProductsCoupons WHERE `%s` = \'%s\'',
-											'left_key_field' => 'CouponId',
-											'left_title_field' => 'Name'),
+						'AssignedCoupon' => Array (
+							'type' => 'int',
+							'formatter' => 'kLEFTFormatter', 'options' => Array (0 => 'None'),
+							'left_sql' => 'SELECT %s FROM ' . TABLE_PREFIX . 'ProductsCoupons WHERE %s',
+							'left_key_field' => 'CouponId', 'left_title_field' => 'Name',
+							'not_null' => 1, 'default' => 0,
+						),
 						'MinQtyFreePromoShipping'	=>	Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
 						'MetaKeywords'			=>	Array ('type' => 'string', 'default' => null),
 	            		'MetaDescription'		=>	Array ('type' => 'string', 'formatter' => 'kFormatter', 'using_fck' => 1, 'default' => null),