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

SHERAZAD 8302 RED
SHERAZAD 8302 RED
100% Acrylic
Dimensions - Prix
0.67m - 41.00 €
0.80m - 49.00 €
PIERRE CARDIN IVORY GREY
PIERRE CARDIN IVORY GREY
100% Acrylic.
Dimensions - Prix
0.67m - 58.00 €
0.80m - 69.00 €
CASINO 7091-59 SAND CHOCO
CASINO 7091-59 SAND CHOCO
100% Heatset Frise.
Dimensions - Prix
0.67m - 22.00 €
BOSTON 5353A GREY
BOSTON 5353A GREY
100% Acrylic Heatset.
Dimensions - Prix
0.67m - 21.00 €
JULIAN 559 CR-20%
JULIAN 559 CR
100% Heat Set
Dimensions - Prix
0.67m - 25.00 € 20.00 €
0.80m - 30.00 € 24.00 €
1.00m - 37.50 € 30.00 €
SHERAZAD 8302 IVORY
SHERAZAD 8302 IVORY
100% Acrylic
Dimensions - Prix
0.67m - 41.00 €
0.80m - 49.00 €
BRAZIL SHAGGY 312 RED-10%
BRAZIL SHAGGY 312 RED
100% Artsilk Shaggy.
Dimensions - Prix
0.67m - 27.78 € 25.00 €
RAFAEL 3633 BRC-YEL-30%
RAFAEL 3633 BRC-YEL
100% Heat Set.
Dimensions - Prix
0.67m - 27.00 € 18.90 €
DECO 32640-1
DECO 32640-1
100% Heatset.
Dimensions - Prix
0.67m - 32.00 €
ELIF 938 NAVY-20%
ELIF 938 NAVY
60% New Zealand wool,40% Acrylic.
Dimensions - Prix
0.80m - 48.00 € 38.40 €
ASTRA 918-9030-50%
ASTRA 918-9030
100% Heat Set.
Dimensions - Prix
0.80m - 35.00 € 17.50 €
LEGACY 560W
LEGACY 560W
100% Heatset.
Dimensions - Prix
0.67m - 28.00 €
BOSTON 5376A MARINE
BOSTON 5376A MARINE
100% Acrylic Heatset.
Dimensions - Prix
0.67m - 21.00 €
BOSTON 5748A GREY
BOSTON 5748A GREY
100% Acrylic Heatset.
Dimensions - Prix
0.67m - 21.00 €
0.80m - 25.00 €
1.00m - 31.00 €
BOHEME 969B
BOHEME 969B
100% Acrylic Frise.
Dimensions - Prix
0.67m - 24.00 €
N.FUGA 7184 BLACK-20%
N.FUGA 7184 BLACK
100% Artsilk Shaggy
Dimensions - Prix
0.67m - 37.00 € 29.60 €
0.80m - 44.00 € 35.20 €
JULIAN 5322 RED-20%
JULIAN 5322 RED
100% Heat Set
Dimensions - Prix
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.
Dimensions - Prix
0.67m - 22.00 €
ANTIQUE K14 WHITE-20%
ANTIQUE K14 WHITE
100% Wool
Dimensions - Prix
0.67m - 28.00 € 22.40 €
MODERN GREYS 70M-20%
MODERN GREYS 70M
100% Acrylic
Dimensions - Prix
0.67m - 33.00 € 26.40 €
SOHO COLLECTION 521/K42
SOHO COLLECTION 521/K42
Acrylic/Senil/Art Silk
Dimensions - Prix
0.67m - 25.00 €
ROYAL DECO 32640-4-10%
ROYAL DECO 32640-4
100% Heatset.
Dimensions - Prix
0.67m - 35.56 € 32.00 €
0.80m - 42.22 € 38.00 €
BOSTON 5365A BEIGE
BOSTON 5365A BEIGE
100% Acrylic Heatset.
Dimensions - Prix
0.67m - 21.00 €
0.80m - 25.00 €
1.00m - 31.00 €
SENTA 7402 CR-GREY-30%
SENTA 7402 CR-GREY
100% Art Silk
Dimensions - Prix
0.80m - 49.00 € 34.30 €
ELIF 4046 CREAM 2-20%
ELIF 4046 CREAM 2
60% New Zealand wool,40% Acrylic.
Dimensions - Prix
0.75m - 45.00 € 36.00 €
ZIEGLER 051 573 J
ZIEGLER 051 573 J
100% Wool Machine made
Dimensions - Prix
0.67m - 35.00 €
MARMARAS D05 NAVY-20%
MARMARAS D05 NAVY
Acrylic, Wool Touch.
Dimensions - Prix
0.80m - 33.00 € 26.40 €
LEGACY 508E
LEGACY 508E
100% Heatset.
Dimensions - Prix
0.67m - 28.00 €
MIAMI 4583 YELLOW-10%
MIAMI 4583 YELLOW
100% Heatset.
Dimensions - Prix
0.67m - 23.00 € 20.70 €
OLYMPIA 6045L CREAM
OLYMPIA 6045L CREAM
100% Acrylic.
Dimensions - Prix
0.67m - 20.00 €
0.80m - 24.00 €
N.FUGA 7187 BLACK-20%
N.FUGA 7187 BLACK
100% Artsilk Shaggy
Dimensions - Prix
0.67m - 37.00 € 29.60 €
REGGAE 1692A BLUE
REGGAE 1692A BLUE
100% Heatset Frise
Dimensions - Prix
0.67m - 21.00 € 16.80 €
SUPER RAINBOW 328-20%
SUPER RAINBOW 328
100% Acrylic
Dimensions - Prix
0.80m - 39.00 € 31.20 €
SUPER RAINBOW 325-20%
SUPER RAINBOW 325
100% Acrylic
Dimensions - Prix
0.67m - 33.00 € 26.40 €
0.80m - 39.00 € 31.20 €
DAMASK 10001 CREAM BLACK-20%
DAMASK 10001 CREAM BLACK
100% New Zealand wool.
Dimensions - Prix
0.75m - 48.00 € 38.40 €
SHERAZAD 8349 RED
SHERAZAD 8349 RED
100% Acrylic
Dimensions - Prix
0.67m - 41.00 €
0.80m - 49.00 €
MARMARAS ROMEO CREAM BLUE-20%
MARMARAS ROMEO CREAM BLUE
Acrylic, Wool Touch.
Dimensions - Prix
0.80m - 33.00 € 26.40 €
LEONARDO 413 CREAM NAVY-20%
LEONARDO 413 CREAM NAVY
100% Heatset.
Dimensions - Prix
0.67m - 22.00 € 17.60 €
ANTIQUE K16 WHITE-20%
ANTIQUE K16 WHITE
100% Wool
Dimensions - Prix
0.67m - 28.00 € 22.40 €
N.ELIF 009 BLACK-60%
N.ELIF 009 BLACK
Wool & Lurex
Dimensions - Prix
0.75m - 80.00 € 32.00 €
BOSTON 5367A D.GREY
BOSTON 5367A D.GREY
100% Acrylic Heatset.
Dimensions - Prix
0.67m - 21.00 €
0.80m - 25.00 €
OLYMPIA 4262F CREAM
OLYMPIA 4262F CREAM
100% Acrylic.
Dimensions - Prix
0.67m - 20.00 €
0.80m - 24.00 €
VERSARI 51913 6032-20%
VERSARI 51913 6032
100% Acrylic
Dimensions - Prix
0.67m - 33.00 € 26.40 €
MOONLIGHT 260 IVORY-30%
MOONLIGHT 260 IVORY
100% Acrylic & Viscose
Dimensions - Prix
0.67m - 37.00 € 25.90 €
ANTIQUE K14 NAVY-20%
ANTIQUE K14 NAVY
100% Wool
Dimensions - Prix
0.67m - 28.00 € 22.40 €
SHERAZAD 8349 IVORY
SHERAZAD 8349 IVORY
100% Acrylic
Dimensions - Prix
0.67m - 41.00 €
0.80m - 49.00 €
MODERN GREYS 82X-20%
MODERN GREYS 82X
100% Acrylic
Dimensions - Prix
0.67m - 33.00 € 26.40 €
0.80m - 39.00 € 31.20 €
FIESTA 856A BLACK
FIESTA 856A BLACK
100% Acrylic
Dimensions - Prix
0.66m - 29.00 €

fr-FR

Tous les matériels, sous une forme quelconque, sur ce site est protégé par copyright et par le grec et le droit international. Le matériel de ce Site peut être utilisé seulement pour un usage personnel. Rien sur ce Site et surtout les photos et les vidéos de nos produits ne peuvent pas être copiés, modifiés, publiés ou distribués de quelque manière que ce soit sans autorisation préalable de Doup.gr.