SELECT t1.id 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 a.`vpcena`!='0.00'
AND a2c.`category_id` IN (188,189,190,191,192,193)
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 a.`vpcena`!='0.00'
AND a2c.`category_id` IN (188,189,190,191,192,193)
) t1
ORDER BY ascase ASC, t1.`sifra` ASC LIMIT 504, 24
