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-13<br>3.50-8    46J
    Dodaj
    v košarico
  • MITAS B-4
    2 1/4-18 (2.25-18) 42J

    34,04 € 23,83 €
    MITAS B-4<br>2 1/4-18 (2.25-18) 42J
    Dodaj
    v košarico
  • MITAS B-3
    2 1/2-18 (2.50-18) 43J

    34,89 € 24,42 €
    MITAS B-3<br>2 1/2-18 (2.50-18) 43J
    Dodaj
    v košarico
  • MITAS B-4
    2 1/2-17 (2.50-17) 43J

    35,62 € 24,94 €
    MITAS B-4<br>2 1/2-17 (2.50-17) 43J
    Dodaj
    v košarico
  • MITAS B-13
    4.00-8C 66N

    35,75 € 25,02 €
    MITAS B-13<br>4.00-8C 66N
    Dodaj
    v košarico
  • MITAS B-13
    4.00-8C 71J

    36,48 € 25,53 €
    MITAS B-13<br>4.00-8C  71J
    Dodaj
    v košarico
  • MITAS B-14
    3.50-10 59J

    36,60 € 25,62 €
    MITAS B-14<br>3.50-10 59J
    Dodaj
    v košarico
  • MITAS MC-2
    2 1/2-16 (2.50-16) 42J

    37,82 € 26,47 €
    MITAS MC-2<br>2 1/2-16 (2.50-16) 42J
    Dodaj
    v košarico
  • MITAS MC-11
    2 1/2-17 (2.50-17) 43J

    37,82 € 26,47 €
    MITAS MC-11<br>2 1/2-17 (2.50-17) 43J
    Dodaj
    v košarico