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`=43
 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

NAVARRO 2916 GREEN
NAVARRO 2916 GREEN
100% Cotton Handmade
Dimensions - PRICE
120cm x 170cm - 125.00 €
130cm x 190cm - 150.00 €
160cm x 230cm - 220.00 €
170cm x 230cm - 235.00 €
DIANA MELODY 682 GREY BLUE
DIANA MELODY 682 GREY BLUE
Cotton Chenille Jacquard Woven
Dimensions - PRICE
120cm x 180cm - 175.00 €
145cm x 200cm - 219.00 €
170cm x 240cm - 299.00 €
200cm x 300cm - 439.00 €
250cm x 300cm - 555.00 €
250cm x 350cm - 629.00 €
AUREUS FASHION AUR01 598 MULTI
AUREUS FASHION AUR01 598 MULTI
Cotton Chenille Jacquard Woven
Dimensions - PRICE
120cm x 170cm - 159.00 €
140cm x 200cm - 205.00 €
155cm x 235cm - 259.00 €
200cm x 280cm - 415.00 €
MY LAOS 453 BLUE
MY LAOS 453 BLUE
100% Soft Poylester,Cross Woven.
Dimensions - PRICE
120cm x 170cm - 139.00 €
160cm x 230cm - 229.00 €
200cm x 285cm - 350.00 €
AUREUS FASHION AUR01 420 BEIGE
AUREUS FASHION AUR01 420 BEIGE
Cotton Chenille Jacquard Woven
Dimensions - PRICE
120cm x 170cm - 159.00 €
140cm x 200cm - 205.00 €
155cm x 235cm - 259.00 €
200cm x 280cm - 415.00 €
NAVARRO 2915 BLUE
NAVARRO 2915 BLUE
100% Cotton Handmade
Dimensions - PRICE
120cm x 170cm - 125.00 €
130cm x 190cm - 150.00 €
160cm x 230cm - 220.00 €
170cm x 230cm - 235.00 €
DIANA UNIS 640 GREY
DIANA UNIS 640 GREY
Cotton Chenille Jacquard Woven
Dimensions - PRICE
120cm x 180cm - 175.00 €
145cm x 200cm - 219.00 €
170cm x 240cm - 299.00 €
250cm x 300cm - 555.00 €
DIANA MELODY 626 GREY YELLOW
DIANA MELODY 626 GREY YELLOW
Cotton Chenille Jacquard Woven
Dimensions - PRICE
120cm x 180cm - 175.00 €
145cm x 200cm - 219.00 €
170cm x 240cm - 299.00 €
200cm x 300cm - 439.00 €
250cm x 300cm - 555.00 €
250cm x 350cm - 629.00 €
AUREUS FASHION AUR01 430 RED
AUREUS FASHION AUR01 430 RED
Cotton Chenille Jacquard Woven
Dimensions - PRICE
120cm x 170cm - 159.00 €
140cm x 200cm - 205.00 €
155cm x 235cm - 259.00 €
200cm x 280cm - 415.00 €
NAVARRO 2917 BEIGE IVORY
NAVARRO 2917 BEIGE IVORY
100% Cotton Handmade
Dimensions - PRICE
120cm x 170cm - 125.00 €
130cm x 190cm - 150.00 €
160cm x 230cm - 220.00 €
170cm x 230cm - 235.00 €
DIANA MELODY 682 GREY RED
DIANA MELODY 682 GREY RED
Cotton Chenille Jacquard Woven
Dimensions - PRICE
120cm x 180cm - 175.00 €
145cm x 200cm - 219.00 €
170cm x 240cm - 299.00 €
200cm x 300cm - 439.00 €
250cm x 300cm - 555.00 €
250cm x 350cm - 629.00 €
AUREUS FASHION AUR01 448 GREY
AUREUS FASHION AUR01 448 GREY
Cotton Chenille Jacquard Woven
Dimensions - PRICE
120cm x 170cm - 159.00 €
140cm x 200cm - 205.00 €
155cm x 235cm - 259.00 €
200cm x 280cm - 415.00 €
NOA KILIM 001-A BEIGE BLUE-20%
NOA KILIM 001-A BEIGE BLUE
100% Cotton
Dimensions - PRICE
155cm x 230cm - 148.75 € 119.00 €
SPIRIT 003 GREY BLUE-20%
SPIRIT 003 GREY BLUE
100% Acrylic
Dimensions - PRICE
120cm x 180cm - 111.25 € 89.00 €
170cm x 245cm - 211.25 € 169.00 €
NOVEL COTTON 2705-20%
NOVEL COTTON 2705
100% Cotton
Dimensions - PRICE
160cm x 230cm - 161.25 € 129.00 €
MY STOCKHOLM STO 341 MUSTARD
MY STOCKHOLM STO 341 MUSTARD
100% Cotton, Handwoven.
Dimensions - PRICE
120cm x 170cm - 89.00 €
160cm x 230cm - 139.00 € 111.20 €
200cm x 290cm - 215.00 €
ANTIGUA GREEN
ANTIGUA GREEN
Viscose & Chenille.
Dimensions - PRICE
160cm x 235cm - 280.00 € 224.00 €
195cm x 280cm - 389.00 €
SUMMER SOHO 1889 25-40%
SUMMER SOHO 1889 25
chenille & viscose
Dimensions - PRICE
140cm x 200cm - 88.75 € 53.25 €
160cm x 230cm - 116.25 € 69.75 €
200cm x 250cm - 157.50 € 94.50 €
MILANO MIL 570 TURQUOISE-20%
MILANO MIL 570 TURQUOISE
100% Chenille, Jaquard Woven.
Dimensions - PRICE
160cm x 230cm - 230.00 €
SEVILLA 5817 FUCHSIA S4-30%
SEVILLA 5817 FUCHSIA S4
100% Viscose, Machine Knotted
Dimensions - PRICE
160cm x 230cm - 265.00 € 238.50 €
DAMASK 72004-022-20%
DAMASK 72004-022
Cotton, Polyester Printed.
Dimensions - PRICE
160cm x 230cm - 145.00 € 116.00 €
PALMS BLUE-20%
PALMS BLUE
100% PP, Machine Woven
Dimensions - PRICE
135cm x 190cm - 124.00 € 99.20 €
160cm x 230cm - 162.00 € 129.60 €
MY MILANO 573 GREEN
MY MILANO 573 GREEN
Chenille,Visoce Jacquard Woven.
Dimensions - PRICE
120cm x 170cm - 115.00 €
155cm x 230cm - 185.00 €
XENON 118-120-40%
XENON 118-120
100% Polyester
Dimensions - PRICE
160cm x 235cm - 156.66 € 94.00 €
CANVAS 492 X-40%
CANVAS 492 X
100% Chenille
Dimensions - PRICE
120cm x 180cm - 37.50 € 30.00 €
150cm x 220cm - 132.50 € 106.00 €
SUMMER SOHO 1004 25-40%
SUMMER SOHO 1004 25
chenille & viscose
Dimensions - PRICE
Bedroom Set - 132.50 € 106.00 €
SASSUOLO MULTI-10%
SASSUOLO MULTI
100% Cotton,Indian Handmade.
Dimensions - PRICE
140cm x 200cm - 158.00 € 142.20 €
BRAID 006
BRAID 006
100% Jute Handmade
Dimensions - PRICE
Ø150cm (Round) - 215.00 €
Ø180cm (Round) - 309.00 €
DAMASK 72008-022-20%
DAMASK 72008-022
Cotton, Polyester Printed.
Dimensions - PRICE
140cm x 200cm - 110.00 € 88.00 €
160cm x 230cm - 145.00 € 116.00 €
HIRA 002 AQUA-20%
HIRA 002 AQUA
100% PP Viscose
Dimensions - PRICE
120cm x 180cm - 111.25 € 89.00 €
155cm x 230cm - 186.25 € 149.00 €
TERNI 1004 MULTI OVAL-20%
TERNI 1004 MULTI OVAL
100% Cotton,Handmade
Dimensions - PRICE
70cm x 140cm(Oval) - 68.00 € 54.40 €
VENUS SPLASH MULTI
VENUS SPLASH MULTI
Viscose & Chenille.
Dimensions - PRICE
160cm x 235cm - 304.00 €
195cm x 280cm - 439.00 €
AMBRA KILIM BLUE
AMBRA KILIM BLUE
100% Cotton, Handwoven.
Dimensions - PRICE
200cm x 290cm - 529.00 €
MY MILANO 572 GINGER
MY MILANO 572 GINGER
Chenille,Visoce Jacquard Woven.
Dimensions - PRICE
120cm x 170cm - 115.00 €
CANDIA 1080-40%
CANDIA 1080
100% Viscose
Dimensions - PRICE
80cm x 150cm - 65.00 € 39.00 €
120cm x 180cm - 116.25 € 69.75 €
160cm x 230cm - 198.75 € 119.25 €
NOA KILIM 003-B CREAM AQUA-20%
NOA KILIM 003-B CREAM AQUA
100% Cotton
Dimensions - PRICE
155cm x 230cm - 148.75 € 119.00 €
SUNSHINE 18340-957-20%
SUNSHINE 18340-957
Chenille Heatset
Dimensions - PRICE
133cm x 190cm - 126.25 € 101.00 €
166cm x 236cm - 196.25 € 157.00 €
VITA BRAID GREEN-20%
VITA BRAID GREEN
100% PP, Machine Woven.
Dimensions - PRICE
133cm x 190cm - 156.25 € 125.00 €
160cm x 230cm - 198.75 € 159.00 €
200cm x 285cm - 273.75 € 219.00 €
CANVAS 234 X-40%
CANVAS 234 X
100% Chenille
Dimensions - PRICE
150cm x 220cm - 103.75 € 62.25 €
BATIK 007-102-35%
BATIK 007-102
Polyester PP Machine Made Sisal
Dimensions - PRICE
160cm x 230cm - 85.00 € 55.25 €
STYLISH BLACK ZIG-ZAG-20%
STYLISH BLACK ZIG-ZAG
100% PP, Machine Woven.
Dimensions - PRICE
160cm x 230cm - 198.75 € 129.19 €
ART3 921-102-55%
ART3 921-102
Chenille,Cotton,Polyester
Dimensions - PRICE
150cm x 220cm - 167.50 € 83.75 €
Bedroom Set - 190.00 € 95.00 €
LAOS 012 D-40%
LAOS 012 D
100% Chenille
Dimensions - PRICE
80cm x 150cm - 37.50 € 22.50 €
BOHEME 18533-952-20%
BOHEME 18533-952
100% PP, Machine Made.
Dimensions - PRICE
160cm x 230cm - 137.50 € 110.00 €
NOVEL COTTON 1749-20%
NOVEL COTTON 1749
100% Cotton
Dimensions - PRICE
160cm x 230cm - 161.25 € 129.00 €
PATCHWORK 006 ORANGE-80%
PATCHWORK 006 ORANGE
100% Wool,Handmade.
Dimensions - PRICE
160cm x 230cm - 848.00 € 169.60 €
200cm x 250cm - 1,090.00 € 218.00 €
SUMMER SOHO 1888 84-40%
SUMMER SOHO 1888 84
chenille & viscose
Dimensions - PRICE
160cm x 230cm - 141.25 € 113.00 €
LAOS 012 R-40%
LAOS 012 R
100% Chenille
Dimensions - PRICE
80cm x 150cm - 37.50 € 22.50 €

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