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