1. High Quality Arm Velcro Wristband with Screw for Waterproof Shell for Gopro3+3/2/1[77001]

    Price:  $7.12

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

     It features wristband or arm strap with high quality  fixed the cameras of the users. It is a perfect option for people who have a passion for photographing. Allows for adjustable strap which  fits for different size of wrists and arms. You can do any other things easily, take pictures or record video at the same time.

    * Elastic strap suitable for any size of arms and wrists
    * Easy and quick to install and remove
    * Material: Nylon
    * Color: Black
    * Function: fix and carry the cameras for photographing
    * Application: for Gopro Hero

    Package Includes:
    1  x Arm velcro wristband
    1 x 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 = '2008' and opa.orders_id = opb.orders_id and opb.products_id != '2008' 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