Index: branches/unlabeled/unlabeled-1.4.2/kernel/units/general/helpers/mod_rewrite_helper.php =================================================================== diff -u -r5942 -r5970 --- branches/unlabeled/unlabeled-1.4.2/kernel/units/general/helpers/mod_rewrite_helper.php (.../mod_rewrite_helper.php) (revision 5942) +++ branches/unlabeled/unlabeled-1.4.2/kernel/units/general/helpers/mod_rewrite_helper.php (.../mod_rewrite_helper.php) (revision 5970) @@ -183,8 +183,8 @@ $query = 'SELECT ccd.l1_cust_'.$item_template_field_id.', FIND_IN_SET(c.CategoryId, '.$this->Conn->qstr($parent_path).') AS Ord1, c.CategoryId, c.Name, ccd.l1_cust_'.$item_template_field_id.' - FROM inp_Category AS c - LEFT JOIN inp_CategoryCustomData AS ccd + FROM '.TABLE_PREFIX.'Category AS c + LEFT JOIN '.TABLE_PREFIX.'CategoryCustomData AS ccd ON ccd.ResourceId = c.ResourceId WHERE c.CategoryId IN ('.$parent_path.') AND ccd.l1_cust_'.$item_template_field_id.' != \'\' ORDER BY FIND_IN_SET(c.CategoryId, '.$this->Conn->qstr($parent_path).') DESC';