Grupe delova || Grejne ploče || Industrijske

SELECT t1.id FROM (SELECT a.*,CASE WHEN a.sifra='530158' THEN 0 WHEN a.sifra='530160' THEN 1 WHEN a.sifra='530154' THEN 2 WHEN a.sifra='530156' THEN 3 WHEN a.sifra='530148' THEN 4 WHEN a.sifra='530153' THEN 5 WHEN a.sifra='530149' THEN 6 WHEN a.sifra='530164' THEN 7 WHEN a.sifra='530150' THEN 8 WHEN a.sifra='530152' THEN 9 WHEN a.sifra='530151' THEN 10 WHEN a.sifra='530159' THEN 11 WHEN a.sifra='530170' THEN 12 WHEN a.sifra='530168' THEN 13 WHEN a.sifra='530157' THEN 14 WHEN a.sifra='530166' THEN 15 WHEN a.sifra='530181' THEN 16 WHEN a.sifra='530163' THEN 17 WHEN a.sifra='530167' THEN 18 WHEN a.sifra='530165' THEN 19 WHEN a.sifra='530162' THEN 20 WHEN a.sifra='530161' THEN 21 ELSE 22 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 a.`vpcena`!='0.00' AND a2c.`category_id` IN (274) UNION SELECT a.*,CASE WHEN a.sifra='530158' THEN 0 WHEN a.sifra='530160' THEN 1 WHEN a.sifra='530154' THEN 2 WHEN a.sifra='530156' THEN 3 WHEN a.sifra='530148' THEN 4 WHEN a.sifra='530153' THEN 5 WHEN a.sifra='530149' THEN 6 WHEN a.sifra='530164' THEN 7 WHEN a.sifra='530150' THEN 8 WHEN a.sifra='530152' THEN 9 WHEN a.sifra='530151' THEN 10 WHEN a.sifra='530159' THEN 11 WHEN a.sifra='530170' THEN 12 WHEN a.sifra='530168' THEN 13 WHEN a.sifra='530157' THEN 14 WHEN a.sifra='530166' THEN 15 WHEN a.sifra='530181' THEN 16 WHEN a.sifra='530163' THEN 17 WHEN a.sifra='530167' THEN 18 WHEN a.sifra='530165' THEN 19 WHEN a.sifra='530162' THEN 20 WHEN a.sifra='530161' THEN 21 ELSE 22 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 a.`vpcena`!='0.00' AND a2c.`category_id` IN (274) ) t1 ORDER BY ascase ASC, t1.`sifra` ASC LIMIT 0, 24