SELECT * FROM (SELECT a.*,CASE
WHEN sifra='330990' THEN 0
ELSE 1
END 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 (35) AND a.`brend` LIKE '%K909%'
UNION
SELECT a.*,CASE
WHEN sifra='330990' THEN 0
ELSE 1
END 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 (35) AND a.`brend` LIKE '%K909%'
AND a.vodi_se_zaliha='') t1 ORDER BY ascase ASC, `sifra` ASC LIMIT 0, 24
