Adventure Caps

These sturdy outdoors-ready caps are perfect for wear on any hunting, fishing, camping, or hiking excursion.

Whether your company specializes in providing hunting gear or you simply want rugged caps that will last for years to come, the Adventure Cap series offers a wide range of great choices.

1054 - Unknown column 'p.products_id' in 'on clause'

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '24'

[TEP STOP]