[SELECT SQL_CALC_FOUND_ROWS id,COUNT(id) AS numMerchants,MIN(price) as minPrice, MATCH name AGAINST ('') AS relevance FROM `products` WHERE MATCH name AGAINST ('') GROUP BY search_name ORDER BY relevance DESC LIMIT 0,24][][SELECT FOUND_ROWS() as resultcount][]
Výsledky vyhledávání: křesadlo
[SELECT DISTINCT category,count from category_list LIMIT 30;][]
