Disk full (/var/tmp/#sql_251d_2); waiting for someone to free some space...<br>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='824' and prodcat_weight.hidden='0' group by products.supplier