INVALID SQL: 1030 : Got error 28 from storage engine SQL QUERY FAILURE: SELECT sql_small_result shipping_promos.*
FROM shipping_promos INNER JOIN shipping_promo_prods_applied ON
shipping_promos.status = '1' AND
shipping_promos.first_synch != 'Y' AND
FROM_UNIXTIME('1337752693','%Y-%m-%d') BETWEEN shipping_promos.start_date AND
shipping_promos.end_date AND
shipping_promos.promoid = shipping_promo_prods_applied.promoid
WHERE shipping_promo_prods_applied.productid = '49208'
ORDER BY shipping_promos.order
Camber Sportswear Max-Weight Pocket T-Shirt 302. Taped neck and shoulders. Cover stitching on neck band, arm seams, shoulders and bottom. Rib collar and cuffs (3% lycra).
Product Tools:
Customer Reviews (last 2 of 2 total)
Bill G., Florida
This is one well made American made T. Camber is one of the few companies that make Tall sizes in their T's and sweats. Trust me, this Camber stuff is bomb-proof. Costs more than imported T's...but Camber is built to last. Camber and Silberman's have my business as long as Camber remains MADE IN THE USA.
Greg Templeton, Location Unknown
I've worn t-shirts for over 45 years and this is simply the best one I've ever owned. If you're looking for a rugged heavy-duty t-shirt that will last for years & years, this is it. Made in USA, outstanding quality. You won't be disappointed.
Cart is empty
