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

LIMA 1865-180-10%
LIMA 1865-180
100% Artsilk Shaggy
Dimensions - PRICE
Set di Cameretta - 297.00 € 267.30 €
ESTIA 7449 PURPLE
ESTIA 7449 PURPLE
100% Heatset
Dimensions - PRICE
Bedroom Set - 85.00 €
ERMIS Dark Red 02-50%
ERMIS Dark Red 02
100% ArtSilk Shaggy Handtufted
Dimensions - PRICE
Bedroom Set - 423.00 € 211.50 €
ESTIA 6704 GREY RED
ESTIA 6704 GREY RED
100% Heatset.
Dimensions - PRICE
Σετ Κρεβατ/μαρας - 65.00 €
FLORIDA 9549 BROWN
FLORIDA 9549 BROWN
100% Heatset Frize
Dimensions - PRICE
Σετ Κρεβατ/μαρας - 99.00 €
VELVET 3883 GREY
VELVET 3883 GREY
100% Heatset
Dimensions - PRICE
Σετ Κρεβατ/μαρας - 155.00 €
ROYAL C97O ORANGE-60%
ROYAL C97O ORANGE
100% ArtSilk Shaggy
Dimensions - PRICE
SPECIAL 2149 BEIGE BROWN
SPECIAL 2149 BEIGE BROWN
100% Heatset
Dimensions - PRICE
Σετ Κρεβατ/μαρας - 135.00 €
ERMIS Black 07-50%
ERMIS Black 07
100% ArtSilk Shaggy Handtufted
Dimensions - PRICE
Bedroom Set - 423.00 € 211.50 €
FLORIDA 2261 BEIGE
FLORIDA 2261 BEIGE
100% Heatset Frize
Dimensions - PRICE
Σετ Κρεβατ/μαρας - 99.00 €
M.T BLACK TIE 103 TERRA-50%
M.T BLACK TIE 103 TERRA
100% New Zealand Wool, Handtufted.
Dimensions - PRICE
Bedroom Set - 484.00 € 242.00 €
BOSTON 5365A BEIGE
BOSTON 5365A BEIGE
100% Heatset, PP.
Dimensions - PRICE
Bedroom Set - 133.00 €
JULIAN 559 RED
JULIAN 559 RED
100% Heatset.
Dimensions - PRICE
Bedroom Set - 110.00 €
FLORIDA 2253 BEIGE
FLORIDA 2253 BEIGE
100% Heatset Frize
Dimensions - PRICE
Σετ Κρεβατ/μαρας - 99.00 €
MILLION 967 RED-50%
MILLION 967 RED
100% Heatset
Dimensions - PRICE
Σετ Κρεβατ/μαρας - 318.00 € 159.00 €
APOLLON 07 10F-50%
APOLLON 07 10F
100% ArtSilk Shaggy Handtufted
Dimensions - PRICE
Bedroom Set - 423.00 € 211.50 €
APOLLON 07 10C-50%
APOLLON 07 10C
100% ArtSilk Shaggy Handtufted
Dimensions - PRICE
Bedroom Set - 423.00 € 211.50 €
ZIEGLER 1600 RED
ZIEGLER 1600 RED
100% Heatset Frise.
Dimensions - PRICE
Bedroom Set - 169.00 €
VELVET 3882 L.GREY
VELVET 3882 L.GREY
100% Heatset
Dimensions - PRICE
Σετ Κρεβατ/μαρας - 155.00 €
JULIAN 5055 CREAM RED
JULIAN 5055 CREAM RED
100% Heatset.
Dimensions - PRICE
Bedroom Set - 110.00 €
ESTIA 6686 GREY
ESTIA 6686 GREY
100% Heatset.
Dimensions - PRICE
Σετ Κρεβατ/μαρας - 65.00 €
ZIEGLER 1631 IVORY NAVY
ZIEGLER 1631 IVORY NAVY
100% Heatset Frise.
Dimensions - PRICE
Σετ Κρεβατ/μαρας - 149.00 €
ZIEGLER 1260 RED IVORY
ZIEGLER 1260 RED IVORY
100% Heatset Frise.
Dimensions - PRICE
Bedroom Set - 169.00 €
ARTEMIS 5378 BEIGE
ARTEMIS 5378 BEIGE
100% Heatset
Dimensions - PRICE
Σετ Κρεβατ/μαρας - 115.00 €
SPECIAL 5878 BEIGE GREY
SPECIAL 5878 BEIGE GREY
100% Heatset
Dimensions - PRICE
Σετ Κρεβατ/μαρας - 135.00 €
SPECIAL 2149 BEIGE GREY
SPECIAL 2149 BEIGE GREY
100% Heatset
Dimensions - PRICE
Σετ Κρεβατ/μαρας - 135.00 €
ESTIA CLASSIC 6878 RED
ESTIA CLASSIC 6878 RED
100% Heatset
Dimensions - PRICE
Σετ Κρεβατ/μαρας - 65.00 €
ZIEGLER 1629 RED NAVY
ZIEGLER 1629 RED NAVY
100% Heatset Frise.
Dimensions - PRICE
Bedroom Set - 169.00 €
IMAGINE 9339-075
IMAGINE 9339-075
100% Acrylic.
Dimensions - PRICE
Bedroom Set - 220.00 € 198.00 €
APOLLON C4 Orange-50%
APOLLON C4 Orange
100% ArtSilk Shaggy Handtufted
Dimensions - PRICE
Bedroom Set - 423.00 € 211.50 €
VELVET 3883 BEIGE
VELVET 3883 BEIGE
100% Heatset
Dimensions - PRICE
Σετ Κρεβατ/μαρας - 155.00 €
DELICE 3928 BEIGE
DELICE 3928 BEIGE
100% Polyester Microfiber.
Dimensions - PRICE
Bedroom Set - 195.00 €
EROS LIGHT BROWN 08-50%
EROS LIGHT BROWN 08
100% ArtSilk Shaggy Handtufted
Dimensions - PRICE
Bedroom Set - 423.00 € 211.50 €
FLORIDA G 133 GREY
FLORIDA G 133 GREY
100% Heatset Frize
Dimensions - PRICE
Bedroom Set - 119.00 €
ESTIA 7245 BROWN
ESTIA 7245 BROWN
100% Heatset
Dimensions - PRICE
Σετ Κρεβατ/μαρας - 65.00 €
MILLION 903 RED-50%
MILLION 903 RED
100% Heatset
Dimensions - PRICE
Σετ Κρεβατ/μαρας - 318.00 € 159.00 €
ERMIS Brown 06-50%
ERMIS Brown 06
100% ArtSilk Shaggy Handtufted
Dimensions - PRICE
Bedroom Set - 423.00 € 211.50 €
VELVET 4818 L.GREY
VELVET 4818 L.GREY
100% Heatset
Dimensions - PRICE
Σετ Κρεβατ/μαρας - 155.00 €
APOLLON 07 10B-50%
APOLLON 07 10B
100% ArtSilk Shaggy Handtufted
Dimensions - PRICE
Bedroom Set - 423.00 € 211.50 €
M.T BLACK TIE 103 CHOCO-50%
M.T BLACK TIE 103 CHOCO
100% New Zealand Wool, Handtufted.
Dimensions - PRICE
Bedroom Set - 484.00 € 242.00 €
ESTIA CLASSIC 8235 RED
ESTIA CLASSIC 8235 RED
100% Heatset
Dimensions - PRICE
Σετ Κρεβατ/μαρας - 65.00 €
VELVET 3880 GREY
VELVET 3880 GREY
100% Heatset
Dimensions - PRICE
Σετ Κρεβατ/μαρας - 155.00 €
ESTIA 7423 GREY RED
ESTIA 7423 GREY RED
100% Heatset
Dimensions - PRICE
Σετ Κρεβατ/μαρας - 65.00 €
ZIEGLER 1594 RED IVORY
ZIEGLER 1594 RED IVORY
100% Heatset Frise.
Dimensions - PRICE
Bedroom Set - 169.00 €
FLORIDA 1875 ORANGE
FLORIDA 1875 ORANGE
100% Heatset Frize
Dimensions - PRICE
Σετ Κρεβατ/μαρας - 99.00 €
N.ELIF 11007 BLACK-20%
N.ELIF 11007 BLACK
100% Wool & Lurex
Dimensions - PRICE
Bedroom Set - 218.75 € 175.00 €
APOLLON 07-10A GOLD-50%
APOLLON 07-10A GOLD
100% ArtSilk Shaggy Handtufted
Dimensions - PRICE
Bedroom Set - 423.00 € 211.50 €
ESTIA 7614 MULTI
ESTIA 7614 MULTI
100% Heatset
Dimensions - PRICE
Σετ Κρεβατ/μαρας - 65.00 €

en-GB

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