[SELECT SQL_CALC_FOUND_ROWS id,COUNT(id) AS numMerchants,MIN(price) as minPrice FROM `pt_products` WHERE (search_name LIKE '%%' OR search_name LIKE '%%') AND (search_name LIKE '%%' OR search_name LIKE '%%') AND (search_name LIKE '%%') AND (search_name LIKE '%%') GROUP BY search_name ORDER BY minPrice DESC LIMIT 0,50][][SELECT FOUND_ROWS() as resultcount][]