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

    Reviews
    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.

     

    Brand

     UltraFire
    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

     Yes

    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

[TEP STOP]