Antwort #5 am: 24. März 2011, 22:02:58
Hallo und danke für die Hilfe. Also aus der Datenbank lasse ich erstmal die Finger....
Wenn ich den CODE an der genannten Stelle einfüge, kommt folgende Fehlermeldung:
1064 - Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen bei 'group by 1, 2, 3, 4 order by 1, 4' in Zeile 30
select po.products_options_id options_id, po.products_options_name options_name, pv.products_options_values_id options_values_id, pv.products_options_values_name options_values_name, count(pa.products_id) option_values_count from products_options po join products_options_values_to_products_options pv2po on pv2po.products_options_id = po.products_options_id join products_options_values pv on pv.products_options_values_id = pv2po.products_options_values_id join products_attributes pa on pa.options_id = po.products_options_id and pa.options_values_id = pv.products_options_values_id join products_to_categories p2c on p2c.products_id = pa.products_id join products p on p.products_id = pa.products_id join (select p.products_id from products p join products_attributes pa on pa.products_id = p.products_id join products_options_values pv on pv.products_options_values_id = pa.options_values_id where pa.options_values_id in (300) and pv.language_id = 2 group by 1 having count(p.products_id) = (select count(products_options_values_id) from products_options_values where language_id = 2 and products_options_values_id in (300))) x on x.products_id = pa.products_id where p2c.categories_id = 1751 and po.language_id = 2 and pv.language_id = 2 and p.products_status = 1 order by products_options_sortorder group by 1, 2, 3, 4 order by 1, 4
[XT SQL Error]