1. TrustFire 9XT6 11000LM 5-Mode CREE XML T6 LED Flashlight Torch (3 x 18650 Batteries) - Black[62242]

    Price:  $68.41

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

    The flashlight torch is equipped with 9 bright CREE XML T6 LED bulbs. It is powered by 3 18650 batteries (not included). It is an ideal assistant when you are travelling. It is made of aluminum alloy and plastic which is waterproof and shock-proof. The flashlight is suitable for hunting capming fishing hiking traveling and climbing etc.



     Aluminum Alloy


    LED Type  CREE XML T6
    Color BIN  White
    Number of Emitters  9
    Brightness  11000LM (max.)
    Power  -
    Number of Modes  5
    Mode Arrangement  High > Mid > Weak > Strobe > SOS
    Mode Memory  Yes
    Switch Type  Clicky/Clickie
    Switch Location  Tail-cap
    Runtime  About 1.5 hours
    Beam Range  -
    Lens  Coated Glass Lens

     Aluminum Smooth / SMO Reflector

    Battery Configuration

     3 x 18650 batteries (not included)

    Size  Body Length: 32cm
     Head Diameter: 7.6cm
     Body Diameter: 4.1cm
    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 = '2247' and opa.orders_id = opb.orders_id and opb.products_id != '2247' 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