SQL Used = SELECT SQL_CALC_FOUND_ROWS *,COUNT(id) AS numMerchants,MIN(price) as minPrice FROM `pt_products` WHERE match(name, description) against ('' in boolean mode) GROUP BY search_name