1. 20M Outdoor Waterproof DSLR SLR Digital Camera Underwater Housing Case Pouch Dry Bag For Canon Nikon-Color Random[63791]

    Price:  $7.09

    This product was added to our catalog on Saturday 01 November, 2014.

    This waterproof DSLR SLR digital camera underwater dry bag can help you photo under water easily, it also suit for cellphone, PSP, mp3, mp4 and etc, really a good outside Photographic accessories.

    * Waterproof SLR Camera cover, dust, sand, snow and wind proof, waterproof, anti-acid and alkali.
    * The camera into the waterproof cover, do not affect the film quality.
    * The waterproof cover allows you to comfortably operate the machines function.
    * Waterproof cover on the back of a transparent design, easy to use camera function and enjoy photos.
    * Hanging provide neck protection. Three insurance airtight seal.
    * No need to worry about falling into the water, you can float.
    The waterproof cover allows you to operate various functions, and prevent your camera from damaging and breaking.
    * Compatible with: most of SLR cameras like Canon, Sony, Nikon, Sigma, Tarmon, Olympus, Fujifilm and Pentax. (Note: Lens alone should not be longer than 80mm.)
    * If falling into the water when using this product, the camera will automatically float on the water.
    * Material: PVC TPU
    * Size: 27cm x 22.5cm x 8cm (Length of strap: about 50cm)
    * Color; Random


    Note: Please test and examine carefully for any potentially water leaking places such as edges and sealers before each usage.


    * 1 x Waterproof Punch Bag



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