[SELECT SQL_CALC_FOUND_ROWS id,COUNT(id) AS numMerchants,MIN(price) as minPrice FROM `products` WHERE category LIKE '%' GROUP BY search_name ORDER BY price DESC LIMIT 120,24][][SELECT FOUND_ROWS() as resultcount][][SELECT category FROM products WHERE category_seo='rum' LIMIT 1][]
Legnépszerűbb, legjobb - Strana 6 Elsomadiborhaz.hu
[SELECT DISTINCT category,count from category_list LIMIT 30;][]
