1. 1-LED 3-Mode Aluminum Alloy Bike Tail Light (2*CR2032)[76191]

    Available Options:

    Price:  $3.92

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

    This is a bike tail light with 1 bright LED. There are 3 lighting modes: Fast strobe SOS and steady light. It is powered by 2 built-in CR2032 cell buttons. It can be installed on the bike tail easily for the silicon buckle bandage. It is suitable for bicycling outdoor. It is an ideal item to ensure your safety when you are riding a bike at night or in bad weather.


    * Head Color: Black / Silver / Blue / Red
    * Material: Plastic + Silicon
    * Total Emitters: 1-LED
    * Color BIN: White Red Red Blue
    * 3 Modes: Sready Light Fast strobe SOS
    * Suitable for mountain bike folding bike road bike etc.
    * Ensure your safety when you are riding a bike at night or in bad weather
    * Battery: 2*CR2032 batteries (built-in)
    * Steady Light Time: 50 hours
    * Flash Lighting Time: 150 hours
    * Size: 2.5 x 2.5 x 2.1cm / 0.98 x 0.98 x 0.83inch
    * Bandage Length: 11.5 cm/4.53 in


    Package Includes:
    1 x Bike Tail Light
    1 x Silicon Bandage
    2 x Batteries


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