Disk full (/mysql_tmp/#sql_73dc_42); waiting for someone to free some space...
query=SELECT products.*, min(products_atts.price) as pricefrom, min(products_atts.pricex) as pricefromx, 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 (1618403623, 1618410020, 1699363675, 1683022528, 1679299397) group by products.id ORDER BY field(products.prod_id, 1618403623, 1618410020, 1699363675, 1683022528, 1679299397) desc, id asc