SELECT SQL_CALC_FOUND_ROWS 1+1, IF(subproducts_rel.product_id AND media2.path != '', `media2`.`path`, media.path) AS image_path, IF(subproducts_rel.product_id AND media2.name != '', CONCAT(media2.name, media2.extension), CONCAT(media.name, media.extension)) AS image_name, IF(subproducts_rel.product_id AND media2.alt_text != '', `media2`.`alt_text`, media.alt_text) AS alt_text, `products`.`type`, `products`.`product_id`, `products`.`banner_text`, `products`.`order_min_quantity`, `products`.`enabled`, `products`.`order_per_item`, `products`.`require_quotation`, `products`.`sale_price`, `products`.`sale_price_total`, `products`.`sale_price_discount_btw6`, `products`.`sale_price_discount_btw21`, COALESCE(NULLIF(products_data.sale_price_discount, 0), products.sale_price_discount) AS sale_price_discount, COALESCE(products_data.sale_price_discount_start, products.sale_price_discount_start) AS sale_price_discount_start, COALESCE(products_data.sale_price_discount_end, products.sale_price_discount_end) AS sale_price_discount_end, (SELECT GROUP_CONCAT(product_themes.name) FROM product_themes INNER JOIN product_themes_rel ON product_themes.theme_id = product_themes_rel.theme_id WHERE product_themes_rel.product_id = products.product_id) AS theme, IF(products.packet_nr, products.packet_nr, products.nr) AS product_nr, `days` AS `deliveryDays`, `products`.`slug`, `products`.`meta_description`, `products`.`meta_keywords`, COALESCE(products_data.description, products.description) AS description, `products`.`video_url`, `products`.`explanation`, `product_categories_rel_tb`.`category_id`, `categories`.`name` AS `category`, IF ((products.sale_price_discount>0 AND products.sale_price_discount_start <= DATE_FORMAT(NOW(), '%Y-%m-%d') AND products.sale_price_discount_end >= DATE_FORMAT(NOW(), '%Y-%m-%d')), `products`.`sale_price_discount`, products.sale_price) AS price, IF ((products.sale_price_discount>0 AND products.sale_price_discount_start <= DATE_FORMAT(NOW(), '%Y-%m-%d') AND products.sale_price_discount_end >= DATE_FORMAT(NOW(), '%Y-%m-%d')), `products`.`sale_price_discount`, products.sale_price_total) AS price_total, IF ((products.sale_price_discount>0 AND products.sale_price_discount_start <= DATE_FORMAT(NOW(), '%Y-%m-%d') AND products.sale_price_discount_end >= DATE_FORMAT(NOW(), '%Y-%m-%d')), 1, 0) AS discountPrice, `products`.`employee_can_buy`, `products`.`employer_can_buy`, COALESCE(products_data.title, products.title) AS title, COALESCE(products_data.detail_title, products.detail_title) AS detail_title, COALESCE(products_data.is_discontinued, products.is_discontinued) AS is_discontinued, COALESCE(products_data.stock, products.stock) AS stock, COALESCE(products_data.short_description, products.short_description) AS short_description, COALESCE(products_data.keywords, products.keywords) AS keywords, COALESCE(products_data.brand, products.brand) AS brand, IF ((products.employer_points_discount>0 AND products.employer_points_discount_start <= DATE_FORMAT(NOW(), '%Y-%m-%d') AND products.employer_points_discount_end >= DATE_FORMAT(NOW(), '%Y-%m-%d')), `products`.`employer_points_discount`, IF(products_data.employer_points, `products_data`.`employer_points`, products.employer_points)) AS employer_price_points, IF ((products.employee_points_discount>0 AND products.employee_points_discount_start <= DATE_FORMAT(NOW(), '%Y-%m-%d') AND products.employee_points_discount_end >= DATE_FORMAT(NOW(), '%Y-%m-%d')), `products`.`employee_points_discount`, IF(products_data.employee_points, `products_data`.`employee_points`, products.employee_points)) AS employee_price_points FROM `products` LEFT JOIN `product_categories_rel` `product_categories_rel_tb` ON `product_categories_rel_tb`.`product_id`=`products`.`product_id` LEFT JOIN `categories` ON `categories`.`category_id` = `product_categories_rel_tb`.`category_id` AND `categories`.`site_id` = 1 LEFT JOIN `media` ON `media`.`category`='product-images' AND `media`.`owner`=`products`.`product_id` AND `media`.`orders` = 0 LEFT JOIN `media_subproducts_orders` ON `products`.`product_id` = `media_subproducts_orders`.`configurable_product_id` AND `media_subproducts_orders`.`orders` = 0 LEFT JOIN `subproducts_rel` ON `subproducts_rel`.`product_id` = `media_subproducts_orders`.`configurable_product_id` LEFT JOIN `media` AS `media2` ON `media2`.`category`='product-images' AND `media2`.`owner`=`media_subproducts_orders`.`product_id` AND `media2`.`orders` = 0 LEFT JOIN `categories` AS `category_parent` ON `category_parent`.`category_id` = `categories`.`parent_id` LEFT JOIN `categories` AS `category_parent_parent` ON `category_parent_parent`.`category_id` = `category_parent`.`parent_id` INNER JOIN `product_sites_rel` ON `products`.`product_id`=`product_sites_rel`.`product_id` AND `product_sites_rel`.`site_id`=1 LEFT JOIN `deliveries` ON `deliveries`.`delivery_id` = `products`.`delivery_days` LEFT JOIN `products_data` ON `products_data`.`item_id` = `products`.`product_id` and `products_data`.`site_id` = '1' WHERE ( CONVERT(products.nr,char) LIKE '%teamwork%' ESCAPE '!' OR CONVERT(products.packet_nr,char) LIKE '%teamwork%' ESCAPE '!' OR `products`.`title` LIKE '%teamwork%' ESCAPE '!' OR `products`.`title` LIKE '%teamwork%' ESCAPE '!' OR `products`.`supplier_article_id` LIKE '%teamwork%' ESCAPE '!' OR `products`.`keywords` LIKE '%teamwork%' ESCAPE '!' OR `products`.`brand` LIKE '%teamwork%' ESCAPE '!' OR `products`.`short_description` LIKE '%teamwork%' ESCAPE '!' OR `products_data`.`title` LIKE '%teamwork%' ESCAPE '!' OR `products_data`.`title` LIKE '%teamwork%' ESCAPE '!' OR `products`.`description` LIKE '%teamwork%' ESCAPE '!' ) AND (`product_categories_rel_tb`.`category_id` IN (346) OR `categories`.`parent_id` IN (346) OR `category_parent`.`parent_id` IN (346) OR `category_parent_parent`.`parent_id` IN (346)) AND `products`.`enabled` = 1 AND `products`.`product_id` NOT IN(SELECT product_id FROM customer_product) AND (`products`.`disable_at` IS NULL OR products.disable_at > CURDATE()) AND `products`.`deleted` = 0 GROUP BY `products`.`product_id` ORDER BY `products`.`sale_price` desc LIMIT 30---0 Wijn alcoholvrij - Wijnen & wijnpakketten - Kerstpakketten | X-masgiftsonline

Originele kerstpakketten

Meer dan 500 pakketten, net even anders!

  • Maatwerk
  • Duurzaam
  • Persoonlijke aandacht
  • 100% tevredenheid gegarandeerd
Alle actieve filters verwijderen

Originele kerstpakketten van X-masgiftsonline (72)

Rituals / Wellness Pakketten (302)

Gifts (2383)

Wijnen & wijnpakketten (187)

Prijs

Filter de producten op prijs

Thema

Filter op het thema

Toon meer
Leverbaar binnen ..
Toon meer
Bestelbaar

Bestelbaar per ..

Voorkeur

Filter op het voorkeur

Vergelijking

Er staan 0 producten in de vergelijking.

Bekijk vergelijking
Zoeken naar ..

Zoeken op trefwoord

  1. Sorteren: Prijs | Naam
Niet gevonden wat u zocht?
Neem gerust contact met ons op en wij helpen u graag verder.

0573-400393

info@xmasgiftsonline.nl

Klik op chat-icoon om chat te starten

06-50518966

Wijn alcoholvrij

De alcoholvrije wijnen worden eerst als normale wijn geproduceerd. Een speciaal proces filtert hierna de alcohol uit de wijn. Het resultaat is iets zoeter maar heeft toch de smaak van echte wijn. Zonder alcohol. Wel net zo lekker.

X-masgiftsonline gebruikt cookies (en daarmee vergelijkbare technieken) om het bezoek en winkelen bij X-masgiftsonline voor jou nog makkelijker en persoonlijker te maken. Met deze cookies kunnen wij en derde partijen jouw internetgedrag binnen en buiten onze website volgen en verzamelen. Hiermee kunnen wij en derde partijen advertenties aanpassen aan jouw interesses en kun je informatie delen via social media. Door verder gebruik te maken van deze website ga je hiermee akkoord. Je kunt je toestemming altijd weer intrekken.
Akkoord
Facebook