1. Window Mount Suction Cup Tripod For GoPro HD Hero1, Hero2, Hero3 w/ 7-cm Diameter Base - Black[68281]

    Price:  $0.00

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

    The item is designed to help gopro camera HD Hero3+/3/2/1 install and fix firmly. Besides, It is used with the camera mount, like as helmet straps. Llightweight and better stability make it a perfect option for you to operate picture and video recording.

    * Holder is for Gopro to be mouted in car
    * Anti-shake design, records high resolution video even on  bumpy roads
    * Dash / Windshield sunction mount for Gopro Camera
    * 180 degrees rotation and adjustable arm for optimum positioning
    * Can be mouted on dash with included adhesive mounting desk
    * Use: Digital camera
    * Type: Mini Tripod / Lightweight
    * Size: 10 x 10 x 10cm

    Package Includes:
    1 x  Suction Cup Tripod

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