Showjackets from Espayo Equestrian

SELECT *, ((rrp-sale_price)/rrp)*100 as percentage FROM products WHERE deleted=0 AND active=1 AND category_level_1 = 'Ladies' AND (brand ='Cavalleria Toscana') AND (category_level_2 ='Showjackets') GROUP BY linked_id ORDER BY rrp ASC LIMIT 0, 30