Index: trunk/admin/category/addcategory_relations.php =================================================================== diff -u -r374 -r661 --- trunk/admin/category/addcategory_relations.php (.../addcategory_relations.php) (revision 374) +++ trunk/admin/category/addcategory_relations.php (.../addcategory_relations.php) (revision 661) @@ -317,13 +317,13 @@ $SearchWords = $objSession->GetVariable("CatRelSearchWord"); if(strlen($SearchWords)) { - $where = $objRelList->AdminSearchWhereClause($SearchWords); + $having = $objRelList->AdminSearchWhereClause($SearchWords); } else - $where = ""; + $having = ""; -if(strlen($where)) - $sql .= " AND ($where)"; +if(strlen($having)) + $sql .= " HAVING ($having)"; if(strlen(trim($objConfig->Get($SortFieldVar)))) {