Televisions
-
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 (2161, 2162, 2163, 2164, 2165, 2166, 2167, 2168, 2169, 2170, 2204, 2205)) ORDER BY FIELD(e.entity_id,2161,2162,2163,2164,2165,2166,2167,2168,2169,2170,2204,2205)
-
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 149
Vispera 24SOLO1 Black 24" Led TV HD Ready
Dimensions: H 100 x W 170 x D 2 cm
£149.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 179
Vispera 32SOLO1 Black 32Inch HD Ready TV
Dimensions: H 47.7 x W 73 x D 18 cm
£179.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 199
Vispera AI32T1 32" Google Smart Freeview HD TV
Dimensions: H 46.9 x W 73 x D 1.7 cm
£199.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 179
Sharp 1T-C32DI2KL2AB 32" HD Ready Frameles LED Android TV
Dimensions: H 46.4 x W 72.3 x D 15.6 cm
£179.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 549
Lg 49SM8600PLA 49' 4K Uhd TV
Dimensions: H 64 x W 109.6 x D 6.3 cm
£549.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 2499
Lg 86UM7600PLB 86 4K UHD TV SMART 3840 x 2160 webOS Freeview HD Freesat HD 20W Bluetooth HDMI x 4 US
Dimensions: H 111.8 x W 194.3 x D 9.3 cm
£2,499.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 1099
Lg OLED42C24LA_AEK 42" 4K OLED Smart TV with Voice Assistants
Dimensions: H 57.7 x W 93.2 x D 1.7 cm
£1,099.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 1299
Sony XR42A90KU 42" 4K Ultra HD HDR Google TV
Dimensions: H 54.6 x W 93.3 x D 5.7 cm
£1,299.00 -
PRIORITY: | QTY: 2 | RECOMMENDED: | PRICE: 349
Sony KD32W800P1U 32" HD Ready HDR Android TV with Voice Assistant
Dimensions: H 44.2 x W 73.3 x D 7.8 cm
£349.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 249
Sony SUWL850 Black Sony TV Wall Mount
Dimensions: H 35.4 x W 56.3 x D 1.1 cm
£249.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 179
Sharp 1T-C24FH2KL2ABB 1T-C24FH2KL2AB 24" HD Ready LED Android Smart TV Chromecast
Dimensions: H 38.5 x W 56 x D 14 cm
£179.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 269
Metz 43MRD6000ZUK 43" DLED UHD Smart TV
Dimensions: H 60 x W 96 x D 9 cm
£269.00
postcode: local: no
session postcode: session local: no











