Warenkorb

Bisher sind keine Artikel ausgewählt.


Währung
No valid database connection Unknown column 'prod.manufacturer_id' in 'order clause' SQL=SELECT prod.product_id, prod.product_thumb_image, prod.product_publish, pr_cat.product_ordering, pr_cat.category_id, (prod.product_price*1.000000000000) AS product_price, IFNULL(cur_lang.product_name, def_lang.product_name) AS product_name, IFNULL(cur_lang.product_short_description, def_lang.product_short_description) AS product_short_description, manuf.manufacturer_name, prod.product_manufacturer_id FROM `lenz_jshopping_products` AS prod LEFT JOIN `lenz_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id INNER JOIN `lenz_jshopping_manufacturers` AS manuf ON manuf.manufacturer_id = prod.product_manufacturer_id LEFT JOIN `lenz_jshopping_products_description` AS cur_lang ON cur_lang.product_id = prod.product_id AND cur_lang.language = 'german' LEFT JOIN `lenz_jshopping_products_description` AS def_lang ON def_lang.product_id = prod.product_id AND def_lang.language = 'german' WHERE manuf.manufacturer_id = '118' AND prod.product_publish = 1 ORDER BY prod.manufacturer_id ASC LIMIT 20 , 10

Produkte

Volltext-Suche Suche nach Hersteller, A-Z Suche nach Produkt, A-Z
Suchen
OK
OK
Zur Herstellerübersicht Haben Sie ein gesuchtes Produkt nicht gefunden?
SparkDynamic GmbH
Neuhofstrasse 17, 8630 Rüti, Switzerland, Telefon-Nr. +41 43 501 30 30 Telefax-Nr. +41 43 501 30 33