35/35 records
sql_findeqxr qvalues =monitor studio
mysql_findeqxr: SELECT * FROM stock LEFT JOIN category AS category ON stock.category = category.recnum WHERE LOWER(stock.manuf) = 'jbl' AND (INSTR(CONCAT_WS(' ',LOWER(stock.manuf),LOWER(stock.partid),LOWER(stock.modelno),LOWER(stock.descr),LOWER(stock.image),LOWER(category.descr)),'monitor')>0 AND INSTR(CONCAT_WS(' ',LOWER(stock.manuf),LOWER(stock.partid),LOWER(stock.modelno),LOWER(stock.descr),LOWER(stock.image),LOWER(category.descr)),'studio')>0) AND (stock.sell is NULL OR stock.sell >= 0) AND stock.image >'' ORDER BY stock.sell DESC, stock.partid ASC LIMIT 5000