SELECT * FROM products WHERE grp = 'avaya' and display = 1 and sale_price > 0 limit 100