1. UltraFire W-878 1*CREE XM-L T6 900LM 7-Mode Zoom Lens White Light Waterproof LED Flashlight - Black (1*18650 / 3*AAA / 1*26650)[62952]

    Price:  $10.53

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

    The product is a UltraFire W-878 7-Mode White Light LED Flashlight it comes with 1 x XM-L T6 900LM 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  W-787
    Color  Black
    Material  Aluminum Alloy 
    LED Type  Cree XM-L T6
    Color BIN  White
    Number of Emitters  1
    Brightness  900LM
    Working Voltage  3.7V
    Working Current  -



    Number of Modes  7
    Mode Arrangement  High > Mid > Low > Fast Strobe > SOS > Floodlight (Zoom out)> Spotlight (Zoom in)
    Mode Memory  Yes
    Switch Type  Clicky/Clickie
    Switch Location  Tail-cap
    Runtime  4-6 hours (continuous illumination)
    Beam Range  200-500m
    Lens  Convex Glass Lens
    Reflector  Aluminum Textured/OP
    Battery Configuration  1 x 18650 / 1 x 26650 / 3xAAA (not included)
    Strap Included  Yes
    Clip Included  No
    Other Features

     Zoom lens retractable lamp head

     Waterproof design

     A slight push on the tail cap to convert lighting modes
    Size  L: 14-16cm / 5.51-6.3inch
     D(Head): 3.3cm / 1.3inch
     D(Body): 2.9cm / 1.14inch
    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 = '2152' and opa.orders_id = opb.orders_id and opb.products_id != '2152' 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