Can't find record in 'prodcat_weight'
query=SELECT distinct(products.supplier), suppliers.supplier_name, count(*) as total from prodcat_weight inner join products on products.prod_id = prodcat_weight.prod_id inner join suppliers on suppliers.sid=products.supplier WHERE prodcat_weight.cat_id='126' and prodcat_weight.hidden='0' group by products.supplier