Liner: i vantaggi

Erreur SQL: Invalid column name 'famille_it_IT'. SELECT this.[_oid] AS this, this_s_documentation.[_oid] AS this_s_documentation, this.modele_it_IT AS this_p_modele_it_IT, this.descriptif_it_IT AS this_p_descriptif_it_IT, this.texte_it_IT AS this_p_texte_it_IT, this.plus_it_IT AS this_p_plus_it_IT, this.caracteristiques_techniques_it_IT AS this_p_caracteristiques_techniques_it_IT, this.video_it_IT AS this_p_video_it_IT, this.lien_it_IT AS this_p_lien_it_IT, this.legende_410_1_it_IT AS this_p_legende_410_1_it_IT, this.legende_410_2_it_IT AS this_p_legende_410_2_it_IT, this.legende_220_1_it_IT AS this_p_legende_220_1_it_IT, this.legende_220_2_it_IT AS this_p_legende_220_2_it_IT, this.legende_220_3_it_IT AS this_p_legende_220_3_it_IT, this.legende_220_4_it_IT AS this_p_legende_220_4_it_IT, this.legende_220_5_it_IT AS this_p_legende_220_5_it_IT, this_s_documentation_it.filename AS this_s_documentation_it_p_filename, this_s_documentation_it.extension AS this_s_documentation_it_p_extension, this_s_documentation_it.description_it_IT AS this_s_documentation_it_p_description_it_IT, this_s_documentation_it.[_oid] AS this_s_documentation_it, 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.width AS this_s_visuel_220_2_p_width, this_s_visuel_220_2.height AS this_s_visuel_220_2_p_height, this_s_visuel_220_2.frames AS this_s_visuel_220_2_p_frames, this_s_visuel_220_2.[_oid] AS this_s_visuel_220_2, 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_it_IT = N'Liner per piscine')) 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 On ((this.documentation = this_s_documentation.[_oid]) AND (this_s_documentation.iso_sid <> N'')) LEFT JOIN alb_private_resource AS this_s_documentation_it On ((this.documentation_it = this_s_documentation_it.[_oid]) AND (this_s_documentation_it.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 INNER JOIN alb_private_resource AS this_s_visuel_220_2_z On ((this_s_visuel_220_2.[_oid] = this_s_visuel_220_2_z.[_oid]) AND (this_s_visuel_220_2_z.iso_sid <> N'')) On ((this.visuel_220_2 = this_s_visuel_220_2.[_oid]) AND (this_s_visuel_220_2.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'')