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

VELVET 077
VELVET 077
Saxony, Micropolyester.
Dimensions - PRICE
Custom Size - 52.00 €
HAMILTON 767-12
HAMILTON 767-12
Eco Moquette 12mm.
Dimensions - PRICE
Square meter - 34.00 €
AFRICAN SUNRISE 4507-37
AFRICAN SUNRISE 4507-37
Machine Made, Sisal Straw Mat.
Dimensions - PRICE
Επιθυμιτό Τετραγωνικό Μέτρο - 43.00 €
LAHORA12 731-02
LAHORA12 731-02
Eco Moquette
Dimensions - PRICE
Square meter - 45.00 €
EXCLUSIVO 95
EXCLUSIVO 95
Eco Moquette.
Dimensions - PRICE
Square meter - 57.00 €
ASTRA 78
ASTRA 78
100% Acrylic,P.P,Eco
Dimensions - PRICE
Ancho 4.00m Longitud por Metro - 70.00 €
ASTRA 70
ASTRA 70
100% Acrylic,P.P,Eco
Dimensions - PRICE
Width 4.00m Length per Meter - 70.00 €
PARIS 7015 WHITE
PARIS 7015 WHITE
100% Artsilk Shaggy
Dimensions - PRICE
Custom Size - 69.00 €
HAMILTON 767-16
HAMILTON 767-16
Eco Moquette 12mm.
Dimensions - PRICE
Eπιθυμητή Τετραγωνικό Μετρό - 28.00 €
CAREZZA SUPREME 150
CAREZZA SUPREME 150
Acrylic,P.A,Eco.
Dimensions - PRICE
Square meter - 64.00 €
SOHO 2326-15-20%
SOHO 2326-15
Special Microfiber,Artsilk Shaggy
Dimensions - PRICE
Custom Size - 78.00 €
FIJI 763-50
FIJI 763-50
Shaggy
Dimensions - PRICE
Square Meter - 38.00 €
EXCLUSIVO 44
EXCLUSIVO 44
Eco Moquette.
Dimensions - PRICE
Square meter - 57.00 €
EXPRESSIONS 12
EXPRESSIONS 12
Acrylic,P.A,Eco.
Dimensions - PRICE
Square meter - 67.00 €
CAROULOOP 114 PURPLE
CAROULOOP 114 PURPLE
Eco Moquette.
Dimensions - PRICE
Square meter - 27.00 €
SENNA 092 BROWN
SENNA 092 BROWN
Eco Moquette Berber.
Dimensions - PRICE
Square meter - 22.00 €
TIGRA 90
TIGRA 90
Eco Moquette Berber 8mm.
Dimensions - PRICE
Square meter - 40.00 €
FIJI 763-03
FIJI 763-03
Shaggy
Dimensions - PRICE
Square Meter - 38.00 €
BENGALI 848-24
BENGALI 848-24
100% Art Silk Shaggy
Dimensions - PRICE
Square Meter - 55.00 €
LAHORA10 731-01
LAHORA10 731-01
Eco Moquette.
Dimensions - PRICE
Square meter - 45.00 €
PARIS 7006 IVORY
PARIS 7006 IVORY
100% Artsilk Shaggy
Dimensions - PRICE
Custom Size - 69.00 €
BINGO 694 BROWN
BINGO 694 BROWN
100% P.P. Berber, Eco.
Dimensions - PRICE
Custom Size - 19.00 €
EXCLUSIVO 79
EXCLUSIVO 79
Eco Moquette.
Dimensions - PRICE
Square meter - 57.00 €
RADIUS 025
RADIUS 025
100% P.P. Berber, Eco.
Dimensions - PRICE
Custom Size - 28.00 €
GALA 680
GALA 680
Embossed Eco Moquette.
Dimensions - PRICE
Square meter - 32.00 €
JARDIN 220
JARDIN 220
Artificial Lawn.
Dimensions - PRICE
Square meter - 61.00 €
BRILLIANT D.GREY 100
BRILLIANT D.GREY 100
100% Art Silk 50mm.
Dimensions - PRICE
Square meter - 75.00 €
BENGALI 848-13
BENGALI 848-13
100% Art Silk Shaggy
Dimensions - PRICE
Square Meter - 55.00 €
IOS BEIGE 798-13
IOS BEIGE 798-13
Eco Moquette Berber 6mm.
Dimensions - PRICE
Square meter - 28.00 €
LUNA 915 SILVER WHITE
LUNA 915 SILVER WHITE
Saxony, 100% Acrylic
Dimensions - PRICE
Custom Size - 61.00 €
TUNDRA 45
TUNDRA 45
Eco Moquette Berber.
Dimensions - PRICE
Square meter - 28.00 €
VOGUE 34
VOGUE 34
100% Acrylic,P.A,Eco
Dimensions - PRICE
Square meter - 60.00 €
METALLO M02
METALLO M02
Handtufed 100% Art Silk Shaggy.
Dimensions - PRICE
Square meter - 65.00 €
PLUTO 194
PLUTO 194
100% P.P. Berber, Eco.
Dimensions - PRICE
Custom Size - 23.00 €
KOBALT 090
KOBALT 090
100% P.P. Berber, Eco.
Dimensions - PRICE
Custom Size - 27.00 €
LARGO 2167
LARGO 2167
Art Lawn,P.E.
Dimensions - PRICE
Width 2.00m Length per Meter - 98.00 €
Width 4.00m Length per Meter - 196.00 €
PRESCIOSA 52
PRESCIOSA 52
Eco Moquette
Dimensions - PRICE
Square meter - 59.00 €
FIJI 763-97
FIJI 763-97
Shaggy
Dimensions - PRICE
Square Meter - 38.00 €
LAHORA10 731-02
LAHORA10 731-02
Eco Moquette
Dimensions - PRICE
Square meter - 45.00 €
BINGO 675 BLUE
BINGO 675 BLUE
100% P.P. Berber, Eco.
Dimensions - PRICE
Custom Size - 19.00 €
TWIST 6363-95
TWIST 6363-95
100% Acrylic Frisee
Dimensions - PRICE
Available dimensions - 75.00 €
DREAMS 600
DREAMS 600
100% Acrylic,P.P,Eco
Dimensions - PRICE
Square meter - 46.00 €
SULTAN 094 BROWN
SULTAN 094 BROWN
Heatset, Artsilk Shaggy.
Dimensions - PRICE
Square Meter - 37.00 €
LAHORA10 731-10
LAHORA10 731-10
Eco Moquette
Dimensions - PRICE
Square meter - 45.00 €
LAHORA12 731-05
LAHORA12 731-05
Eco Moquette
Dimensions - PRICE
Square meter - 45.00 €
FIJI 763-24
FIJI 763-24
Shaggy
Dimensions - PRICE
Square Meter - 38.00 €
DREAMS 650
DREAMS 650
100% Acrylic,P.P,Eco
Dimensions - PRICE
Square meter - 46.00 €
MOROE 120
MOROE 120
100% Acrylic Frise
Dimensions - PRICE
Custom Size - 48.00 €

en-GB

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