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,12987,12988)
AND `jos_vm_product`.`product_id` NOT IN (7712,12987,12988)
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
/components/com_virtuemart/shop_image/product/230x160/ziegler-1259a-red-ivory-a-rotated.jpg
100% Heatset Frise.
Dimensiuni - Preț
133cm x 195cm - 105.00 €170cm x 240cm - 170.00 €200cm x 290cm - 235.00 €Bedroom Set - 149.00 €
/components/com_virtuemart/shop_image/product/230x160/NESCA-2301-plake-rotated.jpg
100% Acrylic
Dimensiuni - Preț
120cm x 180cm - 245.00 €160cm x 230cm - 399.00 €200cm x 290cm - 625.00 €
/components/com_virtuemart/shop_image/product/230x160/MARRAKESH-207-GREY-plake-rotated.jpg
100% Acrylic Heatset
Dimensiuni - Preț
120cm x 170cm - 99.00 €300cm x 400cm - 479.00 €
/components/com_virtuemart/shop_image/product/230x160/hali-7677-614-classic-000sitap-rotated.jpg
100% Heatset.
Dimensiuni - Preț
170cm x 230cm - 269.00 €
/components/com_virtuemart/shop_image/product/230x160/ziegler-1260a-red-navy-a-rotated.jpg
100% Heatset Frise.
Dimensiuni - Preț
133cm x 195cm - 105.00 €170cm x 240cm - 170.00 €200cm x 290cm - 235.00 €Bedroom Set - 149.00 €
/components/com_virtuemart/shop_image/product/230x160/SUN-911-960-plake-rotated.jpg
100% Acrylic Heatset
Dimensiuni - Preț
160cm x 230cm - 115.00 €200cm x 250cm - 155.00 €200cm x 290cm - 180.00 €
/components/com_virtuemart/shop_image/product/230x160/MARRAKESH-210-BLACK-plake-rotated.jpg
100% Acrylic Heatset
Dimensiuni - Preț
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 €
/components/com_virtuemart/shop_image/product/230x160/SUN-10544-960-plake-rotated.jpg
100% Acrylic Heatset
Dimensiuni - Preț
160cm x 230cm - 115.00 €200cm x 250cm - 155.00 €200cm x 290cm - 180.00 €
/components/com_virtuemart/shop_image/product/230x160/MARRAKESH-297-GREY-plake-rotated.jpg
100% Acrylic Heatset
Dimensiuni - Preț
200cm x 290cm - 255.00 €240cm x 340cm - 365.00 €
/components/com_virtuemart/shop_image/product/230x160/MARRAKESH-205-RED-plake-rotated.jpg
100% Acrylic Heatset
Dimensiuni - Preț
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 €
/components/com_virtuemart/shop_image/product/230x160/KLASSIC-315A-plake-rotated.jpg
100% Acrylic Heatset.
Dimensiuni - Preț
80cm x 150cm - 34.00 €133cm x 190cm - 72.00 €160cm x 230cm - 105.00 €200cm x 290cm - 165.00 €Bedroom Set - 92.00 €
/components/com_virtuemart/shop_image/product/230x160/6045A-RED-rotated.jpg
100% Acrylic.
Dimensiuni - Preț
140cm x 200cm - 76.00 €160cm x 230cm - 99.00 €200cm x 250cm - 135.00 €200cm x 300cm - 161.00 €Set dormitor - 94.00 €
/components/com_virtuemart/shop_image/product/230x160/ALPINA-5230---Pink----rotated.jpg
100% Acrylic Polyester
Dimensiuni - Preț
120cm x 170cm - 155.00 €160cm x 230cm - 269.00 €200cm x 290cm - 409.00 €
-40%
/components/com_virtuemart/shop_image/product/230x160/GRAVITY-153-IVORY-plake-rotated.jpg
100% Polyester, Powerloomed
Dimensiuni - Preț
120cm x 156cm - 131.25 € 78.75 €160cm x 235cm - 263.75 € 158.25 €200cm x 285cm - 400.00 € 240.00 €
/components/com_virtuemart/shop_image/product/230x160/KLASSIC-1019A-plake-rotated.jpg
100% Acrylic Heatset.
Dimensiuni - Preț
80cm x 150cm - 34.00 €133cm x 190cm - 72.00 €160cm x 230cm - 105.00 €200cm x 290cm - 165.00 €Bedroom Set - 92.00 €
/components/com_virtuemart/shop_image/product/230x160/VINTAGE-23014-953-plake-rotated.jpg
Acrylic Heatset Polyester
Dimensiuni - Preț
133cm x 190cm - 140.00 €166cm x 236cm - 210.00 €200cm x 250cm - 270.00 €200cm x 290cm - 315.00 €240cm x 340cm - 440.00 €Bedroom Set - 190.00 €
/components/com_virtuemart/shop_image/product/230x160/KLASSIC-2288A-plake-rotated.jpg
100% Acrylic Heatset.
Dimensiuni - Preț
133cm x 190cm - 72.00 €160cm x 230cm - 105.00 €200cm x 290cm - 165.00 €
/components/com_virtuemart/shop_image/product/230x160/ELITE-16959-675-d-rotated.jpg
Acrylic Polyester
Dimensiuni - Preț
160cm x 230cm - 205.00 €200cm x 290cm - 320.00 €
/components/com_virtuemart/shop_image/product/230x160/ELITE-16955-095-d-rotated.jpg
Acrylic Polyester
Dimensiuni - Preț
160cm x 230cm - 205.00 €200cm x 290cm - 320.00 €
/components/com_virtuemart/shop_image/product/230x160/ELITE-16954-953-d-rotated.jpg
Acrylic Polyester
Dimensiuni - Preț
133cm x 190cm - 140.00 €160cm x 230cm - 205.00 €200cm x 250cm - 280.00 €200cm x 290cm - 320.00 €Bedroom Set - 195.00 €
/components/com_virtuemart/shop_image/product/230x160/ASSOS-17515-095-d-rotated.jpg
Acrylic Polyester
Dimensiuni - Preț
133cm x 190cm - 140.00 €160cm x 230cm - 205.00 €200cm x 250cm - 280.00 €200cm x 290cm - 325.00 €
/components/com_virtuemart/shop_image/product/230x160/ASSOS-17180-095-d-rotated.jpg
Acrylic Polyester
Dimensiuni - Preț
133cm x 190cm - 140.00 €160cm x 230cm - 205.00 €200cm x 250cm - 280.00 €200cm x 290cm - 325.00 €
/components/com_virtuemart/shop_image/product/230x160/ASSOS-17222-095-d-rotated.jpg
Acrylic Polyester
Dimensiuni - Preț
160cm x 230cm - 205.00 €200cm x 250cm - 280.00 €200cm x 290cm - 325.00 €
/components/com_virtuemart/shop_image/product/230x160/ASSOS-17194-095-d-rotated.jpg
Acrylic Polyester
Dimensiuni - Preț
160cm x 230cm - 205.00 €200cm x 290cm - 325.00 €
/components/com_virtuemart/shop_image/product/230x160/ASSOS-16060-095-d-rotated.jpg
Acrylic Polyester
Dimensiuni - Preț
160cm x 230cm - 205.00 €200cm x 290cm - 325.00 €
/components/com_virtuemart/shop_image/product/230x160/ALPINA-5230---Turkis----rotated.jpg
100% Acrylic Polyester
Dimensiuni - Preț
120cm x 170cm - 155.00 €160cm x 230cm - 269.00 €200cm x 290cm - 409.00 €
/components/com_virtuemart/shop_image/product/230x160/OUSHAK-555-LIGHT-BLUE-plake-rotated.jpg
100% Acrylic Heatset,Powerloomed
Dimensiuni - Preț
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 €
/components/com_virtuemart/shop_image/product/230x160/VINTAGE-23024-956-d-rotated.jpg
Acrylic Heatset Polyester
Dimensiuni - Preț
133cm x 190cm - 140.00 €166cm x 236cm - 210.00 €200cm x 250cm - 270.00 €200cm x 290cm - 315.00 €240cm x 340cm - 440.00 €
/components/com_virtuemart/shop_image/product/230x160/ELITE-16969-095-d-rotated.jpg
Acrylic Polyester
Dimensiuni - Preț
160cm x 230cm - 205.00 €200cm x 290cm - 320.00 €
-25%
/components/com_virtuemart/shop_image/product/230x160/VENUS-17521-695-plake-rotated.jpg
100% Acrylic.
Dimensiuni - Preț
160cm x 230cm - 265.00 € 198.75 €200cm x 290cm - 415.00 € 311.25 €
/components/com_virtuemart/shop_image/product/230x160/OLIMPOS-15893-670-plake-rotated.jpg
Acrylic, Polyester.
Dimensiuni - Preț
160cm x 230cm - 185.00 €200cm x 290cm - 290.00 €
/components/com_virtuemart/shop_image/product/230x160/OLIMPOS-15891-630-plake-rotated.jpg
Acrylic, Polyester.
Dimensiuni - Preț
160cm x 230cm - 185.00 €200cm x 290cm - 290.00 €
/components/com_virtuemart/shop_image/product/230x160/OLIMPOS-15891-620-plake-rotated.jpg
Acrylic, Polyester.
Dimensiuni - Preț
160cm x 230cm - 185.00 €200cm x 290cm - 290.00 €Bedroom Set - 200.00 €
/components/com_virtuemart/shop_image/product/230x160/OLIMPOS-15890-670-plake-rotated.jpg
Acrylic, Polyester.
Dimensiuni - Preț
160cm x 230cm - 185.00 €200cm x 290cm - 290.00 €
/components/com_virtuemart/shop_image/product/230x160/OLIMPOS-15889-761-plake-rotated.jpg
Acrylic, Polyester.
Dimensiuni - Preț
160cm x 230cm - 185.00 €200cm x 290cm - 290.00 €
/components/com_virtuemart/shop_image/product/230x160/OLIMPOS-15889-010-plake-rotated.jpg
Acrylic, Polyester.
Dimensiuni - Preț
200cm x 290cm - 290.00 €
-20%
/components/com_virtuemart/shop_image/product/230x160/MOHAMADI-15404-110-d-rotated.jpg
100% Acrylic Heatset Frise.
Dimensiuni - Preț
160cm x 230cm - 170.00 € 136.00 €
-20%
/components/com_virtuemart/shop_image/product/230x160/MOHAMADI-15402-110-d-rotated.jpg
100% Acrylic Heatset Frise.
Dimensiuni - Preț
160cm x 230cm - 170.00 € 136.00 €200cm x 290cm - 265.00 € 212.00 €
/components/com_virtuemart/shop_image/product/230x160/ZIEGLER-1629A-IVORY-NAVY-plake-rotated.jpg
100% Heatset Frise.
Dimensiuni - Preț
133cm x 195cm - 105.00 €170cm x 240cm - 170.00 €200cm x 290cm - 235.00 €Bedroom Set - 149.00 €
/components/com_virtuemart/shop_image/product/230x160/ZIEGLER-1594A-RED-IVORY-plake-rotated.jpg
100% Heatset Frise.
Dimensiuni - Preț
133cm x 195cm - 105.00 €170cm x 240cm - 170.00 €200cm x 290cm - 235.00 €Bedroom Set - 149.00 €
/components/com_virtuemart/shop_image/product/230x160/ZIEGLER-1594A-IVORY-RED-plake-rotated.jpg
100% Heatset Frise.
Dimensiuni - Preț
133cm x 195cm - 105.00 €170cm x 240cm - 170.00 €200cm x 290cm - 235.00 €Bedroom Set - 149.00 €
/components/com_virtuemart/shop_image/product/230x160/ZIEGLER-1594A-plake-rotated.jpg
100% Heatset Frise.
Dimensiuni - Preț
133cm x 195cm - 105.00 €170cm x 240cm - 170.00 €200cm x 290cm - 235.00 €Bedroom Set - 149.00 €
/components/com_virtuemart/shop_image/product/230x160/ZIEGLER-1267A-plake-rotated.jpg
100% Heatset Frise.
Dimensiuni - Preț
133cm x 195cm - 105.00 €170cm x 240cm - 170.00 €200cm x 290cm - 235.00 €Bedroom Set - 149.00 €
/components/com_virtuemart/shop_image/product/230x160/ZIEGLER-1260A-plake-rotated.jpg
100% Heatset Frise.
Dimensiuni - Preț
133cm x 195cm - 105.00 €170cm x 240cm - 170.00 €200cm x 290cm - 235.00 €Bedroom Set - 149.00 €
/components/com_virtuemart/shop_image/product/230x160/ZIEGLER-1259B-IVORY-RED-plake-rotated.jpg
100% Heatset Frise.
Dimensiuni - Preț
133cm x 195cm - 105.00 €170cm x 240cm - 170.00 €200cm x 290cm - 235.00 €Bedroom Set - 149.00 €
/components/com_virtuemart/shop_image/product/230x160/VEGAS-CLASSIC-5001-CHERRY-BLACK-plake-rotated.jpg
100% Heatset
Dimensiuni - Preț
160cm x 230cm - 105.00 €200cm x 290cm - 169.00 €Bedroom Set - 99.00 €
/components/com_virtuemart/shop_image/product/230x160/VEGAS-CLASSIC-5001-BEIGE-BLACK-plake-rotated.jpg
100% Heatset
Dimensiuni - Preț
160cm x 230cm - 105.00 €200cm x 290cm - 169.00 €Bedroom Set - 99.00 €
/components/com_virtuemart/shop_image/product/230x160/VEGAS-CLASSIC-1267A-CHERRY-BEIGE-plake-rotated.jpg
100% Heatset
Dimensiuni - Preț
160cm x 230cm - 105.00 €200cm x 290cm - 169.00 €Bedroom Set - 99.00 €
Flycarpet
