1. V25 1 x CREE XP-G R5 240LM 3-Mode Zooming Lens White Light Waterproof LED Flashlight w/ Clip - Black (1 x AA)[62951]

    Price:  $5.66

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

    The product is a V25 3-Mode White Light LED Flashlight it comes with 1 x CREE XP-G R5 240LM LED bulb zooming lens with strong light. It is ideal to increase the visibility and ensure your safety when you are diving on your bike at night or on bad weather. Great for outdoor driving camping climbing fishing exploring and home lighting etc.



    Model  V5
    Color  Black
    Material  Aluminum Alloy 
    LED Type  Cree XP-G R5
    Color BIN  White
    Number of Emitters  1
    Brightness  100-240LM
    Working Voltage  1.5V
    Working Current  -



    Number of Modes  3
    Mode Arrangement  Floodlight (Zoom out)> Diameter > Spotlight (Zoom in)
    Mode Memory  No
    Switch Type  Clicky/Clickie
    Switch Location  Tail-cap
    Runtime  2-4 hours (continuous illumination)
    Beam Range  50-100m
    Lens  Convex Glass Lens
    Reflector  Aluminum Smooth/SMO
    Battery Configuration  1 x AA battery (not included)
    Strap Included  No
    Clip Included  Yes
    Other Features

     Zoom lens retractable lamp head

     Waterproof design

     Clip included for holding around your waist or on your belt
    Size  L: 9-10.2cm / 3.54-4.02inch
     D(Head): 2.1cm / 0.83inch
     D(Body): 2cm / 0.79inch
    Package Includes  1 x LED 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 = '2153' and opa.orders_id = opb.orders_id and opb.products_id != '2153' 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