1. 5000LM CREE XM-L 3x T6 LED Headlight Light Headlamp Head Lamp Flashlight[68447]

    Price:  $21.48

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

    This high quality adjustable super-bright head-lamp provides hands-free convenience for outdoor activities at night or in dark conditions such as caving orienteering camping or mountain biking. Long-lasting bulbs provide the perfect amount of light for your job.


    * Color: Black
    * Model of LED: 3x CREE XM-L T6
    * Lumen: Max to 5000LM
    * Battery: not included
    * Powered by 2 x 18650 3.7V (batteries not included)
    * Mode: 1x Cree XM-L T6/ 2x Cree XM-l T6/ 3x Cree XM-L T6/ Flashing
    * Light Source: CREE XML-T6
    * 90 degree rotation: Yes
    * Application: Suitable for hiking camping hunting night riding caving expedition etc.
    * Internal wiring applies the high efficient booster circuit working voltage is wide and can utilize the batteries in the largest extent
    * Adjustable base is provided for each head lamp with back and forth inclination

    Package Included:
    * 1 x 3 CREE XM-L T6 5000LM Headlamp (batteries not included)


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