[SELECT SQL_CALC_FOUND_ROWS id,COUNT(id) AS numMerchants,MIN(price) as minPrice FROM `pt_products` WHERE brand = 'bpc bonprix collection' GROUP BY search_name LIMIT 0,10][]