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`=34
 AND  `jos_vm_product`.`product_id` NOT IN (7712,12987,12988) 
 AND  `jos_vm_product`.`product_id` NOT IN (7712,12987,12988) 
 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

ZIEGLER 904-347-5.05-70%
ZIEGLER 904-347-5.05
100% Wool, Handknotted.
Dimensiuni - Preț
186cm x 272cm - 4,219.00 € 1,265.70 €
ORIENT MIXED 902-103-1.75-70%
ORIENT MIXED 902-103-1.75
100% Wool, Handknotted.
Dimensiuni - Preț
111cm x 158cm - 1,368.00 € 410.40 €
ZIEGLER 904-347-4.83-70%
ZIEGLER 904-347-4.83
100% Wool, Handknotted.
Dimensiuni - Preț
195cm x 248cm - 4,033.00 € 1,209.90 €
ZIEGLER 1594 L.BROWN IVORY
ZIEGLER 1594 L.BROWN IVORY
100% Heatset Frise.
Dimensiuni - Preț
133cm x 195cm - 105.00 €
170cm x 240cm - 175.00 €
200cm x 290cm - 239.00 €
Bedroom Set - 149.00 €
KHAL MOHAMMADI 904-344-0.92-70%
KHAL MOHAMMADI 904-344-0.92
100% Wool, Handknotted.
Dimensiuni - Preț
80cm x 116cm - 619.00 € 185.70 €
ORIENT MIXED 902-103-1.44-70%
ORIENT MIXED 902-103-1.44
100% Wool, Handknotted.
Dimensiuni - Preț
98cm x 147cm - 1,123.00 € 336.90 €
ELIF K06 NAVY-50%
ELIF K06 NAVY
60% New Zealand wool,40% Acrylic.
Dimensiuni - Preț
200cm x 250cm - 500.00 € 250.00 €
200cm x 300cm - 600.00 € 300.00 €
DAVINCI 57906-6717
DAVINCI 57906-6717
100% Acrylic
Dimensiuni - Preț
160cm x 230cm - 315.00 €
240cm x 300cm - 612.00 €
BIDJA IRAN 15-09075-70%
BIDJA IRAN 15-09075
100% Wool Handknotted
Dimensiuni - Preț
202cm x 311cm - 4,150.00 € 1,245.00 €
CHOBI CB08
CHOBI CB08
100% Wool,Machine Woven.
Dimensiuni - Preț
130cm x 190cm - 430.00 €
164cm x 230cm - 655.00 €
ZIEGLER 904-347-4.18-70%
ZIEGLER 904-347-4.18
100% Wool, Handknotted.
Dimensiuni - Preț
173cm x 242cm - 3,491.00 € 1,047.30 €
ZIEGLER 904-347-4.16-70%
ZIEGLER 904-347-4.16
100% Wool, Handknotted.
Dimensiuni - Preț
172cm x 242cm - 3,471.00 € 1,041.30 €
ZIEGLER 904-347-3.36-70%
ZIEGLER 904-347-3.36
100% Wool, Handknotted.
Dimensiuni - Preț
151cm x 223cm - 2,802.00 € 840.60 €
BOKHARA RUSSIAN 906-319-4.05-70%
BOKHARA RUSSIAN 906-319-4.05
100% Wool, Handknotted.
Dimensiuni - Preț
163cm x 249cm - 6,319.00 € 1,895.70 €
ELIF 960 NAVY-50%
ELIF 960 NAVY
60% New Zealand wool,40% Acrylic.
Dimensiuni - Preț
250cm x 300cm - 750.00 € 375.00 €
JORD CLASSIC AM IVORY
JORD CLASSIC AM IVORY
100% Modacrylic
Dimensiuni - Preț
160cm x 230cm - 1,395.00 €
200cm x 300cm - 2,195.00 €
ATHOS 1550 CREAM-50%
ATHOS 1550 CREAM
Acrylic, Wool Touch.
Dimensiuni - Preț
250cm x 300cm - 470.00 € 235.00 €
ZIEGLER 904-347-5.41-70%
ZIEGLER 904-347-5.41
100% Wool, Handknotted.
Dimensiuni - Preț
199cm x 272cm - 4,514.00 € 1,354.20 €
ARTEMIS 1626 BLACK
ARTEMIS 1626 BLACK
100% Heatset
Dimensiuni - Preț
160cm x 230cm - 125.00 €
200cm x 290cm - 199.00 €
VISCOUNT V56
VISCOUNT V56
100% Acrylic, Machine Made.
Dimensiuni - Preț
120cm x 170cm - 169.00 €
160cm x 230cm - 280.00 €
VENUS 17520-695-25%
VENUS 17520-695
100% Acrylic.
Dimensiuni - Preț
200cm x 290cm - 415.00 € 311.25 €
ELIF 1363 D.BLUE-50%
ELIF 1363 D.BLUE
60% New Zealand wool,40% Acrylic.
Dimensiuni - Preț
200cm x 300cm - 600.00 € 300.00 €
KHAL MOHAMMADI 904-344-6.32-70%
KHAL MOHAMMADI 904-344-6.32
100% Wool, Handknotted.
Dimensiuni - Preț
245cm x 258cm - 4,216.00 € 1,264.80 €
TEHERAN CHINA 15-08288-70%
TEHERAN CHINA 15-08288
100% Wool Handknotted
Dimensiuni - Preț
170cm x 248cm - 3,140.00 € 942.00 €
CHOBI CB05
CHOBI CB05
100% Wool,Machine Woven.
Dimensiuni - Preț
130cm x 190cm - 430.00 €
164cm x 230cm - 655.00 €
200cm x 290cm - 995.00 €
ORIENT MIXED 902-103-3.94-70%
ORIENT MIXED 902-103-3.94
100% Wool, Handknotted.
Dimensiuni - Preț
170cm x 232cm - 3,076.00 € 922.80 €
ARTEMIS 1266 RED
ARTEMIS 1266 RED
100% Heatset
Dimensiuni - Preț
160cm x 230cm - 125.00 €
200cm x 290cm - 199.00 €
REGALIA NAVY
REGALIA NAVY
100% Acrylic.
Dimensiuni - Preț
120cm x 170cm - 185.00 €
160cm x 220cm - 265.00 €
180cm x 270cm - 365.00 €
SAROUK INDIA 15-41123-70%
SAROUK INDIA 15-41123
100% Wool Handknotted
Dimensiuni - Preț
195cm x 292cm - 4,235.00 € 1,270.50 €
ORIENT MIXED 902-103-3.76-70%
ORIENT MIXED 902-103-3.76
100% Wool, Handknotted.
Dimensiuni - Preț
157cm x 240cm - 2,939.00 € 881.70 €
ORIENT MIXED 902-103-1.14-70%
ORIENT MIXED 902-103-1.14
100% Wool, Handknotted.
Dimensiuni - Preț
85cm x 135cm - 895.00 € 268.50 €
PAK. SILK TOUCH 906-204-3.79-70%
PAK. SILK TOUCH 906-204-3.79
100% Wool,Silk Handknotted.
Dimensiuni - Preț
167cm x 227cm - 3,160.00 € 948.00 €
EMPORIO 4605 CR GREY-60%
EMPORIO 4605 CR GREY
100% Acrylic.
Dimensiuni - Preț
165cm x 225cm - 334.00 € 133.60 €
235cm x 300cm - 634.00 € 253.60 €
ORIENT MIXED 902-103-1.57-70%
ORIENT MIXED 902-103-1.57
100% Wool, Handknotted.
Dimensiuni - Preț
105cm x 150cm - 1,228.00 € 368.40 €
ELITE 16969-095
ELITE 16969-095
Acrylic, Polyester.
Dimensiuni - Preț
160cm x 230cm - 210.00 € 168.00 €
WINDSOR WIN04
WINDSOR WIN04
100% Acrylic, Machine Made.
Dimensiuni - Preț
80cm x 150cm - 75.00 €
120cm x 170cm - 115.00 €
160cm x 230cm - 189.00 €
240cm x 340cm - 399.00 €
ELIF 10578 CR5-50%
ELIF 10578 CR5
60% New Zealand wool,40% Acrylic.
Dimensiuni - Preț
170cm x 240cm - 408.00 € 204.00 €
200cm x 250cm - 500.00 € 250.00 €
200cm x 300cm - 600.00 € 300.00 €
KLASSIK 1019A CHERRY
KLASSIK 1019A CHERRY
100% Acrylic Heatset.
Dimensiuni - Preț
80cm x 150cm - 34.00 €
133cm x 190cm - 72.00 €
160cm x 230cm - 105.00 €
200cm x 290cm - 165.00 €
Bedroom Set - 92.00 €
MILLION 907 IVORY-50%
MILLION 907 IVORY
100% Heatset
Dimensiuni - Preț
160cm x 230cm - 310.00 € 155.00 €
ELIF 1650 CR-50%
ELIF 1650 CR
60% New Zealand wool,40% Acrylic.
Dimensiuni - Preț
170cm x 240cm - 408.00 € 204.00 €
200cm x 250cm - 500.00 € 250.00 €
200cm x 300cm - 600.00 € 300.00 €
250cm x 300cm - 750.00 € 375.00 €
WINDSOR WIN06
WINDSOR WIN06
100% Acrylic, Machine Made.
Dimensiuni - Preț
80cm x 150cm - 75.00 €
120cm x 170cm - 115.00 €
160cm x 230cm - 189.00 €
200cm x 300cm - 299.00 €
ORIENT MIXED 902-103-2.27-70%
ORIENT MIXED 902-103-2.27
100% Wool, Handknotted.
Dimensiuni - Preț
112cm x 203cm - 1,773.00 € 531.90 €
ZIEGLER 904-347-4.86-70%
ZIEGLER 904-347-4.86
100% Wool, Handknotted.
Dimensiuni - Preț
197cm x 247cm - 4,058.00 € 1,217.40 €
KHAL MOHAMMADI 904-344-6.12-70%
KHAL MOHAMMADI 904-344-6.12
100% Wool, Handknotted.
Dimensiuni - Preț
204cm x 300cm - 4,082.00 € 1,224.60 €
ORIENT MIXED 902-103-0.91-70%
ORIENT MIXED 902-103-0.91
100% Wool, Handknotted.
Dimensiuni - Preț
80cm x 114cm - 711.00 € 213.30 €
PAK. SILK TOUCH 906-204-2.39-70%
PAK. SILK TOUCH 906-204-2.39
100% Wool,Silk Handknotted.
Dimensiuni - Preț
126cm x 190cm - 1,993.00 € 597.90 €
ORIENT MIXED 902-103-3.31-70%
ORIENT MIXED 902-103-3.31
100% Wool, Handknotted.
Dimensiuni - Preț
155cm x 214cm - 2,587.00 € 776.10 €
JAMILA 9437-011
JAMILA 9437-011
100% Acrylic.
Dimensiuni - Preț
200cm x 290cm - 405.00 €

ro-RO

Toate materialele de pe acest site sunt proprietatea intelectuală a xalia.com