1. Built in 4GB Video Glass with 72 inch Wide-screen 16:9 Virtual Picture Music Ebook LCD Display-Black[57597]

    Price:  $170.88

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

    This video glasses integrates video storage, playing and display in one digital broadcase. When wearing it, you experience a 72-inch 16:9 screen, which is exceptionally clear and delicate. Together with the clear screen, surround sound, making you stay as in the theater. The unique optical display technology, mobile broadcast technology and innovative design, together with elegant structure make the class a fantastic enjoy for you. 32 GB expandable storage space, making you being able to put it more added program at any time to play and enjoy.

    * Name of item:Video glass
    * Color:Black
    * Ultra-light and wire-free for portable carring
    * New brand with high quality
    * Memory:Built-in 4GB memory, support TF card, up to 32GB(Not included)
    * System:Support the Hassel, support files play and files browsing
    * Display:72inch 16:9 virtual display(2 meters distance)
    * Menu language:zh-CN, zh-HK, En, De, It, Nl, Fr, Es, Pl, Ru, Tr, Cs, Ja, Sk, Kr, IL, Ar, Eg
    * Menu system:Picture menu, word menu
    * Audio format:MP3,WMA, FLAC, AAC, APE
    * Frequency response:30HZ-18KHZ, 0dB+-3dB
    * Output power:L(10mW)+R(10mW)
    * Built-in audio:Format, rock, pop, classic, custom, bass, jazz
    * Custom sound:Support
    * Play-FX Sound:Support
    * Resolution:RM/RMVB:Below 720*576 AVI:Below 800*480 and FLV format play
    * USB interface:High speed USB 2.0
    * Recharger:DC 5V input
    * Power source:3.7V Lithium polymer batteries
    * Volume:170mmx55mx30mm
    * Operate system:Support Windows 2000/XP/Vista
    * AV-in:Auto recognition NTSC/PAL system
    * Weight:0.358kg

    Package included:
    1* Video galss
    1* Power charger
    1* USB cable
    1* TV cable
    1* 3.5mm cable
    1* Light shield
    1* Deluxe carrying case

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 = '1718' and opa.orders_id = opb.orders_id and opb.products_id != '1718' 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