Ein unerwarteter Fehler ist aufgetreten.

An exception occurred while executing ' SELECT variationen.reise_variation_id , variationen.FK_akeneo_id AS variation_akeneo_id , variationen.name , variationen.seo_url_key , variationen.FK_reise_id AS reise_id , reisen.FK_akeneo_id AS reise_akeneo_id , reisen.name AS reise_name , termine.anzahlUebernachtungen , va.family_id AS reise_family_id , veranstalter.FK_akeneo_id AS veranstalter_akeneo_id , IF(sortierung_akeneo.value_decimal IS NULL, 0, 1) AS hatSortierschluessel FROM usrdb_ebuchcbl_backend.eb_reise_variationen variationen JOIN usrdb_ebuchcbl_backend.eb_reise_variationen_etappen etappen ON etappen.FK_reise_variation_id=variationen.reise_variation_id JOIN usrdb_ebuchcbl_backend.eb_reisen reisen ON reisen.reise_id=variationen.FK_reise_id JOIN usrdb_ebuchcbl_backend.eb_termine termine ON termine.FK_reise_variation_id = variationen.reise_variation_id LEFT JOIN usrdb_ebuchcbl_akeneo2.pim_catalog_product va ON va.id=reisen.FK_akeneo_id JOIN usrdb_ebuchcbl_backend.eb_veranstalter veranstalter ON veranstalter.veranstalter_id=reisen.FK_veranstalter_id LEFT JOIN usrdb_ebuchcbl_akeneo2.pim_catalog_product_value sortierung_akeneo ON sortierung_akeneo.entity_id=variationen.FK_akeneo_id AND sortierung_akeneo.attribute_id=94 WHERE variationen.reise_variation_id IN () AND variationen.aktiv=1 GROUP BY variationen.reise_variation_id ORDER BY hatSortierschluessel DESC , sortierung_akeneo.value_decimal DESC , variationen.name ASC ': SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND variationen.aktiv=1 GROUP BY variationen.reise_variation_id ORDER BY' at line 6

< Zurück zur Startseite