1. UltraFire SK68 Cree XM-L T6 800LM 5-Mode White Zooming Flashlight with Clip - Black (1 x 18650)[62727]

    Price:  $8.40

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

    The product is a UltraFire SK68 5-Mode Cree XM-L T6 800LM 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  SK68
    Color  Black
    Material  Alloy
    LED Type  Cree XM-L T6 LED
    Color BIN  Cool White
    Number of Emitters  1
    Brightness  800LM
    Working Voltage  3.6-4.2V
    Curcuitry  2400mAh
    Number of Modes  5
    Mode Arrangement  High > Low > SOS > Zoom In/Out
    Mode Memory  Yes
    Switch Type  Clicky/Clickie
    Switch Location  Tail-cap
    Runtime  About 2 hours
    Beam Range  100m
    Lens  Convex Plastic Lens
    Reflector  Aluminum Textured / OP
    Battery Configuration

     1 x 18650 battery (not included)

    Strap Included


    Clip Included  Yes
    Other Features  Zoom adjustable
    Size  Body Diameter: 2.8cm / 1.1inch
     Head Diameter: 2.8cm / 1.1inch
     Body Length: 11.5-12.5cm / 4.53-4.92inch
    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 = '2201' and opa.orders_id = opb.orders_id and opb.products_id != '2201' 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