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 <= '20220119 20:41:28'
AND dontpublishafter >= '20220119 20:41:28'
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
