Wetsuit Boots

select * from (select distinct p.products_id, pd.products_page_heading, p.products_price, pd.products_name, p.products_tax_class_id, p.products_image, m.manufacturers_name from products p, products_description pd, manufacturers m where p.manufacturers_id = m.manufacturers_id and p.products_status = '1' and p.products_ordered_last_90 > 0 and p.products_id = pd.products_id and pd.language_id = '1' and products_price >= 30 order by p.boost DESC, p.products_ordered_last_90 desc, pd.products_name LIMIT 15) a order by rand() limit 4

From the blog

Essential Guide to Buoyancy AidsEssential Guide to Buoyancy Aids

Everything you need to know about buoyancy aids

MysticMystic's Guide to Impact Vests

Mystic have created some of the best impact vests available, but how do you choose between so many great options?

New In: Gill Zenlite Dinghy RangeNew In: Gill Zenlite Dinghy Range

The newest tech from Gill for warm weather sailing

Visiting from United States?

US Flag Continue to IE

Your browser is extremely out of date. We strongly recommend that you try a different browser for the best experience when using our website. Close.