quote: q: schenker
SELECT SQL_NO_CACHE catalog.stock_num, catalog.descr, catalog.cat, DATE_FORMAT(catalog.release_date, '%m/%d/%y') as rdate, DATE_FORMAT(catalog.prebook_date, '%m/%d/%y') as pdate, MATCH(search_text_short) AGAINST ('+schenker ') AS score FROM catalog_search INNER JOIN catalog ON catalog_search.stock_num = catalog.stock_num LEFT JOIN extended_data ON extended_data.stock_num = catalog.stock_num WHERE loc_num='001' AND match(search_text_short) against('+schenker ') ORDER BY score DESC LIMIT 0, 50