EDEA

Edea is a company established in 2000 and that debuted on 02.02.2002: two years of intense research that allowed Edea to bring new ideas and innovative projects in the skates production. Research, development and production are entirely based in Italy and focused only on figure-skating boots (both ice and rollers). The company was founded by Sabrina Merlo, the daughter of Antonio Merlo and Caterina Rizzo, and the niece of Armando Rizzo, who had founded Risport in 1972. In 1995 Risport was sold and it is still present in the market with its production. Currently, Mr. Merlo and Mr. Rizzo are considered the 'wisdom' of Edea and they are part of it as Supervisors. Challenges, changes and technical innovation in the skates field are considered at Edea a stimulus to lead the company to the Top.

Loading...
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE ((stock_status_index.stock_status = 1) AND (e.entity_id IN (82851, 82853, 82855, 82852, 82854))) AND (e.created_in <= '1637884861') AND (e.updated_in > '1637884861') ORDER BY FIELD(e.entity_id,82851,82853,82855,82852,82854)