Modified 2.0.6.0: Kategorie Keywords

        $where_str_cat .= " ) ";

        $listing_sql_categories = "Select * from ".TABLE_CATEGORIES." c LEFT JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd on c.categories_id = cd.categories_id where $where_str_cat AND cd.language_id = '".(int)$_SESSION['languages_id']."'";

        $categories_query = xtc_db_query($listing_sql_categories);

        while ($categories = xtc_db_fetch_array($categories_query)) {

           if(!in_array($categories['categories_id'], $arr_categories_affected)){

              $arr_categories_affected[]=$categories['categories_id'];

        while ($products_from_keywords = xtc_db_fetch_array($keywords_query)) {

           $arr_included_products[] = "'" . $products_from_keywords['products_id'] . "'";                  

        }     

           $listing_sql = str_replace("WHERE p.products_id IN (", "WHERE p.products_id IN (".join($arr_included_products, ",") . ",", $listing_sql);  

        }