1. Hot New Aurora master lots colors 12 Light LED Projector MP3 Speaker USB Lamp[15626]

    Price:  $23.50

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

    Create your own blue sea waves and enjoy the relaxing moment now! All you need is this innovative Relaxing Ocean Projector Pot.

    Feature :
    * Brand New & High Quality.
    * New mini-wave projection lamps, modeling simple, easy to use.
    * Apply to bathrooms, the living room, bedroom or any space, reproduce the sparkling sea at any time a glorious natural beauty, allows you to feel as immersed in the deep sea calm and the sea embrace peace, creating a romantic, leisure and cozy atmosphere of the space to achieve physical and mental relaxation effect.
    * It is also a small stereo speaker, allows you to enjoy the beautiful environment, but also can enjoy the wonderful music.
    * Power by 4 AA batteries, also supports external USB and 4.5V DC plug.
    * Automatic sleep function, an hour later automatically closed, you can also press the key to close it to open.
    * Built-in Mini speaker can be as ipod, mp3 speakers, features intimate and easy to use.
    * Projected swinging light like a ocean surface makes you relax at bath room or living room.
    * Dimension: 13.5cm x 13.5cm x 12.5cm.

    Package inlcude :
    * 1 x Ocean Projector
    * 1 x 3.5mm Audio Cable
    * 1 x USB Cable
    * 1 x AC Adapter

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