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 (2728, 2730, 2731, 2732, 2733, 2752, 2760, 2761, 2762, 2767, 2768, 2789)) ORDER BY FIELD(e.entity_id,2728,2730,2731,2732,2733,2752,2760,2761,2762,2767,2768,2789)
-
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 499
Samsung UE50DU8500KXXU UHD 4K TV
Dimensions: H 65 x W 112 x D 3 cm
£499.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 549
Samsung QE32LS03BBUXXU 32" The Frame 4K Ultra HD QLED Smart TV with Voice Assistant
Dimensions: H 41.9 x W 72.9 x D 2.5 cm
£549.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 549
Sharp 4T-C55EQ4KM2AG 55" 4K UHD Frameless Quantum Dot Android TV
Dimensions: H 80.5 x W 122.8 x D 26.2 cm
£549.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 429
Lg 43UR91006LA_AEK 43" 4K Smart LED TV
Dimensions: H 65.1 x W 112.1 x D 5.7 cm
£429.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 1199
Lg OLED55B36LA_AEK OLED48C36LA_AEK 48" 4K Smart OLED TV
Dimensions: H 74.4 x W 122.8 x D 24.6 cm
£1,199.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 329
Lg 43UT80006LA.AEK 43" 4K LED Smart TV
Dimensions: H 62.1 x W 96.7 x D 21.6 cm
£329.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 539
Samsung QE50Q60DAUXXU 50" QLED TV
Dimensions: H 65 x W 119 x D 3 cm
£539.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 369
Samsung UE43DU8000KXXU 43" 4K LED TV
Dimensions: H 56 x W 97 x D 3 cm
£369.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 149
Sharp 1T-C32FH2KL2AB 32" HD Ready LED Android Smart TV Chromecast
Dimensions: H 46.2 x W 71.9 x D 21.5 cm
£149.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 299
Vispera 27ELEGANT1 27" FHD LED Smart TV
Dimensions: H 41.4 x W 62 x D 8.5 cm
£299.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 329
Vispera 32ELEGANT1 32" FHD LED Smart TV
Dimensions: H 47.2 x W 72.1 x D 8.5 cm
£329.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 699
Samsung SPLFF3CLAXXXU Projector
Dimensions: H 172.8 x W 102.4 x D 95.2 cm
£699.00
postcode: local: no
session postcode: session local: no











