Cooling & Air Care
-
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 (2020, 2620, 2783, 2784, 2785, 2963, 3003, 3010, 3011, 3670, 3740, 3754)) ORDER BY FIELD(e.entity_id,2020,2620,2783,2784,2785,2963,3003,3010,3011,3670,3740,3754)
-
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 349.99
Ebac D1821RWG White Dehumidifier
Dimensions: H 50 x W 32.5 x D 27.5 cm
£349.99 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 375
Ebac DJ421RWH-GB 4850 Dehumidifier - 21L
Dimensions: H 54.5 x W 34 x D 26.5 cm
£375.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 265
Ebac DE84RYE-GB Powerdri 18
Dimensions: H 54.5 x W 34 x D 26.5 cm
£265.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 349
Ebac DI821RWG-GB 3850e
Dimensions: H 50 x W 32.5 x D 27.5 cm
£349.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 309
Ebac DJ418RWH-GB 4650
Dimensions: H 54.5 x W 34 x D 26.5 cm
£309.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 59.99
Igenix IGFD2016W Cooling Fan
Dimensions: H 130 x W 42 x D 45 cm
£59.99 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 49.99
Igenix IGFD4010W Cooling Fan
Dimensions: H 31.8 x W 24.9 x D 24.9 cm
£49.99 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 329
Shark HP300UK NeverChange5 Air Purifier Max - White
Dimensions: H 57 x W 33.5 x D 33.5 cm
£329.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 249.99
Shark HP150UK NeverChange5 Air Purifier - White
Dimensions: H 385 x W 237 x D 266 cm
£249.99 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 189
Russell Hobbs RHDH2002B 20L Dehumidifier - Black
Dimensions: H 51 x W 35 x D 24.5 cm
£189.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 79.99
Igenix DF1670 Digital Pedestal Fan 16'
Dimensions: H 136 x W 40 x D 45 cm
£79.99 -
PRIORITY: | QTY: 2 | RECOMMENDED: | PRICE: 79.99
Vybra VS001-OFG Graphite Dual Height Tilt & Swing Oscillating Fan
Dimensions: H 51 x W 22.5 x D 38.5 cm
£79.99
postcode: local: no
session postcode: session local: no











