SQL_ERROR:
SELECT
stravel_offer.id,
stravel_offer.comment,
travel_offer.title,
travel_offer.route,
travel_offer.days_cnt,
travel_offer.nights_cnt,
travel_offer.transport_type_id,
travel_offer.meal_type_id,
sys_object_node.is_promo,
MIN(travel_price_table.best_price) AS price,
travel_price_table.currency_id,
simage.name AS image,
snode.name AS node_name,
stravel_offer_type.name as travel_offer_type
FROM
sys_object stravel_offer LEFT JOIN travel_offer ON (stravel_offer.id = travel_offer.id)
LEFT JOIN sys_object simage ON (travel_offer.image_id = simage.id AND simage.sys_object_type_id = '30')
LEFT JOIN travel_offer_type ON (travel_offer.travel_offer_type_id = travel_offer_type.id) LEFT JOIN sys_object stravel_offer_type ON (stravel_offer_type.id = travel_offer_type.id AND stravel_offer_type.sys_object_type_id = '38')
LEFT JOIN sys_object stravel_price_table ON (stravel_price_table.parent_sys_object_id = stravel_offer.id AND stravel_price_table.is_deleted = 0 AND stravel_price_table.sys_object_type_id = '44')
LEFT JOIN travel_price_table ON (stravel_price_table.id = travel_price_table.id),
sys_object ssys_object_node LEFT JOIN sys_object_node ON (ssys_object_node.id = sys_object_node.id),
sys_object snode LEFT JOIN node ON (node.id = snode.id)
WHERE
ssys_object_node.parent_sys_object_id = stravel_offer.id AND
snode.parent_sys_object_id = '5505' AND
sys_object_node.node_id = snode.id AND
sys_object_node.is_promo = 1 AND
stravel_offer.is_deleted = 0 AND
ssys_object_node.is_deleted = 0 AND
ssys_object_node.is_hidden = 0 AND
snode.is_deleted = 0 AND
stravel_offer.sys_object_type_id = '80' AND
ssys_object_node.sys_object_type_id = '28' AND
snode.sys_object_type_id = '27'
GROUP BY
stravel_offer.id
SQL_ERROR: Got error 28 from storage engine
