Disk full (/mysql_tmp/#sql_73dc_42); waiting for someone to free some space...<br>query=SELECT products.*, min(products_atts.price) as pricefrom, count(products_atts.product_id) as attcount, products_images.filename as thefile from products left join products_atts on products.id=products_atts.product_id left join products_images on products.prod_id=products_images.prod_id and products_images.firstimg=1 where hidden=0 AND products.prod_id IN (1426013789, 1460103370, 1460104459, 1426012512) group by products.id ORDER BY field(products.prod_id, 1426013789, 1460103370, 1460104459, 1426012512) desc, id asc