Grupe delova || Grejne ploče || Standardne

SELECT t1.id FROM (SELECT a.*,CASE WHEN a.sifra='530101' THEN 0 WHEN a.sifra='530173' THEN 1 WHEN a.sifra='530174' THEN 2 WHEN a.sifra='530175' THEN 3 WHEN a.sifra='530106' THEN 4 WHEN a.sifra='530177' THEN 5 WHEN a.sifra='530178' THEN 6 WHEN a.sifra='530185' THEN 7 WHEN a.sifra='530180' THEN 8 WHEN a.sifra='530183' THEN 9 WHEN a.sifra='530182' THEN 10 WHEN a.sifra='530196' THEN 11 WHEN a.sifra='530195' THEN 12 WHEN a.sifra='530190' THEN 13 WHEN a.sifra='530136' THEN 14 WHEN a.sifra='530192' THEN 15 WHEN a.sifra='530193' THEN 16 WHEN a.sifra='530194' THEN 17 WHEN a.sifra='530114' THEN 18 WHEN a.sifra='530169' THEN 19 WHEN a.sifra='530115' THEN 20 WHEN a.sifra='530197' THEN 21 WHEN a.sifra='530116' THEN 22 WHEN a.sifra='530186' THEN 23 WHEN a.sifra='530142' THEN 24 WHEN a.sifra='530147' THEN 25 WHEN a.sifra='530143' THEN 26 WHEN a.sifra='530176' THEN 27 ELSE 28 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 (273) UNION SELECT a.*,CASE WHEN a.sifra='530101' THEN 0 WHEN a.sifra='530173' THEN 1 WHEN a.sifra='530174' THEN 2 WHEN a.sifra='530175' THEN 3 WHEN a.sifra='530106' THEN 4 WHEN a.sifra='530177' THEN 5 WHEN a.sifra='530178' THEN 6 WHEN a.sifra='530185' THEN 7 WHEN a.sifra='530180' THEN 8 WHEN a.sifra='530183' THEN 9 WHEN a.sifra='530182' THEN 10 WHEN a.sifra='530196' THEN 11 WHEN a.sifra='530195' THEN 12 WHEN a.sifra='530190' THEN 13 WHEN a.sifra='530136' THEN 14 WHEN a.sifra='530192' THEN 15 WHEN a.sifra='530193' THEN 16 WHEN a.sifra='530194' THEN 17 WHEN a.sifra='530114' THEN 18 WHEN a.sifra='530169' THEN 19 WHEN a.sifra='530115' THEN 20 WHEN a.sifra='530197' THEN 21 WHEN a.sifra='530116' THEN 22 WHEN a.sifra='530186' THEN 23 WHEN a.sifra='530142' THEN 24 WHEN a.sifra='530147' THEN 25 WHEN a.sifra='530143' THEN 26 WHEN a.sifra='530176' THEN 27 ELSE 28 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 (273) ) t1 ORDER BY ascase ASC, t1.`sifra` ASC LIMIT 0, 24