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`=39
 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 `jos_{vm}_product_category_xref`.`product_list` ASC

OCEAN 500 MULTI
OCEAN 500 MULTI
100% Viscose Handwoven
Dimensions - PRICE
130cm x 190cm - 485.00 €
170cm x 240cm - 790.00 €
RABBIT 100 ANTHRACITE
RABBIT 100 ANTHRACITE
Handtufted Micro Polyester Shaggy
Dimensions - PRICE
120cm x 170cm - 150.00 €
160cm x 230cm - 270.00 €
180cm x 280cm - 360.00 €
ANTIGUA 400 MULTI
ANTIGUA 400 MULTI
100% Polyester
Dimensions - PRICE
120cm x 170cm - 150.00 €
160cm x 230cm - 255.00 €
200cm x 290cm - 405.00 €
RABBIT 100-R CREME
RABBIT 100-R CREME
Handtufted Micro Polyester Shaggy
Dimensions - PRICE
Ø160cm (Round) - 199.00 €
QUEEN 200 LIGHT BLUE
QUEEN 200 LIGHT BLUE
100% Acrylic
Dimensions - PRICE
120cm x 170cm - 210.00 €
160cm x 230cm - 370.00 €
200cm x 290cm - 587.00 €
VINTAGE 8400 GREY
VINTAGE 8400 GREY
100% Polyacrylic
Dimensions - PRICE
140cm x 200cm - 140.00 €
160cm x 230cm - 185.00 €
200cm x 290cm - 290.00 €
RABBIT 100 WHITE
RABBIT 100 WHITE
Handtufted Micro Polyester Shaggy
Dimensions - PRICE
120cm x 170cm - 150.00 €
160cm x 230cm - 270.00 €
180cm x 280cm - 360.00 €
VINTAGE 8403 PETROL
VINTAGE 8403 PETROL
100% Polyacrylic
Dimensions - PRICE
160cm x 230cm - 185.00 €
200cm x 290cm - 290.00 €
SUNSET ORANGE BLUE 8070-28
SUNSET ORANGE BLUE 8070-28
New Zealand Wool Cotton Handwoven
Dimensions - PRICE
120cm x 170cm - 229.00 €
140cm x 200cm - 285.00 €
170cm x 240cm - 405.00 €
VINTAGE 8403 ANTHRACITE
VINTAGE 8403 ANTHRACITE
100% Polyacrylic
Dimensions - PRICE
160cm x 230cm - 185.00 €
200cm x 290cm - 290.00 €
GRACE SHAGGY 002 SILVER GREY
GRACE SHAGGY 002 SILVER GREY
100% Polyester Shaggy
Dimensions - PRICE
120cm x 170cm - 115.00 €
160cm x 230cm - 199.00 €
RABBIT 100-R ANTHRACITE
RABBIT 100-R ANTHRACITE
Handtufted Micro Polyester Shaggy
Dimensions - PRICE
Ø160cm (Round) - 199.00 €
RABBIT 100 PINK
RABBIT 100 PINK
Handtufted Micro Polyester Shaggy
Dimensions - PRICE
120cm x 170cm - 150.00 €
160cm x 230cm - 270.00 €
180cm x 280cm - 360.00 €
GRACE SHAGGY 010 VIOLET
GRACE SHAGGY 010 VIOLET
100% Polyester Shaggy
Dimensions - PRICE
120cm x 170cm - 115.00 €
MOVE 4453-66
MOVE 4453-66
100% Acrylic Heatset Frise
Dimensions - PRICE
120cm x 170cm - 139.00 €
133cm x 190cm - 169.00 €
160cm x 230cm - 249.00 €
200cm x 290cm - 399.00 €
MOVE 4453-23
MOVE 4453-23
100% Acrylic Heatset Frise
Dimensions - PRICE
120cm x 170cm - 139.00 €
133cm x 190cm - 169.00 €
160cm x 230cm - 249.00 €
200cm x 290cm - 399.00 €
GRACE SHAGGY 005 TAUPE
GRACE SHAGGY 005 TAUPE
100% Polyester Shaggy
Dimensions - PRICE
120cm x 170cm - 115.00 €
160cm x 230cm - 199.00 €
GRACE SHAGGY 003 ANTHRACITE
GRACE SHAGGY 003 ANTHRACITE
100% Polyester Shaggy
Dimensions - PRICE
120cm x 170cm - 115.00 €
160cm x 230cm - 199.00 €
200cm x 290cm - 305.00 €
RABBIT 100-R WHITE
RABBIT 100-R WHITE
Handtufted Micro Polyester Shaggy
Dimensions - PRICE
Ø160cm (Round) - 199.00 €
OCEAN 200 TURQUOISE
OCEAN 200 TURQUOISE
100% Viscose Handwoven
Dimensions - PRICE
130cm x 190cm - 485.00 €
170cm x 240cm - 790.00 €
VINTAGE 8402 TAUPE
VINTAGE 8402 TAUPE
100% Polyacrylic
Dimensions - PRICE
140cm x 200cm - 140.00 €
160cm x 230cm - 185.00 €
200cm x 290cm - 290.00 €
SUNSET YELLOW BLUE 8070-23
SUNSET YELLOW BLUE 8070-23
New Zealand Wool Cotton Handwoven
Dimensions - PRICE
120cm x 170cm - 229.00 €
140cm x 200cm - 285.00 €
170cm x 240cm - 405.00 €
HARLEQUIN 01A
HARLEQUIN 01A
100% Acrylic,Handtufted.
Dimensions - PRICE
160cm x 230cm - 334.00 €
VINTAGE 8400 CREAM BLUE
VINTAGE 8400 CREAM BLUE
100% Polyacrylic
Dimensions - PRICE
140cm x 200cm - 140.00 €
160cm x 230cm - 185.00 €
200cm x 290cm - 290.00 €
ANTIGUA 200 ORANGE
ANTIGUA 200 ORANGE
100% Polyester
Dimensions - PRICE
120cm x 170cm - 150.00 €
160cm x 230cm - 255.00 €
200cm x 290cm - 405.00 €
RABBIT 100 GREY BLUE
RABBIT 100 GREY BLUE
Handtufted Micro Polyester Shaggy
Dimensions - PRICE
120cm x 170cm - 150.00 €
160cm x 230cm - 270.00 €
180cm x 280cm - 360.00 €
GRACE SHAGGY 001 SILVER
GRACE SHAGGY 001 SILVER
100% Polyester Shaggy
Dimensions - PRICE
120cm x 170cm - 115.00 €
160cm x 230cm - 199.00 €
ANTIGUA 100 MULTI
ANTIGUA 100 MULTI
100% Polyester
Dimensions - PRICE
120cm x 170cm - 150.00 €
160cm x 230cm - 255.00 €
200cm x 290cm - 405.00 €
RABBIT 100-R PINK
RABBIT 100-R PINK
Handtufted Micro Polyester Shaggy
Dimensions - PRICE
Ø160cm (Round) - 199.00 €
OCEAN 100 RED
OCEAN 100 RED
100% Viscose Handwoven
Dimensions - PRICE
130cm x 190cm - 485.00 €
170cm x 240cm - 790.00 €
HEAVEN & EARTH 4604-66
HEAVEN & EARTH 4604-66
Acrylic Polyester
Dimensions - PRICE
120cm x 170cm - 139.00 €
200cm x 290cm - 399.00 €
OCEAN 400 PINK BLUE
OCEAN 400 PINK BLUE
100% Viscose Handwoven
Dimensions - PRICE
130cm x 190cm - 485.00 €
170cm x 240cm - 790.00 €
RABBIT 100 CREME
RABBIT 100 CREME
Handtufted Micro Polyester Shaggy
Dimensions - PRICE
120cm x 170cm - 150.00 €
160cm x 230cm - 270.00 €
180cm x 280cm - 360.00 €
QUEEN 300 CREAM
QUEEN 300 CREAM
100% Acrylic
Dimensions - PRICE
120cm x 170cm - 210.00 €
160cm x 230cm - 370.00 €
200cm x 290cm - 587.00 €
ANTIGUA 600 MULTI
ANTIGUA 600 MULTI
100% Polyester
Dimensions - PRICE
120cm x 170cm - 150.00 €
160cm x 230cm - 255.00 €
200cm x 290cm - 405.00 €
RABBIT 100-R GREY BLUE
RABBIT 100-R GREY BLUE
Handtufted Micro Polyester Shaggy
Dimensions - PRICE
Ø160cm (Round) - 199.00 €
GRACE SHAGGY 006 BLUE GREY
GRACE SHAGGY 006 BLUE GREY
100% Polyester Shaggy
Dimensions - PRICE
120cm x 170cm - 115.00 €
160cm x 230cm - 199.00 €
200cm x 290cm - 305.00 €
SUNSET TAUPE 8070-66
SUNSET TAUPE 8070-66
New Zealand Wool Cotton Handwoven
Dimensions - PRICE
120cm x 170cm - 229.00 €
140cm x 200cm - 285.00 €
170cm x 240cm - 405.00 €
QUEEN 100 LIGHT BLUE
QUEEN 100 LIGHT BLUE
100% Acrylic
Dimensions - PRICE
120cm x 170cm - 210.00 €
160cm x 230cm - 370.00 €
200cm x 290cm - 587.00 €
QUINTESSENCE HEATHER
QUINTESSENCE HEATHER
Pure New Wool Viscose Handtufted
Dimensions - PRICE
140cm x 200cm - 505.00 €
170cm x 240cm - 749.00 €
200cm x 280cm - 1,025.00 €
ARTISTIC FLORAL BLUE GREY
ARTISTIC FLORAL BLUE GREY
Micropolyester, Acrylic Heatset.
Dimensions - PRICE
75cm x 150cm - 55.00 €
133cm x 190cm - 125.00 €
166cm x 230cm - 185.00 €
200cm x 300cm - 289.00 €
GUY LAROCHE OBERON BLACK WHITE
GUY LAROCHE OBERON BLACK WHITE
Viscose Leather Handtufted
Dimensions - PRICE
190cm x 290cm - 1,190.00 €
WOOLEN KILM-15%
WOOLEN KILM
100%Wool Hand Loomknotted
Dimensions - PRICE
130cm x 190cm - 230.00 € 195.50 €
160cm x 230cm - 350.00 € 297.50 €
200cm x 300cm - 460.00 € 391.00 €
250cm x 300cm - 680.00 € 578.00 €
250cm x 350cm - 780.00 € 663.00 €
ESTIA 7428 TURQUOISE
ESTIA 7428 TURQUOISE
100% Heatset
Dimensions - PRICE
133cm x 190cm - 49.00 €
160cm x 230cm - 69.00 €
200cm x 290cm - 109.00 €
Bedroom Set - 65.00 €
COLORES COL01
COLORES COL01
100% Acrylic,Machine Woven.
Dimensions - PRICE
120cm x 170cm - 139.00 €
160cm x 230cm - 214.00 €
SKY 21876-795
SKY 21876-795
100% Acrylic Heatset Frise
Dimensions - PRICE
133cm x 190cm - 85.00 €
160cm x 230cm - 120.00 €
200cm x 290cm - 190.00 €
240cm x 300cm - 240.00 €
VINTAGE 1601 WHITE
VINTAGE 1601 WHITE
100% Acrylic Heatset
Dimensions - PRICE
120cm x 170cm - 105.00 €
160cm x 230cm - 175.00 € 140.00 €
200cm x 290cm - 259.00 €
GEM RAY GREY BLACK
GEM RAY GREY BLACK
Acrylic Polyester
Dimensions - PRICE
120cm x 170cm - 205.00 €
160cm x 230cm - 345.00 €

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