OK :oops:
a mistake; when browsing categories i got on error on the p2c not beeing unique.
New fix, please forget the fix above (can a moderator delete it please??):
around line 15 replace
$str_pos_products = strpos($sql_lower,TABLE_PRODUCTS . ' p');
with
$str_pos_products = strpos($sql_lower,TABLE_PRODUCTS . ' p');
$str_pos_p2c = strpos($sql_lower,TABLE_PRODUCTS_TO_CATEGORIES . ' p2c');
around line 91 replace
$str_pos_products = strpos($sql_lower,TABLE_PRODUCTS . ' p');
$str_pos_p2c = strpos($sql_lower,TABLE_PRODUCTS_TO_CATEGORIES . ' p2c');
with
if ($str_pos_p2c!=true){
$sql = substr($sql,0,$add_pos).
" INNER JOIN ".TABLE_PRODUCTS_TO_CATEGORIES." p2c ON (p2c.products_id=p.products_id)
INNER JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd
ON (p2c.categories_id = cd.categories_id
AND cd.language_id=".$_SESSION['languages_id']."
AND cd.categories_description LIKE '%-".SITE_NAME."-%') ".
substr($sql,$add_pos);
}else{
$sql = substr($sql,0,$add_pos).
" INNER JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd
ON (p.master_categories_id = cd.categories_id
AND cd.language_id=".$_SESSION['languages_id']."
AND cd.categories_description LIKE '%-".SITE_NAME."-%') ".
substr($sql,$add_pos);
}