Antwort #7 am: 05. April 2013, 17:26:00
don't panic...
es soll mir keiner einen Code vorkauen. Den kann ich selbst coden.
Problem ist, dass ich XTC nicht kenne und dessen symbosen nicht.
Grad hab ich ewig dran gesessen um das mit den Staffelpreisen zu verstehen.
Nun steh ich vor den attributen, wo ich aufgrund der masse an informationen bis dato keinen Weg reinfinde.
SELECT p.*,
pd.*,
cd.categories_name,
cd.categories_id,
tr.tax_rate,
tr.tax_description,
GROUP_CONCAT(DISTINCT CONCAT(pi.image_nr, '=', pi.image_name) SEPARATOR ',') AS images,
GROUP_CONCAT(DISTINCT CONCAT( po.quantity, '=', po.personal_offer) SEPARATOR ',') AS prices
FROM ( products AS p,
products_description AS pd,
tax_rates AS tr
)
RIGHT JOIN products_to_categories AS ptc ON p.products_id = ptc.products_id
LEFT JOIN categories AS c ON ptc.categories_id = c.categories_id
LEFT JOIN categories_description AS cd ON c.categories_id = cd.categories_id
LEFT JOIN products_images AS pi ON pi.products_id = p.products_id
LEFT JOIN personal_offers_by_customers_status_0 AS po ON po.products_id = p.products_id
WHERE p.products_id = pd.products_id
AND p.products_tax_class_id = tr.tax_rates_id
AND pd.language_id = (SELECT `languages_id` FROM `languages` WHERE `name` = 'Deutsch')
AND p.products_id = 4297
GROUP BY p.products_id
ORDER BY p.products_id
Nunja... mal schaun, ob sich einer erbarmt ... ansonsten hab ich jetzt schon mal für die nachwelt festgehalten