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

OUSHAK 555 LIGHT BLUE
OUSHAK 555 LIGHT BLUE
100% Acrylic Heatset,Powerloomed
Dimensions - PRICE
0.80m - 34.00 €
OUSHAK 753 DARK BROWN
OUSHAK 753 DARK BROWN
100% Acrylic Heatset,Powerloomed
Dimensions - PRICE
0.80m - 34.00 €
KLASSIK 1533A CHERRY
KLASSIK 1533A CHERRY
100% Acrylic Heatset.
Dimensions - PRICE
0.67m - 19.00 €
0.80m - 23.00 €
KLASSIK 1536A CREAM
KLASSIK 1536A CREAM
100% Acrylic Heatset.
Dimensions - PRICE
0.67m - 19.00 €
0.80m - 23.00 €
KLASSIK 6283A CHERRY
KLASSIK 6283A CHERRY
100% Acrylic Heatset.
Dimensions - PRICE
0.67m - 19.00 €
0.80m - 23.00 €
KLASSIK 7838A CHERRY
KLASSIK 7838A CHERRY
100% Acrylic Heatset.
Dimensions - PRICE
0.67m - 19.00 €
0.80m - 23.00 €
KLASSIK 7838B NAVY
KLASSIK 7838B NAVY
100% Acrylic Heatset.
Dimensions - PRICE
0.67m - 19.00 €
0.80m - 23.00 €
ASSOS 772
ASSOS 772
100% Acrylic.
Dimensions - PRICE
0.67m - 29.00 €
ASSOS 779
ASSOS 779
100% Acrylic.
Dimensions - PRICE
0.67m - 29.00 €
0.80m - 35.00 €
AVENUE 114I
AVENUE 114I
100% Acrylic Heatset.
Dimensions - PRICE
0.67m - 47.00 €
BOSTON 6315A MARINE
BOSTON 6315A MARINE
100% Acrylic Heatset.
Dimensions - PRICE
0.67m - 21.00 €
0.80m - 25.00 €
BOSTON 6330A FUME
BOSTON 6330A FUME
100% Acrylic Heatset.
Dimensions - PRICE
0.67m - 21.00 €
1.00m - 31.00 €
KIWI 521W
KIWI 521W
100% Acrylic Heatset.
Dimensions - PRICE
0.67m - 38.00 €
OUSHAK 392 BROWN
OUSHAK 392 BROWN
100% Acrylic Heatset,Powerloomed
Dimensions - PRICE
0.80m - 34.00 €
MARMARAS FULDEN CREAM-20%
MARMARAS FULDEN CREAM
Acrylic, Wool Touch.
Dimensions - PRICE
0.67m - 31.00 € 24.80 €
MARMARAS D05 NAVY-20%
MARMARAS D05 NAVY
Acrylic, Wool Touch.
Dimensions - PRICE
0.80m - 39.00 € 31.20 €
MARMARAS ROMEO CREAM BLUE-20%
MARMARAS ROMEO CREAM BLUE
Acrylic, Wool Touch.
Dimensions - PRICE
0.80m - 39.00 € 31.20 €
LEONARDO 413 CREAM NAVY-20%
LEONARDO 413 CREAM NAVY
100% Heatset.
Dimensions - PRICE
0.67m - 28.00 € 22.40 €
SULEIMAN 188-317-20%
SULEIMAN 188-317
100% New Zealand Wool
Dimensions - PRICE
0.67m - 41.00 € 32.80 €
VERSARI 51913 6032-20%
VERSARI 51913 6032
100% Acrylic
Dimensions - PRICE
0.67m - 39.00 € 31.20 €
VISCONTI 5002-400-20%
VISCONTI 5002-400
100% Acrylic
Dimensions - PRICE
0.67m - 42.00 € 33.60 €
ZEN PRESTIGE 171 YELLOW NAVY-20%
ZEN PRESTIGE 171 YELLOW NAVY
100% Heatset
Dimensions - PRICE
0.80m - 30.00 € 24.00 €
PIERRE CARDIN IVORY BEIGE
PIERRE CARDIN IVORY BEIGE
100% Acrylic.
Dimensions - PRICE
0.67m - 64.00 €
0.80m - 75.00 €
PIERRE CARDIN IVORY GREY
PIERRE CARDIN IVORY GREY
100% Acrylic.
Dimensions - PRICE
0.67m - 64.00 €
0.80m - 75.00 €
BOHEME 202A
BOHEME 202A
100% Acrylic Frise.
Dimensions - PRICE
0.67m - 30.00 €
ELIF 4046 CREAM 2-20%
ELIF 4046 CREAM 2
60% New Zealand wool,40% Acrylic.
Dimensions - PRICE
0.75m - 51.00 € 40.80 €
ELIF 938 NAVY-20%
ELIF 938 NAVY
60% New Zealand wool,40% Acrylic.
Dimensions - PRICE
0.80m - 54.00 € 43.20 €
MIAMI 4583 YELLOW-10%
MIAMI 4583 YELLOW
100% Heatset.
Dimensions - PRICE
0.67m - 29.00 € 26.10 €
ANTIQUE K14 NAVY-20%
ANTIQUE K14 NAVY
100% Wool
Dimensions - PRICE
0.67m - 34.00 € 27.20 €
ANTIQUE K14 WHITE-20%
ANTIQUE K14 WHITE
100% Wool
Dimensions - PRICE
0.67m - 34.00 € 27.20 €
ANTIQUE K16 WHITE-20%
ANTIQUE K16 WHITE
100% Wool
Dimensions - PRICE
0.67m - 34.00 € 27.20 €
DAMASK 10001 CREAM BLACK-20%
DAMASK 10001 CREAM BLACK
100% New Zealand wool.
Dimensions - PRICE
0.75m - 54.00 € 43.20 €
DAMASK 10008 CREAM-20%
DAMASK 10008 CREAM
100% New Zealand wool.
Dimensions - PRICE
0.75m - 54.00 € 43.20 €
BOHEME 997B
BOHEME 997B
100% Acrylic Frise.
Dimensions - PRICE
0.67m - 30.00 €
CASINO 7091-59 SAND CHOCO
CASINO 7091-59 SAND CHOCO
100% Heatset Frise.
Dimensions - PRICE
0.67m - 28.00 €
CASINO 5102-81 GREY
CASINO 5102-81 GREY
100% Heatset Frise.
Dimensions - PRICE
0.67m - 28.00 €
LYDIA 2128A RED
LYDIA 2128A RED
100% Heatset.
Dimensions - PRICE
0.67m - 28.00 €
0.80m - 32.00 €
1.00m - 38.00 €
BOSTON 5376A MARINE
BOSTON 5376A MARINE
100% Heatset, PP.
Dimensions - PRICE
0.67m - 28.00 €
BOSTON 5367A D.GREY
BOSTON 5367A D.GREY
100% Heatset, PP.
Dimensions - PRICE
0.67m - 28.00 €
BOSTON 5748A GREY
BOSTON 5748A GREY
100% Heatset, PP.
Dimensions - PRICE
0.67m - 28.00 €
1.00m - 38.00 €
BOSTON 5353A GREY
BOSTON 5353A GREY
100% Heatset, PP.
Dimensions - PRICE
0.67m - 28.00 €
BOSTON 5376A RED
BOSTON 5376A RED
100% Heatset, PP.
Dimensions - PRICE
0.80m - 32.00 €
1.00m - 38.00 €
BOSTON 5365A BEIGE
BOSTON 5365A BEIGE
100% Heatset, PP.
Dimensions - PRICE
0.67m - 28.00 €
0.80m - 32.00 €
1.00m - 37.00 €
LEGACY 606X-30%
LEGACY 606X
100% Heatset.
Dimensions - PRICE
0.67m - 40.00 € 28.00 €
LEGACY 560W-30%
LEGACY 560W
100% Heatset.
Dimensions - PRICE
0.67m - 40.00 € 28.00 €
LEGACY 508E-30%
LEGACY 508E
100% Heatset.
Dimensions - PRICE
0.67m - 28.00 € 19.60 €
OLYMPIA 4262F CREAM
OLYMPIA 4262F CREAM
100% Acrylic.
Dimensions - PRICE
0.67m - 26.00 €
0.80m - 30.00 €
OLYMPIA 6045L CREAM
OLYMPIA 6045L CREAM
100% Acrylic.
Dimensions - PRICE
0.67m - 26.00 €
0.80m - 30.00 €

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