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