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 MC-12
    3.00-10

    27,82 € 19,47 €
    MITAS MC-12<br>3.00-10
    Dodaj
    v košarico
  • MITAS B-4
    2 1/4-18 (2.25-18)

    27,82 € 19,47 €
    MITAS B-4<br>2 1/4-18 (2.25-18)
    Dodaj
    v košarico
  • MITAS B-13
    3.50-8

    28,06 € 19,64 €
    MITAS B-13<br>3.50-8
    Dodaj
    v košarico
  • MITAS B-3
    2 1/2-18 (2.50-18)

    28,55 € 19,98 €
    MITAS B-3<br>2 1/2-18 (2.50-18)
    Dodaj
    v košarico
  • MITAS MC-26 CAPRI
    80/80-16

    30,87 € 21,61 €
    MITAS MC-26 CAPRI<br>80/80-16
    Dodaj
    v košarico
  • MITAS B-13
    4.00-8C

    30,87 € 21,61 €
    MITAS B-13<br>4.00-8C
    Dodaj
    v košarico
  • MITAS MC-2
    2 1/2-16 (2.50-16)

    30,87 € 21,61 €
    MITAS MC-2<br>2 1/2-16 (2.50-16)
    Dodaj
    v košarico
  • MITAS MC-11
    2 1/2-17 (2.50-17)

    30,87 € 21,61 €
    MITAS MC-11<br>2 1/2-17 (2.50-17)
    Dodaj
    v košarico
  • MITAS B-13
    4.00-8C

    31,48 € 22,03 €
    MITAS B-13<br>4.00-8C
    Dodaj
    v košarico