Reids Tackle

Sales Message Goes Here


Product 31/31

Previous
Return to the Product List
Next

Preston Innovations Rod Safe - U

£6.99

Designed to be extremely simple and compact, the Rod Safe – U is tough, durable and perfect for almost any type of fishing. There is a deep line slot at the base of the rest allowing you to move your line while the rod is in the rest, essential for tensioning your line correctly. The height of the sides has been calculated to ensure maximum security, while still being easy to remove the rod when a bite occurs.

Add to Cart:

  • Manufactured by: Preston Innovations


This product was added to our catalog on Tuesday 10 November, 2020.

1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'db1712967_reids.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
in:
[select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '4254' and opa.orders_id = opb.orders_id and opb.products_id != '4254' 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 6]