Disk full (/mysql_tmp/#sql_73dc_42); waiting for someone to free some space...
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 (1649141603, 1649140902, 1649065811) group by products.id ORDER BY field(products.prod_id, 1649141603, 1649140902, 1649065811) desc, id asc