[SELECT * , MIN( price ) AS minPrice, MAX( price ) AS maxPrice, COUNT( id ) AS numMerchants, MATCH name AGAINST ('Part x 2587 039 2 Lid Assembly 580C Multi') AS relevance FROM `products` WHERE MATCH name AGAINST ('Part x 2587 039 2 Lid Assembly 580C Multi') AND name <> 'Part #x-2587-039-2, Lid Assembly (580C), Multi' GROUP BY name ORDER BY relevance DESC LIMIT 9][Lost connection to server during query]
|