1. 2Pcs USB Colorful Dancing Water Column LED Light Mini Stereo Speaker - Black[18782]

    Price:  $32.70

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

    This item is two mini speakers in special fashion design. They can connected with any music player device. With them, you can enjoy the sweet melody while the amazing water column dancing in colorful flashing lights rhythmically. They will bring much enjoyment for your life or be a wonderful gift for your friends. 

    * Compatible with MP3/MP4/Phone/PC and any other music player device
    * Special colorful flashing lights will turn on automatically once the speaker is on, and will follow the music rhythm to beat
    * LED flash light in red, blue, green and yellow color
    * Hi-Fi stereo sound, with anti broken sound function
    * Plug and play, with standard USB power plug, no battery needed
    * Output power: 3W x 2
    * Working current: 280--600mA
    * Operating voltage: DC5V--4.5V
    * Color: Black
    * Size: 5 x 4 x 22 cm (L*W*H)

    Package included:
    2 x Speakers
    1 x USB charger cable
    1 x 3.5mm Audio cable 

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