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 (-1002311) 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 (-1002311) 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 (-1002311) 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 (-1002311) 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: PXE801DC1E
-
Crna |
-
80cm |
-
Senzorsko |
-
Da |
-
Indukcija
115.990,00 RSD
Šifra: PVS611B16E
-
Crna |
-
60cm |
-
Senzorsko |
-
Ne |
-
Indukcija
160.990,00 RSD
Šifra: PVS631HB1E
-
Crna |
-
60cm |
-
Senzorsko |
-
Ne |
-
Indukcija
70.990,00 RSD
Šifra: PUG611AA5D
-
Crna |
-
60cm |
-
Senzorsko |
-
Da |
-
Indukcija
44.990,00 RSD
Šifra: PUE61RBB6E
-
Crna |
-
60cm |
-
Senzorsko |
-
Da |
-
Indukcija
53.990,00 RSD
Šifra: PKN645BA2E
-
Inox |
-
60cm |
-
Senzorsko |
-
Ne |
-
Staklokeramika
40.990,00 RSD
Šifra: PKF375FP2E
-
Inox |
-
30cm |
-
Senzorsko |
-
Ne |
-
Staklokeramika
40.990,00 RSD
Šifra: PKE61RAA2E
-
Crna |
-
60cm |
-
Senzorsko |
-
Da |
-
Staklokeramika
32.990,00 RSD
Šifra: PXE675DC1E
109.990,00 RSD
