VAŠ EKSPERT ZA KUHINJU

Zatvori
Pretraga artikala
0 Korpa 0,00 RSD
Zatvori

Korpa je prazna

Zatvori
SELECT t1.id, t1.primaran, t1.naziv, t1.mpcena, t1.ascase,t1.AdditionalProperty_1,t1.AdditionalProperty_2 FROM (SELECT a.id,a.primaran,a.naziv,a.mpcena,a.AdditionalProperty_1,a.AdditionalProperty_2,1 as ascase FROM `artikli` a LEFT JOIN artikli a2 on a2.parent_id = a.id WHERE a.`id`!='0' AND a.parent_id IS NULL AND a.`naziv` LIKE '%CULINA%' AND a.`novo`!='on' AND a.`aktivan`='on' AND a.`mpcena`!='0.00' AND a.`prikaz_b2c`='on' OR (a.`id`!='0' AND a2.`naziv` LIKE '%CULINA%' AND a2.`novo`!='on' AND a2.`aktivan`='on' AND a2.`mpcena`!='0.00' AND a2.`prikaz_b2c`='on') UNION SELECT a.id,a.primaran,a.naziv,a.mpcena,a.AdditionalProperty_1,a.AdditionalProperty_2,1 as ascase FROM `artikli` a WHERE a.`id`!='0' AND a.parent_id IS NULL AND a.`naziv` LIKE '%CULINA%' AND a.`novo`!='on' AND a.`aktivan`='on' AND a.`mpcena`!='0.00' AND a.`prikaz_b2c`='on' UNION SELECT a.id,a.primaran,a.naziv,MIN(a.mpcena) as mpcena,a.AdditionalProperty_1,a.AdditionalProperty_2,1 as ascase FROM artikli a INNER JOIN artikli a2 ON a2.id = a.parent_id WHERE a.`id`!='0' AND a.parent_id IS NOT NULL AND a.`naziv` LIKE '%CULINA%' AND a.`novo`!='on' AND a.`aktivan`='on' AND a.`mpcena`!='0.00' AND a.`prikaz_b2c`='on' GROUP BY a.parent_id ) t1 ORDER BY CASE WHEN t1.AdditionalProperty_1 = 4 THEN 0 WHEN t1.AdditionalProperty_1 = 1 THEN 1 WHEN t1.AdditionalProperty_1 = 2 THEN 2 WHEN t1.AdditionalProperty_1 = 5 THEN 3 ELSE 4 END ASC, `id` DESC
BLANCO CULINA-S II inox-finish ultraresist
Izdvajamo
Šifra: 527462

BLANCO CULINA-S II inox-finish ultraresist

106.990,00 RSD
Blanco CULINA-S II Mini saten platinum
Izdvajamo
Šifra: 527703

Blanco CULINA-S II Mini saten platinum

  • Metalik |
  • Sa tušem |
  • Saten platinum
72.990,00 RSD
Blanco CULINA-S II saten platinum
Izdvajamo
Šifra: 527702

Blanco CULINA-S II saten platinum

  • Metalik |
  • Sa tušem |
  • Saten platinum
79.590,00 RSD
BLANCO CULINA-S II Mini saten dark steel
Izdvajamo
Šifra: 527469

BLANCO CULINA-S II Mini saten dark steel

  • Metalik |
  • Sa tušem |
  • Saten dark steel
53.990,00 RSD
BLANCO CULINA-S II Mini Black Matt
Izdvajamo
Šifra: 527468

BLANCO CULINA-S II Mini Black Matt

  • Silgranit-Look |
  • Sa tušem |
  • Black Matt
53.590,00 RSD
Blanco CULINA-S II Mini inox-finish ultraresist
Izdvajamo
Šifra: 527467

Blanco CULINA-S II Mini inox-finish ultraresist

53.990,00 RSD
Blanco CULINA-S II Sensor
Izdvajamo
Šifra: 527466

Blanco CULINA-S II Sensor

  • Metalik |
  • Sa tušem |
  • Inox-finish UltraResist
103.990,00 RSD
BLANCO CULINA-S II saten dark steel
Izdvajamo
Šifra: 527465

BLANCO CULINA-S II saten dark steel

  • Metalik |
  • Sa tušem |
  • Saten dark steel
77.590,00 RSD
BLANCO CULINA-S II Black Matt
Izdvajamo
Šifra: 527464

BLANCO CULINA-S II Black Matt

  • Silgranit-Look |
  • Sa tušem |
  • Black Matt
77.590,00 RSD
BLANCO CULINA-S II inox-finish ultraresist
Izdvajamo
Šifra: 527463

BLANCO CULINA-S II inox-finish ultraresist

  • Metalik |
  • Sa tušem |
  • Inox-finish UltraResist
76.990,00 RSD
Uslovi kupovine
Uslovi kupovine
Odustanak od kupovine
Odustanak od kupovine
Dostava
Dostava