Erreur SQL:
Invalid column name 'author_en_GB'.
SELECT
this.[_oid] AS this
FROM (SELECT
this.[_oid] AS this
FROM dm_card_actualites AS this
INNER JOIN ocs_card AS this_z
On ((this.[_oid] = this_z.[_oid]) AND (this_z.iso_sid <> N''))
WHERE
(this.iso_sid <> N'')
AND (this.startvisibilitydate <= CAST('2017-10-23 0:0:0' as datetime))
AND (this.endvisibilitydate >= CAST('2017-10-23 0:0:0' as datetime))
AND ((this.author_en_GB = N'NL (EN)') OR (this.author_en_GB = N'AE (EN)'))) as col INNER JOIN dm_card_actualites 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''))
WHERE
(this.iso_sid <> N'')
Erreur SQL:
Invalid column name 'author_en_GB'.
SELECT
this.[_oid] AS this,
this.title_en_GB AS this_p_title_en_GB,
this_s_image.[_oid] AS this_s_image,
this_s_image_z.urlDir AS this_s_image_z_p_urlDir,
this_s_image_z.filename AS this_s_image_z_p_filename,
this_s_image_z.extension AS this_s_image_z_p_extension
FROM (SELECT
this.[_oid] AS this
FROM dm_card_actualites AS this
INNER JOIN ocs_card AS this_z
On ((this.[_oid] = this_z.[_oid]) AND (this_z.iso_sid <> N''))
WHERE
(this.iso_sid <> N'')
AND (this.startvisibilitydate <= CAST('2017-10-23 0:0:0' as datetime))
AND (this.endvisibilitydate >= CAST('2017-10-23 0:0:0' as datetime))
AND ((this.author_en_GB = N'NL (EN)') OR (this.author_en_GB = N'AE (EN)'))) as col INNER JOIN dm_card_actualites 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_image
INNER JOIN alb_private_resource AS this_s_image_z
On ((this_s_image.[_oid] = this_s_image_z.[_oid]) AND (this_s_image_z.iso_sid <> N''))
On ((this.image = this_s_image.[_oid]) AND (this_s_image.iso_sid <> N''))
WHERE
(this.iso_sid <> N'')
NEW PRODUCTS
Erreur SQL:
Invalid column name 'author_en_GB'.
SELECT
this.[_oid] AS this
FROM (SELECT
this.[_oid] AS this
FROM dm_card_nouveautes AS this
INNER JOIN ocs_card AS this_z
On ((this.[_oid] = this_z.[_oid]) AND (this_z.iso_sid <> N''))
WHERE
(this.iso_sid <> N'')
AND (this.startvisibilitydate <= CAST('2017-10-23 0:0:0' as datetime))
AND (this.endvisibilitydate >= CAST('2017-10-23 0:0:0' as datetime))
AND (this.author_en_GB = N'AE (EN)')) as col INNER JOIN dm_card_nouveautes 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''))
WHERE
(this.iso_sid <> N'')
Erreur SQL:
Invalid column name 'author_en_GB'.
SELECT
this.[_oid] AS this,
this.title_en_GB AS this_p_title_en_GB,
this_s_image.[_oid] AS this_s_image,
this_s_image_z.urlDir AS this_s_image_z_p_urlDir,
this_s_image_z.filename AS this_s_image_z_p_filename,
this_s_image_z.extension AS this_s_image_z_p_extension
FROM (SELECT
this.[_oid] AS this
FROM dm_card_nouveautes AS this
INNER JOIN ocs_card AS this_z
On ((this.[_oid] = this_z.[_oid]) AND (this_z.iso_sid <> N''))
WHERE
(this.iso_sid <> N'')
AND (this.startvisibilitydate <= CAST('2017-10-23 0:0:0' as datetime))
AND (this.endvisibilitydate >= CAST('2017-10-23 0:0:0' as datetime))
AND (this.author_en_GB = N'AE (EN)')) as col INNER JOIN dm_card_nouveautes 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_image
INNER JOIN alb_private_resource AS this_s_image_z
On ((this_s_image.[_oid] = this_s_image_z.[_oid]) AND (this_s_image_z.iso_sid <> N''))
On ((this.image = this_s_image.[_oid]) AND (this_s_image.iso_sid <> N''))
WHERE
(this.iso_sid <> N'')
