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`=44
 AND  `jos_vm_product`.`product_id` NOT IN (7712) 
 AND  `jos_vm_product`.`product_id` NOT IN (7712) 
 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

MIAMI 4583 YELLOW-10%
MIAMI 4583 YELLOW
100% Heatset.
Размери - Цена
0.67m - 23.00 € 20.70 €
LEONARDO 413 CREAM NAVY-20%
LEONARDO 413 CREAM NAVY
100% Heatset.
Размери - Цена
0.67m - 22.00 € 17.60 €
SUPER RAINBOW 325-20%
SUPER RAINBOW 325
100% Acrylic
Размери - Цена
0.67m - 33.00 € 26.40 €
0.80m - 39.00 € 31.20 €
CASINO 7091-34 GREΥ BLUE
CASINO 7091-34 GREΥ BLUE
100% Heatset Frise.
Размери - Цена
0.67m - 22.00 €
RAFAEL 3633 BRC-YEL-30%
RAFAEL 3633 BRC-YEL
100% Heat Set.
Размери - Цена
0.67m - 27.00 € 18.90 €
JULIAN 5322 CR-20%
JULIAN 5322 CR
100% Heat Set
Размери - Цена
0.67m - 25.00 € 20.00 €
0.80m - 30.00 € 24.00 €
1.00m - 37.50 € 30.00 €
ELIF 4046 CREAM 2-20%
ELIF 4046 CREAM 2
60% New Zealand wool,40% Acrylic.
Размери - Цена
0.75m - 45.00 € 36.00 €
LEGACY 606X
LEGACY 606X
100% Heatset.
Размери - Цена
0.67m - 28.00 €
JULIAN 5322 RED-20%
JULIAN 5322 RED
100% Heat Set
Размери - Цена
0.67m - 25.00 € 20.00 €
0.80m - 30.00 € 24.00 €
1.00m - 37.50 € 30.00 €
CASINO 5102-91 CHOCO CREAM
CASINO 5102-91 CHOCO CREAM
100% Heatset Frise.
Размери - Цена
0.67m - 22.00 €
BOSTON 5367A D.GREY
BOSTON 5367A D.GREY
100% Heatset, PP.
Размери - Цена
0.67m - 21.00 €
REGGAE 1692A BLUE
REGGAE 1692A BLUE
100% Heatset Frise
Размери - Цена
0.67m - 21.00 € 16.80 €
ROYAL DECO 32640-4-10%
ROYAL DECO 32640-4
100% Heatset.
Размери - Цена
0.67m - 35.56 € 32.00 €
0.80m - 42.22 € 38.00 €
BOHEME 969B
BOHEME 969B
100% Acrylic Frise.
Размери - Цена
0.67m - 24.00 €
N.ELIF 009 BLACK-60%
N.ELIF 009 BLACK
Wool & Lurex
Размери - Цена
0.75m - 80.00 € 32.00 €
ANTIQUE K14 WHITE-20%
ANTIQUE K14 WHITE
100% Wool
Размери - Цена
0.67m - 28.00 € 22.40 €
BOHEME 997B
BOHEME 997B
100% Acrylic Frise.
Размери - Цена
0.67m - 24.00 €
0.80m - 28.00 €
DECO 32640-1
DECO 32640-1
100% Heatset.
Размери - Цена
0.67 - 32.00 €
MALAIDORI 886 GRI-CR-20%
MALAIDORI 886 GRI-CR
Shaggy
Размери - Цена
0.67m - 48.00 € 38.40 €
0.80m - 57.00 € 45.60 €
BOSTON 5376A MARINE
BOSTON 5376A MARINE
100% Heatset, PP.
Размери - Цена
0.67m - 21.00 €
DAMASK 10008 CREAM-20%
DAMASK 10008 CREAM
100% New Zealand wool.
Размери - Цена
0.75m - 48.00 € 38.40 €
PIERRE CARDIN IVORY BEIGE
PIERRE CARDIN IVORY BEIGE
100% Acrylic.
Размери - Цена
0.67m - 58.00 €
0.80m - 69.00 €
ZIEGLER 051 573 J
ZIEGLER 051 573 J
100% Wool Machine made
Размери - Цена
0.67m - 35.00 €
SENTA 7402 CR-GREY-30%
SENTA 7402 CR-GREY
100% Art Silk
Размери - Цена
0.80m - 49.00 € 34.30 €
ZIEGLER 051 573 C
ZIEGLER 051 573 C
100% Wool.Machine made
Размери - Цена
0.67m - 33.00 €
SHERAZAD 8349 IVORY
SHERAZAD 8349 IVORY
100% Acrylic
Размери - Цена
0.67m - 41.00 €
0.80m - 49.00 €
PIERRE CARDIN IVORY GREY
PIERRE CARDIN IVORY GREY
100% Acrylic.
Размери - Цена
0.67m - 58.00 €
0.80m - 69.00 €
SUPER RAINBOW 326-20%
SUPER RAINBOW 326
100% Acrylic
Размери - Цена
0.80m - 39.00 € 31.20 €
LYDIA 2128A RED
LYDIA 2128A RED
100% Heatset.
Размери - Цена
0.67m - 22.00 €
0.80m - 26.00 €
1.00m - 32.00 €
ANTIQUE K14 NAVY-20%
ANTIQUE K14 NAVY
100% Wool
Размери - Цена
0.67m - 28.00 € 22.40 €
JULIAN 559 CR-20%
JULIAN 559 CR
100% Heat Set
Размери - Цена
0.67m - 25.00 € 20.00 €
0.80m - 30.00 € 24.00 €
1.00m - 37.50 € 30.00 €
SHERAZAD 8302 RED
SHERAZAD 8302 RED
100% Acrylic
Размери - Цена
0.67m - 41.00 €
0.80m - 49.00 €
BRAZIL SHAGGY 312 RED-10%
BRAZIL SHAGGY 312 RED
100% Artsilk Shaggy.
Размери - Цена
0.67m - 27.78 € 25.00 €
SUPER RAINBOW 328-20%
SUPER RAINBOW 328
100% Acrylic
Размери - Цена
0.80m - 39.00 € 31.20 €
N.FUGA 7187 BLACK-20%
N.FUGA 7187 BLACK
100% Artsilk Shaggy
Размери - Цена
0.67m - 37.00 € 29.60 €
MOONLIGHT 269 BLACK-30%
MOONLIGHT 269 BLACK
100% Acrylic & Viscose
Размери - Цена
0.80m - 44.00 € 30.80 €
LEGACY 560W
LEGACY 560W
100% Heatset.
Размери - Цена
0.67m - 28.00 €
JULIAN 559 RED-20%
JULIAN 559 RED
100% Heat Set
Размери - Цена
0.67m - 25.00 € 20.00 €
0.80m - 30.00 € 24.00 €
1.00m - 37.50 € 30.00 €
MOONLIGHT 260 IVORY-30%
MOONLIGHT 260 IVORY
100% Acrylic & Viscose
Размери - Цена
0.67m - 37.00 € 25.90 €
SOHO COLLECTION 521/K42
SOHO COLLECTION 521/K42
Acrylic/Senil/Art Silk
Размери - Цена
Широчина 0.67 m Дължина на метър - 25.00 €
VISCONTI 5002-400-20%
VISCONTI 5002-400
100% Acrylic
Размери - Цена
0.67m - 36.00 € 28.80 €
N.FUGA 7184 BLACK-20%
N.FUGA 7184 BLACK
100% Artsilk Shaggy
Размери - Цена
0.67m - 37.00 € 29.60 €
0.80m - 44.00 € 35.20 €
BOSTON 5376A RED
BOSTON 5376A RED
100% Heatset, PP.
Размери - Цена
0.80m - 25.00 €
1.00m - 31.00 €
ANTIQUE K16 WHITE-20%
ANTIQUE K16 WHITE
100% Wool
Размери - Цена
0.67m - 28.00 € 22.40 €
N.ELIF 009 GREY-60%
N.ELIF 009 GREY
Wool & Lurex.
Размери - Цена
0.75m - 80.00 € 32.00 €
BOSTON 5748A GREY
BOSTON 5748A GREY
100% Heatset, PP.
Размери - Цена
0.67m - 21.00 €
0.80m - 25.00 €
1.00m - 31.00 €
DAMASK 10001 CREAM BLACK-20%
DAMASK 10001 CREAM BLACK
100% New Zealand wool.
Размери - Цена
0.75m - 48.00 € 38.40 €
LEGACY 508E
LEGACY 508E
100% Heatset.
Размери - Цена
0.67m - 28.00 €

bg-BG

Целият материал на сайта представлява интелектуална собственост xalia.com