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.`category_id` IN (10011,-1001199,-1001150,-1001146,-1001140,-1001139,-1001134,-1001125,-1001123,-1001122,-1001121,-1001120,-1001119,-1001118,-1001117,-1001116,-1001115,-1001114,-1001113,-1001112,-1001111,-100111) AND a.`novo`!='on' AND a.`aktivan`='on' AND a.`mpcena`!='0.00' AND a.`prikaz_b2c`='on'
OR (a.`id`!='0' AND a2.`category_id` IN (10011,-1001199,-1001150,-1001146,-1001140,-1001139,-1001134,-1001125,-1001123,-1001122,-1001121,-1001120,-1001119,-1001118,-1001117,-1001116,-1001115,-1001114,-1001113,-1001112,-1001111,-100111) 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.`category_id` IN (10011,-1001199,-1001150,-1001146,-1001140,-1001139,-1001134,-1001125,-1001123,-1001122,-1001121,-1001120,-1001119,-1001118,-1001117,-1001116,-1001115,-1001114,-1001113,-1001112,-1001111,-100111) 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.`category_id` IN (10011,-1001199,-1001150,-1001146,-1001140,-1001139,-1001134,-1001125,-1001123,-1001122,-1001121,-1001120,-1001119,-1001118,-1001117,-1001116,-1001115,-1001114,-1001113,-1001112,-1001111,-100111) 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
Šifra: 949599535
74.990,00 RSD
Šifra: 949599524
-
Ne |
-
Indukcija |
-
Crna |
-
80cm |
-
Senzorsko
191.990,00 RSD
Šifra: 949599477
131.990,00 RSD
Šifra: 949599476
145.990,00 RSD
Šifra: 949599475
174.990,00 RSD
Šifra: 949598457
-
Ne |
-
Indukcija |
-
Crna |
-
60cm |
-
Senzorsko
146.990,00 RSD
Šifra: 949598450
88.990,00 RSD
Šifra: 949598446
-
Crna |
-
80cm |
-
Senzorsko |
-
Ne |
-
Indukcija
292.990,00 RSD
Šifra: 949598445
-
Crna |
-
80cm |
-
Senzorsko |
-
Ne |
-
Indukcija
203.990,00 RSD
Šifra: 949598409
-
Crna |
-
90cm |
-
Senzorsko |
-
Ne |
-
Indukcija
138.990,00 RSD
Šifra: 949598226
-
Crna |
-
80cm |
-
Senzorsko |
-
Ne |
-
Indukcija
190.990,00 RSD
Šifra: 949598220
-
Crna |
-
80cm |
-
Senzorsko |
-
Ne |
-
Indukcija
96.990,00 RSD
Šifra: 949598182
-
60cm |
-
Senzorsko |
-
Ne |
-
Indukcija |
-
Crna
88.990,00 RSD
Šifra: 949598180
-
Crna |
-
80cm |
-
Senzorsko |
-
Ne |
-
Indukcija
115.990,00 RSD
Šifra: 949498316
-
Crna |
-
Pirolitičko |
-
Potapajući dugmići |
-
Multifunkcionalna |
-
71l
68.990,00 RSD
Šifra: 949494933
-
Crna |
-
Pirolitičko |
-
Na dodir |
-
Multifunkcionalna |
-
71l
105.990,00 RSD
Šifra: 949494932
-
Crna sa inox detaljima |
-
Pirolitičko |
-
Na dodir |
-
Parna |
-
71l
118.990,00 RSD
Šifra: 949494931
-
Crna sa inox detaljima |
-
Pirolitičko |
-
Na dodir |
-
Multifunkcionalna |
-
71l
109.990,00 RSD
Šifra: 949494916
-
Crna sa inox detaljima |
-
Pirolitičko |
-
Na dodir |
-
Parna |
-
71l
97.990,00 RSD
Šifra: 949494903
129.990,00 RSD
Šifra: 949288422
-
Crna sa inox detaljima |
-
Pirolitičko |
-
Na dodir |
-
Multifunkcionalna |
-
71l
79.990,00 RSD
Šifra: 947727580
106.990,00 RSD
Šifra: 947727557
432.990,00 RSD
Šifra: 947727545
89.990,00 RSD