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`=34
 AND  `jos_vm_product`.`product_id` NOT IN (7712) 
 AND  `jos_vm_product`.`product_id` NOT IN (7712) 
 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

MARRAKESH BLACK BORDER
MARRAKESH BLACK BORDER
100% Acrylic Heatset
Размери - Цена
120cm x 170cm - 99.00 €
160cm x 230cm - 169.00 €
200cm x 290cm - 255.00 €
240cm x 340cm - 365.00 €
300cm x 400cm - 479.00 €
MARRAKESH GREY
MARRAKESH GREY
100% Acrylic Heatset
Размери - Цена
200cm x 290cm - 255.00 €
240cm x 340cm - 365.00 €
MARRAKESH RED BORDER
MARRAKESH RED BORDER
100% Acrylic Heatset
Размери - Цена
120cm x 170cm - 99.00 €
160cm x 230cm - 169.00 €
200cm x 290cm - 255.00 €
240cm x 340cm - 365.00 €
300cm x 400cm - 479.00 €
NESCA FLORAL BEIGE
NESCA FLORAL BEIGE
100% Acrylic
Размери - Цена
120cm x 180cm - 245.00 €
160cm x 230cm - 399.00 €
200cm x 290cm - 625.00 €
MARRAKESH GREY BORDER
MARRAKESH GREY BORDER
100% Acrylic Heatset
Размери - Цена
120cm x 170cm - 99.00 €
300cm x 400cm - 479.00 €
HALI BEIGE RED
HALI BEIGE RED
100% Heatset.
Размери - Цена
170cm x 230cm - 269.00 €
KLASSIK 315A CHERRY
KLASSIK 315A CHERRY
100% Acrylic Heatset.
Размери - Цена
80cm x 150cm - 34.00 €
133cm x 190cm - 72.00 €
160cm x 230cm - 105.00 €
200cm x 290cm - 165.00 €
Bedroom Set - 92.00 €
OLYMPIA 6045A RED
OLYMPIA 6045A RED
100% Acrylic.
Размери - Цена
140cm x 200cm - 76.00 €
160cm x 230cm - 99.00 €
200cm x 250cm - 135.00 €
200cm x 300cm - 161.00 €
спален комплект - 94.00 €
ALPINA 5230 PINK
ALPINA 5230 PINK
100% Acrylic Polyester
Размери - Цена
120cm x 170cm - 155.00 €
160cm x 230cm - 269.00 €
200cm x 290cm - 409.00 €
GRAVITY 153 IVORY-40%
GRAVITY 153 IVORY
100% Polyester, Powerloomed
Размери - Цена
120cm x 156cm - 131.25 € 78.75 €
160cm x 235cm - 263.75 € 158.25 €
200cm x 285cm - 400.00 € 240.00 €
KLASSIK 1019A CHERRY
KLASSIK 1019A CHERRY
100% Acrylic Heatset.
Размери - Цена
80cm x 150cm - 34.00 €
133cm x 190cm - 72.00 €
160cm x 230cm - 105.00 €
200cm x 290cm - 165.00 €
Bedroom Set - 92.00 €
VINTAGE 23014-953
VINTAGE 23014-953
Acrylic Heatset,Polyester.
Размери - Цена
166cm x 236cm - 210.00 €
Bedroom Set - 190.00 €
KLASSIK 2288A CHERRY
KLASSIK 2288A CHERRY
100% Acrylic Heatset.
Размери - Цена
133cm x 190cm - 72.00 €
160cm x 230cm - 105.00 €
200cm x 290cm - 165.00 €
ELITE 16959-675
ELITE 16959-675
Acrylic, Polyester.
Размери - Цена
160cm x 230cm - 210.00 €
200cm x 290cm - 325.00 €
ELITE 16955-095
ELITE 16955-095
Acrylic, Polyester.
Размери - Цена
160cm x 230cm - 210.00 €
ELITE 16954-953
ELITE 16954-953
Acrylic, Polyester.
Размери - Цена
160cm x 230cm - 210.00 €
Bedroom set - 200.00 €
ASSOS 17515-095
ASSOS 17515-095
Acrylic, Polyester.
Размери - Цена
160cm x 230cm - 210.00 €
200cm x 250cm - 280.00 €
200cm x 290cm - 325.00 €
ASSOS 17180-095
ASSOS 17180-095
Acrylic, Polyester.
Размери - Цена
133cm x 190cm - 145.00 €
160cm x 230cm - 210.00 €
200cm x 250cm - 280.00 €
200cm x 290cm - 325.00 €
ASSOS 17222-095
ASSOS 17222-095
Acrylic, Polyester.
Размери - Цена
160cm x 230cm - 210.00 €
200cm x 250cm - 280.00 €
200cm x 290cm - 325.00 €
ASSOS 17194-095
ASSOS 17194-095
Acrylic, Polyester.
Размери - Цена
160cm x 230cm - 210.00 €
200cm x 290cm - 325.00 €
ALPINA 5230 TURQUOISE
ALPINA 5230 TURQUOISE
100% Acrylic Polyester
Размери - Цена
120cm x 170cm - 155.00 €
160cm x 230cm - 269.00 €
200cm x 290cm - 409.00 €
OUSHAK 555 LIGHT BLUE
OUSHAK 555 LIGHT BLUE
100% Acrylic Heatset,Powerloomed
Размери - Цена
120cm x 170cm - 86.00 €
160cm x 230cm - 155.00 €
200cm x 250cm - 210.00 €
200cm x 300cm - 250.00 €
240cm x 300cm - 300.00 €
VINTAGE 23024-956
VINTAGE 23024-956
Acrylic Heatset,Polyester.
Размери - Цена
166cm x 236cm - 265.00 €
200cm x 290cm - 310.00 €
Bedroom Set - 190.00 €
ELITE 16969-095
ELITE 16969-095
Acrylic, Polyester.
Размери - Цена
160cm x 230cm - 210.00 €
VENUS 17521-695-25%
VENUS 17521-695
100% Acrylic.
Размери - Цена
160cm x 230cm - 265.00 € 198.75 €
200cm x 290cm - 415.00 € 311.25 €
VENUS 17520-695-25%
VENUS 17520-695
100% Acrylic.
Размери - Цена
200cm x 290cm - 415.00 € 311.25 €
OLYMPOS 15893-670
OLYMPOS 15893-670
Acrylic, Polyester.
Размери - Цена
160cm x 230cm - 185.00 €
200cm x 290cm - 290.00 €
OLYMPOS 15891-630
OLYMPOS 15891-630
Acrylic, Polyester.
Размери - Цена
160cm x 230cm - 185.00 €
200cm x 290cm - 290.00 €
OLYMPOS 15891-620
OLYMPOS 15891-620
Acrylic, Polyester.
Размери - Цена
160cm x 230cm - 185.00 €
200cm x 290cm - 290.00 €
Bedroom Set - 200.00 €
OLYMPOS 15890-670
OLYMPOS 15890-670
Acrylic, Polyester.
Размери - Цена
160cm x 230cm - 185.00 €
200cm x 290cm - 290.00 €
OLYMPOS 15889-761
OLYMPOS 15889-761
Acrylic, Polyester.
Размери - Цена
160cm x 230cm - 185.00 €
200cm x 290cm - 290.00 €
OLYMPOS 15889-010
OLYMPOS 15889-010
Acrylic, Polyester.
Размери - Цена
200cm x 290cm - 290.00 €
MOHAMADI 15404-110-20%
MOHAMADI 15404-110
100% Acrylic Heatset Frise.
Размери - Цена
200cm x 290cm - 265.00 € 212.00 €
MOHAMADI 15402-110-20%
MOHAMADI 15402-110
100% Acrylic Heatset Frise.
Размери - Цена
160cm x 230cm - 170.00 € 136.00 €
200cm x 290cm - 265.00 € 212.00 €
ZIEGLER 1629 IVORY NAVY
ZIEGLER 1629 IVORY NAVY
100% Heatset Frise.
Размери - Цена
133cm x 195cm - 105.00 €
170cm x 240cm - 175.00 €
200cm x 290cm - 239.00 €
Bedroom Set - 149.00 €
ZIEGLER 1594 RED IVORY
ZIEGLER 1594 RED IVORY
100% Heatset Frise.
Размери - Цена
133cm x 195cm - 105.00 €
170cm x 240cm - 175.00 €
200cm x 290cm - 239.00 €
ZIEGLER 1594 IVORY RED
ZIEGLER 1594 IVORY RED
100% Heatset Frise.
Размери - Цена
133cm x 195cm - 105.00 €
170cm x 240cm - 175.00 €
200cm x 290cm - 239.00 €
ZIEGLER 1594 L.BROWN IVORY
ZIEGLER 1594 L.BROWN IVORY
100% Heatset Frise.
Размери - Цена
133cm x 195cm - 105.00 €
170cm x 240cm - 175.00 €
200cm x 290cm - 239.00 €
ZIEGLER 1267 RED IVORY
ZIEGLER 1267 RED IVORY
100% Heatset Frise.
Размери - Цена
133cm x 195cm - 105.00 €
170cm x 240cm - 175.00 €
200cm x 290cm - 239.00 €
Bedroom Set - 149.00 €
ZIEGLER 1260 RED IVORY
ZIEGLER 1260 RED IVORY
100% Heatset Frise.
Размери - Цена
133cm x 195cm - 105.00 €
170cm x 240cm - 175.00 €
200cm x 290cm - 239.00 €
Bedroom Set - 149.00 €
ZIEGLER 1259 IVORY RED
ZIEGLER 1259 IVORY RED
100% Heatset Frise.
Размери - Цена
133cm x 195cm - 105.00 €
170cm x 240cm - 175.00 €
200cm x 290cm - 239.00 €
VEGAS CLASSIC 5001 CHERRY
VEGAS CLASSIC 5001 CHERRY
100% Heatset
Размери - Цена
133cm x 190cm - 70.00 €
160cm x 230cm - 105.00 €
200cm x 290cm - 169.00 €
VEGAS CLASSIC 5001 BEIGE
VEGAS CLASSIC 5001 BEIGE
100% Heatset
Размери - Цена
133cm x 190cm - 70.00 €
160cm x 230cm - 105.00 €
200cm x 290cm - 169.00 €
VEGAS CLASSIC 1266 CHERRY
VEGAS CLASSIC 1266 CHERRY
100% Heatset
Размери - Цена
133cm x 190cm - 70.00 €
160cm x 230cm - 105.00 €
200cm x 290cm - 169.00 €
VEGAS CLASSIC 1266 BEIGE
VEGAS CLASSIC 1266 BEIGE
100% Heatset
Размери - Цена
133cm x 190cm - 70.00 €
160cm x 230cm - 105.00 €
200cm x 290cm - 169.00 €
ZIEGLER 1629 RED NAVY
ZIEGLER 1629 RED NAVY
100% Heatset Frise.
Размери - Цена
133cm x 195cm - 105.00 €
170cm x 240cm - 175.00 €
200cm x 290cm - 239.00 €
Bedroom Set - 149.00 €
ZIEGLER 1631 IVORY RED
ZIEGLER 1631 IVORY RED
100% Heatset Frise.
Размери - Цена
133cm x 195cm - 105.00 €
170cm x 240cm - 175.00 €
200cm x 290cm - 239.00 €
Bedroom Set - 149.00 €
OUSHAK 555 BROWN
OUSHAK 555 BROWN
100% Acrylic Heatset,Powerloomed
Размери - Цена
160cm x 230cm - 155.00 €
200cm x 300cm - 250.00 €

Целият материал на сайта представлява интелектуална собственост xalia.com