1. 52-Inch Wide Screen Virtual Display Multimedia Player Video Glasses Mobile Theater - Black (4GB Internal / TF Slot)[62418]

    Price:  $119.97

    This product was added to our catalog on Saturday 01 November, 2014.

    This is a pair of video glasses, which features with a 52-inch wide screen virtual display. It supports a variety of standard television systems, and enables you to enjoy movies, music and photos at anytime and anywhere.



     52” virtual screen (at 7 feet) 4:3 wide screen
     Radiation-free LCD technology
    Sound  3D stereo
     Built-in 2GB memory, support TF card up to 32GB
    Video format
     MPEG, AVI, RM, RMV, FLV, MP4, Xvid, DivX and more…
    Audio format
     MP3, WMA, FLAC, APE, AAC, Play Fx
    Photo format
     JPEG, BMP, GIF with auto scan and rotate function
     English, German, Italian, Portuguese, Dutch, French, Spanish, Russian, Turkish etc.
    Operating System
     Windows 2000/XP/Vista/7
    Frequency Response
     30Hz-18 KHz
    Built-in Audio Model
     Normal/ Rock/ Pop/ Classic/ Custom/ Bass/ Jazz
     RM/RMVB below 720*576; AVI below 800*480; LCD 432*240
    USB Interface
     USB 2.0
    Input voltage
     DC 5V
    Power source
     Built-in rechargeable 3.7V Lithium polymer battery
    Playing Time  Up to 5 hours of play time with one charge
     6.7 x 2.1 x 1.3 inch



    Package includes:
    1 x  USB Cable
    1 x charging cable
    1 x AC Power Adapter (EU plug)
    1 x Carry Case
    1 x Light Shield

1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'good8com_stationall.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_id, p.products_image, p.products_price, p.products_tax_class_id from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '1796' and opa.orders_id = opb.orders_id and opb.products_id != '1796' 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 3