1. One Touch/3 Modes Waterproof Bicycle LED Flashlight Light of Silica Gel-Color random[17068]

    Price:  $1.83

    This product was added to our catalog on Sunday 02 November, 2014.

    This product is bicycle light features one touch and 3 modes such as fast strobe slow strob and light which are mutually changed easily.Be fir for bicycle mountaineering and outdoor activities etc.


    * Name ot item:Bicycle light
    * Color random
    * Easy operation
    * Bicycle accessory
    * 3 modes for light: Fast strob slow stron an light
    * Material:Silica gel
    * Waterproof design
    * One touch design for easy operation
    * Be fir for bicycle mountaineering and outdoor activities etc.
    * Light with durable stable use since high quality
    * Powered by 2xCR2032 batteries(included)
    * Size:4.5x3x3cm/1.77x1.18x1.18inch

    Package include:
    1* Bicycle light



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