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

MAUI MH-3477-02 720 TURQUOISE
MAUI MH-3477-02 720 TURQUOISE
100% Acrylic Handtufted
Dimensions - PRICE
100cm x 160cm - 225.00 €
120cm x 180cm - 279.00 €
ACAPULCO KIDS ACK 141 MULTI
ACAPULCO KIDS ACK 141 MULTI
100% Acrylic Frise,Handcarved.
Dimensions - PRICE
120cm x 170cm - 115.00 €
160cm x 230cm - 170.00 €
HAPPINESS EMOTION HA012 598 MULTI
HAPPINESS EMOTION HA012 598 MULTI
100% Acrylic Frise.
Dimensions - PRICE
120cm x 170cm - 159.00 €
140cm x 200cm - 195.00 €
160cm x 230cm - 244.00 €
COTTON BABY 025011-15%
COTTON BABY 025011
100% Cotton
Dimensions - PRICE
120cm x 160cm - 197.00 € 167.45 €
SYDNEY 800 1301-020 703 BLUE
SYDNEY 800 1301-020 703 BLUE
100% Acrylic Machine Printed
Dimensions - PRICE
120cm x 180cm - 215.00 €
165cm x 230cm - 274.00 €
ESTIA 7614 MULTI
ESTIA 7614 MULTI
100% Acrylic Heatset
Dimensions - PRICE
160cm x 230cm - 89.00 €
200cm x 290cm - 139.00 €
HAPPINESS PARDIS HA027 598 MULTI
HAPPINESS PARDIS HA027 598 MULTI
100% Acrylic Frise.
Dimensions - PRICE
140cm x 200cm - 195.00 €
200cm x 290cm - 349.00 €
240cm x 290cm - 415.00 €
240cm x 340cm - 475.00 €
COTTON BABY 018008-15%
COTTON BABY 018008
100% Cotton
Dimensions - PRICE
120cm x 160cm - 197.00 € 167.45 €
PRINCESS DISNEY 10130
PRINCESS DISNEY 10130
100% Heatset Printed.
Dimensions - PRICE
133cm x 190cm - 135.00 €
160cm x 230cm - 170.00 €
COTTON BABY 012003-15%
COTTON BABY 012003
100% Cotton
Dimensions - PRICE
120cm x 160cm - 197.00 € 167.45 €
HAPPY SHAGGY 531-750  PURPLE
HAPPY SHAGGY 531-750 PURPLE
100% Acrylic Machine Woven
Dimensions - PRICE
133cm x 190cm - 189.00 €
DISNEY 10115
DISNEY 10115
100% Heatset Printed.
Dimensions - PRICE
133cm x 190cm - 135.00 €
AUSSIE BEN DINOS
AUSSIE BEN DINOS
100% Heatset Frise
Dimensions - PRICE
120cm x 170cm - 165.00 €
160cm x 230cm - 255.00 €
RAINBOW RABBIT PURPLE
RAINBOW RABBIT PURPLE
100% Heatset Frise
Dimensions - PRICE
120cm x 170cm - 155.00 €
200cm x 290cm - 349.00 €
MINNIE DISNEY MK 10024
MINNIE DISNEY MK 10024
100% Heatset Printed.
Dimensions - PRICE
133cm x 190cm - 135.00 €
160cm x 230cm - 170.00 €
PIRATES KIDS BLUE
PIRATES KIDS BLUE
100% Acrylic Handtufted.
Dimensions - PRICE
110cm x 170cm - 269.00 €
130cm x 190cm - 339.00 €
BAMBINO 2102 PINK
BAMBINO 2102 PINK
100% Heatset
Dimensions - PRICE
120cm x 170cm - 105.00 €
160cm x 230cm - 164.00 €
CONFETTI 72501
CONFETTI 72501
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 €
JUPITER 21294-090
JUPITER 21294-090
100% Acrylic.
Dimensions - PRICE
133cm x 190cm - 115.00 €
160cm x 230cm - 165.00 €
ACAPULCO KIDS ACK 140 MULTI
ACAPULCO KIDS ACK 140 MULTI
100% Acrylic Frise,Handcarved.
Dimensions - PRICE
120cm x 170cm - 115.00 €
160cm x 230cm - 170.00 €
HAPPINESS NEW BRUSH HA026 598 MULTI
HAPPINESS NEW BRUSH HA026 598 MULTI
100% Acrylic Frise.
Dimensions - PRICE
120cm x 170cm - 159.00 €
140cm x 200cm - 195.00 €
160cm x 230cm - 244.00 €
ROYAL KIDS 8E15A M
ROYAL KIDS 8E15A M
100% Heatset Frize
Dimensions - PRICE
80cm x 150cm - 53.00 €
DORA 4565-4-50%
DORA 4565-4
100% Acrylic
Dimensions - PRICE
170cm x 240cm - 250.00 € 125.00 €
BAMBINO 2101 LIGHT PINK
BAMBINO 2101 LIGHT PINK
100% Heatset
Dimensions - PRICE
80cm x 150cm - 79.00 €
120cm x 170cm - 105.00 €
160cm x 230cm - 164.00 € 131.20 €
BAMBINO 2103 YELLOW
BAMBINO 2103 YELLOW
100% Heatset
Dimensions - PRICE
80cm x 150cm - 79.00 €
120cm x 170cm - 105.00 €
160cm x 230cm - 164.00 €
FLORIDA 2205 FLOWERS
FLORIDA 2205 FLOWERS
100% Heatset
Dimensions - PRICE
133cm x 190cm - 91.00 €
160cm x 230cm - 123.00 €
NEW KIDS HAPPY OWLS-10%
NEW KIDS HAPPY OWLS
100% Acrylic Frise.
Dimensions - PRICE
67cm x 140cm - 60.00 €
80cm x 150cm - 70.00 €
160cm x 230cm - 180.00 €
200cm x 290cm - 273.00 €
CANDY CC09 BUTTERFLY
CANDY CC09 BUTTERFLY
100% Cotton, Handtufted.
Dimensions - PRICE
100cm x 150cm - 150.00 €
120cm x 170cm - 199.00 €
NEWBORN BEIGE
NEWBORN BEIGE
100% Acrylic Handtufted.
Dimensions - PRICE
110cm x 170cm - 269.00 €
150cm x 220cm - 439.00 €
DIAMOND 20740-075
DIAMOND 20740-075
100% Acrylic Frise.
Dimensions - PRICE
133cm x 190cm - 110.00 €
160cm x 230cm - 165.00 €
TEDDY BEAR BLUE
TEDDY BEAR BLUE
100% Cotton, Machinewoven.
Dimensions - PRICE
100cm x 150cm - 155.00 €
120cm x 170cm - 195.00 €
KIDDO 1588
KIDDO 1588
100% HeatSet
Dimensions - PRICE
JUPITER 21291-090
JUPITER 21291-090
100% Acrylic.
Dimensions - PRICE
133cm x 190cm - 155.00 €
160cm x 230cm - 165.00 €
DIAMOND 11560-030
DIAMOND 11560-030
100% Acrylic Frise.
Dimensions - PRICE
133cm x 190cm - 130.00 €
160cm x 230cm - 185.00 €
DORA 4566-9-50%
DORA 4566-9
100% Acrylic
Dimensions - PRICE
170cm x 240cm - 250.00 € 125.00 €
FLORIDA 3153 CAR
FLORIDA 3153 CAR
100% Heatset Frize
Dimensions - PRICE
80cm x 150cm - 39.00 €
133cm x 190cm - 75.00 €
160cm x 230cm - 109.00 €
GROOVE LINES LAGOO
GROOVE LINES LAGOO
Handtufted 100% Pure New Wool.
Dimensions - PRICE
140cm x 200cm - 645.00 €
170cm x 240cm - 930.00 €
200cm x 280cm - 1,270.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 €
COTTON BABY 010009-15%
COTTON BABY 010009
100% Cotton
Dimensions - PRICE
120cm x 160cm - 197.00 € 167.45 €
NEW KIDS SAVANA ANIMALS-10%
NEW KIDS SAVANA ANIMALS
100% Acrylic Frise.
Dimensions - PRICE
67cm x 140cm - 60.00 €
80cm x 150cm - 70.00 €
133cm x 190cm - 126.00 €
160cm x 230cm - 180.00 €
COTTON BABY 025001-15%
COTTON BABY 025001
100% Cotton
Dimensions - PRICE
120cm x 160cm - 197.00 € 167.45 €
COTTON BABY 016022-15%
COTTON BABY 016022
100% Cotton
Dimensions - PRICE
90cm x 200cm - 197.00 € 167.45 €
KASMIR MODERN CITY 2059
KASMIR MODERN CITY 2059
100% Acrylic.
Dimensions - PRICE
160cm x 230cm - 237.00 €
COTTON BABY 029006-15%
COTTON BABY 029006
100% Cotton
Dimensions - PRICE
120cm x 160cm - 197.00 € 167.45 €
CANDY CC07 FLOWER
CANDY CC07 FLOWER
100% Cotton, Handtufted.
Dimensions - PRICE
100cm x 150cm - 150.00 €
120cm x 170cm - 199.00 €
DIAMOND 21131-110
DIAMOND 21131-110
100% Acrylic Frise.
Dimensions - PRICE
133cm x 190cm - 110.00 €
160cm x 230cm - 165.00 €
200cm x 250cm - 210.00 €
BEN10 10076
BEN10 10076
100% Acrylic, Handtufted
Dimensions - PRICE
140cm x 200cm - 135.00 €
160cm x 230cm - 165.00 €
SAINT CLAIR RACE
SAINT CLAIR RACE
Acrylic,PP Machine Made.
Dimensions - PRICE
115cm x 175cm - 115.00 €
150cm x 200cm - 169.00 €

en-GB

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