1. Bluetooth Sun Glasses 2GB Mp3 Player Hi-Fi Stereo Headset Sunglasses - Black[19731]

    Price:  $32.34

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

    This item is a Bluetooth Sun Glasses 2GB Mp3 Player Hi-Fi Stereo Headset Sunglasses. It a stereo MP3 + Bluetooth function sunglasses. Compatible with various Bluetooth enabled devices such as mobile phones, PDAs, and laptops, MP5, and so on.

    * 100% brand new in retail package.
    * Bluetooth V2.0 with effective distance of 10m
    * Hi-Fi stereo quality headphone
    * Capacity: 2GB.
    * Color: Black
    * Charge Time: 3-4 hours.
    * Play Time: 2-4 hours.
    * Interface: Standard USB 1.1/2.0.
    * Voice Output Frequency: 18HZ-20KHZ.
    * Compatible File Formats: Mp3 / WAV / WMA.
    * Built-in 3.7V Lithium-ion Polymer Battery.
    * Lens is changeable, can be replaced by short-sighted lens
    * Comes with an extra pair of grey lens for replacement
    * If you need to send to other places, can be equipped with connector.
    * A: English ZJ-0006
    * B: European ZJ-0005
    * C: Australian ZJ-0007

    * Frame size: 15cm x 3.5cm (L x W)
    * Lens size: 15cm x 3.5cm (L x W)
    * Arm length: 13.5cm
    * Power Adapter input: 110-240V AC
    * Power Adapter output: 5.0V DC/500mAh
    * Working temperature: 0°C~60°C
    * Storage temperature: -20°C~80°C
    * Operating System: Windows 7/XP/2000/Vista

    Package included:
    * 1 x 2GB Sunglass mp3 player
    * 1 x earphone
    * 1 x USB cable
    * 1 x power adapter with USB port (US plug)
    * 1 x Carry case for the glasses
    * 1 x pair of grey lens
    * 1 x Cleaning Cloth
    * 1 x English User Manual

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