FREE SHIPPING ON ORDERS OVER $50
EXEC [sp_StylePaging_Kevin_New3] 1, 49, '', '', '' ,'PLUS', 'Jackets & Vests','', 'ORDER BY DistDate Desc',''
EXEC [sp_StylePaging_Cnt_Kevin_New3] 1, 49, '', '', '' ,'PLUS', 'Jackets & Vests','', 'ORDER BY DistDate Desc',''
SELECT * FROM TblSubBanner Where Category = 'plus' AND SubCategory='jackets & vests'