query
RESULTSET
query
  ABSTRACT AB_VERSION AREA BANNER BREAKPOINT CAT_ID CONTENU_BLOCK_ID CREATIONDATE DISKPATH DOC_TPL_ID DONTPUBLISHAFTER GENERATED_HTML GENERATED_HTML_AT HAS_BREADCRUMB 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 SITEMAP_XML 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] [empty string] 0 [empty string] 4872 [empty string] PT [empty string] 0 [empty string] [empty string] [empty string] Sophie Wilson 2019-09-26 11:53:46.0 topbannerplp 0 0 PT 0 2019-08-01 13:19:00.0 1740 0 0 3 0 [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 <= '20220816 14:15:10' AND dontpublishafter >= '20220816 14:15:10' and (langue_id is null or langue_id = 'PT') and (pays_id is null or pays_id = 'pt') AND site = 3
Envio grátis para encomendas superiores a 175 € excl. IVA

Lexmark