SQLSTATE[HY000]: General error: 1021 Disk full (/tmp/#sql_7128_38.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (Connection: mysql, SQL: select distinct `ec_products`.*, (select count(*) from `ec_reviews` where `ec_products`.`id` = `ec_reviews`.`product_id` and `status` = published) as `reviews_count`, (select avg(`ec_reviews`.`star`) from `ec_reviews` where `ec_products`.`id` = `ec_reviews`.`product_id` and `status` = published) as `reviews_avg` 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-04-07 15:45:44' OR ec_products.end_date < '2025-04-07 15:45:44' ) ) THEN ec_products.price WHEN ( ec_products.sale_type = 1 AND ec_products.start_date <= '2025-04-07 15:45:44' AND ec_products.end_date >= '2025-04-07 15:45:44' ) THEN ec_products.sale_price WHEN ( ec_products.sale_type = 1 AND ec_products.start_date IS NULL AND ec_products.end_date >= '2025-04-07 15:45:44' ) THEN ec_products.sale_price WHEN ( ec_products.sale_type = 1 AND ec_products.start_date <= '2025-04-07 15:45:44' 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 `ec_products`.`is_featured` = 1 and `ec_products`.`is_variation` = 0 order by `ec_products`.`order` asc, `ec_products`.`created_at` desc limit 10)