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
LEFT JOIN artikli a2 on a2.parent_id = a.id
WHERE a.`id`!='0' AND a.parent_id IS NULL
AND a.`naziv` LIKE '%LATO%' AND a.`novo`!='on' AND a.`aktivan`='on' AND a.`mpcena`!='0.00' AND a.`prikaz_b2c`='on'
|| (a.`id`!='0' AND a2.`naziv` LIKE '%LATO%' 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,1 as ascase
FROM `artikli` a
WHERE a.`id`!='0' AND a.parent_id IS NULL
AND a.`naziv` LIKE '%LATO%' 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,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 '%LATO%' 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 ascase ASC, `id` DESC
Šifra: 124251
1.810,00 RSD
Dostupno boja: 8
8.990,00 RSD
Šifra: 526699
8.590,00 RSD
Šifra: 123917
2.180,00 RSD
Šifra: 525810
-
Antracit |
-
Silgranit-Look
8.990,00 RSD
Šifra: 525809
-
Metalik |
-
Inox -finish UltraResist
6.990,00 RSD
Šifra: 525808
5.990,00 RSD
Šifra: 525789
-
Black Matt |
-
Silgranit-Look
7.990,00 RSD
Šifra: 123826
1.600,00 RSD
Šifra: 123708
2.120,00 RSD