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

ATHOS 1525 CREAM-50%
ATHOS 1525 CREAM
Acrylic, Wool Touch.
Διαστάσεις - Τιμή
250cm x 300cm - 470.00 € 235.00 €
THIBET TERRA-50%
THIBET TERRA
100% Handknotted New Zealand Wool
Διαστάσεις - Τιμή
170cm x 240cm - 1,990.00 € 995.00 €
EXCLUSIVE 74705 NAVY-50%
EXCLUSIVE 74705 NAVY
100% New Zealand Wool T5
Διαστάσεις - Τιμή
250cm x 350cm - 700.00 € 350.00 €
ALEXANDER 02YEL-50%
ALEXANDER 02YEL
30%Wool & 70%Viscose
Διαστάσεις - Τιμή
165cm x 235cm - 930.00 € 465.00 €
200cm x 300cm - 1,440.00 € 720.00 €
JADE WENGE 8050-40%
JADE WENGE 8050
Τεχνητό Μετάξι & Suede Leather & Μαλλί.
Διαστάσεις - Τιμή
160cm x 230cm - 580.00 € 348.00 €
190cm x 290cm - 875.00 € 525.00 €
AVEIRO BEIGE 502-40%
AVEIRO BEIGE 502
Τεχνητό Μετάξι & Πολυέστερ.
Διαστάσεις - Τιμή
160cm x 230cm - 540.00 € 324.00 €

Όλο το υλικό του ιστότοπου αποτελεί πνευματική ιδιοκτησία του xalia.