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

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 €
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 €
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-20%
SUMMER SOHO 1889 25
chenille & viscose
Dimensions - PRICE
100cm x 150cm - 47.50 € 38.00 €
140cm x 200cm - 88.75 € 71.00 €
160cm x 230cm - 116.25 € 93.00 €
200cm x 250cm - 157.50 € 126.00 €
Bedroom Set - 107.50 € 86.00 €
LUCCA JUTE MULTI-R-20%
LUCCA JUTE MULTI-R
100% Natural Jute,Handmade.
Dimensions - PRICE
150cm (round) - 150.00 € 120.00 €
MILANO MIL 570 TURQUOISE-20%
MILANO MIL 570 TURQUOISE
100% Chenille, Jaquard Woven.
Dimensions - PRICE
160cm x 230cm - 230.00 €
PALMA 1646 D7-20%
PALMA 1646 D7
100% Viscose
Dimensions - PRICE
160cm x 230cm - 116.25 € 93.00 €
BOHEME 18531-095-20%
BOHEME 18531-095
100% PP, Machine Made.
Dimensions - PRICE
133cm x 190cm - 95.00 € 76.00 €
SEVILLA 5817 FUCHSIA S4-10%
SEVILLA 5817 FUCHSIA S4
100% Viscose, Machine Knotted
Dimensions - PRICE
160cm x 230cm - 265.00 € 238.50 €
200cm x 250cm - 351.00 € 315.90 €
DAMASK 72004-022-20%
DAMASK 72004-022
Cotton, Polyester Printed.
Dimensions - PRICE
140cm x 200cm - 110.00 € 88.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 491 W-20%
CANVAS 491 W
100% Chenille
Dimensions - PRICE
150cm x 220cm - 132.50 € 106.00 €
CANVAS 492 X-20%
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-20%
SUMMER SOHO 1004 25
chenille & viscose
Dimensions - PRICE
Bedroom Set - 132.50 € 106.00 €
VIOLETE 2916F CREAM BLUE
VIOLETE 2916F CREAM BLUE
100% Viscose
Dimensions - PRICE
80cm x 150cm - 40.00 €
120cm x 180cm - 73.00 €
170cm x 240cm - 138.00 €
SASSUOLO MULTI-10%
SASSUOLO MULTI
100% Cotton,Indian Handmade.
Dimensions - PRICE
140cm x 200cm - 158.00 € 142.20 €
ART3 517-102-50%
ART3 517-102
Chenille,Cotton,Polyester
Dimensions - PRICE
150cm x 220cm - 167.50 € 83.75 €
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 €
155cm x 230cm - 185.00 €
PALMA 1646 02-20%
PALMA 1646 02
100% Viscose
Dimensions - PRICE
140cm x 200cm - 88.75 € 71.00 €
160cm x 230cm - 116.25 € 93.00 €
CANDIA 1080-20%
CANDIA 1080
100% Viscose
Dimensions - PRICE
80cm x 150cm - 65.00 € 52.00 €
120cm x 180cm - 116.25 € 93.00 €
160cm x 230cm - 198.75 € 159.00 €
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-20%
CANVAS 234 X
100% Chenille
Dimensions - PRICE
75cm x 150cm - 35.00 € 28.00 €
120cm x 180cm - 67.50 € 54.00 €
150cm x 220cm - 103.75 € 83.00 €
CANVAS 619 X-20%
CANVAS 619 X
100% Chenille
Dimensions - PRICE
75cm x 150cm - 35.00 € 28.00 €
BATIK 007-102-20%
BATIK 007-102
Polyester PP Machine Made Sisal
Dimensions - PRICE
160cm x 230cm - 85.00 € 68.00 €
CANVAS 706 W-20%
CANVAS 706 W
100% Chenille
Dimensions - PRICE
75cm x 150cm - 35.00 € 28.00 €
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-50%
ART3 921-102
Chenille,Cotton,Polyester
Dimensions - PRICE
150cm x 220cm - 167.50 € 83.75 €
Bedroom Set - 190.00 € 95.00 €
LAOS 012 D-20%
LAOS 012 D
100% Chenille
Dimensions - PRICE
80cm x 150cm - 37.50 € 30.00 €
BOHEME 18533-952-20%
BOHEME 18533-952
100% PP, Machine Made.
Dimensions - PRICE
133cm x 190cm - 95.00 € 76.00 €
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-20%
SUMMER SOHO 1888 84
chenille & viscose
Dimensions - PRICE
160cm x 230cm - 141.25 € 113.00 €
LAOS 012 R-20%
LAOS 012 R
100% Chenille
Dimensions - PRICE
80cm x 150cm - 37.50 € 30.00 €
NOVEL COTTON 1719 CORAL-20%
NOVEL COTTON 1719 CORAL
100% Cotton
Dimensions - PRICE
160cm x 230cm - 161.25 € 129.00 €
BATIK 024-102-20%
BATIK 024-102
Polyester PP Machine Made Sisal
Dimensions - PRICE
200cm x 250cm - 116.25 € 93.00 €
200cm x 290cm - 133.75 € 107.00 €
DECO ART ATTACK MULTI
DECO ART ATTACK MULTI
Cotton, Acrylic.
Dimensions - PRICE
160cm x 235cm - 280.00 €
200cm x 285cm - 419.00 €

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