SQLSTATE[HY000]: General error: 1021 Disk full (/tmp/#sql-temptable-234-90520-a83d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (Connection: mysql, SQL: select distinct `ec_products`.*, `ec_products`.`with_storehouse_management`, `ec_products`.`stock_status`, `ec_products`.`quantity`, `ec_products`.`allow_checkout_when_out_of_stock` from `ec_products` inner join ( SELECT DISTINCT ec_products.id, CASE WHEN ( ec_products.sale_type = 0 AND ec_products.sale_price <> 0 ) THEN ec_products.sale_price WHEN ( ec_products.sale_type = 0 AND ec_products.sale_price = 0 ) THEN ec_products.price WHEN ( ec_products.sale_type = 1 AND ( ec_products.start_date > '2025-07-18 23:56:26' OR ec_products.end_date < '2025-07-18 23:56:26' ) ) THEN ec_products.price WHEN ( ec_products.sale_type = 1 AND ec_products.start_date <= '2025-07-18 23:56:26' AND ec_products.end_date >= '2025-07-18 23:56:26' ) THEN ec_products.sale_price WHEN ( ec_products.sale_type = 1 AND ec_products.start_date IS NULL AND ec_products.end_date >= '2025-07-18 23:56:26' ) THEN ec_products.sale_price WHEN ( ec_products.sale_type = 1 AND ec_products.start_date <= '2025-07-18 23:56:26' AND ec_products.end_date IS NULL ) THEN ec_products.sale_price ELSE ec_products.price END AS final_price FROM ec_products ) AS products_with_final_price on `products_with_final_price`.`id` = `ec_products`.`id` where `status` = published and exists (select * from `ec_product_collections` inner join `ec_product_collection_products` on `ec_product_collections`.`id` = `ec_product_collection_products`.`product_collection_id` where `ec_products`.`id` = `ec_product_collection_products`.`product_id` and `ec_product_collection_products`.`product_collection_id` in (5)) and `ec_products`.`is_variation` = 0 order by CASE WHEN ec_products.with_storehouse_management = 0 THEN CASE WHEN ec_products.stock_status = out_of_stock THEN 1 ELSE 0 END ELSE CASE WHEN ec_products.quantity <= 0 AND ec_products.allow_checkout_when_out_of_stock = 0 THEN 1 ELSE 0 END END ASC , `ec_products`.`order` asc, `ec_products`.`created_at` desc limit 8)