Your cart is empty
Add to Cart:

Rhino Pipe Tube 2m


The NEW Rhino Products Universal Pipe Tube Carrier. Modern design manufactured from aluminium tubing for lightness and strength. The end cones are manufactured from glass filled plastic with an integral steel bulkhead for increased strength and security, aerodynamic design lowers wind drag and noise. New locking mechanism improves security and the product has been fully crash tested at 20g. Full TUV approval has been obtained for this product.

3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'chamele1_direct.xp.sort_order' which is not in SELECT list; this is incompatible with DISTINCT
[select distinct p.products_id, p.products_image, pd.products_name from products_xsell xp, products p, products_description pd where xp.products_id = '1422' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 order by xp.sort_order asc limit 6]