1. B Model Floating Handheld Stick Floaty Grip Stabilizer Bobber w/ Strap + Screw for Gopro Hero3+/3/2/1[68298]

    Price:  $8.65

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

    The item is designed specially  to fix your camera when you take pictures and record video on the water. The handheld stick,  floaty grip, high quality and practical function make it a perfect option for you. Besides, its bright yellow color make it easy to spot and save when your device drop in the water.

    * Quick and simple to assemble on camera
    * Strong and durable material
    * Wristband is adjustable

    * Appropriate for all Hero 3+/3/2/1
    * Designed for your GoPro camera
    * Provides easy and quick photographing even on the water

    * Material: Plastic
    * Color: Yellow / Orange
    * Weight: 70g
    * Package Size: 20 x 10 x 5 cm

    Package Includes:
    1 x Floaty stick
    1 x Wristband
    1 x Long Screw

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