SELECT t1.id, t1.primaran, t1.naziv, t1.mpcena, t1.ascase FROM
(SELECT a.id,a.primaran,a.naziv,a.mpcena,1 as ascase
FROM `artikli` a
WHERE a.`id`!='0' AND a.parent_id IS NULL
AND a.`category_id` IN (-100012) AND a.`novo`!='on' AND a.`aktivan`='on' AND a.`mpcena`!='0.00' AND a.`prikaz_b2c`='on' AND (a.`filter` LIKE "%a7913a%" )
UNION
SELECT a.id,a.primaran,a.naziv,a.mpcena,1 as ascase
FROM `artikli` a
WHERE a.`id`!='0' AND a.parent_id IS NULL
AND a.`category_id` IN (-100012) AND a.`novo`!='on' AND a.`aktivan`='on' AND a.`mpcena`!='0.00' AND a.`prikaz_b2c`='on' AND (a.`filter` LIKE "%a7913a%" )
UNION
SELECT a.id,a.primaran,a.naziv,MIN(a.mpcena) as mpcena,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 (-100012) AND a.`novo`!='on' AND a.`aktivan`='on' AND a.`mpcena`!='0.00' AND a.`prikaz_b2c`='on' AND (a.`filter` LIKE "%a7913a%" )
GROUP BY a.parent_id
) t1 ORDER BY ascase ASC, `id` DESC
Šifra: 526688
-
Metalik |
-
Bez tuša |
-
Zlatno saten
42.990,00 RSD
Šifra: 526687
-
Metalik |
-
Sa tušem |
-
Zlatno saten
55.990,00 RSD
Šifra: 526683
-
Metalik |
-
Bez tuša |
-
Zlatno saten
33.890,00 RSD
Šifra: 526684
-
Metalik |
-
Sa tušem |
-
Zlatno saten
38.490,00 RSD