|
|
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 = '98' AND prod.product_publish = 1
ORDER BY prod.manufacturer_id ASC LIMIT 0 , 10
Warning: Invalid argument supplied for foreach() in /usr/www/users/lenz48/components/com_jshopping/functions.php on line 489
|
Volltext-Suche
|
Suche nach Hersteller, A-Z
|
Suche nach Produkt, A-Z
|
|
|
|
|
|
Lenzinger GmbH - lenzinger.net
Schulhausstrasse, CH-8340 Hinwil, Switzerland, Tel: +41 43 843 23 50, Fax: +41 43 843 23 60
|
All rights reserved. © 2013 lenzinger.net
|
Login
