1. Quick Soft Rapid Neck Single Shoulder Belt Q Strap for DSLR Camera [55842]

    Price:  $8.26

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

    This Quick Shoulder Belt Strap System is good accessories in your Cameras. Look at the photos and you can see this strap is well put together.  No chance of your camera coming loose. This is truly a great product at a great price. The design stops the strap from slipping off your shoulder while letting you move the camera in any direction. Easy to put on and just as easy to take off, just a great all around product. Works perfectly with all cameras it attaches to the tripod hole on the bottom of the camera.

    * This Quick strap features a lightweight design that allows you to draw up your DSLR quickly on tripod.
    * Soft & comfortable padding.
    * Light-weighted. Overall DSLR weight is evenly distributed, and you still feel comfortable even after hours of continuous shooting.
    * Adjustable straps length.
    * Single strape
    * Durable metal hook & mounting plate.
    * Weight of Tripd Connection Plate   37g (0.08lb / 185ct) 

    Package Included
    * Quick Shoulder Belt Strap Set x1
    * Tripod Connection Plate x1

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