47/47 records
mysql_findexxr: SELECT * FROM stock LEFT JOIN category AS category ON stock.category = category.recnum WHERE INSTR(LOWER(stock.manuf),'tannoy')>0 AND (stock.sell is NULL OR stock.sell >= 0) ORDER BY stock.sell DESC, stock.partid ASC LIMIT 5500