[SELECT SQL_CALC_FOUND_ROWS id,COUNT(id) AS numMerchants,MIN(price) as minPrice FROM `products` WHERE ean LIKE '%' GROUP BY search_name LIMIT 0,24][][SELECT FOUND_ROWS() as resultcount][]
Vyhledávání pomocí EAN kódu 885075878033 - Outdoor Millitary
[SELECT DISTINCT category,count from category_list LIMIT 30;][]
