Antwort #16 am: 28. Mai 2010, 13:43:25
Hallo Marco,
sind eure Artikel Kategorien zugeordnet? Bzw was liefern die folgenden Abfragen, wenn Du sie direkt auf dem Server ausführst:
SELECT p.products_tax_class_id, p.products_sort, p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_discount_allowed, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.products_startpage, p.products_startpage_sort
FROM products p, products_description pd, products_to_categories p2c
WHERE p.products_id = pd.products_id
AND pd.language_id = '2'
AND p.products_id = p2c.products_id
AND p2c.categories_id = '0'
ORDER BY p.products_sort, pd.products_name ASC
und die hier
SELECT COUNT(*)
FROM products p, products_description pd, products_to_categories p2c
WHERE p.products_id = pd.products_id
AND pd.language_id = '2'
AND p.products_id = p2c.products_id
AND p2c.categories_id = '0'
Grüße, Volker