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

FROZEN DISNEY 10005
FROZEN DISNEY 10005
100% Heatset Printed.
Dimensiuni - Preț
80cm x 120cm - 30.00 €
133cm x 190cm - 115.00 €
160cm x 240cm - 145.00 €
VEGAS 9116 LONDON
VEGAS 9116 LONDON
100% Heatset
Dimensiuni - Preț
133cm x 190cm - 70.00 €
160cm x 230cm - 105.00 €
200cm x 290cm - 169.00 €
PLAY PINK MEADOW
PLAY PINK MEADOW
100% Acrylic.
Dimensiuni - Preț
90cm x 90cm - 59.00 €
ART3 90-119-50%
ART3 90-119
Chenille,Cotton,Polyester
Dimensiuni - Preț
150cm x 220cm - 150.00 € 75.00 €
SIMPLE STARS WHITE
SIMPLE STARS WHITE
100% Acrylic Handtufted.
Dimensiuni - Preț
110cm x 170cm - 249.00 €
130cm x 190cm - 319.00 €
SEALIFE
SEALIFE
100% Acrylic Handtufted.
Dimensiuni - Preț
70cm x 140cm - 169.00 €
90cm x 160cm - 225.00 €
140cm x 200cm - 435.00 €
COTTON BABY 018008-15%
COTTON BABY 018008
100% Cotton
Dimensiuni - Preț
120cm x 160cm - 172.00 € 146.20 €
SOFT UNI 756 L.PURPLE
SOFT UNI 756 L.PURPLE
100% Artsilk Shaggy Handtufted.
Dimensiuni - Preț
160cm x 230cm - 365.00 €
190cm x 290cm - 545.00 €
FLASH 1877-25%
FLASH 1877
100% Acrylic Frize
Dimensiuni - Preț
133cm x 190cm - 92.00 € 69.00 €
160cm x 230cm - 135.00 € 101.25 €
200cm x 250cm - 180.00 € 135.00 €
SUNSET CUBES
SUNSET CUBES
100% Heatset, Hand Carved.
Dimensiuni - Preț
160cm x 220cm - 215.00 €
DRAGON & CASTLE 508-02
DRAGON & CASTLE 508-02
100% Acrylic, Handtuft
Dimensiuni - Preț
120cm x 180cm - 309.00 €
140cm x 200cm - 415.00 €
170cm x 240cm - 599.00 €
MACADOR SOLID PASTEL BLUE
MACADOR SOLID PASTEL BLUE
100% Artsilk Shaggy, Handmade.
Dimensiuni - Preț
120cm x 170cm - 229.00 €
140cm x 200cm - 309.00 €
160cm x 230cm - 399.00 €
200cm x 290cm - 619.00 €
GUAYA STRIPES MULTI
GUAYA STRIPES MULTI
100% Heatset Frise
Dimensiuni - Preț
120cm x 170cm - 179.00 €
160cm x 230cm - 309.00 €
200cm x 290cm - 509.00 €
HAPPY SMALL CROCODILE GREEN
HAPPY SMALL CROCODILE GREEN
100% Acrylic Handtufted.
Dimensiuni - Preț
70cm x 140cm - 179.00 €
90cm x 160cm - 249.00 €
120cm x 180cm - 389.00 €
JUPITER 21270-910-20%
JUPITER 21270-910
100% Acrylic.
Dimensiuni - Preț
160cm x 230cm - 140.00 € 98.00 €
DIAMOND 21497-760
DIAMOND 21497-760
100% Acrylic Frise.
Dimensiuni - Preț
133cm x 190cm - 110.00 €
160cm x 230cm - 165.00 €
RAINBOW 004
RAINBOW 004
100% Acrylic, Printed
Dimensiuni - Preț
133cm x 190cm - 99.00 €
DAISY 6010 FUCHSIA
DAISY 6010 FUCHSIA
100% Artsilk Handtufted.
Dimensiuni - Preț
Ø90cm (Round) - 119.00 € 95.20 €
Ø130cm (Round) - 225.00 €
COTTON BABY 012004-15%
COTTON BABY 012004
100% Cotton
Dimensiuni - Preț
120cm x 160cm - 172.00 € 146.20 €
PLAY NELLIE PINK
PLAY NELLIE PINK
100% Acrylic.
Dimensiuni - Preț
80cm x 120cm - 65.00 €
SAINT CLAIR HEARTS
SAINT CLAIR HEARTS
Acrylic,PP Machine Made.
Dimensiuni - Preț
115cm x 175cm - 95.00 €
150cm x 200cm - 149.00 €
DORA 4566-9-50%
DORA 4566-9
100% Acrylic
Dimensiuni - Preț
170cm x 240cm - 198.00 € 99.00 €
MY CURACAO CUR 490 PETROL
MY CURACAO CUR 490 PETROL
Soft Micropolyester,Handtufted
Dimensiuni - Preț
120cm x 170cm - 120.00 €
RAINBOW 2000 GREEN
RAINBOW 2000 GREEN
100% Acrylic Shaggy
Dimensiuni - Preț
80cm x 150cm - 75.00 €
120cm x 170cm - 115.00 €
160cm x 230cm - 195.00 € 156.00 €
200cm x 290cm - 289.00 €
DAISY 6010 WHITE
DAISY 6010 WHITE
100% Artsilk Handtufted.
Dimensiuni - Preț
Ø90cm (Round) - 119.00 € 95.20 €
DIAMOND 15193-030
DIAMOND 15193-030
100% Acrylic Frise.
Dimensiuni - Preț
160cm x 230cm - 165.00 €
MY FAIRYTALE FAIR 638 UNDER THE SEA
MY FAIRYTALE FAIR 638 UNDER THE SEA
100% Acrylic, Printed.
Dimensiuni - Preț
130cm x 190cm - 99.00 €
HAPPINESS SMILE HA008 598 MULTI
HAPPINESS SMILE HA008 598 MULTI
100% Acrylic Frise.
Dimensiuni - Preț
160cm x 230cm - 209.00 €
TEDDY BEAR BEIGE ROUND
TEDDY BEAR BEIGE ROUND
100% Cotton, Machinewoven.
Dimensiuni - Preț
Ø100cm (Round) - 99.00 €
MY TORINO KIDS TOK 234 GLAMOUR
MY TORINO KIDS TOK 234 GLAMOUR
Chenille, Printed Jacquard Woven.
Dimensiuni - Preț
120cm x 170cm - 95.00 €
160cm x 230cm - 149.00 €
CORAL 3
CORAL 3
Microfiber soft velvet
Dimensiuni - Preț
160cm x 230cm - 176.00 €
200cm x 290cm - 278.00 €
SAINT CLAIR TEDDY BLUE
SAINT CLAIR TEDDY BLUE
Acrylic,PP Machine Made.
Dimensiuni - Preț
115cm x 175cm - 95.00 €
150cm x 200cm - 149.00 €
DIAMOND 21511-055
DIAMOND 21511-055
100% Acrylic Frise.
Dimensiuni - Preț
133cm x 190cm - 110.00 €
160cm x 230cm - 165.00 €
KITTY KAT BEIGE PINK
KITTY KAT BEIGE PINK
100% Acrylic Handtufted.
Dimensiuni - Preț
110cm x 170cm - 249.00 €
130cm x 190cm - 319.00 €
PASSION 75700-20%
PASSION 75700
Handtufted 100% Acrylic
Dimensiuni - Preț
140cm x 200cm - 470.00 €
170cm x 240cm - 665.00 €
DISNEY 10009 MK
DISNEY 10009 MK
100% Heatset Printed.
Dimensiuni - Preț
133cm x 190cm - 115.00 €
160cm x 240cm - 145.00 €
GUAYA BLINK MULTI
GUAYA BLINK MULTI
100% Heatset Frise
Dimensiuni - Preț
120cm x 170cm - 179.00 €
160cm x 230cm - 309.00 €
200cm x 290cm - 509.00 €
COTTON BABY 025011-15%
COTTON BABY 025011
100% Cotton
Dimensiuni - Preț
120cm x 160cm - 172.00 € 146.20 €
SNUGGIE RED
SNUGGIE RED
100% Heatset Frise
Dimensiuni - Preț
80cm x 150cm - 85.00 €
133cm x 200cm - 159.00 €
200cm x 290cm - 319.00 €
FLORIDA 9774 SUN LILAC
FLORIDA 9774 SUN LILAC
100% Heatset Frize
Dimensiuni - Preț
80cm x 150cm - 39.00 €
200cm x 290cm - 169.00 €
HAPPINESS QUATTRO HA011 598 MULTI
HAPPINESS QUATTRO HA011 598 MULTI
100% Acrylic Frise.
Dimensiuni - Preț
120cm x 170cm - 119.00 €
140cm x 200cm - 159.00 €
160cm x 230cm - 209.00 €
NEW KIDS HAPPY BUGS-10%
NEW KIDS HAPPY BUGS
100% Acrylic Frise.
Dimensiuni - Preț
67cm x 140cm - 40.00 €
80cm x 150cm - 50.00 €
133cm x 190cm - 106.00 €
160cm x 230cm - 155.00 €
DIAMOND 21999-755
DIAMOND 21999-755
100% Acrylic Frise
Dimensiuni - Preț
Ø120cm (Round) - 65.00 € 52.00 €
GUAYA BEAT MULTI
GUAYA BEAT MULTI
100% Heatset Frise
Dimensiuni - Preț
120cm x 170cm - 179.00 €
160cm x 230cm - 309.00 €
200cm x 290cm - 509.00 €
CORAL 2
CORAL 2
Microfiber soft velvet
Dimensiuni - Preț
200cm x 290cm - 278.00 €
SMART BUTTON MULTI
SMART BUTTON MULTI
100% Acrylic Handtufted.
Dimensiuni - Preț
110cm x 170cm - 249.00 €
150cm x 220cm - 419.00 €
PUNK 4070/68-20%
PUNK 4070/68
100% Handtufed Acrylic Espirelle
Dimensiuni - Preț
140cm x 200cm - 199.00 €
VINTAGE 1602 WHITE
VINTAGE 1602 WHITE
100% Heatset
Dimensiuni - Preț
80cm x 150cm - 69.00 €
120cm x 170cm - 105.00 €
160cm x 230cm - 175.00 € 140.00 €
200cm x 290cm - 259.00 €

ro-RO

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