1. Bicycle Sports Handlebar Mount Seatpost Pipe Rack Roll Bar Mounting for GoPro HD Hero3 Hero2 - Black[68273]

    Price:  $4.05

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

    The item is designed to help GoPro HD Hero3 Hero2 installĀ  handlebar mount on the sports bicycle. The mini tripod, lightweight and better stability make it a perfect option for you to operate picture and video recording when you are driving on the road.

    * Compatible with all HD Hero, Hero2, Hero3 camera
    * Easy to install and remove
    * It fit s for handlebar of 17MM-37MM in diameter
    * With better stability of the fixed camera on the bumpy road
    * be installed on the rail, the bicycle, bumper, ski pole, ACTS go walking sticks, etc., or any other in its grasp on a rod.

    * Brand Name: SINDAX OEM
    * Model: GP01
    * Color: Black
    * Weight: 70g
    * Size: 80 x 80 x 35mm
    * Extend Length: 23mm
    * material: ABS plastic

    Package Includes:
    1 x Sports Handlebar Mount 17mm - 23 mm
    Note: The camera and the housing are 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 = '1907' and opa.orders_id = opb.orders_id and opb.products_id != '1907' 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