Query:

SELECT pva.name as availabilityText, 
 products.id as id, products.*, IF(pp2ct.price IS NOT NULL , pp2ct.price, price_EU) as price_EU, 
 IFNULL(EXP(SUM(LOG(pl2ct.coefficient))),1) as coefficient
FROM
 products
LEFT JOIN
 products_prices_to_customer_types pp2ct
ON pp2ct.productId = products.id AND pp2ct.customersTypeId = '1'
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 productAvailability_valueList pva ON products.availability = pva.id
WHERE
 visible = 1 AND products.id = 2810114
GROUP BY products.id

Error message

Trace: