[SELECT COUNT(*) AS resultcount FROM (SELECT search_name FROM `pt_products` USE INDEX (name_2) WHERE MATCH name AGAINST ('') GROUP BY search_name LIMIT 301) AS search_count_cap][][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 300) AS search_results_capped LIMIT 0,40][] Vypínák kulový kloub ENERGY NE00261

Všechny kategorie
Obchody
Kategorie autodílů
[SELECT id, name, slug FROM `pt_categories` WHERE parent_id=0 ORDER BY name LIMIT 20][]
Dle značky auta
[SELECT id, name, slug FROM `pt_vehicle_brands` WHERE parent_id=0 ORDER BY name LIMIT 20][]
Pneumatiky

Kontakt

Hledali jste: Vypínák kulový kloub ENERGY NE00261

Žádný výsledek :(

Bohužel Vašemu vyhledávání neodpovídá žádný produkt z naší databáze.

Zkuste se podívat do našich kategorií:

[Select * from pt_category_list WHERE category REGEXP '^[a-zA-Z]+[y]$' ORDER by count DESC LIMIT 25; ][]

Nebo se podívejte se na naše oblíbené značky vozidel:

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

↑