Erreur SQL:
Invalid column name 'famille_it_IT'.
SELECT
this.[_oid] AS this,
this.modele_produit_it_IT AS this_p_modele_produit_it_IT,
this.descriptif_synthetique_produit_it_IT AS this_p_descriptif_synthetique_produit_it_IT,
this.caracteristiques_techniques_it_IT AS this_p_caracteristiques_techniques_it_IT,
this.lien_video_it_IT AS this_p_lien_video_it_IT,
this_s_visuel.width AS this_s_visuel_p_width,
this_s_visuel.height AS this_s_visuel_p_height,
this_s_visuel.frames AS this_s_visuel_p_frames,
this_s_visuel.[_oid] AS this_s_visuel,
this_s_visuel_z.description_it_IT AS this_s_visuel_z_p_description_it_IT,
this_s_documentation_commerciale_it.filename AS this_s_documentation_commerciale_it_p_filename,
this_s_documentation_commerciale_it.extension AS this_s_documentation_commerciale_it_p_extension,
this_s_documentation_commerciale_it.description_it_IT AS this_s_documentation_commerciale_it_p_description_it_IT,
this_s_documentation_commerciale_it.[_oid] AS this_s_documentation_commerciale_it
FROM (SELECT
this_k_1.result1 AS this_k_1_1,
this.[_oid] AS this,
this.rang_apparition AS o_1
FROM dm_card_fiche_produit 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_fiche_produit 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)
LEFT JOIN alb_private_resource AS this_s_documentation_commerciale_it
On ((this.documentation_commerciale_it = this_s_documentation_commerciale_it.[_oid]) AND (this_s_documentation_commerciale_it.iso_sid <> N''))
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'fiches_produits')
AND (this.famille_it_IT = N'Coperture per l''inverno e di sicurezza')
AND this_s_documentation_commerciale_it.[_oid] <> 0) as col INNER JOIN dm_card_fiche_produit 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_image AS this_s_visuel
INNER JOIN alb_private_resource AS this_s_visuel_z
On ((this_s_visuel.[_oid] = this_s_visuel_z.[_oid]) AND (this_s_visuel_z.iso_sid <> N''))
On ((this.visuel = this_s_visuel.[_oid]) AND (this_s_visuel.iso_sid <> N''))
LEFT JOIN alb_private_resource AS this_s_documentation_commerciale_it
On ((this.documentation_commerciale_it = this_s_documentation_commerciale_it.[_oid]) AND (this_s_documentation_commerciale_it.iso_sid <> N''))
WHERE
(this.iso_sid <> N'')
ORDER BY col.o_1 ASC
Per ulteriori informazioni sui questi prodotti, siete pregati di contattare il nostro personale incaricato.