Query:

SELECT SQL_CALC_FOUND_ROWS 
 products.*, pva.name as availabilityText, 
 pva.position as avpos, 
 CEIL( 100 * 
 IF( 
 price_action_from < NOW() AND (price_action_to + INTERVAL 1 DAY) > NOW() AND price_action > 0 AND
price_action IS NOT NULL, 
 ROUND(price_action * (tax_rate / 100 + 1), 2) * EXP(SUM(LOG(pl2ct.coefficient))) 
 , 
 ROUND(IF(pp2ct.price IS NOT NULL , pp2ct.price, price_EU) * (tax_rate / 100 + 1), 2) *
EXP(SUM(LOG(pl2ct.coefficient)))
 ) 
 ) / 100 AS active_price, 
CEIL(IF(pp2ct.price IS NOT NULL , pp2ct.price, price_EU) * EXP(SUM(LOG(pl2ct.coefficient))) * (1 +
products.tax_rate / 100)) AS price, 
 EXP(SUM(LOG(pl2ct.coefficient))) as coefficient, 
IF(pp2ct.price IS NOT NULL , pp2ct.price, price_EU) AS price_EU
FROM (
SELECT products.* 
FROM products
LEFT JOIN
 products_to_categories
ON products_to_categories.product_id = products.id
WHERE 1 
 AND visible = 1 AND productType = 1 AND products.id IN (1065806, 6073925, 5494337, 6073926)
 AND base_id IS NULL
GROUP BY products.id ) as products
LEFT JOIN
 productAvailability_valueList pva ON products.availability = pva.id
LEFT JOIN
 products_to_price_levels ON products_to_price_levels.productId = products.id
LEFT JOIN
 price_levels ON price_levels.id = products_to_price_levels.priceLevelId
LEFT JOIN price_levels_to_customers_types AS pl2ct ON pl2ct.price_level_id = price_levels.id AND
pl2ct.customers_type_id = 1
LEFT JOIN customers_types AS ctypes ON ctypes.id = pl2ct.customers_type_id
LEFT JOIN
 products_prices_to_customer_types pp2ct
ON pp2ct.productId = products.id AND pp2ct.customersTypeId = '1'
GROUP BY products.id
ORDER BY FIELD(products.id,1065806,6073925,5494337,6073926)
LIMIT 0,51

Error message

Trace: