Bubble covers
Erreur SQL:
Invalid column name 'visuel_220_2_en'.
SELECT
this.[_oid] AS this,
this.modele_en_GB AS this_p_modele_en_GB,
this.descriptif_en_GB AS this_p_descriptif_en_GB,
this.texte_en_GB AS this_p_texte_en_GB,
this.plus_en_GB AS this_p_plus_en_GB,
this.caracteristiques_techniques_en_GB AS this_p_caracteristiques_techniques_en_GB,
this.video_en_GB AS this_p_video_en_GB,
this.lien_en_GB AS this_p_lien_en_GB,
this.legende_410_1_en_GB AS this_p_legende_410_1_en_GB,
this.legende_410_2_en_GB AS this_p_legende_410_2_en_GB,
this.legende_220_1_en_GB AS this_p_legende_220_1_en_GB,
this.legende_220_2_en_GB AS this_p_legende_220_2_en_GB,
this.legende_220_3_en_GB AS this_p_legende_220_3_en_GB,
this.legende_220_4_en_GB AS this_p_legende_220_4_en_GB,
this.legende_220_5_en_GB AS this_p_legende_220_5_en_GB,
this_s_documentation_en.filename AS this_s_documentation_en_p_filename,
this_s_documentation_en.extension AS this_s_documentation_en_p_extension,
this_s_documentation_en.description_en_GB AS this_s_documentation_en_p_description_en_GB,
this_s_documentation_en.[_oid] AS this_s_documentation_en,
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_en.width AS this_s_visuel_220_2_en_p_width,
this_s_visuel_220_2_en.height AS this_s_visuel_220_2_en_p_height,
this_s_visuel_220_2_en.frames AS this_s_visuel_220_2_en_p_frames,
this_s_visuel_220_2_en.[_oid] AS this_s_visuel_220_2_en,
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_en_GB = N'Bubble covers:')) 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_en
On ((this.documentation_en = this_s_documentation_en.[_oid]) AND (this_s_documentation_en.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_en
INNER JOIN alb_private_resource AS this_s_visuel_220_2_en_z
On ((this_s_visuel_220_2_en.[_oid] = this_s_visuel_220_2_en_z.[_oid]) AND (this_s_visuel_220_2_en_z.iso_sid <> N''))
On ((this.visuel_220_2_en = this_s_visuel_220_2_en.[_oid]) AND (this_s_visuel_220_2_en.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'')
Contact our teams to find out more about these products.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Aucune fiche disponible pour le moment.
