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 (3096, 3098, 3099, 3101, 3104, 3105, 3106, 3107, 3108, 3109, 3110, 3111)) ORDER BY FIELD(e.entity_id,3096,3098,3099,3101,3104,3105,3106,3107,3108,3109,3110,3111)
-
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 3999
Sony XR98X90LU 98"4K UHD HDR Google Smart TV
Dimensions: H 13.05 x W 219.9 x D 4.65 cm
£3,999.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 2199
Sony XR55A95LU 55"4K UHD HDR Google Smart TV
Dimensions: H 84 x W 136 x D 18 cm
£2,199.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 2999
Sony XR65A95LU 65"4K UHD HDR Google Smart TV
Dimensions: H 95 x W 164 x D 18 cm
£2,999.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 2779
Sony K77XR80PU 77" 4K OLED TV
Dimensions: H 101.2 x W 171.3 x D 3.8 cm
£2,779.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 1699
Sony K65XR70U 65" 4K QLED TV
Dimensions: H 85.6 x W 144.5 x D 34.5 cm
£1,699.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 2069
Sony K75XR70PU 75" 4K QLED TV
Dimensions: H 96 x W 166.8 x D 5.7 cm
£2,069.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 2979
Sony K75XR90PU 75" 4K QLED TV
Dimensions: H 166.7 x W 96 x D 4.8 cm
£2,979.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 1499
Sony K55XR80PU 55" 4K OLED TV
Dimensions: H 73.2 x W 122.3 x D 24.8 cm
£1,499.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 3579
Sony K85XR90PU 85" 4K QLED TV
Dimensions: H 109.7 x W 188.8 x D 45.7 cm
£3,579.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 1349
Sony K55XR70PU 55" 4K Neo QLED Mini LED HDR Google TV
Dimensions: H 73.3 x W 122.5 x D 34.5 cm
£1,349.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 499
Samsung UE55DU8000KXXU UHD 4K TV
Dimensions: H 74.78 x W 123.21 x D 22.88 cm
£499.00 -
PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 5999
Samsung QE85QN95DATXXU 85" 4K Neo QLED TV
Dimensions: H 114.25 x W 189 x D 31.8 cm
£5,999.00
postcode: local: no
session postcode: session local: no











