[SELECT * FROM (SELECT id,COUNT(id) AS numMerchants,MIN(price) as minPrice FROM `pt_products` WHERE (search_name LIKE '%%') AND (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 500) AS search_results_capped LIMIT 0,40][] [SELECT * FROM `pt_products` WHERE id IN ()][] Zaparkorun Nerezový lis na česnek | By

Vítejte v nejlepších cenách

Porovnávejte ceny a najděte tu nejlepší

Kategorie

Obchody
TOP kategorie
[SELECT id, name, slug FROM `pt_categories` WHERE parent_id=0 ORDER BY name LIMIT 20][]
Články
[SELECT slug, h1_title, price_limit FROM `pt_price_pages` WHERE is_active=1 ORDER BY price_limit ASC LIMIT 10][] Dárky podle ceny
Kontakt

Nejprodávanější

Vyhledávali jste: Zaparkorun Nerezový lis na česnek

[SELECT * , MIN( price ) AS minPrice, MAX( price ) AS maxPrice, COUNT( id ) AS numMerchants, CASE normalised_name WHEN '' THEN 3 END AS sequence FROM `pt_products` WHERE normalised_name IN ('Millhills London Dry 07 L 38') AND merchant!='TopAlkohol.cz' GROUP BY normalised_name ORDER BY sequence][]

↑