35% OFF EARLY BLACK FRIDAY SALE | USE CODE: BF35
EXEC [sp_StylePaging_Kevin_New3_TEST_LC] 721, 769, '', '', '' ,'bottoms', 'jeans','', 'ORDER BY DistDate Desc',''
EXEC [sp_StylePaging_Cnt_Kevin_New3_TEST_LC] 721, 769, '', '', '' ,'bottoms', 'jeans','', 'ORDER BY DistDate Desc',''
SELECT * FROM TblSubBanner Where Category = 'bottoms' AND SubCategory='jeans'