Találatok száma: : 18
Erre keresett: ot2
  • OT222AGD 1m USB-Lightning Ozaki

    OZAKI0713
    OT222AGD 1m USB-Lightning
    Ár: / Price
    8990 Ft (27% áfával)

    Kosárba / Add to cart
  • OT222ARG 1m USB-Lightning Ozaki

    OZAKI0712
    OT222ARG 1m USB-Lightning
    Ár: / Price
    8990 Ft (27% áfával)

    Kosárba / Add to cart
  • OT290BKEN O!tool-KeePad Ozaki

    OZAKI0656
    OT290BKEN O!tool-KeePad
    Ár: / Price
    29990 Ft (27% áfával)

    Kosárba / Add to cart
  • OT282CBK 2.1Car Charger 90cm Ozaki

    OZAKI0622
    OT282CBK  2.1Car Charger 90cm
    Ár: / Price
    14990 Ft (27% áfával)

    Kosárba / Add to cart
  • OT227WH Combo Cable+ Ozaki

    OZAKI0612
    OT227WH Combo Cable+
    Ár: / Price
    7990 Ft (27% áfával)

    Kosárba / Add to cart
  • OT227BK Combo Cable+ Ozaki

    OZAKI0611
    OT227BK Combo Cable+
    Ár: / Price
    5990 Ft (27% áfával)

    Kosárba / Add to cart
  • OT281WBK 4.2 Dual Car Charger Ozaki

    OZAKI0606
    OT281WBK 4.2 Dual Car Charger
    Ár: / Price
    7490 Ft (27% áfával)

    Kosárba / Add to cart
  • OT281LBK 4.2 Dual Car Charger Ozaki

    OZAKI0604
    OT281LBK 4.2 Dual Car Charger
    Ár: / Price
    7490 Ft (27% áfával)

    Kosárba / Add to cart
  • OT281CBK 4.2 Dual Car Charger Ozaki

    OZAKI0603
    OT281CBK 4.2 Dual Car Charger
    Ár: / Price
    7490 Ft (27% áfával)

    Kosárba / Add to cart
  • OT280LBK 2.4 Car Charger Ozaki

    OZAKI0602
    OT280LBK  2.4 Car Charger
    Ár: / Price
    5990 Ft (27% áfával)

    Kosárba / Add to cart
  • OT221ABK 10cm USB-Lightning Ozaki

    OZAKI0578
    OT221ABK 10cm USB-Lightning
    Ár: / Price
    7990 Ft (27% áfával)

    Kosárba / Add to cart
  • OT225WH O!tool-Combo Cable WH Ozaki

    OZAKI0463
    OT225WH O!tool-Combo Cable WH
    Ár: / Price
    8990 Ft (27% áfával)

    Kosárba / Add to cart
  • OT225BK O!tool-Combo Cable BK Ozaki

    OZAKI0462
    OT225BK O!tool-Combo Cable BK
    Ár: / Price
    4990 Ft (27% áfával)

    Kosárba / Add to cart
  • OT241BK 5200mAH akku Ozaki

    OZAKI0438
    OT241BK 5200mAH akku
    Ár: / Price
    24990 Ft (27% áfával)

    Kosárba / Add to cart
  • OT241WH 5200mAH akku Ozaki

    OZAKI0389
    OT241WH 5200mAH akku
    Ár: / Price
    24900 Ft (27% áfával)

    Kosárba / Add to cart
  • OT240AB 2600mAH akku Ozaki

    OZAKI0388
    OT240AB 2600mAH akku
    Ár: / Price
    17990 Ft (27% áfával)

    Kosárba / Add to cart
  • OT240PK 2600mAH akku Ozaki

    OZAKI0387
    OT240PK 2600mAH akku
    Ár: / Price
    17990 Ft (27% áfával)

    Kosárba / Add to cart
  • OT240BU 2600mAH akku Ozaki

    OZAKI0386
    OT240BU 2600mAH akku
    Ár: / Price
    17990 Ft (27% áfával)

    Kosárba / Add to cart
  • 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 (( ( (LCASE(concat_ws(' ',web_termek_torzs.TermekKod,web_termek_torzs.MgTermekKod,web_termek_szovegek.TermekNev,web_termek_szovegek.NevMasodik,web_termek_szovegek.NevHarmadik,web_termek_szovegek.Megjegyzes) ) LIKE '%ot2%' ) ) ) OR ( web_termek_torzs.TermekKod = "%ot2%" )) GROUP BY TermekKod ORDER BY TermekKod DESC LIMIT 0,60