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]	4885	[empty string]	ES	[empty string]	0	[empty string]	[empty string]	[empty string]	Sophie Wilson	2019-09-26 12:07:47.0	topbannerpdp	0	0	ES	0	2019-08-01 13:20:00.0	1743	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 <= '20220928 19:48:07' AND dontpublishafter >= '20220928 19:48:07' 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 175 € (sin IVA)