Rendezés
Találatok száma: 10
  • OT241BK 5200mAH akku

    OT241BK 5200mAH akku Ozaki

    OZAKI0438
    Ár: / Price
    19490 Ft (27% áfával)

  • OT240AB 2600mAH akku

    OT240AB 2600mAH akku Ozaki

    OZAKI0388
    Ár: / Price
    12290 Ft (27% áfával)

  • OT240PK 2600mAH akku

    OT240PK 2600mAH akku Ozaki

    OZAKI0387
    Ár: / Price
    12290 Ft (27% áfával)

  • OT240BU 2600mAH akku

    OT240BU 2600mAH akku Ozaki

    OZAKI0386
    Ár: / Price
    12290 Ft (27% áfával)

  • PP268AGD Gum++ AL/GD 6000mAh

    PP268AGD Gum++ AL/GD 6000mAh Just Mobile

    JUST092
    Ár: / Price
    21990 Ft (27% áfával)

  • PP268AGY Gum++ AL/GY 6000mAh

    PP268AGY Gum++ AL/GY 6000mAh Just Mobile

    JUST091
    Ár: / Price
    21990 Ft (27% áfával)

  • PP268ABK Gum++ AL/BK 6000mAh

    PP268ABK Gum++ AL/BK 6000mAh Just Mobile

    JUST090
    Ár: / Price
    21990 Ft (27% áfával)

  • PP600GD TopGum GOLD 6000mAh

    PP600GD TopGum GOLD 6000mAh Just Mobile

    JUST079
    Ár: / Price
    19990 Ft (27% áfával)

  • PP600SI TopGum SL&BK 6000mAh

    PP600SI TopGum SL&BK 6000mAh Just Mobile

    JUST078
    Ár: / Price
    19990 Ft (27% áfával)

  • PP828 Gum Max Duo 11200 akku

    PP828 Gum Max Duo 11200 akku Just Mobile

    JUST050
    Ár: / Price
    36990 Ft (27% áfával)

  • SELECT web_termek_torzs.TermekKod FROM `web_termek_torzs`,`web_termek_szovegek`,`web_listaar` LEFT OUTER JOIN web_keszlet ON (web_keszlet.CegKod = web_listaar.CegKod AND web_keszlet.TermekKod = web_listaar.TermekKod AND web_keszlet.Raktar = 0) ,`web_termek_kategoria` WHERE web_termek_torzs.CegKod = "STEELBIRD" AND web_termek_szovegek.CegKod = "STEELBIRD" AND web_listaar.CegKod = "STEELBIRD" AND web_termek_kategoria.CegKod = "STEELBIRD" AND LENGTH(web_termek_torzs.TermekKod) > 2 AND web_termek_torzs.TermekKod = web_termek_szovegek.TermekKod AND web_termek_torzs.TermekKod = web_listaar.TermekKod AND web_listaar.AlapAr >= 0 AND (web_keszlet.Mennyiseg > 0 OR web_termek_torzs.Statusza = "R") AND web_termek_torzs.TermekKod = web_termek_kategoria.TermekKod AND web_termek_torzs.Statusza IN ('R','V') AND web_termek_szovegek.Nyelv = "HUN" AND (web_termek_torzs.seria_value = "" OR (web_termek_torzs.seria_value <> "" AND web_termek_torzs.seria_list_show = "1")) AND web_termek_kategoria.Kod LIKE "OM%" GROUP BY TermekKod ORDER BY TermekKod DESC LIMIT 0,60