SQLSTATE[HY000]: General error: 1114 The table '/tmp/#sql_17803d_385' is full (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-12-17 10:21:17' OR
ec_products.end_date < '2025-12-17 10:21:17'
)
) THEN ec_products.price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-12-17 10:21:17' AND
ec_products.end_date >= '2025-12-17 10:21:17'
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date IS NULL AND
ec_products.end_date >= '2025-12-17 10:21:17'
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-12-17 10:21:17' 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_variation` = 0 and `ec_products`.`id` != 6752149536903 and (`ec_products`.`is_variation` = 1 or `ec_products`.`store_id` is null or not exists (select * from `mp_stores` where `ec_products`.`store_id` = `mp_stores`.`id`) or exists (select * from `mp_stores` where `ec_products`.`store_id` = `mp_stores`.`id` and `status` = published)) 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 6) (View: platform/themes/farmart/views/ecommerce/product.blade.php)
