Query: LEFT JOIN `jos_{vm}_product_price` ON `jos_{vm}_product`.`product_id` = `jos_{vm}_product_price`.`product_id`
 LEFT JOIN `jos_vm_product_discount`
ON (`jos_vm_product`.`product_discount_id` = `jos_vm_product_discount`.`discount_id` OR `jos_vm_product`.`product_discount_id` = '0')  WHERE `jos_{vm}_product_category_xref`.`product_id`=`jos_{vm}_product`.`product_id`
 AND `jos_{vm}_product_category_xref`.`category_id`=`jos_{vm}_category`.`category_id`
 AND `jos_{vm}_product_category_xref`.`category_id`=37
 AND  `jos_vm_product`.`product_id` NOT IN (7712,12987) 
 AND  `jos_vm_product`.`product_id` NOT IN (7712,12987) 
 AND ((`jos_{vm}_product`.`product_id`=`jos_{vm}_product_price`.`product_id` AND `jos_{vm}_shopper_group`.`shopper_group_id`=`jos_{vm}_product_price`.`shopper_group_id`) OR `jos_{vm}_product_price`.`product_id` IS NULL) 
 AND `jos_{vm}_shopper_group`.`default` = 1
 AND ((`product_parent_id`='0') OR (`product_parent_id`='')) 
 AND (`product_publish`='Y')  
 AND `product_publish`='Y' 
 AND `category_publish`='Y' 
 GROUP BY `jos_{vm}_product`.`product_sku` 
 ORDER BY RAND() ASC

STANFORD 806-01
STANFORD 806-01
Eco Moquette Berber 9mm.
Dimensions - PRICE
Square meter - 28.00 €
VOGUE 35
VOGUE 35
100% Acrylic,P.A,Eco
Dimensions - PRICE
Square meter - 60.00 €
BRILLIANT RED 010
BRILLIANT RED 010
100% Art Silk 50mm.
Dimensions - PRICE
Square meter - 75.00 €
VELVET 093
VELVET 093
Saxony, Micropolyester.
Dimensions - PRICE
Custom Size - 52.00 €
AFRICAN SUNRISE 4507-37
AFRICAN SUNRISE 4507-37
Machine Made, Sisal Straw Mat.
Dimensions - PRICE
Επιθυμιτό Τετραγωνικό Μέτρο - 43.00 €
SOHO 2326-95-20%
SOHO 2326-95
Special Microfiber,Artsilk Shaggy
Dimensions - PRICE
Custom Size - 78.00 €
PARMA 090 IVORY
PARMA 090 IVORY
Eco Moquette.
Dimensions - PRICE
Square meter - 24.00 €
RADIUS 090
RADIUS 090
100% P.P. Berber, Eco.
Dimensions - PRICE
Custom Size - 28.00 €
ASTRA 78
ASTRA 78
100% Acrylic,P.P,Eco
Dimensions - PRICE
Ancho 4.00m Longitud por Metro - 70.00 €
ROYAL SATIN 272 L.GRAY
ROYAL SATIN 272 L.GRAY
100% Artsilk Shaggy
Dimensions - PRICE
Custom Size - 64.00 €
HERMITAGE 852-25
HERMITAGE 852-25
Eco Moquette 20mm.
Dimensions - PRICE
Square meter - 41.00 €
LAHORA17 731-02
LAHORA17 731-02
Eco Moquette
Dimensions - PRICE
Square meter - 45.00 €
VICTORIA 68
VICTORIA 68
Eco Moquette Berber 8mm.
Dimensions - PRICE
Square meter - 36.00 €
PARIS 7011 GREY
PARIS 7011 GREY
100% Artsilk Shaggy
Dimensions - PRICE
Custom Size - 69.00 €
VOGUE 11
VOGUE 11
100% Acrylic,P.A,Eco
Dimensions - PRICE
Square meter - 60.00 €
HAMILTON 767-03
HAMILTON 767-03
Eco Moquette 12mm.
Dimensions - PRICE
Square meter - 34.00 €
AKTUA 194
AKTUA 194
100% Acrylic,P.A,Eco
Dimensions - PRICE
Custom Size m2 - 28.00 €
SOHO 817-06
SOHO 817-06
Shaggy
Dimensions - PRICE
Square Meter - 41.00 €
FIJI 763-24
FIJI 763-24
Shaggy
Dimensions - PRICE
Square Meter - 38.00 €
NIKIE 12-064
NIKIE 12-064
100% Acrylic,P.A,Eco
Dimensions - PRICE
Custom size m2 - 27.00 €
BERLIN 754-25
BERLIN 754-25
Eco Moquette Berber 8mm.
Dimensions - PRICE
Square meter - 28.00 €
VOGUE 17
VOGUE 17
100% Acrylic,P.A,Eco
Dimensions - PRICE
Square meter - 60.00 €
ULTRA-75
ULTRA-75
Eco Moquette 100% Acrylic.
Dimensions - PRICE
Square meter - 51.00 €
NIKIE 12-039
NIKIE 12-039
100% Acrylic,P.A,Eco
Dimensions - PRICE
Custom size m2 - 27.00 €
AVATAR 7235 PINK
AVATAR 7235 PINK
100% Acrylic Frise
Dimensions - PRICE
Custom Size - 43.00 €
TIGRA 39
TIGRA 39
Eco Moquette Berber 8mm.
Dimensions - PRICE
Square meter - 40.00 €
CASA 12-760
CASA 12-760
100% Acrylic,P.P,Eco
Dimensions - PRICE
Custom Size m2 - 31.00 €
SILK 12-915
SILK 12-915
100% Acrylic,P.A,Eco
Dimensions - PRICE
Custom size m2 - 45.00 €
RADIUS 093
RADIUS 093
100% P.P. Berber, Eco.
Dimensions - PRICE
Custom Size - 28.00 €
SOHO 817-03
SOHO 817-03
Shaggy
Dimensions - PRICE
Square Meter - 41.00 €
HAMILTON 767-12
HAMILTON 767-12
Eco Moquette 12mm.
Dimensions - PRICE
Square meter - 34.00 €
SUPERIOR 040
SUPERIOR 040
100% Acrylic
Dimensions - PRICE
Custom Size - 59.00 €
HAMILTON 767-13
HAMILTON 767-13
Eco Moquette 12mm.
Dimensions - PRICE
Square meter - 34.00 €
SILKY 40
SILKY 40
100% Art Silk 20mm.
Dimensions - PRICE
Square meter - 80.00 €
NATURE DESIGN 4001-21
NATURE DESIGN 4001-21
100% PP,Machine Made Sisal.
Dimensions - PRICE
Custom Size - 46.00 €
DUBLIN 202
DUBLIN 202
Eco Moquette Woolen.
Dimensions - PRICE
Square meter - 40.00 €
MOROE 180
MOROE 180
100% Acrylic Frise
Dimensions - PRICE
Custom Size - 48.00 €
HAMILTON 767-24
HAMILTON 767-24
Μοκέτα Οικολογική
Dimensions - PRICE
Eπιθυμητή Τετραγωνικό Μετρό - 24.00 €
SUPERIOR 025
SUPERIOR 025
100% Acrylic
Dimensions - PRICE
Custom Size - 59.00 €
FORZA 82
FORZA 82
100% Acrylic,P.P,Eco
Dimensions - PRICE
Width 4.00m Length per Meter - 70.00 €
VARNA SHAGGY 78R RED
VARNA SHAGGY 78R RED
100% ArtSilk Shaggy.
Dimensions - PRICE
Square Meter - 58.00 €
FORTESSE 95
FORTESSE 95
Eco Moquette Crossover.
Dimensions - PRICE
4.00m - 174.00 €
NATURE DESIGN 4001-41
NATURE DESIGN 4001-41
100% PP,Machine Made Sisal.
Dimensions - PRICE
Custom Size - 46.00 €
VENUS 612
VENUS 612
100% Acrylic Shaggy
Dimensions - PRICE
Custom Size - 64.00 €
BENGALI 848-13
BENGALI 848-13
100% Art Silk Shaggy
Dimensions - PRICE
Square Meter - 55.00 €
ROYAL A65R-10%
ROYAL A65R
100% Art silk
Dimensions - PRICE
Square meter - 76.00 € 68.40 €
HAMILTON 767-35
HAMILTON 767-35
Eco Moquette 12mm.
Dimensions - PRICE
Square meter - 34.00 €
SYGMA 016
SYGMA 016
100% Acrylic,P.A,Eco
Dimensions - PRICE
Custom Size m2 - 49.00 €

en-GB

All material, in any form, on this website is copyrighted by xalia.com