47/47 records
mysql_findinxr: SELECT * FROM stock LEFT JOIN category AS category ON stock.category = category.recnum WHERE INSTR(LOWER(stock.manuf),'jbl')>0 AND (INSTR(CONCAT_WS(' ',LOWER(stock.manuf),LOWER(stock.partid),LOWER(stock.modelno),LOWER(stock.descr),LOWER(stock.image),LOWER(category.descr)),'jbl22')>0 OR INSTR(CONCAT_WS(' ',LOWER(stock.manuf),LOWER(stock.partid),LOWER(stock.modelno),LOWER(stock.descr),LOWER(stock.image),LOWER(category.descr)),'jbl24')>0 OR INSTR(CONCAT_WS(' ',LOWER(stock.manuf),LOWER(stock.partid),LOWER(stock.modelno),LOWER(stock.descr),LOWER(stock.image),LOWER(category.descr)),'jbl23')>0 OR INSTR(CONCAT_WS(' ',LOWER(stock.manuf),LOWER(stock.partid),LOWER(stock.modelno),LOWER(stock.descr),LOWER(stock.image),LOWER(category.descr)),'jbl21')>0) AND (stock.sell is NULL OR stock.sell >= 0) AND stock.image >'' ORDER BY stock.sell DESC, stock.partid ASC LIMIT 5500