1. S900 Hi-Fi TF Card Slot MP3 Player Bluetooth HeadPhone FM Red[53977]

    Price:  $19.50

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

    Unique Sport Mp3 Player + Bluetooth Stereo Headset Headphone Earphone It is not just a mp3 player but also Bluetooth stereo headset. When a call comes, you will hearing ringing on the headset, under mobile phone standard mode, pressing multi-function key can answer the call. When the call ends, it resumes to music. You will never missing a call at anytime and anywhere Bluetooth headset with MP3 built in, TF card support and Bluetooth wireless communication functions Brand new and high quality Easy to take, free your hand any time Ease your lift and makes your life convenient Fashionable and unique design.

    * Bluetooth Version: Bluetooth 2.1+EDR technology
    * Frequency Range: 2.4GHz-2.480GHz
    * GHz Bluetooth Distance: 10m
    * External Expansion Card: TF card up to 16GB
    * Frequency rESPONSE: 20Hz-20kHz
    * MP3 music listening time: about 4 hours
    * Fm listening time: about 8 hours
    * Battery: 3.7V/260mAh rechargeable lithium-ion battery
    * Dimension: 95x70x20mm

    Package include:
    * Bluetooth headphone x 1
    * AC charger x 1
    * USB cable x 1
    * Earphone cap x 2

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