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 (48) OR `categories`.`parent_id` IN (48) OR `category_parent`.`parent_id` IN (48) OR `category_parent_parent`.`parent_id` IN (48)) 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 `title` asc LIMIT 30 € 25.00 - € 30.00 - Originele kerstpakketten <span>van X-masgiftsonline</span> - 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

25.00 - 30.00

In de prijscategorie van 25.00 - 30.00 vindt u de leukste en meest originele kerstpakketten aan. Uitstekend geprijsde kerstpakketten vol kwaliteit en natuurlijk net een beetje anders. Wie wil dat nou niet? Onze 25 tot 30 kerstpakketten zijn er in diverse variaties en thema's. Stuk voor stuk prachtige en rijk gevulde kerstpakketten. En uiteraard kunt u deze ook nog weer aanpassen naar uw eigen specifieke wensen. Heel gemakkelijk online.

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