Disk full (/var/tmp/#sql_20cc_3); waiting for someone to free some space...
query=SELECT products.*, min(products_atts.price) as pricefrom, min(products_atts.pricex) as pricexfrom, count(products_atts.product_id) as attcount from prodcat_weight_sync inner join products on products.prod_id=prodcat_weight_sync.prod_id left join products_atts on products.id=products_atts.product_id WHERE prodcat_weight_sync.synckey='IB975wm9kMMz2Cm5x5X0' group by products.id