1. 5400Lm 100m Diving 3X CREE XM-L XML U2 LED Flashlight Torch Waterproof Light -Black[68428]

    Price:  $30.91

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

    This is 5400Lm 100m Diving 3X CREE XM-L XML U2 LED Flashlight Torch Waterproof Light. This is a high quality LED flashlight with strong light and durable material which will surely meet your various needs and bring you much convenience.


    * LED : 3X CREE XM-L U2 LED
    * Color BIN: white
    * Material: Aluminum
    * Luminous Flux: 5400Lm (max)
    * Battery cofigurations: 2 x 18650 battery
    * Voltage input: 9.4V
    * Switch type: Push
    * Modes: One to advance the brightness gradually
    * Lens: Coated glass lens
    * LED lifespan: 100000 hours
    * LED quantity: 3pcs
    * Reflector: Aluminum textured reflector
    * Size: 198 x 44(bezel) x 25mm(body)
    * Applications: Hard-anodized finish; Anti-abrasive free-scratch shock-proof; Ultra-deep trench structure; Skid-proof effect is excellent when diving

    Package Included:
    * 1 x Diving flashlight (batteries not included)


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 = '2046' and opa.orders_id = opb.orders_id and opb.products_id != '2046' 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