Xerox Shop - Tulostimet

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]	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 <= '20220927 18:53:00' AND dontpublishafter >= '20220927 18:53:00' 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 175 € ilman ALV:a