Index: branches/5.2.x/units/discount_items/discount_items_event_handler.php
===================================================================
diff -u -N -r14986 -r15009
--- branches/5.2.x/units/discount_items/discount_items_event_handler.php	(.../discount_items_event_handler.php)	(revision 14986)
+++ branches/5.2.x/units/discount_items/discount_items_event_handler.php	(.../discount_items_event_handler.php)	(revision 15009)
@@ -1,6 +1,6 @@
 <?php
 /**
-* @version	$Id: discount_items_event_handler.php 14986 2012-01-04 16:11:56Z alex $
+* @version	$Id: discount_items_event_handler.php 15009 2012-01-06 20:37:54Z alex $
 * @package	In-Commerce
 * @copyright	Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
 * @license	Commercial License
@@ -60,7 +60,7 @@
 			if ($prefix == 'c') {
 				// select all products from selected categories and their subcategories
 				$sql = 'SELECT DISTINCT p.ResourceId
-						FROM '.TABLE_PREFIX.'Category c
+						FROM '.TABLE_PREFIX.'Categories c
 						LEFT JOIN '.TABLE_PREFIX.'CategoryItems ci ON c.CategoryId = ci.CategoryId
 						LEFT JOIN '.TABLE_PREFIX.'Products p ON p.ResourceId = ci.ItemResourceId
 						WHERE (p.ProductId IS NOT NULL) AND (c.ParentPath LIKE "%|'.implode('|%" OR c.ParentPath LIKE "%|', $item_ids).'|%")';