Felisi

Felisi began life in Ferrara in 1973 as a small craft workshop. Today it has become a world-renowned firm, boasting an increasingly refined, demanding and faithful clientele. Since its inception, the cornerstone of the company's success has been its leather artisans, and the training they have provided to the next generation as apprentices. Felisi is deeply rooted in the Ferrara region of Italy, home to both its laboratory and factory, thus guaranteeing careful, direct supervision of each and every stage of the production process.

SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 0 WHERE (`attribute_id` IN('993')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, tsv.value ASC SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 0 WHERE (`attribute_id` IN('993')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, tsv.value ASC SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 0 WHERE (`attribute_id` IN('993')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, tsv.value ASC SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = 0 WHERE (`attribute_id` IN('993')) AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, tsv.value ASC