GARANCIA NAJNIŽŠEJ CENY
Podľa údajov z porovnávačov cien je naša ponuka dnes na Slovensku najlacnejšia. S nami ušetríte.
Ďalšie farby:
Cena vr. DPH: €186.48
Vrátenie tovaru do 14 dní bez udania dôvodu
Kód:
7972
Záruka:
24 mesiacov
Doplnky Fuxo
Darček zadarmo k stoličkám Fuxo - prosím vyberte iba jeden
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND p.products_id = pd.products_id
AND pd.l' at line 17
SELECT
p.products_id, p.products_image, p.products_tax_class_id, p.products_ordered, p.products_quantity, p.products_delivery,
p.products_id, pd.language_id, p.size,
pd.products_name, p.products_price,
(SELECT specials_new_products_price FROM specials WHERE specials.status = 1 AND p.products_id = specials.products_id ORDER BY specials.specials_id DESC LIMIT 1) AS price_new,
(SELECT products_price FROM products_prices WHERE p.products_id = products_prices.products_id AND products_prices.language_id = 7) AS language_products_price
FROM
products_description pd,
products p
WHERE
p.products_accessories_group = (2796)
AND p.products_price > 0
AND p.products_accessories_group <> '-1'
AND p.products_id <>
AND p.products_id = pd.products_id
AND pd.language_id = '7'
AND p.products_status = '1'
AND pd.products_name <> ' '
GROUP BY p.products_id
ORDER BY p.products_ordered_last_3_month DESC, p.products_quantity DESC