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) 
 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 RAND() ASC

COTTON BABY 018012-15%
COTTON BABY 018012
100% Cotton
Dimensions - PRICE
120cm x 160cm - 197.00 € 167.45 €
COTTON BABY 016001-15%
COTTON BABY 016001
100% Cotton
Dimensions - PRICE
90cm x 200cm - 197.00 € 167.45 €
SAINT CLAIR TOY PINK
SAINT CLAIR TOY PINK
Acrylic,PP Machine Made.
Dimensions - PRICE
115cm x 175cm - 115.00 €
150cm x 200cm - 169.00 €
FLORIDA 5519 TOWN
FLORIDA 5519 TOWN
100% Heatset Frize
Dimensions - PRICE
80cm x 150cm - 39.00 €
133cm x 190cm - 75.00 €
160cm x 230cm - 109.00 €
200cm x 290cm - 169.00 €
MAUI 3363-01 800 MULTI
MAUI 3363-01 800 MULTI
100% Acrylic,Handtufted.
Dimensions - PRICE
100cm x 160cm - 225.00 €
DIAMOND 21110-061
DIAMOND 21110-061
100% Acrylic Frize.
Dimensions - PRICE
133cm x 190cm - 130.00 €
160cm x 230cm - 185.00 €
STARS BLUE
STARS BLUE
100% Heatset
Dimensions - PRICE
80cm x 150cm - 55.00 €
100cm x 180cm - 74.00 €
134cm x 190cm - 99.00 €
160cm x 230cm - 135.00 €
BOOGIE STRIPIE WOOGIE MARINE-60%
BOOGIE STRIPIE WOOGIE MARINE
100% Pure New Wool, Handtufted.
Dimensions - PRICE
90cm x 140cm - 330.00 € 132.00 €
SUNSET BLINK
SUNSET BLINK
100% Heatset, Hand Carved.
Dimensions - PRICE
120cm x 170cm - 175.00 €
160cm x 220cm - 235.00 €
FOLLIE SHAGGY 300 GREEN
FOLLIE SHAGGY 300 GREEN
100% Artsilk Shaggy
Dimensions - PRICE
120cm x 180cm - 119.00 €
140cm x 200cm - 149.00 €
160cm x 230cm - 195.00 €
Ø200cm (Round) - 210.00 €
200cm x 250cm - 259.00 €
200cm x 300cm - 305.00 €
Ø250cm (Round) - 315.00 €
250cm x 300cm - 385.00 €
250cm x 350cm - 449.00 €
300cm x 400cm - 619.00 €
SMALL LUCKY ZOO BEIGE
SMALL LUCKY ZOO BEIGE
100% Acrylic Handtufted.
Dimensions - PRICE
70cm x 140cm - 165.00 €
90cm x 160cm - 215.00 €
120cm x 180cm - 295.00 €
SOFT UNI 713 DENIM
SOFT UNI 713 DENIM
100% Artsilk Shaggy Handtufted.
Dimensions - PRICE
160cm x 230cm - 390.00 €
CAROUSEL 32356-6264-10%
CAROUSEL 32356-6264
100% Acrylic
Dimensions - PRICE
133cm x 195cm - 135.00 € 121.50 €
160cm x 230cm - 184.00 € 165.60 €
TEDDY BEAR BEIGE ROUND
TEDDY BEAR BEIGE ROUND
100% Cotton, Machinewoven.
Dimensions - PRICE
Ø100cm (Round) - 119.00 €
WAIKIKI WAI 382 MULTI
WAIKIKI WAI 382 MULTI
100% Acrylic Frise
Dimensions - PRICE
200cm x 290cm - 245.00 €
CAMER STAR PINK
CAMER STAR PINK
100% Modacrylic, Handtufted.
Dimensions - PRICE
120cm x 170cm - 329.00 €
TEDDY BEAR BEIGE
TEDDY BEAR BEIGE
100% Cotton, Machinewoven.
Dimensions - PRICE
100cm x 150cm - 155.00 €
120cm x 170cm - 195.00 €
JUST HEARTS PINK
JUST HEARTS PINK
100% Polyester Microfibre.
Dimensions - PRICE
120cm x 170cm - 209.00 €
BIRDIE BEIGE
BIRDIE BEIGE
100% Acrylic Handtufted.
Dimensions - PRICE
70cm x 140cm - 189.00 €
90cm x 160cm - 259.00 €
120cm x 180cm - 379.00 €
140cm x 200cm - 479.00 €
SAINT CLAIR TEDDY PINK
SAINT CLAIR TEDDY PINK
Acrylic,PP Machine Made.
Dimensions - PRICE
115cm x 175cm - 115.00 €
150cm x 200cm - 169.00 €
ESTIA 7437 MULTI
ESTIA 7437 MULTI
100% Acrylic Heatset
Dimensions - PRICE
133cm x 190cm - 69.00 €
COTTON BABY 028003-15%
COTTON BABY 028003
100% Cotton
Dimensions - PRICE
120cm x 160cm - 197.00 € 167.45 €
MAMBA TBD 496-230 ROSE
MAMBA TBD 496-230 ROSE
100% Acrylic Machine Woven
Dimensions - PRICE
120cm x 180cm - 165.00 €
140cm x 200cm - 215.00 €
DIAMOND 21900-050
DIAMOND 21900-050
100% Acrylic Frise
Dimensions - PRICE
133cm x 190cm - 115.00 € 92.00 €
160cm x 230cm - 165.00 € 132.00 €
GRAFFITI 043
GRAFFITI 043
100% Synthetic
Dimensions - PRICE
133cm x 190cm - 88.00 €
160cm x 230cm - 115.00 €
CANDY CC10 ROCKET
CANDY CC10 ROCKET
100% Cotton, Handtufted.
Dimensions - PRICE
100cm x 150cm - 150.00 €
120cm x 170cm - 199.00 €
DISNEY 10905
DISNEY 10905
100% Heatset Printed.
Dimensions - PRICE
120cm x 160cm - 95.00 €
133cm x 190cm - 135.00 €
160cm x 240cm - 165.00 €
COTTON BABY 016022-15%
COTTON BABY 016022
100% Cotton
Dimensions - PRICE
90cm x 200cm - 197.00 € 167.45 €
KALEIDO CURVES POP
KALEIDO CURVES POP
Handtufted 100% Pure New Wool.
Dimensions - PRICE
140cm x 200cm - 645.00 €
170cm x 240cm - 930.00 €
200cm x 280cm - 1,270.00 €
DAISY 6010 LIME
DAISY 6010 LIME
100% Artsilk Handtufted.
Dimensions - PRICE
Ø90cm (Round) - 139.00 € 111.20 €
GUAYA BRICKS MULTI
GUAYA BRICKS MULTI
100% Heatset Frise
Dimensions - PRICE
120cm x 170cm - 199.00 €
160cm x 230cm - 334.00 €
TEDDY BEAR BLUE ROUND
TEDDY BEAR BLUE ROUND
100% Cotton, Machinewoven.
Dimensions - PRICE
Ø100cm (Round) - 119.00 €
FLASH 2002-25%
FLASH 2002
100% Acrylic Frize
Dimensions - PRICE
133cm x 190cm - 112.00 €
160cm x 230cm - 155.00 €
RAINBOW 2000 ORANGE
RAINBOW 2000 ORANGE
100% Acrylic Shaggy
Dimensions - PRICE
80cm x 150cm - 95.00 €
120cm x 170cm - 135.00 €
160cm x 230cm - 220.00 €
200cm x 290cm - 319.00 €
PARTY COLLECTION HAPPY STARS
PARTY COLLECTION HAPPY STARS
100% Acrylic Frise.
Dimensions - PRICE
80cm x 150cm - 36.00 €
133cm x 190cm - 79.00 €
160cm x 230cm - 115.00 €
PRINCESS DISNEY 10130
PRINCESS DISNEY 10130
100% Heatset Printed.
Dimensions - PRICE
133cm x 190cm - 135.00 €
160cm x 230cm - 170.00 €
PRINCESS RAPUNZEL DISNEY 10112
PRINCESS RAPUNZEL DISNEY 10112
100% Heatset Printed.
Dimensions - PRICE
133cm x 190cm - 135.00 €
160cm x 230cm - 170.00 €
FRESH 76801
FRESH 76801
Handtufted 100% Acrylic
Dimensions - PRICE
70cm x 140cm - 190.00 €
120cm x 180cm - 320.00 €
140cm x 200cm - 470.00 €
170cm x 240cm - 665.00 €
200cm x 300cm - 970.00 €
XIAN ELEMENTS 77000
XIAN ELEMENTS 77000
Handtufted 100% Acrylic
Dimensions - PRICE
170cm x 240cm - 674.00 €
200cm x 300cm - 989.00 €
CONNY GREY
CONNY GREY
100% Acrylic Handtufted.
Dimensions - PRICE
110cm x 170cm - 269.00 €
130cm x 190cm - 339.00 €
BOOGIE STRIPIE WOOGIE SORBET-60%
BOOGIE STRIPIE WOOGIE SORBET
100% Pure New Wool, Handtufted.
Dimensions - PRICE
90cm x 140cm - 330.00 € 132.00 €
BAMBINO 2105 PURPLE
BAMBINO 2105 PURPLE
100% Heatset
Dimensions - PRICE
80cm x 150cm - 79.00 €
120cm x 170cm - 105.00 €
160cm x 230cm - 164.00 € 131.20 €
ROYAL KIDS 8E15A M
ROYAL KIDS 8E15A M
100% Heatset Frize
Dimensions - PRICE
80cm x 150cm - 53.00 €
CANDY CC09 BUTTERFLY
CANDY CC09 BUTTERFLY
100% Cotton, Handtufted.
Dimensions - PRICE
100cm x 150cm - 150.00 €
120cm x 170cm - 199.00 €
FOXY AQUA
FOXY AQUA
Handtufted 100% Pure New Wool
Dimensions - PRICE
90cm x 150cm - 300.00 €
120cm x 180cm - 485.00 €
140cm x 200cm - 699.00 €
DISNEY 10906
DISNEY 10906
100% Heatset Printed.
Dimensions - PRICE
120cm x 160cm - 95.00 €
133cm x 190cm - 135.00 €
SEMMEL BUNNY GREEN
SEMMEL BUNNY GREEN
100% Heatset Frise
Dimensions - PRICE
133cm x 200cm - 179.00 €
PLAY ALL STARS BLUE
PLAY ALL STARS BLUE
100% Acrylic.
Dimensions - PRICE
100cm x 150cm - 112.00 €
120cm x 170cm - 135.00 €

en-GB

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