1. UltraFire KC01 CREE XM-L T6 1800LM 6-Mode Zooming Lens ED Flashlight Torch with Strap (1 x 18650) - Black + Coppery[62724]

    Price:  $9.16

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

    The product is a UltraFire KC01 6-Mode Cree XM-L T6 1800LM LED Flashlight Torch with zooming lens. It is made of Aluminum alloy. The flashlight is ideal for hunting camping fishing hiking travelling climbing etc.



    Model  KC01
    Color  Black + Coppery
    Material  Metal
    LED Type  Cree XM-L T6 LED
    Color BIN  White
    Number of Emitters  1
    Brightness  1800LM
    Working Voltage  4.2V (max.)
    Curcuitry  -
    Number of Modes  6
    Mode Arrangement  High > Mid > Fast Strobe > Zoom In/Out & Diameter
    Mode Memory  Yes
    Switch Type  Clicky/Clickie
    Switch Location  Tail-cap
    Runtime  About 1.5 hours
    Beam Range  -
    Lens  Convex Plastic Lens
    Reflector  Aluminum Textured / OP
    Battery Configuration

     1 x 18650 battery (not included)

    Strap Included


    Clip Included  No
    Other Features  Zoom adjustable
    Size  Body Diameter: 2.9cm / 1.14inch
     Head Diameter: 3.4cm / 1.34inch
     Body Length: 11.3-12.7cm / 4.45-5inch
    Package Includes  1 x Flashlight



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