[SELECT * FROM (SELECT id,COUNT(id) AS numMerchants,MIN(price) as minPrice, MATCH name AGAINST ('') AS relevance FROM `pt_products` USE INDEX (name_2) WHERE MATCH name AGAINST ('') GROUP BY search_name ORDER BY relevance DESC LIMIT 500) AS search_results_capped LIMIT 160,40][] [SELECT * FROM `pt_products` WHERE id IN ()][] Dámská sukně LITEX černá Barva: černá Velikost: 46 | Strana 5

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: černá Velikost

[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][]

↑