query
RESULTSET
query
  ABSTRACT AB_VERSION AREA BANNER BREAKPOINT CAT_ID CONTENU_BLOCK_ID CREATIONDATE DISKPATH DOC_TPL_ID DONTPUBLISHAFTER HEIGHT_ELEM ID INGRESS LANGUE_ID MENU MENU_DONTDISPLAY META META_DESC META_KEYWORD MODIFIER MODIFYDATE NAMONIC NB_COL NB_LG PAYS_ID PRODUCTGROUP_ID PUBLISHAFTER PUBLISHDEPARTMENT SCAT_ID SELECTION_ID SITE STAT STATUT_DOC STATUT_DOCUMENT TITLE TITLEIMAGE TYPE_DOC TYPE_PRODUIT_ID WEIGHT WIDTH_ELEM WRITER
1 [empty string] 0 [empty string] [empty string] [empty string] 0 62 2019-08-06 13:19:41.0 topbannerplp [empty string] 2026-08-31 00:00:00.0 [empty string] 4884 [empty string] ES [empty string] 0 [empty string] [empty string] [empty string] Sophie Wilson 2019-09-26 12:07:26.0 topbannerplp 0 0 ES 0 2019-08-01 13:19:00.0 1743 0 0 3 [empty string] 0 0 topBannerPLP [empty string] [empty string] 0 3 [empty string] [empty string]
CACHED false
EXECUTIONTIME 16
SQL SELECT doc.*, isnull(statut_document,0) as statut_doc FROM doc WITH (nolock) inner join ud_contenu_block WITH (nolock) on ud_contenu_block.contenu_block_id = doc.contenu_block_id WHERE ud_contenu_block.libelle = 'topBannerPLP' AND publishafter <= '20211126 19:56:43' AND dontpublishafter >= '20211126 19:56:43' and (langue_id is null or langue_id = 'ES') and (pays_id is null or pays_id = 'es') AND site = 3
Envío gratuito para pedidos superiores a 125 € (sin IVA)

AltaLink