1. 2-in-1 USB Colorful Water-drop Touch Sensor Mini Speaker with LED Table Lamp Light[13109]

    Price:  $22.83

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

    This item is in special design of a energy saving LED table lamp with a mini speaker at the bottom. With it, you can enjoy the sweet melody while the amazing tiny water-drops dancing in colorful flashing lights rhythmically. It is a nice table lamp and a Mini music player as well. It will bring much enjoyment for your life or be a wonderful gift for your friends.

    * With touch sensor, you can turn on/off the soft LED light and adjust its brightness
    * Special colorful flashing lights will turn on automatically once the speaker is on, and will follow the music rhythm to beat
    * Hi-Fi high-quality and high-efficiency speaker, with clear and loud voice
    * Energy saving LED lamp, can be a bedroom night light
    * Durable ABS plastic and transparent water column
    * Plug and play, no additional driver is needed
    * Suitable for all products with music player, such as mp3, mp4, PC, mobile phone, etc
    * Battery: Built-in Li-ion battery (rechargeable)
    * Charging input: DC 5V or USB
    * Color: White
    * Size: 25.5 x 7.8 cm (Height * Diameter)

    Package included:
    1 x LED lamp with speaker
    1 x USB charger cable
    1 x Audio cable
    1 x User manual in Chinese and English

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