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