FREE SHIPPING ON ORDERS OVER $50
EXEC [sp_StylePaging_Kevin_New3] 1, 49, '', '', '' ,'BOTTOMS', 'Junior Deal','', 'ORDER BY DistDate Desc',''
EXEC [sp_StylePaging_Cnt_Kevin_New3] 1, 49, '', '', '' ,'BOTTOMS', 'Junior Deal','', 'ORDER BY DistDate Desc',''
SELECT * FROM TblSubBanner Where Category = 'bottoms' AND SubCategory='junior deal'