1. Mini Wireless In-Ear Stereo Music 2-Channel Bluetooth Earphone with Microphone for iPhone 5/5S/4/4S and More - 5 Colors[70539]

    Price:   $19.54 $21.29

    Reviews
    This product was added to our catalog on Saturday 25 October, 2014.

    This item is an earphone which is in fashion design. It can be connected with various of Bluetooth enabled devices such as iPhone iPad tablet PC Samsung Galaxy etc. With this comfortable mini stereo music Bluetooth earphone you can enjoy nice music in a private space at anywhere and anytime without disturbing other people around you. Additional it is designed with a built-in microphone which can make you talk with your friends more easily and quickly. It will be a nice partner for you.

     

    Features:
    * Fashion and nice design
    * In-ear type comfortable to wear
    * Clear and nice sound effect
    * With built-in microphone for convenient communication with your friends
    * Swith ON/OFF key
    * Volume+/- and Next/Previous Song control
    * Suitable for all Bluetooth enabled device such as Samsung Motorola Nokia HTC Sony LG Lenovo Huawei mobile phones iPhone iPad tablet PC and laptop PS3 PS4 etc.

    Specifications:
    * Color: Black / White / Red / Green / Yellow
    * Frequency: 2.4GHz
    * Bluetooth Version: V2.1+EDR
    * Bluetooth Protocol: Headset / hands-stereo
    * Transmission Power: Class 2
    * Music Time: about 3 hours
    * Talk Time: about 3 hours
    * Standby Time: about 100 hours
    * Cable Length: 45cm / 17.72inch

    Package includes:
    1 x Bluetooth Earphone
    1 x AC Power Adapter (US Plug)
    2 x Ear Hooks
    3 x Pairs of Earmuffs (3 sizes)
    1 x 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 = '26' and opa.orders_id = opb.orders_id and opb.products_id != '26' 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

[TEP STOP]