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 (2231, 2232, 2233, 2481, 2589, 2591, 2640, 2684, 2689, 2723, 2725, 2727)) ORDER BY FIELD(e.entity_id,2231,2232,2233,2481,2589,2591,2640,2684,2689,2723,2725,2727)
-
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 2099
Lg OLED65C26LD_AEK 77" 4K OLED Smart TV with Voice Assistants
Dimensions: H 104.3 x W 172.3 x D 21.5 cm
£2,099.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 2299
Lg OLED65G26LA_AEK 65" 4K OLED Smart TV with Voice Assistants
Dimensions: H 82.1 x W 144.1 x D 2.5 cm
£2,299.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 199
Metz 32MTD6000ZUK 32" HD Smart TV
Dimensions: H 47 x W 3.5 x D 19 cm
£199.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 449
Samsung QE43Q60CAUXXU QLED 4K HD TV
Dimensions: H 55.9 x W 96.5 x D 2.5 cm
£449.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 499
Sharp 4T-C50EQ4KM2AG 50" 4K UHD Frameless Quantum Dot Android TV
Dimensions: H 77.3 x W 111.3 x D 23.2 cm
£499.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 1149
Sharp 4T-C75EQ4KM2AG 75" 4K UHD Frameless Quantum Dot Android TV
Dimensions: H 105.4 x W 167.2 x D 31.3 cm
£1,149.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 329
Sharp 4T-C43FN2KL2AB 43"4K Ultra HD Smart TV
Dimensions: H 55.8 x W 96.19 x D 9.48 cm
£329.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 311
Lg 43UR78006LK_AEK 43" 4K Smart LED TV
Dimensions: H 56.4 x W 96.7 x D 5.77 cm
£311.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 949
Hisense 65U7HQTUK 65" 4K ULED Smart TV
Dimensions: H 89.1 x W 161 x D 17.1 cm
£949.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 399
Samsung UE43CU8000KXXU UHD 4K HDR TV
Dimensions: H 60.01 x W 96.55 x D 19.51 cm
£399.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 499
Sharp 4T-C50EQ3KM2AG 1904T-C50EQ3KM2AG 50" 4K Ultra HD Smart TV Quantum Dot
Dimensions: H 66.9 x W 113.2 x D 23.2 cm
£499.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 419
Samsung UE50DU8000KXXU 50" 4K LED TV
Dimensions: H 65 x W 112 x D 3 cm
£419.00
postcode: local: no
session postcode: session local: no











