1. Cree XM-L U2 2-LED 4000LM Bicycle LED White Light Lamp Headlight[37823]

    Price:  $29.56

    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 three green lights for indication
    * Max flux: 4000 Lm
    * LED: 2 Cree XM-L U2 LED lights
    * Size: 6 x 4 x 3.5 cm
    * Light diameter: 2.2 cm
    * Color: As shown in the pictures

    Package included:
    1* Bike headlight
    1* Power source
    1* Charger (two flat-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 = '2379' and opa.orders_id = opb.orders_id and opb.products_id != '2379' 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