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`=71
 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 `jos_{vm}_product_category_xref`.`product_list` ASC

COSY GLAMOUR ESP-0400-60-R
COSY GLAMOUR ESP-0400-60-R
100% Heatset Frise.
Dimensions - PRICE
Ø200cm (Round) - 219.00 €
RAINBOW KELIM ESP-7708-11
RAINBOW KELIM ESP-7708-11
100% Cotton, Handwoven
Dimensions - PRICE
160cm x 230cm - 399.00 €
LOFT ESP-4223-42
LOFT ESP-4223-42
100% Polyester Microfibre Handufted
Dimensions - PRICE
120cm x 170cm - 229.00 €
130cm x 190cm - 269.00 €
160cm x 230cm - 399.00 €
200cm x 200cm - 439.00 €
200cm x 290cm - 639.00 €
NEW GLAMOUR ESP-3303-17
NEW GLAMOUR ESP-3303-17
100% Artsilk Handtufted.
Dimensions - PRICE
170cm x 240cm - 495.00 €
200cm x 200cm - 495.00 €
200cm x 300cm - 749.00 €
LIGHT MELLOW ACC-004-10
LIGHT MELLOW ACC-004-10
100% Pure Wool Handwoven
Dimensions - PRICE
130cm x 190cm - 279.00 €
160cm x 230cm - 399.00 €
200cm x 290cm - 639.00 €
NATHAM KELIM ESP-6012-02
NATHAM KELIM ESP-6012-02
100% Wool Handwoven
Dimensions - PRICE
130cm x 190cm - 299.00 €
160cm x 230cm - 449.00 €
GOBI ESP-7112-01
GOBI ESP-7112-01
Wool & Jute, Handwoven.
Dimensions - PRICE
160cm x 230cm - 379.00 €
YAGOUR WH-5966-095
YAGOUR WH-5966-095
100% Polyester Shaggy
Dimensions - PRICE
120cm x 170cm - 149.00 €
160cm x 225cm - 269.00 €
200cm x 200cm - 299.00 €
200cm x 290cm - 429.00 €
LOTTE KELIM ESP-6021-02
LOTTE KELIM ESP-6021-02
100% Wool Handwoven
Dimensions - PRICE
130cm x 190cm - 349.00 €
160cm x 230cm - 499.00 €
SNAKE WH-0722-04
SNAKE WH-0722-04
100% Polyester Microfibre.
Dimensions - PRICE
120cm x 170cm - 169.00 €
133cm x 200cm - 219.00 €
160cm x 225cm - 299.00 €
PHYSICAL WH-0878-04
PHYSICAL WH-0878-04
100% Polyester Microfiber
Dimensions - PRICE
120cm x 170cm - 169.00 €
133cm x 200cm - 219.00 €
160cm x 225cm - 299.00 €
KAYLA KELIM ESP-6116-02
KAYLA KELIM ESP-6116-02
100% Wool Handwoven
Dimensions - PRICE
160cm x 230cm - 499.00 €
DREAMING ESP-3247-720
DREAMING ESP-3247-720
100% Acrylic, Machine Woven
Dimensions - PRICE
120cm x 170cm - 109.00 €
133cm x 200cm - 149.00 €
160cm x 225cm - 199.00 €
BAROQUE VINTAGE WH-17305-096
BAROQUE VINTAGE WH-17305-096
100% Polyester Microfiber
Dimensions - PRICE
120cm x 170cm - 199.00 €
133cm x 200cm - 249.00 €
160cm x 225cm - 339.00 €
200cm x 290cm - 549.00 €
240cm x 290cm - 749.00 €
RELAXX ESP-4150-06
RELAXX ESP-4150-06
Acrylic Microfiber, Machine Tufted
Dimensions - PRICE
120cm x 170cm - 169.00 €
130cm x 190cm - 199.00 €
160cm x 230cm - 299.00 €
200cm x 290cm - 479.00 €
RABAN ESP-4183-01
RABAN ESP-4183-01
100% Wool Handtufted
Dimensions - PRICE
120cm x 180cm - 499.00 €
140cm x 200cm - 669.00 €
170cm x 240cm - 969.00 €
RELAXX ESP-4150-24
RELAXX ESP-4150-24
Acrylic Microfiber, Machine Tufted
Dimensions - PRICE
120cm x 170cm - 169.00 €
130cm x 190cm - 199.00 €
160cm x 230cm - 299.00 €
200cm x 290cm - 479.00 €
LOFT ESP-4223-23
LOFT ESP-4223-23
100% Polyester Microfibre Handufted
Dimensions - PRICE
120cm x 170cm - 229.00 €
130cm x 190cm - 269.00 €
160cm x 230cm - 399.00 €
200cm x 200cm - 439.00 €
200cm x 290cm - 639.00 €
NEW GLAMOUR ESP-3303-04
NEW GLAMOUR ESP-3303-04
100% Artsilk Handtufted.
Dimensions - PRICE
120cm x 180cm - 275.00 €
PASTELLA ACC-001-10
PASTELLA ACC-001-10
100% Pure Wool Handwoven
Dimensions - PRICE
130cm x 190cm - 279.00 €
160cm x 230cm - 399.00 €
200cm x 290cm - 639.00 €
AARON KELIM ESP-6010-02
AARON KELIM ESP-6010-02
100% Wool Handwoven
Dimensions - PRICE
130cm x 190cm - 269.00 €
160cm x 230cm - 399.00 €
PETALS ESP-4018-02
PETALS ESP-4018-02
100% Acrylic Handtufted.
Dimensions - PRICE
140cm x 200cm - 439.00 €
170cm x 240cm - 639.00 €
AFELLA WH-5965-095
AFELLA WH-5965-095
100% Polyester Shaggy
Dimensions - PRICE
120cm x 170cm - 149.00 €
133cm x 200cm - 199.00 €
160cm x 225cm - 269.00 €
200cm x 200cm - 299.00 €
200cm x 290cm - 429.00 €
MAYA KELIM ESP-6019-06
MAYA KELIM ESP-6019-06
Chenille Cotton Handwoven
Dimensions - PRICE
130cm x 190cm - 269.00 €
160cm x 230cm - 399.00 €
CROCO WH-0721-01
CROCO WH-0721-01
100% Polyester Microfibre.
Dimensions - PRICE
120cm x 170cm - 169.00 €
133cm x 200cm - 219.00 €
160cm x 225cm - 299.00 €
PHYSICAL WH-0873-04
PHYSICAL WH-0873-04
100% Polyester Microfiber
Dimensions - PRICE
120cm x 170cm - 169.00 €
133cm x 200cm - 219.00 €
160cm x 225cm - 299.00 €
CROCHET STYLE ESP-6115-08
CROCHET STYLE ESP-6115-08
100% Cotton Handwoven
Dimensions - PRICE
Ø120cm (Round) - 129.00 €
RELIEF ESP-3243-952
RELIEF ESP-3243-952
Arcylic, Machine Woven
Dimensions - PRICE
120cm x 170cm - 149.00 €
133cm x 200cm - 199.00 €
200cm x 290cm - 429.00 €
BEL ETAGE WH-17304-080
BEL ETAGE WH-17304-080
100% Polyester Microfiber
Dimensions - PRICE
120cm x 170cm - 199.00 €
133cm x 200cm - 249.00 €
160cm x 225cm - 339.00 €
200cm x 290cm - 549.00 €
240cm x 290cm - 749.00 €
RELAXX ESP-4150-02
RELAXX ESP-4150-02
Acrylic Microfiber, Machine Tufted
Dimensions - PRICE
120cm x 170cm - 169.00 €
130cm x 190cm - 199.00 €
160cm x 230cm - 299.00 €
200cm x 290cm - 479.00 €
ARAMIS ESP-4182-01
ARAMIS ESP-4182-01
100% Wool Handtufted
Dimensions - PRICE
120cm x 180cm - 499.00 €
140cm x 200cm - 669.00 €
170cm x 240cm - 969.00 €
RELAXX ESP-4150-21
RELAXX ESP-4150-21
Acrylic Microfiber, Machine Tufted
Dimensions - PRICE
120cm x 170cm - 169.00 €
130cm x 190cm - 199.00 €
160cm x 230cm - 299.00 €
200cm x 290cm - 479.00 €
LOFT ESP-4223-20
LOFT ESP-4223-20
100% Polyester Microfibre Handufted
Dimensions - PRICE
120cm x 170cm - 229.00 €
130cm x 190cm - 269.00 €
160cm x 230cm - 399.00 €
200cm x 200cm - 439.00 €
200cm x 290cm - 639.00 €
NEW GLAMOUR ESP-3303-13
NEW GLAMOUR ESP-3303-13
100% Artsilk Handtufted.
Dimensions - PRICE
120cm x 180cm - 275.00 €
140cm x 200cm - 345.00 €
170cm x 240cm - 495.00 €
200cm x 200cm - 495.00 €
200cm x 300cm - 749.00 €
RAINBOW KELIM ESP-7708-07
RAINBOW KELIM ESP-7708-07
100% Cotton, Handwoven
Dimensions - PRICE
160cm x 230cm - 399.00 €
LOFT ESP-4223-38
LOFT ESP-4223-38
100% Polyester Microfibre Handufted
Dimensions - PRICE
120cm x 170cm - 229.00 €
130cm x 190cm - 269.00 €
160cm x 230cm - 399.00 €
200cm x 200cm - 439.00 €
200cm x 290cm - 639.00 €
COOL GLAMOUR ESP-9001-10
COOL GLAMOUR ESP-9001-10
100% Artsilk Shaggy, Machine Tufted.
Dimensions - PRICE
120cm x 180cm - 229.00 €
140cm x 200cm - 275.00 €
170cm x 240cm - 415.00 €
200cm x 200cm - 415.00 €
200cm x 300cm - 635.00 €
PHYSICAL WH-0870-08
PHYSICAL WH-0870-08
100% Polyester Microfiber
Dimensions - PRICE
120cm x 170cm - 169.00 €
133cm x 200cm - 219.00 €
160cm x 225cm - 299.00 €
HUDSON KELIM ESP-6113-02
HUDSON KELIM ESP-6113-02
100% Wool Handwoven
Dimensions - PRICE
130cm x 190cm - 299.00 €
160cm x 230cm - 449.00 €
WOODLAND WH-2870-953
WOODLAND WH-2870-953
Heatset Frise,Polyester Shrink Yarn.
Dimensions - PRICE
133cm x 200cm - 199.00 €
RIAD CM-2522-760
RIAD CM-2522-760
Acrylic Heatset
Dimensions - PRICE
120cm x 170cm - 139.00 €
133cm x 200cm - 179.00 €
160cm x 225cm - 249.00 €
200cm x 290cm - 379.00 €
CHIMERA ESP-3387-953
CHIMERA ESP-3387-953
Acrylic, Machine Woven
Dimensions - PRICE
120cm x 170cm - 149.00 €
133cm x 200cm - 199.00 €
160cm x 225cm - 269.00 €
200cm x 290cm - 429.00 €
PAST FUTURE WH-12268-01
PAST FUTURE WH-12268-01
100% Chenille
Dimensions - PRICE
120cm x 170cm - 139.00 €
133cm x 190cm - 169.00 €
160cm x 230cm - 249.00 €
RELAXX ESP-4150-17
RELAXX ESP-4150-17
Acrylic Microfiber, Machine Tufted
Dimensions - PRICE
120cm x 170cm - 169.00 €
130cm x 190cm - 199.00 €
200cm x 290cm - 479.00 €
LOFT ESP-4223-17
LOFT ESP-4223-17
100% Polyester Microfibre Handufted
Dimensions - PRICE
120cm x 170cm - 229.00 €
130cm x 190cm - 269.00 €
160cm x 230cm - 399.00 €
200cm x 200cm - 439.00 €
200cm x 290cm - 639.00 €
NEW GLAMOUR ESP-3303-14
NEW GLAMOUR ESP-3303-14
100% Artsilk Handtufted.
Dimensions - PRICE
120cm x 180cm - 275.00 €
140cm x 200cm - 345.00 €
170cm x 240cm - 495.00 €
200cm x 200cm - 495.00 €
200cm x 300cm - 749.00 €
RAINBOW KELIM ESP-7708-03
RAINBOW KELIM ESP-7708-03
100% Cotton, Handwoven
Dimensions - PRICE
130cm x 190cm - 289.00 €
160cm x 230cm - 399.00 €
LOFT ESP-4223-35
LOFT ESP-4223-35
100% Polyester Microfibre Handufted
Dimensions - PRICE
120cm x 170cm - 229.00 €
130cm x 190cm - 269.00 €
160cm x 230cm - 399.00 €
200cm x 200cm - 439.00 €
200cm x 290cm - 639.00 €

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