Coperture a bolle
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_it.width AS this_s_visuel_220_2_it_p_width,
this_s_visuel_220_2_it.height AS this_s_visuel_220_2_it_p_height,
this_s_visuel_220_2_it.frames AS this_s_visuel_220_2_it_p_frames,
this_s_visuel_220_2_it.[_oid] AS this_s_visuel_220_2_it,
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'Coperture a bolle')) 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_it
INNER JOIN alb_private_resource AS this_s_visuel_220_2_it_z
On ((this_s_visuel_220_2_it.[_oid] = this_s_visuel_220_2_it_z.[_oid]) AND (this_s_visuel_220_2_it_z.iso_sid <> N''))
On ((this.visuel_220_2_it = this_s_visuel_220_2_it.[_oid]) AND (this_s_visuel_220_2_it.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'')
Per ulteriori informazioni sui questi prodotti, siete pregati di contattare il nostro personale incaricato.
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_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
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)
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 a bolle')) 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''))
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.
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_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
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)
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 a bolle OXO')) 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''))
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.
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_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
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)
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 a bolle Geobubble')) 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''))
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.
Erreur SQL:
Invalid column name 'famille_it_IT'.
SELECT
this.[_oid] AS this,
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.filename AS this_s_documentation_p_filename,
this_s_documentation.extension AS this_s_documentation_p_extension,
this_s_documentation.description_it_IT AS this_s_documentation_p_description_it_IT,
this_s_documentation.[_oid] AS this_s_documentation,
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'Couvertures à bulles garanties IT')) 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_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'')
Aucune fiche disponible pour le moment.
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'Finitura delle coperture a bolle')) 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'')
Per ulteriori informazioni sui questi prodotti, siete pregati di contattare il nostro personale incaricato.
