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] 4876 [empty string] DE [empty string] 0 [empty string] [empty string] [empty string] Sophie Wilson 2019-09-26 11:56:21.0 topbannerplp 0 0 AT 0 2019-08-01 13:19:00.0 1741 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 <= '20220121 21:00:04' AND dontpublishafter >= '20220121 21:00:04' and (langue_id is null or langue_id = 'DE') and (pays_id is null or pays_id = 'at') AND site = 3
Gratis-Versand bei allen Bestellungen über 125 € zzgl. MwSt.

Kyocera