SELECT SQL_CALC_FOUND_ROWS ident,
CONCAT(znamka,' ',komercialno_ime,'
',naziv) as naziv,
slika_1 as slika ,
cena * 1.22 AS cena_z_ddv,
cena_pred_akcijo * 1.22 as cena_pred_akcijo,
znamka
FROM _produkti_moto_gume
WHERE znamka = 'MITAS'
ORDER BY cena LIMIT 9,9
MITAS B-13
3.50-8 46J
32,45 € 22,72 €
MITAS B-4
2 1/4-18 (2.25-18) 42J
34,04 € 23,83 €
MITAS B-3
2 1/2-18 (2.50-18) 43J
34,89 € 24,42 €
MITAS B-4
2 1/2-17 (2.50-17) 43J
35,62 € 24,94 €
MITAS B-13
4.00-8C 66N
35,75 € 25,02 €
MITAS B-13
4.00-8C 71J
36,48 € 25,53 €
MITAS B-14
3.50-10 59J
36,60 € 25,62 €
MITAS MC-2
2 1/2-16 (2.50-16) 42J
37,82 € 26,47 €
MITAS MC-11
2 1/2-17 (2.50-17) 43J
37,82 € 26,47 €