query
RESULTSET
query
  ABSTRACT AB_VERSION AREA BANNER BREAKPOINT CAT_ID CONTENU_BLOCK_ID CREATIONDATE DISKPATH DOC_TPL_ID DONTPUBLISHAFTER 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 0 [empty string] 4916 [empty string] FI [empty string] 0 [empty string] [empty string] [empty string] Sophie Wilson 2019-09-26 12:50:48.0 topbannerplp 0 0 FI 0 2019-08-01 13:19:00.0 1751 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 <= '20220125 05:36:35' AND dontpublishafter >= '20220125 05:36:35' and (langue_id is null or langue_id = 'FI') and (pays_id is null or pays_id = 'fi') AND site = 3
Ilmainen toimitus kaikille tilauksille, joiden arvo on yli 125 € ilman ALV:a

HP PageWide