1. 52" 4:3 Display Size 3D Stereo Video Glasses Sunglasses for iPhone iPad[38762]

    Price:  $89.19

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

    The product is a 52" 4:3 display size 3D stereo video glasses for iPhone iPad, noew you can watch moive anytime anywhere!

    * Demountable: consists of video part and general-purpose polarized sunglasses
    * Removed the video part. It can be used as polarized sunglasses with stylish appearance
    * Installed the video part, It can be used as video glasses with superior audio and video quality


    no radiation full-color LCD micro-display
    Virtual screen
    52inch 4:3 large screen (at 2 meter's distance)
    Color depth
    input 24-bit
    Optical visible angle
    26 degree angle
    Built-in ploymer battery, 3.7V 800mAh
    Maximum power
    Battery duration
    Power consumption
    Sample rate
    Video input
    mixed video input
    Video format
    MTSC/PAL/SECAM automatic selection
    double-channel stero earbuds
    MP3 bit rates
    64K bps- 320K bps
    WMA bit rate
    64K bps - 384K bps
    Frequency responce
    20Hz to 20KHz
    Viewing angle
    controllable degree is -15 degrees to 15 degrees
    Net weight
    60g (not including earphones)
    Operating system
    windows 2000/XP/Vista/7 OSX

    Package include:
    * Video glasses x 1
    * USB data cable x 1
    * USB cable x 1
    * D/V adapter x 1
    * AV cable x 1
    * Light shield x 1
    * Deluxe carryinh case x 1

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