SELECT DISTINCT Category, SubCategory, Image1 FROM SHOP_PRODUCTS_HEADER WHERE Active = 'Y' AND ActiveOnline = 'Y' AND CategoryImage = 'Y' AND Category = 'category.asp'