Grupe delova || Kondenzatori
Filteri
Aktivni filteri
Slika
Šifra
Artikal
Cena
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.`prikaz_b2c`='on'
AND a.`mpcena`!='0.00'
AND a2c.`category_id` IN (275) AND (a.`filter` LIKE "%a2134a%" AND a2c.`category_id` IN (275) )
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.`prikaz_b2c`='on'
AND a.`mpcena`!='0.00'
AND a2c.`category_id` IN (275) AND (a.`filter` LIKE "%a2134a%" AND a2c.`category_id` IN (275) )
AND a.vodi_se_zaliha='') t1
ORDER BY ascase ASC, t1.`sifra` ASC LIMIT 0, 24
Kategorija je prazna