Xerox Shop -

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	61	2019-08-06 13:20:56.0	topbannerpdp	[empty string]	2026-08-31 00:00:00.0	[empty string]	[empty string]	0	[empty string]	4909	[empty string]	DE	[empty string]	0	[empty string]	[empty string]	[empty string]	Sophie Wilson	2019-09-26 12:46:38.0	topbannerpdp	0	0	DE	0	2019-08-01 13:20:00.0	1749	0	0	3	0	[empty string]	0	0	topBannerPDP	[empty string]	[empty string]	0	4	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

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 = 'topBannerPDP' AND publishafter <= '20220816 15:28:55' AND dontpublishafter >= '20220816 15:28:55' and (langue_id is null or langue_id = 'DE') and (pays_id is null or pays_id = 'de') AND site = 3