Search Center

machines & surface processing
machines
tools & manufacturing logistics
machines & services
surface treatment
coating technologies
profile wrapping technologies
surface treatment services
industrial halls
windows
doors
suppliers & accessories
facades & winter gardens
window coverings & gates
glass
assembly

Search:

Search:
material choice
« previous   | 1 | 2 | 3 | 4 | 5 |  
SELECT SQL_CALC_FOUND_ROWS A.* ,R.logo as R_logo,R.nazwa as R_nazwa,R.id as R_id,R.xstatus as R_xstatus,R.symbol as R_symbol,R.status as R_status,R.woj as R_woj,R.opis as R_opis , Z.woj as Z_woj, Z.powiat as Z_powiat, A.opisen as opis,RAND() random,0 as __search_priority FROM act_base_asortyment as A LEFT JOIN act_base_firmy as R ON R.id = A.firma LEFT JOIN act_base_siec as Z ON R.id = Z.firma AND Z.status = 1 WHERE ((A.menu_id = '602' OR (A.mcat9 & 32768)) AND (R.status = 1 AND A.hide = 0 AND R.xstatus >= 1) AND A.status = 1 ) AND (A.perms & 1) AND A.lang & 4 AND A.date_end >= NOW() AND A.date_start <= NOW() GROUP BY A.id ORDER BY R.xstatus DESC, (A.foto != '') DESC, random, R.pub_time DESC, A.akolej LIMIT 0, 21
F4362007 Montana Eiche tabak Techprofil
Konrad Hornschuch AG
F4362007 Montana Eiche tabak Techprofil
Classic range           Designs like...
F4565053 altweiss TP 60
Konrad Hornschuch AG
F4565053 altweiss TP 60
PLAIN range – TP 60 films         ...
F4703003 woodec Sheffield Oak concrete
Konrad Hornschuch AG
F4703003 woodec Sheffield Oak concrete
skai Woodec //NEW     genuine wood look like never before...
F4363042 Noce Sorrento balsamico Techprofil
Konrad Hornschuch AG
F4363042 Noce Sorrento balsamico Techprofil
  Life-like range        Thanks to a special...
F4466062 jet black matt cool colors PLUS
Konrad Hornschuch AG
F4466062 jet black matt cool colors PLUS
skai cool colors PLUS           ...
Środek czyszczący 5101
Berger-Zobel GmbH  Coating Systems
ZOBEL Cleaner 5101
ZOBEL Cleaner 5101 for coated wood and plastic surfaces...
Emulsja ochronna 5102
Berger-Zobel GmbH  Coating Systems
ZOBEL Protective Emulsion 5102
ZOBEL Protective Emulsion 5102 for coated wood and...
Zowo-tec® 260
Berger-Zobel GmbH  Coating Systems
Zowo-tec® 260
Zowo-tec® 260 Insulating Primer white, opaque...
F4565057 brillant weiss TP 60
Konrad Hornschuch AG
F4565057 brillant weiss TP 60
PLAIN range – TP 60 films         ...
Zowo-plast®1450
Berger-Zobel GmbH  Coating Systems
Zowo-plast®1450
Zowo-plast®1450 1C-PUR PVC-Single-Layer Coating...
Zowo-plast®1480
Berger-Zobel GmbH  Coating Systems
Zowo-plast®1480
Zowo-plast®1480 1C-PUR PVC-Metallic-Single-Layer Coating...

« previous   | 1 | 2 | 3 | 4 | 5 |