SELECT * FROM (SELECT a.*,1 as ascase
FROM `artikli` a
INNER JOIN artikli2category a2c ON a.`id` = a2c.`id_artikla`
WHERE a.`id`!='0'
AND a.`novo`!='on'
AND a.`aktivan`='on'
AND a.`naziv`!=''
AND `prikaz_b2c`='on'
AND a.`mpcena`!='0.00'
AND a2c.`category_id` IN (34) AND a.`brend` LIKE '%K912%'
UNION
SELECT a.*,1 as ascase
FROM `artikli` a
INNER JOIN artikli2category a2c ON a.`id` = a2c.`id_artikla`
WHERE a.`id`!='0'
AND a.`novo`!='on'
AND a.`aktivan`='on'
AND a.`naziv`!=''
AND `prikaz_b2c`='on'
AND a.`mpcena`!='0.00'
AND a2c.`category_id` IN (34) AND a.`brend` LIKE '%K912%'
AND a.vodi_se_zaliha='') t1 ORDER BY ascase ASC, `sifra` ASC LIMIT 0, 24
