1. AIR 05 2-in-1 Indoor LED Light Bulb Wireless Bluetooth Speaker with Remote Control for Smartphone/MP3 Player/Laptop - Warm White[68864]

    Price:  $53.01

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

    This LED light owns a unique and proprietary 2-in-1 design the Air 05 is both a Bluetooth speaker and an LED light bulb in one! Easily installed into any light bulb socket(E27) for discreet and convenient placement the Air 05 supports a wide range of Bluetooth wireless audio profiles making it compatible with Bluetooth-enabled devices: including the IPhone iPod Touch and iPad what's more the Air 05 also offers a transmission range of up to 10m.

     

    Features:
    * Unique innovative design 2 in 1 wireless Bluetooth speaker and LED light bulb
    * 5 Watts stereo speaker and 5 watts high efficiency LED light bulb
    * Bluetooth Class 2 transmitting / receiving working distance up to 10m
    * Supports HSP HFP A2DP AVRCP Bluetooth wireless audio profile for use with iPhone iPod touch iPad and other Bluetooth enabled devices
    * Pure digital technology DSP gives your music purity and clarity
    * Full function remote control power by 2 AAA batteries(not included)
    * BQB approved and fully compatible with other Bluetooth enable devices
    * Simply setup no technical setup or wring required

     

    Specification:
    * Connection type: E27
    * Material: Plastic
    * Bluetooth version: V3.0+EDR(support
    V3.0+EDR class 2)
    * Bluetooth profile: HSP HFP

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