1. 1200LM Bicycle T6 LED Light Lamp Headlight[37822]

    Price:  $30.12

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

    This item is a LED headlight which is specially for bike. It is very convenient to install and use. It will make your riding be more safely at dark night. 


    * Convenient and easy to install
    * Specially used for bicycle
    * Make you ride bike more safety and have a better view at night
    * The brightness can be adjusted
    * One button to turn on/off and adjust with green light indication
    * Flux: 1200 Lm
    * LED quantity: 1
    * Discharge time: 180 munites (100% brightness)
    * Diameter: 4cm
    * Length: 5cm
    * Color: As shown in the pictures

    Package included:
    1* Bike headlight
    1* Strap
    1* Power source
    1* Charger (two round-pin plug)
    2* Rubber rings


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