Anyway, open /includes/display/BrandProductListing.php, find:
Code: Select all
$result = $GLOBALS['ISC_CLASS_DB']->Query("SELECT * FROM [|PREFIX|]brands ORDER BY brandname ASC");
Code: Select all
$result = $GLOBALS['ISC_CLASS_DB']->Query(" SELECT brandid,
brandname,
brandpagetitle,
brandmetakeywords,
brandmetadesc,
brandimagefile,
brandsearchkeywords
FROM (SELECT prodname,
Sum(prodvisible) AS total,
prodbrandid
FROM [|PREFIX|]products
GROUP BY prodbrandid) AS checker
JOIN [|PREFIX|]brands b
ON b.brandid = prodbrandid
WHERE total > 0
ORDER BY brandname ASC");
![Very Happy :D](./images/smilies/icon_e_biggrin.gif)