Katalog
Přihlášení uživatele
AKČNÍ NABÍDKY ![více zde](/images/btn_vicezde.png)
45000,– Kč
![Kompletní sportovní podvozek H&R pro BMW řada 3 (E46) Touring Typ 346L, 2WD, jen 330d, se snížením 35/20mm](/upl/images-mini_101337.jpg)
14999,– Kč
![Sportovní kit sání Pipercross na Škoda Octavia III RS 5E 1.8/2.0 TSi EA888 Gen3 (karbonový airbox)](/upl/images-mini_85061.jpg)
13380,– Kč
SQL failed: Unknown column 'prodShortDesc1.ppvValue' in 'where clause'|SELECT DISTINCT
MATCH(prodName) AGAINST('+powerflex +S60') as relevance
,p.*
FROM products p
LEFT JOIN productBrand ON
pbId = prodBrand
INNER JOIN productGroups ON
pgId = prodGroup
AND pgShow = 1
AND prodShow = 1
LEFT JOIN prodDesignation ON
pdProdId = prodId
LEFT JOIN carModels ON
cmId = pdCarModel WHERE (( prodDesc LIKE '%powerflex%' AND prodDesc LIKE '%S60%' ) OR ( prodCode LIKE '%powerflex%' AND prodCode LIKE '%S60%' ) OR ( pbName LIKE '%powerflex%' AND pbName LIKE '%S60%' ) OR ( prodShortDesc1.ppvValue LIKE '%powerflex%' AND prodShortDesc1.ppvValue LIKE '%S60%' ) OR ( prodShortDesc2.ppvValue LIKE '%powerflex%' AND prodShortDesc2.ppvValue LIKE '%S60%' ) OR ( prodDesc1.ppvValue LIKE '%powerflex%' AND prodDesc1.ppvValue LIKE '%S60%' ) OR ( prodDesc2.ppvValue LIKE '%powerflex%' AND prodDesc2.ppvValue LIKE '%S60%' )) ORDER BY relevance DESC, prodName ASC LIMIT 18, 18