Your cart is empty

BDP-S470 3D Blu-ray Disc Player

$200.00

Watch 3D Blu-ray Disc movies in crystal-clear Full HD 1080p, or connect to the internet and access an unrivaled assortments of movies, videos and music. Access premium content providers such as Netflix, You-Tube, Pandora and many more. Use your iPhone or iPod touch as a remote control when you download the free BD Remote application, featuring a search option for additional information. Deliver full HD stereo surround sound to fill larger rooms. Horizontal Resolution: 1,920 lines. Audio D/A Converter: 24bit/192kHz. Video D/A Converter: 24bit/192KHz. Includes Blue-ray Disc player, remote, A/V cable, user manuals. 19 1/5”w x 11 4/5”d x 3 11/31”h. Manufacturer’s limited one-year warranty. Shpg. Wt. 7 lbs.


Add to Cart:


1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'marineco_znc1.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
in:
[select p.products_id, p.products_image from znc_orders_products opa, znc_orders_products opb, znc_orders o, znc_products p where opa.products_id = '28814' and opa.orders_id = opb.orders_id and opb.products_id != '28814' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = 1 group by p.products_id order by o.date_purchased desc limit 6]