select t.*, p.keywords, p.description, ml.keywords as key, ml.description as des, case when google_v = '' then '' else ' ' end as google_v, case when ml.description = '' then '' else '' end as shortdes, case when ml.keywords = '' then '' else '' end as shortkey, (case when t.isbgrepeat then 'repeat' else 'no-repeat' end) as html_isbgrepeat, (case when t.lettertype != '' then 'font-family: "' || t.lettertype || '";' else 'font-family: Arial, Verdana, Helvetica, sans-serif;' end) as html_lettertype, (case when t.lettertype_body != '' then 'div#kolomwrapper {font-family: ' || t.lettertype_body || ']];}' else '' end) as html_lettertype_body, (case when t.contentbackground != '' then 'div#main div#kolomwrapper{ background: ' || t.contentbackground || '; } div#main2 div#kolomwrapper{ background: ' || t.contentbackground || '; } div#headerSlider{background:' || t.contentbackground || ';} div#headerBlocks{background:' || t.contentbackground || ';}' else '' end) as html_contentbackground, (case when t.contentcolor != '' then 'div#main div#kolomwrapper{color:' || t.contentcolor || '; }' else '' end) as html_contentcolor, case when "tab1_header_oid" > 0 then "tab1_header_oid" else "tab1_header_oid" end as header_tab_oid, case when "tab1_mainlitexthover" != '' then "tab1_mainlitexthover" else "tab1_mainlitexthover" end as mainlitexthover, case when "tab1_sublitext" != '' then "tab1_sublitext" else "tab1_sublitext" end as sublitext, case when "tab1_sublitexthover" != '' then "tab1_sublitexthover" else "tab1_sublitexthover" end as sublitexthover, case when "tab1_defcolor" != '' then "tab1_defcolor" else "tab1_defcolor" end as defcolor, case when curpage = 'klanten' then 'template_klanten' else template end as template, '' as addurl from ( select a.id as aid, a.caption as acaption, a.istoonprijzen, a.isadmin as aisadmin, m.id as mid, t.objectnaam as template, o.*, a.garantietermijn, a.headerembedcode, a.footerembedcode, a.isslnieuwseigenschappen, a.werkgebied, a.shop_verzenddrempel, a.shop_verzendkosten, substring('http://www.tegro.nl/site/productenindex.html' from 'site\/([^\/|\/.]+)') as curpage, 'http://www.tegro.nl/site/productenindex.html' as url, a.google_a, a.google_v, nl.kolommen, nl.iskolomrechts, cst.image_oid as cornertop_oid, csb.image_oid as cornerbot_oid, a.snoobi_code, a.isactivewebshop, (CASE WHEN o.footer_marginleft > 20 THEN 20 ELSE o.footer_marginleft END) AS footer_marginleft, (CASE WHEN o.istoongrotefooter = false THEN 'height:40px; line-height:30px;' ELSE 'border-top:1px solid '|| o.footer_bordercolor_h ||'; padding:15px 0px 15px 0px; line-height:16px;' END) AS opmaak_footer from izinstl_account a inner join izinstl_opmaak o on (a.url = 'www.tegro.nl' and a.status_id in (1,3) and o.account_id = a.id) left join izinstl_menustyle m on (m.id = o.menustyle_id) left join izinstl_template t on (o.template_id = t.id) left join izinstl_nieuwslayout nl on (nl.account_id = a.id) left join izinstl_cornerstyle cst on (cst.id = o.moduletop_cornerstyle_id) left join izinstl_cornerstyle csb on (csb.id = o.modulebot_cornerstyle_id) limit 1 ) t left join izinstl_pagina p on ( p.id = 0 ) left join izinstl_menulayout ml on (p.id = ml.pagina_id and ml.account_id = t.aid) limit 1;
Tegro B.V.
0 0 0

Producten filteren

x resultaten reset

Producten


Wisa Sydney fontein 40 wit met kraangat 9100901715




fontein

Sphinx E-Con II fontein 40 cm SZ400500000 wit

fontein


Fontein

Comfort fontein 36cm wit inclusief bevestigingsset . voorheen Sanibase

Fontein


Fontein

Comfort fontein 40cm wit met bevestigingsset . .

Fontein


Fontein

Venlo fontein 35cm wit V147601 - H3063B01

Fontein


Fontein

V&B Onovo fontein 36x27,5cm 53603601 .

Fontein


fontein

V&B O.novo fontein compact 360x275mm wit alpin 53603701 00

fontein


Fontein

IDE Eurovit fontein 36 wit V211301

Fontein


Fontein

Jika Euroline fontein 41 wit . 81527.1.000

Fontein


Hoekfontein

Comfort hoekfontein m/inkeping voorzijde wit m.bevestig.set . .

Hoekfontein


Fontein

V&B OMNIA ARCH. FONTEIN 36 WIT 53733501

Fontein


fontein

Sphinx 300 fontein 36x25cm S8400100000 wit

fontein


Duravit D-Code fontein 1kr.gat m/overloop wit 450mm 07054500002




Hoekfontein

Comfort hoekfontein rond wit met bevestigingsset . .

Hoekfontein


fontein

Sphinx 280 fontein 36 S8401200000 wit

fontein


fontein

Sphinx 300 fontein 40x29,5cm S8400200000 wit

fontein


Fontein

V&B Omnia Pro fontein 40x25cm 73361B01 wit

Fontein


hoekfontein

IDE Eurovit hoekfontein 36 wit V220201

hoekfontein


Duravit D-code fontein m/kr.g. links 50x22cm 07065000092




Duravit D-code fontein m/kr.g. rechts 50x22cm 07065000082




Fontein

Jika Euroline fontein 36 wit . 81193.2.000

Fontein


fontein

Sphinx 300 fontein 36x25cm z/k raangat S8400105000 wit

fontein


V&B Onovo fontein 450x350mm compact wit alpin 53604501




V&B Onovo fontein 500x400mm compact wit alpin 53605001




V&B O.novo fontein compact 450x350mm wit alpin 53604601 00




V&B O.novo fontein compact 500x400mm wit alpin 53605101 00




V&B Onovo fontein 500x250mm compact wit alpin 53615001 .




V&B O.novo fontein compact 500x250mm wit alpin 53615101 00




fontein

Sphinx 315 fontein 36x26cm wit 00 S8402800000

fontein


Hoekfontein

Venlo hoekfontein wit V220301 - H3063B03

Hoekfontein


Fontein

IDE Connect Arc fontein 35x26 wit E791301

Fontein


Hoekfontein

Jika Euroline hoekfontein wit 8166120001045

Hoekfontein



Pagina: «   1   2   3   4   ... 11