Used gear for sale lighting and accessories

mysql_findexxr: SELECT * FROM stock LEFT JOIN category AS category ON stock.category = category.recnum WHERE INSTR(LOWER(category.descr),'lighting')>0 AND (INSTR(CONCAT_WS(' ',LOWER(category.descr),LOWER(stock.partid),LOWER(stock.image),LOWER(stock.manuf),LOWER(stock.modelno),LOWER(stock.descr)),'laser')>0) AND stock.sell3 >= 1 ORDER BY stock.sell3 DESC, stock.partid ASC LIMIT 5500