SELECT t1.id, t1.primaran, t1.naziv, t1.mpcena, t1.ascase FROM (SELECT a.id,a.primaran,a.naziv,a.mpcena,CASE WHEN a.sifra='521841' THEN 0 ELSE 1 END 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 (-100011) AND a.`novo`!='on' AND a.`aktivan`='on' AND a.`mpcena`!='0.00' AND a.`prikaz_b2c`='on' AND (a.`filter` LIKE "%a44a%" ) AND (a.`filter` LIKE "%a344a%" ) || (a.`id`!='0' AND a2.`category_id` IN (-100011) AND a2.`novo`!='on' AND a2.`aktivan`='on' AND a2.`mpcena`!='0.00' AND a2.`prikaz_b2c`='on' AND (a.`filter` LIKE "%a44a%" ) AND (a.`filter` LIKE "%a344a%" )) UNION SELECT a.id,a.primaran,a.naziv,a.mpcena,CASE WHEN a.sifra='521841' THEN 0 ELSE 1 END as ascase FROM `artikli` a WHERE a.`id`!='0' AND a.parent_id IS NULL AND a.`category_id` IN (-100011) AND a.`novo`!='on' AND a.`aktivan`='on' AND a.`mpcena`!='0.00' AND a.`prikaz_b2c`='on' AND (a.`filter` LIKE "%a44a%" ) AND (a.`filter` LIKE "%a344a%" ) UNION SELECT a.id,a.primaran,a.naziv,MIN(a.mpcena) as mpcena,CASE WHEN a.sifra='521841' THEN 0 ELSE 1 END 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 (-100011) AND a.`novo`!='on' AND a.`aktivan`='on' AND a.`mpcena`!='0.00' AND a.`prikaz_b2c`='on' AND (a.`filter` LIKE "%a44a%" ) AND (a.`filter` LIKE "%a344a%" ) GROUP BY a.parent_id ) t1 ORDER BY ascase ASC, `id` DESC