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 (10023,-1002344,-1002339,-1002338,-1002337,-1002325,-1002320,-1002319,-1002318,-1002317,-1002316,-1002315,-1002314,-1002313,-1002312,-1002311,-100231) 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 (10023,-1002344,-1002339,-1002338,-1002337,-1002325,-1002320,-1002319,-1002318,-1002317,-1002316,-1002315,-1002314,-1002313,-1002312,-1002311,-100231) 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 (10023,-1002344,-1002339,-1002338,-1002337,-1002325,-1002320,-1002319,-1002318,-1002317,-1002316,-1002315,-1002314,-1002313,-1002312,-1002311,-100231) 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 (10023,-1002344,-1002339,-1002338,-1002337,-1002325,-1002320,-1002319,-1002318,-1002317,-1002316,-1002315,-1002314,-1002313,-1002312,-1002311,-100231) 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: PKF611BB2E
31.990,00 RSD
Šifra: DFM064W55
28.990,00 RSD
Šifra: SPV2HMX02E
57.990,00 RSD
Šifra: HBF134ES1
46.990,00 RSD
Šifra: DBB63BC60
34.990,00 RSD
Šifra: SMV25EX06F
58.990,00 RSD
Šifra: KIV86VSE0
93.990,00 RSD
Šifra: HBA234EB3
56.990,00 RSD
Šifra: PUG611AA5D
-
60cm |
-
Senzorsko |
-
Da |
-
Indukcija |
-
Crna
39.990,00 RSD
Šifra: WAN2829NBY
71.990,00 RSD
Šifra: SMV6ECX23E
107.990,00 RSD
Šifra: SMV4EVX11E
75.990,00 RSD
Šifra: SMH4HVX14E
69.990,00 RSD
Šifra: HBF134EB2
48.990,00 RSD
Šifra: HBG536EB4
67.990,00 RSD
Šifra: HBA571BB4
63.990,00 RSD
Šifra: WTZ27400
10.990,00 RSD
Šifra: PUE64KBB5E
45.990,00 RSD
Šifra: KGN39LBCF
144.990,00 RSD
Šifra: KIN96NSE0
-
Kombinovani |
-
Bez komore |
-
Ugradni |
-
Da |
-
290l
108.990,00 RSD
Šifra: KBN96VFE0
-
Bez komore |
-
Ugradni |
-
Da |
-
383l |
-
Kombinovani
164.990,00 RSD
Šifra: DLN56AC60
-
645m3/h |
-
Ugradni |
-
Tasteri |
-
Crna |
-
60cm |
-
Ne
46.990,00 RSD
Šifra: DLN56AC50
-
Inox |
-
60cm |
-
Ne |
-
645m3/h |
-
Ugradni |
-
Tasteri
44.990,00 RSD
Šifra: BFL523MS0
-
Ne |
-
800W |
-
Ugradna |
-
Mehaničko |
-
20l
41.990,00 RSD