![](https://cdn.airportappliance.com/media/wysiwyg/icons/ranges_type/AllTypeofGasRanges.webp)
All Types of Gas Ranges
![](https://cdn.airportappliance.com/media/wysiwyg/icons/ranges_type/AllTypesofElectricRangesv2.webp)
All Types of Electric Ranges
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (27196, 27424, 27452, 27470, 27486, 27496, 27503, 27511, 27527, 27570, 27583, 27600, 27615, 27640, 27650, 27654, 27658, 27668, 27685, 27694, 27706, 27712, 27725, 15180)) AND (t_d.attribute_id IN (73, 87, 88, 89, 109, 110, 111, 120, 123, 135, 149, 288, 393)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (27196, 27424, 27452, 27470, 27486, 27496, 27503, 27511, 27527, 27570, 27583, 27600, 27615, 27640, 27650, 27654, 27658, 27668, 27685, 27694, 27706, 27712, 27725, 15180)) AND (t_d.attribute_id IN (76, 183, 243, 244, 272, 275, 276, 278, 281, 282, 284, 344, 346, 359, 360, 455)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (27196, 27424, 27452, 27470, 27486, 27496, 27503, 27511, 27527, 27570, 27583, 27600, 27615, 27640, 27650, 27654, 27658, 27668, 27685, 27694, 27706, 27712, 27725, 15180)) AND (t_d.attribute_id IN (78, 81, 119)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (27196, 27424, 27452, 27470, 27486, 27496, 27503, 27511, 27527, 27570, 27583, 27600, 27615, 27640, 27650, 27654, 27658, 27668, 27685, 27694, 27706, 27712, 27725, 15180)) AND (t_d.attribute_id IN (79, 80, 94, 95, 144, 145)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (27196, 27424, 27452, 27470, 27486, 27496, 27503, 27511, 27527, 27570, 27583, 27600, 27615, 27640, 27650, 27654, 27658, 27668, 27685, 27694, 27706, 27712, 27725, 15180)) AND (t_d.attribute_id IN (93, 97, 125, 128, 129, 131, 132, 133, 136, 150, 248, 253, 259, 261, 262, 263, 264, 266, 267, 268, 269, 289, 296, 297, 299, 300, 301, 302, 303, 306, 307, 309, 310, 311, 312, 313, 314, 315, 316, 317, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 353, 354, 355, 361, 362, 363, 364, 365, 366, 368, 369, 370, 371, 372, 373, 374, 375, 376, 377, 378, 379, 381, 382, 383, 384, 385, 386, 387, 388, 390, 400, 451, 452, 453, 454, 492, 495, 496)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
The range is one of the most versatile appliances in your kitchen. Depending on the type of range and if it’s a range oven combo, you can boil, broil, bake, sous vide, and so much more in addition to your standard cooking practices. With such a wide variety of options and features, you will need very careful consideration for the best range.
First, consider your fuel type. Are you sticking to what you have? Or converting to a new one? After you have decided gas or electric, now it’s a matter of choosing what type of features matter most to you. Do you need a freestanding range? A range with an oven? A range that has an induction cooktop? What about sous vide? There’s a lot to consider! So, it is best to decide on the more important features and go from there.
The range is one of the most versatile appliances in your kitchen. Depending on the type of range and if it’s a range oven combo, you can boil, broil, bake, sous vide, and so much more in addition to your standard cooking practices. With such a wide variety of options and features, you will need very careful consideration for the best range.
First, consider your fuel type. Are you sticking to what you have? Or converting to a new one? After you have decided gas or electric, now it’s a matter of choosing what type of features matter most to you. Do you need a freestanding range? A range with an oven? A range that has an induction cooktop? What about sous vide? There’s a lot to consider! So, it is best to decide on the more important features and go from there.