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

GALA 360
GALA 360
Embossed Eco Moquette.
Dimensions - PRICE
Square meter - 32.00 €
EXCLUSIVO 33
EXCLUSIVO 33
Eco Moquette.
Dimensions - PRICE
Square meter - 57.00 €
EXCLUSIVO 78
EXCLUSIVO 78
Eco Moquette
Dimensions - PRICE
Square meter - 57.00 €
SOHO 817-17
SOHO 817-17
Shaggy
Dimensions - PRICE
Square Meter - 41.00 €
PLUTO 076
PLUTO 076
100% P.P. Berber, Eco.
Dimensions - PRICE
Custom Size - 23.00 €
JADE 870-12
JADE 870-12
100% Art Silk Shaggy.
Dimensions - PRICE
Square Meter - 52.00 €
JADE 870-36
JADE 870-36
100% Art Silk Shaggy.
Dimensions - PRICE
Square Meter - 52.00 €
SMART A201 WHITE
SMART A201 WHITE
100% Acrylic Shaggy.
Dimensions - PRICE
Custom Size - 32.00 €
ASTRA 81
ASTRA 81
100% Acrylic,P.P,Eco
Dimensions - PRICE
Width 4.00m Length per Meter - 70.00 €
BINGO 675 BLUE
BINGO 675 BLUE
100% P.P. Berber, Eco.
Dimensions - PRICE
Custom Size - 19.00 €
HAMILTON 767-02
HAMILTON 767-02
Eco Moquette 12mm.
Dimensions - PRICE
Square meter - 34.00 €
HARVEST 05
HARVEST 05
100%Pure New Wool/Felted
Dimensions - PRICE
Square meter - 630.00 €
MARS 057 BEIGE
MARS 057 BEIGE
100% P.P. Berber, Eco.
Dimensions - PRICE
Custom Size - 20.00 €
HAMILTON 767-25
HAMILTON 767-25
Eco Moquette 12mm.
Dimensions - PRICE
Square meter - 34.00 €
AVATAR 7235 GREEN
AVATAR 7235 GREEN
100% Acrylic Frise
Dimensions - PRICE
Custom Size - 43.00 €
SYDNEY 2205
SYDNEY 2205
Art Lawn, PVC
Dimensions - PRICE
Square meter - 35.00 €
DALTON 792 BROWN
DALTON 792 BROWN
100% P.P. Berber
Dimensions - PRICE
Custom Size - 20.00 €
PAPILLION M.VISON
PAPILLION M.VISON
100% Artsilk Shaggy
Dimensions - PRICE
Custom Size - 51.00 €
PARMA 093 BEIGE
PARMA 093 BEIGE
Eco Moquette.
Dimensions - PRICE
Square meter - 24.00 €
VOGUE 35
VOGUE 35
100% Acrylic,P.A,Eco
Dimensions - PRICE
Square meter - 60.00 €
MOROE 785
MOROE 785
100% Acrylic Frise
Dimensions - PRICE
Custom Size - 48.00 €
RIPE 05 HIGH
RIPE 05 HIGH
100% Μohair/Tufted
Dimensions - PRICE
Square meter - 710.00 €
VELVET 039
VELVET 039
Saxony, Micropolyester.
Dimensions - PRICE
Custom Size - 52.00 €
GALA 180
GALA 180
Embossed Eco Moquette.
Dimensions - PRICE
Square meter - 32.00 €
PRATO 48
PRATO 48
Artificial Lawn.
Dimensions - PRICE
Width 1.90m Length per Meter - 36.00 €
CORN 08
CORN 08
100% Polyester & Cotton/Tufted
Dimensions - PRICE
Square meter - 565.00 €
PLUTO 020
PLUTO 020
100% P.P. Berber, Eco.
Dimensions - PRICE
Custom Size - 23.00 €
HAMILTON 767-12
HAMILTON 767-12
Eco Moquette 12mm.
Dimensions - PRICE
Square meter - 34.00 €
VENUS 714
VENUS 714
100% Acrylic Shaggy
Dimensions - PRICE
Custom Size - 64.00 €
RIPE MIX 102 LOW
RIPE MIX 102 LOW
100% Μohair/Tufted
Dimensions - PRICE
Square meter - 710.00 €
DREAMS 920
DREAMS 920
100% Acrylic,P.P,Eco
Dimensions - PRICE
Square meter - 46.00 €
VICTORIA 68
VICTORIA 68
Eco Moquette Berber 8mm.
Dimensions - PRICE
Square meter - 36.00 €
LUNA 915 SILVER WHITE
LUNA 915 SILVER WHITE
Saxony, 100% Acrylic
Dimensions - PRICE
Custom Size - 61.00 €
BALI 822-13
BALI 822-13
Shaggy
Dimensions - PRICE
Square Meter - 44.00 €
STANFORD 806-06
STANFORD 806-06
Eco Moquette Berber 9mm.
Dimensions - PRICE
Square meter - 28.00 €
VENUS 612
VENUS 612
100% Acrylic Shaggy
Dimensions - PRICE
Custom Size - 64.00 €
SMART B103 L.BLUE
SMART B103 L.BLUE
100% Acrylic Shaggy.
Dimensions - PRICE
Custom Size - 32.00 €
VELVET 077
VELVET 077
Saxony, Micropolyester.
Dimensions - PRICE
Custom Size - 52.00 €
FOLLIE 500 IVORY
FOLLIE 500 IVORY
100% Artsilk Shaggy
Dimensions - PRICE
Custom Size - 53.00 €
BISHA 80
BISHA 80
100% Acrylic,P.P,Eco
Dimensions - PRICE
Width 4.00 m Length per Meter - 70.00 €
JARDIN 220
JARDIN 220
Artificial Lawn.
Dimensions - PRICE
Square meter - 61.00 €
FIJI 763-39
FIJI 763-39
Shaggy
Dimensions - PRICE
Square Meter - 38.00 €
MOROE 680
MOROE 680
100% Acrylic Frise
Dimensions - PRICE
Custom Size - 48.00 €
VELVET 031
VELVET 031
Saxony, Micropolyester.
Dimensions - PRICE
Custom Size - 52.00 €
AVATAR 7235 BLUE
AVATAR 7235 BLUE
100% Acrylic Frise
Dimensions - PRICE
Custom Size - 43.00 €
GALA 810
GALA 810
Embossed Eco Moquette.
Dimensions - PRICE
Square meter - 32.00 €
HERMITAGE 852-25
HERMITAGE 852-25
Eco Moquette 20mm.
Dimensions - PRICE
Square meter - 41.00 €
ΗΑΥ 06
ΗΑΥ 06
100% Linen/Tufted
Dimensions - PRICE
Square meter - 585.00 €

en-GB

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