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 = "605"
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
- 2Materiaal?
- 3Gewenste afwerking?
-
4Ontwerp 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 = "606" 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
€ 0,00 (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
€ 0,00 (excl. BTW)
Informatie
Specificaties
Materiaal | Dibond® |
Gewicht | tot 6,6 kg./m2 |
Brandcertificaat | M1 |
Printtechniek | UV-print |
Maximale printbreedte uit één stuk | Dibond®: 146 cm |
Dikte | 3, 4 en 6 mm |
Afwerking | Meshdoek: zoom en ringen om de 30 cm Overige materialen: schoonsnijden met ringen om de 30 cm |
Binnen/buiten | Binnen en buiten |
Afwerking | Schoon- en contoursnijden, Forex® en Dibond® zijn ook met boorgaten te bestellen. |
Door de snel wisselende grondstof en transportprijzen in de hedendaagse onrustige markt zijn de prijzen die je ziet 'moment prijzen'.