Disk full (/var/tmp/#sql_251d_0); 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='p8Y5yJoN1meekoPQl4cd' group by products.id