SELECT decores_i18n.i18n_foreign_key AS id, decores_i18n.title, decores.search_image, decores.number FROM `decores`INNER JOIN `decores_i18n` ON (`decores`.`id` = `decores_i18n`.`i18n_foreign_key` AND `decores_i18n`.`i18n_country_language_id` = 33) INNER JOIN products ON products.top_decore_id = decores.id INNER JOIN module_attributes ON module_attributes.foreign_class = 'decores' AND module_attributes.foreign_id = decores.id WHERE products.sku_is_active = 1 AND products.sku_is_approved = 1 AND products.core_material_is_active = 1 AND products.family_is_active = 1 AND decores_i18n.is_active = 1 AND decores_i18n.is_approved = 1 AND products.category_id = 7 AND products.i18n_country_language_id = 33 AND products.collection_id = GROUP BY decores.id ORDER BY module_attributes.value, decores_i18n.order_weight DESC
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY decores.id ORDER BY module_attributes.value, decores_i18n.order_weig...' at line 3 Stock Availability - Flooring and Wall Panels - Express Services - Kronospan - Leading manufacturer of wood-based panels
Kronospan Luxembourg

1, Rue Gadderscheier
L-4984 Soleuvre
Luxembourg


On StockOn Stock

On RequestOn Request

Available in 7 daysAvailable in 7 days

Formats (mm) Thickness (mm)
SPC Wall Panels
2800x1230
4
White
K349_70x45_crop_478b24840a K349 PT Silk Flow  
0110_70x45_crop_478b24840a 0110 PT White  
K551_70x45_crop_478b24840a K551 PT Calacatta Olympus  
R101-1_70x45_crop_478b24840a R101 PT Statuario  
R102-1_70x45_crop_478b24840a R102 PT Venato Nature  
R154_70x45_crop_478b24840a R154 PT Marble Gold  
R162B_70x45_crop_478b24840a R162B PT Golden Cane B  
Yellow
K365_70x45_crop_478b24840a K365 FN Coast Evoke Oak  
Beige
0564_70x45_crop_478b24840a 0564 PT Almond  
5981_70x45_crop_478b24840a 5981 PT Cashmere  
K024_70x45_crop_478b24840a K024 PT Beige Pietra Marble  
R159B_70x45_crop_478b24840a R159B PT Soulstone B  
R130_70x45_crop_478b24840a R130 PT Greige Babylon  
R104_70x45_crop_478b24840a R104 PT Rainforest Brown  
R122_70x45_crop_478b24840a R122 FN Yacht Wood  
Brown
R120_70x45_crop_478b24840a R120 PT Native Steel  
R160_70x45_crop_478b24840a R160 PT Skali  
R164A_70x45_crop_478b24840a R164A PT Mink Plant A  
R165B_70x45_crop_478b24840a R165B PT Mink Plant B  
Grey
R155_70x45_crop_478b24840a R155 PT Elphain  
R119_70x45_crop_478b24840a R119 PT Crema Valpolicella  
R109_70x45_crop_478b24840a R109 PT Concrete  
R115_70x45_crop_478b24840a R115 PT Brooklyn Grey  
R158A_70x45_crop_478b24840a R158A PT Soulstone A  
R156A_70x45_crop_478b24840a R156A PT Atacama Fields A  
R157B_70x45_crop_478b24840a R157B PT Atacama Fields B  
R105_70x45_crop_478b24840a R105 PT Copper Lamiera  
R166_70x45_crop_478b24840a R166 PT Greige  
Black
0190_70x45_crop_478b24840a 0190 PT Black  
K026_70x45_crop_478b24840a K026 PT Grey Pietra Marble  
R106_70x45_crop_478b24840a R106 PT Marquina  
Green
R161A_70x45_crop_478b24840a R161A PT Golden Cane A  
R163_70x45_crop_478b24840a R163 PT Silver Sage  
Red
K104_70x45_crop_478b24840a K104 PT Rusty Copper