Luftpolsterfolien

Erreur SQL: Invalid column name 'visuel_220_2_de'. SELECT this.[_oid] AS this, this.modele_de_DE AS this_p_modele_de_DE, this.descriptif_de_DE AS this_p_descriptif_de_DE, this.texte_de_DE AS this_p_texte_de_DE, this.plus_de_DE AS this_p_plus_de_DE, this.caracteristiques_techniques_de_DE AS this_p_caracteristiques_techniques_de_DE, this.video_de_DE AS this_p_video_de_DE, this.lien_de_DE AS this_p_lien_de_DE, this.legende_410_1_de_DE AS this_p_legende_410_1_de_DE, this.legende_410_2_de_DE AS this_p_legende_410_2_de_DE, this.legende_220_1_de_DE AS this_p_legende_220_1_de_DE, this.legende_220_2_de_DE AS this_p_legende_220_2_de_DE, this.legende_220_3_de_DE AS this_p_legende_220_3_de_DE, this.legende_220_4_de_DE AS this_p_legende_220_4_de_DE, this.legende_220_5_de_DE AS this_p_legende_220_5_de_DE, this_s_documentation_de.filename AS this_s_documentation_de_p_filename, this_s_documentation_de.extension AS this_s_documentation_de_p_extension, this_s_documentation_de.description_de_DE AS this_s_documentation_de_p_description_de_DE, this_s_documentation_de.[_oid] AS this_s_documentation_de, this_s_visuel_410_1.width AS this_s_visuel_410_1_p_width, this_s_visuel_410_1.height AS this_s_visuel_410_1_p_height, this_s_visuel_410_1.frames AS this_s_visuel_410_1_p_frames, this_s_visuel_410_1.[_oid] AS this_s_visuel_410_1, this_s_visuel_410_2.width AS this_s_visuel_410_2_p_width, this_s_visuel_410_2.height AS this_s_visuel_410_2_p_height, this_s_visuel_410_2.frames AS this_s_visuel_410_2_p_frames, this_s_visuel_410_2.[_oid] AS this_s_visuel_410_2, this_s_visuel_220_1.width AS this_s_visuel_220_1_p_width, this_s_visuel_220_1.height AS this_s_visuel_220_1_p_height, this_s_visuel_220_1.frames AS this_s_visuel_220_1_p_frames, this_s_visuel_220_1.[_oid] AS this_s_visuel_220_1, this_s_visuel_220_2_de.width AS this_s_visuel_220_2_de_p_width, this_s_visuel_220_2_de.height AS this_s_visuel_220_2_de_p_height, this_s_visuel_220_2_de.frames AS this_s_visuel_220_2_de_p_frames, this_s_visuel_220_2_de.[_oid] AS this_s_visuel_220_2_de, this_s_visuel_220_3.width AS this_s_visuel_220_3_p_width, this_s_visuel_220_3.height AS this_s_visuel_220_3_p_height, this_s_visuel_220_3.frames AS this_s_visuel_220_3_p_frames, this_s_visuel_220_3.[_oid] AS this_s_visuel_220_3, this_s_visuel_220_4.width AS this_s_visuel_220_4_p_width, this_s_visuel_220_4.height AS this_s_visuel_220_4_p_height, this_s_visuel_220_4.frames AS this_s_visuel_220_4_p_frames, this_s_visuel_220_4.[_oid] AS this_s_visuel_220_4, this_s_visuel_220_5.width AS this_s_visuel_220_5_p_width, this_s_visuel_220_5.height AS this_s_visuel_220_5_p_height, this_s_visuel_220_5.frames AS this_s_visuel_220_5_p_frames, this_s_visuel_220_5.[_oid] AS this_s_visuel_220_5 FROM (SELECT this_k_1.result1 AS this_k_1_1, this.[_oid] AS this FROM dm_card_pages_produits AS this INNER JOIN ocs_card AS this_z LEFT JOIN ocs_catalog AS this_z_s_ocsCatalog On ((this_z.ocsCatalog = this_z_s_ocsCatalog.[_oid]) AND (this_z_s_ocsCatalog.iso_sid <> N'')) On ((this.[_oid] = this_z.[_oid]) AND (this_z.iso_sid <> N'')) LEFT JOIN (SELECT c0.[_oid] AS origin, COUNT(DISTINCT this.[_oid]) AS result1 FROM xrm_category AS this INNER JOIN dm_card_pages_produits AS c0 INNER JOIN ocs_card_ocsVisibility AS c0_l On ((c0.[_oid] = c0_l.[_from]) AND (c0.iso_sid <> N'')) INNER JOIN ocs_card AS c0_z On ((c0.[_oid] = c0_z.[_oid]) AND (c0_z.iso_sid <> N'')) On ((this.[_oid] = c0_l.[_to]) AND (c0_l.iso_sid <> N'')) WHERE (this.iso_sid <> N'') AND (this.[_oid] IN (515, 517)) GROUP BY c0.[_oid]) AS this_k_1 On (this.[_oid] = this_k_1.origin) WHERE (this.iso_sid <> N'') AND (CASE WHEN (this_z_s_ocsCatalog.useValidation = 1) THEN this_z.ocsStatus ELSE CASE WHEN ((this_z.ocsStatus = 2) OR (this_z.ocsStatus = 3)) THEN this_z.ocsStatus ELSE 0 END END = 2) AND ((this_z_s_ocsCatalog.useXRM = 0) OR ((this_z_s_ocsCatalog.useXRM = 1) AND (this_k_1.result1 > 0))) AND (this_z_s_ocsCatalog.name = N'pages_produits') AND (this.famille_de_DE = N'Luftpolsterfolien')) as col INNER JOIN dm_card_pages_produits AS this ON this._oid = col.this INNER JOIN ocs_card AS this_z On ((this.[_oid] = this_z.[_oid]) AND (this_z.iso_sid <> N'')) LEFT JOIN alb_private_resource AS this_s_documentation_de On ((this.documentation_de = this_s_documentation_de.[_oid]) AND (this_s_documentation_de.iso_sid <> N'')) LEFT JOIN alb_private_image AS this_s_visuel_410_1 INNER JOIN alb_private_resource AS this_s_visuel_410_1_z On ((this_s_visuel_410_1.[_oid] = this_s_visuel_410_1_z.[_oid]) AND (this_s_visuel_410_1_z.iso_sid <> N'')) On ((this.visuel_410_1 = this_s_visuel_410_1.[_oid]) AND (this_s_visuel_410_1.iso_sid <> N'')) LEFT JOIN alb_private_image AS this_s_visuel_410_2 INNER JOIN alb_private_resource AS this_s_visuel_410_2_z On ((this_s_visuel_410_2.[_oid] = this_s_visuel_410_2_z.[_oid]) AND (this_s_visuel_410_2_z.iso_sid <> N'')) On ((this.visuel_410_2 = this_s_visuel_410_2.[_oid]) AND (this_s_visuel_410_2.iso_sid <> N'')) LEFT JOIN alb_private_image AS this_s_visuel_220_1 INNER JOIN alb_private_resource AS this_s_visuel_220_1_z On ((this_s_visuel_220_1.[_oid] = this_s_visuel_220_1_z.[_oid]) AND (this_s_visuel_220_1_z.iso_sid <> N'')) On ((this.visuel_220_1 = this_s_visuel_220_1.[_oid]) AND (this_s_visuel_220_1.iso_sid <> N'')) LEFT JOIN alb_private_image AS this_s_visuel_220_2_de INNER JOIN alb_private_resource AS this_s_visuel_220_2_de_z On ((this_s_visuel_220_2_de.[_oid] = this_s_visuel_220_2_de_z.[_oid]) AND (this_s_visuel_220_2_de_z.iso_sid <> N'')) On ((this.visuel_220_2_de = this_s_visuel_220_2_de.[_oid]) AND (this_s_visuel_220_2_de.iso_sid <> N'')) LEFT JOIN alb_private_image AS this_s_visuel_220_3 INNER JOIN alb_private_resource AS this_s_visuel_220_3_z On ((this_s_visuel_220_3.[_oid] = this_s_visuel_220_3_z.[_oid]) AND (this_s_visuel_220_3_z.iso_sid <> N'')) On ((this.visuel_220_3 = this_s_visuel_220_3.[_oid]) AND (this_s_visuel_220_3.iso_sid <> N'')) LEFT JOIN alb_private_image AS this_s_visuel_220_4 INNER JOIN alb_private_resource AS this_s_visuel_220_4_z On ((this_s_visuel_220_4.[_oid] = this_s_visuel_220_4_z.[_oid]) AND (this_s_visuel_220_4_z.iso_sid <> N'')) On ((this.visuel_220_4 = this_s_visuel_220_4.[_oid]) AND (this_s_visuel_220_4.iso_sid <> N'')) LEFT JOIN alb_private_image AS this_s_visuel_220_5 INNER JOIN alb_private_resource AS this_s_visuel_220_5_z On ((this_s_visuel_220_5.[_oid] = this_s_visuel_220_5_z.[_oid]) AND (this_s_visuel_220_5_z.iso_sid <> N'')) On ((this.visuel_220_5 = this_s_visuel_220_5.[_oid]) AND (this_s_visuel_220_5.iso_sid <> N'')) WHERE (this.iso_sid <> N'')