Wij adviseren je graag bij het samenstellen van je product.
Bel ons op 085 - 040 90 18
Ma - Vr. 09:00 - 17:00
Bestellen
-
SELECT cnt.id as content_id,
cnt.title as content_title,
cnt.ordering,
cnt.featured,
cnt.alias as content_alias,
cnt.catid, cnt.images,
cnt.state,
cnt.introtext,
cat.id as cat_id,
cat.title as cat_title,
cat.alias as cat_alias,
m.content_id, m.ordering,
MAX(case when f.field_id = 3 then f.value end) as afbeelding,
MAX(case when f.field_id = 6 then f.value end) as prijs,
MAX(case when f.field_id = 32 then f.value end) as prijsberekening,
MAX(case when f.field_id = 38 then f.value end) as label,
MAX(case when f.field_id = 40 then f.value end) as info,
MAX(case when f.field_id = 276 then f.value end) as bleed,
MAX(case when f.field_id = 316 then f.value end) as dpi,
MAX(case when f.field_id = 317 then f.value end) as multiple_layouts,
MAX(case when f.field_id = 318 then f.value end) as template,
MAX(case when f.field_id = 319 then f.value end) as canvas_size,
MAX(case when f.field_id = 320 then f.value end) as rulers,
MAX(case when f.field_id = 324 then f.value end) as spotcolor,
MAX(case when f.field_id = 325 then f.value end) as multiple_pages,
MAX(case when f.field_id = 315 then f.value end) as safety_margin,
MAX(case when f.field_id = 328 then f.value end) as verpakking,
MAX(case when f.field_id = 332 then f.value end) as verzendkosten,
MAX(case when f.field_id = 343 then f.value end) as sides
FROM snm_categories cat
LEFT JOIN snm_content cnt
ON cnt.catid = cat.id AND cnt.state = 1
LEFT JOIN snm_fields_values f
ON cnt.id = f.item_id
LEFT JOIN snm_content_multicats m
ON m.content_id = cnt.id
WHERE cnt.catid = "336"
GROUP BY cnt.id, cnt.title, cnt.featured, cnt.alias, cnt.catid, cnt.images, cnt.state, cnt.introtext, cat.id, cat.title, cat.alias
ORDER BY m.ordering DESC
- 2Formaat?
- 3Materiaal?
- 4Model?
- 5Mastzijde?
- 6Afwerking?
-
7Ontwerp controleren? Wat betekend dit?
SELECT cnt.id as content_id, cnt.title as content_title, cnt.ordering, cnt.featured, cnt.alias as content_alias, cnt.catid, cnt.images, cnt.state, cnt.introtext, cat.id as cat_id, cat.title as cat_title, cat.alias as cat_alias, m.content_id, m.ordering, MAX(case when f.field_id = 3 then f.value end) as afbeelding, MAX(case when f.field_id = 6 then f.value end) as prijs, MAX(case when f.field_id = 32 then f.value end) as prijsberekening, MAX(case when f.field_id = 38 then f.value end) as label, MAX(case when f.field_id = 40 then f.value end) as info, MAX(case when f.field_id = 276 then f.value end) as bleed, MAX(case when f.field_id = 316 then f.value end) as dpi, MAX(case when f.field_id = 317 then f.value end) as multiple_layouts, MAX(case when f.field_id = 318 then f.value end) as template, MAX(case when f.field_id = 319 then f.value end) as canvas_size, MAX(case when f.field_id = 320 then f.value end) as rulers, MAX(case when f.field_id = 324 then f.value end) as spotcolor, MAX(case when f.field_id = 325 then f.value end) as multiple_pages, MAX(case when f.field_id = 315 then f.value end) as safety_margin, MAX(case when f.field_id = 328 then f.value end) as verpakking, MAX(case when f.field_id = 332 then f.value end) as verzendkosten, MAX(case when f.field_id = 343 then f.value end) as sides FROM snm_categories cat LEFT JOIN snm_content cnt ON cnt.catid = cat.id AND cnt.state = 1 LEFT JOIN snm_fields_values f ON cnt.id = f.item_id LEFT JOIN snm_content_multicats m ON m.content_id = cnt.id WHERE cnt.catid = "335" GROUP BY cnt.id, cnt.title, cnt.featured, cnt.alias, cnt.catid, cnt.images, cnt.state, cnt.introtext, cat.id, cat.title, cat.alias ORDER BY m.ordering DESC
SELECT cnt.id as content_id, cnt.title as content_title, cnt.ordering, cnt.featured, cnt.alias as content_alias, cnt.catid, cnt.images, cnt.state, cnt.introtext, cat.id as cat_id, cat.title as cat_title, cat.alias as cat_alias, m.content_id, m.ordering, MAX(case when f.field_id = 3 then f.value end) as afbeelding, MAX(case when f.field_id = 6 then f.value end) as prijs, MAX(case when f.field_id = 32 then f.value end) as prijsberekening, MAX(case when f.field_id = 38 then f.value end) as label, MAX(case when f.field_id = 40 then f.value end) as info, MAX(case when f.field_id = 276 then f.value end) as bleed, MAX(case when f.field_id = 316 then f.value end) as dpi, MAX(case when f.field_id = 317 then f.value end) as multiple_layouts, MAX(case when f.field_id = 318 then f.value end) as template, MAX(case when f.field_id = 319 then f.value end) as canvas_size, MAX(case when f.field_id = 320 then f.value end) as rulers, MAX(case when f.field_id = 324 then f.value end) as spotcolor, MAX(case when f.field_id = 325 then f.value end) as multiple_pages, MAX(case when f.field_id = 315 then f.value end) as safety_margin, MAX(case when f.field_id = 328 then f.value end) as verpakking, MAX(case when f.field_id = 332 then f.value end) as verzendkosten, MAX(case when f.field_id = 343 then f.value end) as sides FROM snm_categories cat LEFT JOIN snm_content cnt ON cnt.catid = cat.id AND cnt.state = 1 LEFT JOIN snm_fields_values f ON cnt.id = f.item_id LEFT JOIN snm_content_multicats m ON m.content_id = cnt.id WHERE cnt.catid = "334" GROUP BY cnt.id, cnt.title, cnt.featured, cnt.alias, cnt.catid, cnt.images, cnt.state, cnt.introtext, cat.id, cat.title, cat.alias ORDER BY m.ordering DESC
SELECT cnt.id as content_id, cnt.title as content_title, cnt.ordering, cnt.featured, cnt.alias as content_alias, cnt.catid, cnt.images, cnt.state, cnt.introtext, cat.id as cat_id, cat.title as cat_title, cat.alias as cat_alias, m.content_id, m.ordering, MAX(case when f.field_id = 3 then f.value end) as afbeelding, MAX(case when f.field_id = 6 then f.value end) as prijs, MAX(case when f.field_id = 32 then f.value end) as prijsberekening, MAX(case when f.field_id = 38 then f.value end) as label, MAX(case when f.field_id = 40 then f.value end) as info, MAX(case when f.field_id = 276 then f.value end) as bleed, MAX(case when f.field_id = 316 then f.value end) as dpi, MAX(case when f.field_id = 317 then f.value end) as multiple_layouts, MAX(case when f.field_id = 318 then f.value end) as template, MAX(case when f.field_id = 319 then f.value end) as canvas_size, MAX(case when f.field_id = 320 then f.value end) as rulers, MAX(case when f.field_id = 324 then f.value end) as spotcolor, MAX(case when f.field_id = 325 then f.value end) as multiple_pages, MAX(case when f.field_id = 315 then f.value end) as safety_margin, MAX(case when f.field_id = 328 then f.value end) as verpakking, MAX(case when f.field_id = 332 then f.value end) as verzendkosten, MAX(case when f.field_id = 343 then f.value end) as sides FROM snm_categories cat LEFT JOIN snm_content cnt ON cnt.catid = cat.id AND cnt.state = 1 LEFT JOIN snm_fields_values f ON cnt.id = f.item_id LEFT JOIN snm_content_multicats m ON m.content_id = cnt.id WHERE cnt.catid = "337" GROUP BY cnt.id, cnt.title, cnt.featured, cnt.alias, cnt.catid, cnt.images, cnt.state, cnt.introtext, cat.id, cat.title, cat.alias ORDER BY m.ordering DESC
SELECT cnt.id as content_id, cnt.title as content_title, cnt.ordering, cnt.featured, cnt.alias as content_alias, cnt.catid, cnt.images, cnt.state, cnt.introtext, cat.id as cat_id, cat.title as cat_title, cat.alias as cat_alias, m.content_id, m.ordering, MAX(case when f.field_id = 3 then f.value end) as afbeelding, MAX(case when f.field_id = 6 then f.value end) as prijs, MAX(case when f.field_id = 32 then f.value end) as prijsberekening, MAX(case when f.field_id = 38 then f.value end) as label, MAX(case when f.field_id = 40 then f.value end) as info, MAX(case when f.field_id = 276 then f.value end) as bleed, MAX(case when f.field_id = 316 then f.value end) as dpi, MAX(case when f.field_id = 317 then f.value end) as multiple_layouts, MAX(case when f.field_id = 318 then f.value end) as template, MAX(case when f.field_id = 319 then f.value end) as canvas_size, MAX(case when f.field_id = 320 then f.value end) as rulers, MAX(case when f.field_id = 324 then f.value end) as spotcolor, MAX(case when f.field_id = 325 then f.value end) as multiple_pages, MAX(case when f.field_id = 315 then f.value end) as safety_margin, MAX(case when f.field_id = 328 then f.value end) as verpakking, MAX(case when f.field_id = 332 then f.value end) as verzendkosten, MAX(case when f.field_id = 343 then f.value end) as sides FROM snm_categories cat LEFT JOIN snm_content cnt ON cnt.catid = cat.id AND cnt.state = 1 LEFT JOIN snm_fields_values f ON cnt.id = f.item_id LEFT JOIN snm_content_multicats m ON m.content_id = cnt.id WHERE cnt.catid = "338" GROUP BY cnt.id, cnt.title, cnt.featured, cnt.alias, cnt.catid, cnt.images, cnt.state, cnt.introtext, cat.id, cat.title, cat.alias ORDER BY m.ordering DESC
€ 13,95 (excl. BTW)
Twijfel je nog? Speel dan op zeker en schakel voor slechts
€ 9,- onze PRO Ontwerpcontrole in.
Wel zo prettig!
Spoed bij je bestelling? Bel : 085 040 90 18
Bonnetje
€ 13,95 (excl. BTW)
Informatie
Extra info:
Mastvlaggen zijn verkrijgbaar in twee modellen: een staande en een rechte variant. Kies voor het rechte model uit zes formaten, voor het staande model kun je kiezen uit vijf formaten. Tip: het rechte model mastvlag met band, koord en lus is ook bruikbaar als gevelvlag. We bieden de keuze tussen een afwerking met witte band en haken of met zwarte band en haken. Je bepaalt zelf of je deze afwerking aan de linker- of de rechterzijde van de mastvlag wilt. Met Printzelf is jouw vlag in ieder geval: Geslaagd!
Specificaties
Materiaal | Flag, Flag PET en Flag longlife |
Gewicht |
Flag en Flag PET: 110 gr./m² |
Brandcertificaat | EN 13501 - Klasse B |
Printtechniek | Sublimatie |
Formaten |
Recht model: 100 x 70 cm, 150 x 100 cm, 200 x 100 cm en 225 x 150 cm |
Afwerking |
Recht model: band, koord en lus of band en haken |
Translucent | Ja, voor 90 tot 95% |
Levensduur |
Flag en Flag PET: drie tot vier maanden, tot windkracht zes |
Door de snel wisselende grondstof en transportprijzen in de hedendaagse onrustige markt zijn de prijzen die je ziet 'moment prijzen'.