SQLSTATE[HY000]: General error: 1021 Disk full (/tmp/#sql_7128_43.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-06 12:26:41' OR ec_products.end_date < '2025-04-06 12:26:41' ) ) THEN ec_products.price WHEN ( ec_products.sale_type = 1 AND ec_products.start_date <= '2025-04-06 12:26:41' AND ec_products.end_date >= '2025-04-06 12:26:41' ) 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-06 12:26:41' ) THEN ec_products.sale_price WHEN ( ec_products.sale_type = 1 AND ec_products.start_date <= '2025-04-06 12:26:41' 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_categories` inner join `ec_product_category_product` on `ec_product_categories`.`id` = `ec_product_category_product`.`category_id` where `ec_products`.`id` = `ec_product_category_product`.`product_id` and `ec_product_category_product`.`category_id` in (8, 12, 13, 33)) and `ec_products`.`is_variation` = 0 and `ec_products`.`id` != 22 order by `ec_products`.`order` asc, `ec_products`.`created_at` desc limit 7) (View: platform/themes/martfury/views/ecommerce/product.blade.php)