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