get->id: 2
Category query with limit:
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='HFO01PE040120G' THEN 0 WHEN a.sifra='HFO02PE040120F' THEN 1 WHEN a.sifra='HFO03PE060060O' THEN 2 WHEN a.sifra='HPL03WH082062C' THEN 3 WHEN a.sifra='HPL01WH082062C' THEN 4 WHEN a.sifra='HPL06WH117070C' THEN 5 WHEN a.sifra='HPL07WH070117C' THEN 6 WHEN a.sifra='OPO01BK029042C' THEN 7 WHEN a.sifra='HPL01BK075033C' THEN 8 WHEN a.sifra='HPL02BK033075C' THEN 9 WHEN a.sifra='OPL10BK090076C' THEN 10 WHEN a.sifra='HPL12BK117070C' THEN 11 WHEN a.sifra='HPL11BK070117C' THEN 12 WHEN a.sifra='HPL09BK086057C' THEN 13 WHEN a.sifra='HPL08BK086057C' THEN 14 WHEN a.sifra='OPO06BK040032C' THEN 15 WHEN a.sifra='OPO07BK040047C' THEN 16 WHEN a.sifra='HPL10BK074055C' THEN 17 WHEN a.sifra='OPL08BK300137C' THEN 18 ELSE 19 END as ascase FROM `artikli` a LEFT JOIN categories c ON c.id=a.category_id INNER JOIN artikli2category a2c ON a.`id` = a2c.`id_artikla` WHERE a.`id`!='0' AND a.`novo`!='on' AND a.`aktivan`='on' AND a.prikaz_b2c='on' AND a.`mpcena`!='0.00' AND a2c.category_id IN (2,10,11,12,13,97,98,99,112,117,126,63,64,65,66,67,70,71,72,105,106,107,108,109,110,111,113,114,115,116,118,119,123,124,125,127,128,129,130,131,138,139,140) UNION SELECT a.id,a.primaran,a.naziv,a.mpcena,CASE WHEN a.sifra='HFO01PE040120G' THEN 0 WHEN a.sifra='HFO02PE040120F' THEN 1 WHEN a.sifra='HFO03PE060060O' THEN 2 WHEN a.sifra='HPL03WH082062C' THEN 3 WHEN a.sifra='HPL01WH082062C' THEN 4 WHEN a.sifra='HPL06WH117070C' THEN 5 WHEN a.sifra='HPL07WH070117C' THEN 6 WHEN a.sifra='OPO01BK029042C' THEN 7 WHEN a.sifra='HPL01BK075033C' THEN 8 WHEN a.sifra='HPL02BK033075C' THEN 9 WHEN a.sifra='OPL10BK090076C' THEN 10 WHEN a.sifra='HPL12BK117070C' THEN 11 WHEN a.sifra='HPL11BK070117C' THEN 12 WHEN a.sifra='HPL09BK086057C' THEN 13 WHEN a.sifra='HPL08BK086057C' THEN 14 WHEN a.sifra='OPO06BK040032C' THEN 15 WHEN a.sifra='OPO07BK040047C' THEN 16 WHEN a.sifra='HPL10BK074055C' THEN 17 WHEN a.sifra='OPL08BK300137C' THEN 18 ELSE 19 END as ascase FROM `artikli` a LEFT JOIN categories c ON c.id=a.category_id INNER JOIN artikli2category a2c ON a.`id` = a2c.`id_artikla` WHERE a.`id`!='0' AND a.`novo`!='on' AND a.`aktivan`='on' AND a.prikaz_b2c='on' AND a.`mpcena`!='0.00' AND a2c.category_id IN (2,10,11,12,13,97,98,99,112,117,126,63,64,65,66,67,70,71,72,105,106,107,108,109,110,111,113,114,115,116,118,119,123,124,125,127,128,129,130,131,138,139,140) AND a.vodi_se_zaliha='' ) t1 ORDER BY ascase ASC, `id` DESC LIMIT 0, 24

Category query all:
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='HFO01PE040120G' THEN 0 WHEN a.sifra='HFO02PE040120F' THEN 1 WHEN a.sifra='HFO03PE060060O' THEN 2 WHEN a.sifra='HPL03WH082062C' THEN 3 WHEN a.sifra='HPL01WH082062C' THEN 4 WHEN a.sifra='HPL06WH117070C' THEN 5 WHEN a.sifra='HPL07WH070117C' THEN 6 WHEN a.sifra='OPO01BK029042C' THEN 7 WHEN a.sifra='HPL01BK075033C' THEN 8 WHEN a.sifra='HPL02BK033075C' THEN 9 WHEN a.sifra='OPL10BK090076C' THEN 10 WHEN a.sifra='HPL12BK117070C' THEN 11 WHEN a.sifra='HPL11BK070117C' THEN 12 WHEN a.sifra='HPL09BK086057C' THEN 13 WHEN a.sifra='HPL08BK086057C' THEN 14 WHEN a.sifra='OPO06BK040032C' THEN 15 WHEN a.sifra='OPO07BK040047C' THEN 16 WHEN a.sifra='HPL10BK074055C' THEN 17 WHEN a.sifra='OPL08BK300137C' THEN 18 ELSE 19 END as ascase FROM `artikli` a LEFT JOIN categories c ON c.id=a.category_id INNER JOIN artikli2category a2c ON a.`id` = a2c.`id_artikla` WHERE a.`id`!='0' AND a.`novo`!='on' AND a.`aktivan`='on' AND a.prikaz_b2c='on' AND a.`mpcena`!='0.00' AND a2c.category_id IN (2,10,11,12,13,97,98,99,112,117,126,63,64,65,66,67,70,71,72,105,106,107,108,109,110,111,113,114,115,116,118,119,123,124,125,127,128,129,130,131,138,139,140) UNION SELECT a.id,a.primaran,a.naziv,a.mpcena,CASE WHEN a.sifra='HFO01PE040120G' THEN 0 WHEN a.sifra='HFO02PE040120F' THEN 1 WHEN a.sifra='HFO03PE060060O' THEN 2 WHEN a.sifra='HPL03WH082062C' THEN 3 WHEN a.sifra='HPL01WH082062C' THEN 4 WHEN a.sifra='HPL06WH117070C' THEN 5 WHEN a.sifra='HPL07WH070117C' THEN 6 WHEN a.sifra='OPO01BK029042C' THEN 7 WHEN a.sifra='HPL01BK075033C' THEN 8 WHEN a.sifra='HPL02BK033075C' THEN 9 WHEN a.sifra='OPL10BK090076C' THEN 10 WHEN a.sifra='HPL12BK117070C' THEN 11 WHEN a.sifra='HPL11BK070117C' THEN 12 WHEN a.sifra='HPL09BK086057C' THEN 13 WHEN a.sifra='HPL08BK086057C' THEN 14 WHEN a.sifra='OPO06BK040032C' THEN 15 WHEN a.sifra='OPO07BK040047C' THEN 16 WHEN a.sifra='HPL10BK074055C' THEN 17 WHEN a.sifra='OPL08BK300137C' THEN 18 ELSE 19 END as ascase FROM `artikli` a LEFT JOIN categories c ON c.id=a.category_id INNER JOIN artikli2category a2c ON a.`id` = a2c.`id_artikla` WHERE a.`id`!='0' AND a.`novo`!='on' AND a.`aktivan`='on' AND a.prikaz_b2c='on' AND a.`mpcena`!='0.00' AND a2c.category_id IN (2,10,11,12,13,97,98,99,112,117,126,63,64,65,66,67,70,71,72,105,106,107,108,109,110,111,113,114,115,116,118,119,123,124,125,127,128,129,130,131,138,139,140) AND a.vodi_se_zaliha='' ) t1 ORDER BY ascase ASC, `id` DESC