Jen tento týden >> Zemětřesení cen: slevy 20-70% na vše Nakoupit nejvýhodněji >>>

Slevy obuvi a kabelek Iberius

(skladem 132 modelů)
předchozí12233...66další
předchozí12233...66další
DATABASE error - details in debug mail for administratorERR2: MySQL server has gone away
SELECT DISTINCT i.*, it0.value AS item_poznamka ,it1.value AS item_poznamka1 ,it2.value AS item_priority ,it3.value AS item_sezona ,it4.value AS item_poznamka2 ,it5.value AS item_svrsek ,it6.value AS item_podsivka ,it7.value AS item_podesev ,it8.value AS item_model ,it9.value AS item_sire ,it10.value AS item_typpodesve ,it11.value AS item_znacka ,it12.value AS item_slevapct ,it13.value AS item_vysepodesve ,it14.value AS item_vysepodpatku ,it15.value AS item_sez ,it16.value AS item_stelka_z_pametove_peny ,it17.value AS item_texova_membrana ,it18.value AS item_zateplena ,it19.value AS item_prava_ovci_vlna ,it20.value AS item_vyjimatelna_stelka ,it21.value AS item_stitek ,it22.value AS item_typobuvi ,it23.value AS item_global_code ,it24.value AS item_neprodejne ,it25.value AS item_dod_kod ,it26.value AS item_vyska_boty ,it27.value AS item_vyrobni_zpusob ,it28.value AS item_sire_lytka ,it29.value AS item_kabelky_vyska ,it30.value AS item_kabelky_sirka ,it31.value AS item_format_a4 ,it32.value AS item_vrchni_zip ,it33.value AS item_odepinatelny_popruh ,itc.costw AS item_cost, itc.vat_rate FROM ineshop_items i LEFT JOIN ineshop_item_text it0 ON (i.item_code=it0.item_code AND it0.text_name='poznamka.cs_CZ') LEFT JOIN ineshop_item_text it1 ON (i.item_code=it1.item_code AND it1.text_name='poznamka1.cs_CZ') LEFT JOIN ineshop_item_text it2 ON (i.item_code=it2.item_code AND it2.text_name='priority.cs_CZ') LEFT JOIN ineshop_item_text it3 ON (i.item_code=it3.item_code AND it3.text_name='sezona.cs_CZ') LEFT JOIN ineshop_item_text it4 ON (i.item_code=it4.item_code AND it4.text_name='poznamka2.cs_CZ') LEFT JOIN ineshop_item_text it5 ON (i.item_code=it5.item_code AND it5.text_name='svrsek.cs_CZ') LEFT JOIN ineshop_item_text it6 ON (i.item_code=it6.item_code AND it6.text_name='podsivka.cs_CZ') LEFT JOIN ineshop_item_text it7 ON (i.item_code=it7.item_code AND it7.text_name='podesev.cs_CZ') LEFT JOIN ineshop_item_text it8 ON (i.item_code=it8.item_code AND it8.text_name='model.cs_CZ') LEFT JOIN ineshop_item_text it9 ON (i.item_code=it9.item_code AND it9.text_name='sire.cs_CZ') LEFT JOIN ineshop_item_text it10 ON (i.item_code=it10.item_code AND it10.text_name='typpodesve.cs_CZ') LEFT JOIN ineshop_item_text it11 ON (i.item_code=it11.item_code AND it11.text_name='znacka.cs_CZ') LEFT JOIN ineshop_item_text it12 ON (i.item_code=it12.item_code AND it12.text_name='slevapct.cs_CZ') LEFT JOIN ineshop_item_text it13 ON (i.item_code=it13.item_code AND it13.text_name='vysepodesve.cs_CZ') LEFT JOIN ineshop_item_text it14 ON (i.item_code=it14.item_code AND it14.text_name='vysepodpatku.cs_CZ') LEFT JOIN ineshop_item_text it15 ON (i.item_code=it15.item_code AND it15.text_name='sez.cs_CZ') LEFT JOIN ineshop_item_text it16 ON (i.item_code=it16.item_code AND it16.text_name='stelka_z_pametove_peny.cs_CZ') LEFT JOIN ineshop_item_text it17 ON (i.item_code=it17.item_code AND it17.text_name='texova_membrana.cs_CZ') LEFT JOIN ineshop_item_text it18 ON (i.item_code=it18.item_code AND it18.text_name='zateplena.cs_CZ') LEFT JOIN ineshop_item_text it19 ON (i.item_code=it19.item_code AND it19.text_name='prava_ovci_vlna.cs_CZ') LEFT JOIN ineshop_item_text it20 ON (i.item_code=it20.item_code AND it20.text_name='vyjimatelna_stelka.cs_CZ') LEFT JOIN ineshop_item_text it21 ON (i.item_code=it21.item_code AND it21.text_name='stitek.cs_CZ') LEFT JOIN ineshop_item_text it22 ON (i.item_code=it22.item_code AND it22.text_name='typobuvi.cs_CZ') LEFT JOIN ineshop_item_text it23 ON (i.item_code=it23.item_code AND it23.text_name='global_code.cs_CZ') LEFT JOIN ineshop_item_text it24 ON (i.item_code=it24.item_code AND it24.text_name='neprodejne.cs_CZ') LEFT JOIN ineshop_item_text it25 ON (i.item_code=it25.item_code AND it25.text_name='dod_kod.cs_CZ') LEFT JOIN ineshop_item_text it26 ON (i.item_code=it26.item_code AND it26.text_name='vyska_boty.cs_CZ') LEFT JOIN ineshop_item_text it27 ON (i.item_code=it27.item_code AND it27.text_name='vyrobni_zpusob.cs_CZ') LEFT JOIN ineshop_item_text it28 ON (i.item_code=it28.item_code AND it28.text_name='sire_lytka.cs_CZ') LEFT JOIN ineshop_item_text it29 ON (i.item_code=it29.item_code AND it29.text_name='kabelky_vyska.cs_CZ') LEFT JOIN ineshop_item_text it30 ON (i.item_code=it30.item_code AND it30.text_name='kabelky_sirka.cs_CZ') LEFT JOIN ineshop_item_text it31 ON (i.item_code=it31.item_code AND it31.text_name='format_a4.cs_CZ') LEFT JOIN ineshop_item_text it32 ON (i.item_code=it32.item_code AND it32.text_name='vrchni_zip.cs_CZ') LEFT JOIN ineshop_item_text it33 ON (i.item_code=it33.item_code AND it33.text_name='odepinatelny_popruh.cs_CZ') LEFT JOIN ineshop_costs itc ON (i.item_code=itc.item_code AND itc.cost_name='3' ) LEFT JOIN ineshop_enabled_items ei ON ei.item_code=i.item_code LEFT JOIN ineshop_gifts gft ON gft.gift_code=i.item_code LEFT JOIN ineshop_item_promo iprm ON iprm.item_code=i.item_code WHERE ei.enabled=1 AND gft.gift_code IS NULL AND i.item_count>0 AND (iprm.promo_id='sale' ) ORDER BY item_cost , item_code DATABASE error - details in debug mail for administratorERR2: MySQL server has gone away
SELECT DISTINCT i.*, it0.value AS item_poznamka ,it1.value AS item_poznamka1 ,it2.value AS item_priority ,it3.value AS item_sezona ,it4.value AS item_poznamka2 ,it5.value AS item_svrsek ,it6.value AS item_podsivka ,it7.value AS item_podesev ,it8.value AS item_model ,it9.value AS item_sire ,it10.value AS item_typpodesve ,it11.value AS item_znacka ,it12.value AS item_slevapct ,it13.value AS item_vysepodesve ,it14.value AS item_vysepodpatku ,it15.value AS item_sez ,it16.value AS item_stelka_z_pametove_peny ,it17.value AS item_texova_membrana ,it18.value AS item_zateplena ,it19.value AS item_prava_ovci_vlna ,it20.value AS item_vyjimatelna_stelka ,it21.value AS item_stitek ,it22.value AS item_typobuvi ,it23.value AS item_global_code ,it24.value AS item_neprodejne ,it25.value AS item_dod_kod ,it26.value AS item_vyska_boty ,it27.value AS item_vyrobni_zpusob ,it28.value AS item_sire_lytka ,it29.value AS item_kabelky_vyska ,it30.value AS item_kabelky_sirka ,it31.value AS item_format_a4 ,it32.value AS item_vrchni_zip ,it33.value AS item_odepinatelny_popruh ,itc.costw AS item_cost, itc.vat_rate FROM ineshop_items i LEFT JOIN ineshop_item_text it0 ON (i.item_code=it0.item_code AND it0.text_name='poznamka.cs_CZ') LEFT JOIN ineshop_item_text it1 ON (i.item_code=it1.item_code AND it1.text_name='poznamka1.cs_CZ') LEFT JOIN ineshop_item_text it2 ON (i.item_code=it2.item_code AND it2.text_name='priority.cs_CZ') LEFT JOIN ineshop_item_text it3 ON (i.item_code=it3.item_code AND it3.text_name='sezona.cs_CZ') LEFT JOIN ineshop_item_text it4 ON (i.item_code=it4.item_code AND it4.text_name='poznamka2.cs_CZ') LEFT JOIN ineshop_item_text it5 ON (i.item_code=it5.item_code AND it5.text_name='svrsek.cs_CZ') LEFT JOIN ineshop_item_text it6 ON (i.item_code=it6.item_code AND it6.text_name='podsivka.cs_CZ') LEFT JOIN ineshop_item_text it7 ON (i.item_code=it7.item_code AND it7.text_name='podesev.cs_CZ') LEFT JOIN ineshop_item_text it8 ON (i.item_code=it8.item_code AND it8.text_name='model.cs_CZ') LEFT JOIN ineshop_item_text it9 ON (i.item_code=it9.item_code AND it9.text_name='sire.cs_CZ') LEFT JOIN ineshop_item_text it10 ON (i.item_code=it10.item_code AND it10.text_name='typpodesve.cs_CZ') LEFT JOIN ineshop_item_text it11 ON (i.item_code=it11.item_code AND it11.text_name='znacka.cs_CZ') LEFT JOIN ineshop_item_text it12 ON (i.item_code=it12.item_code AND it12.text_name='slevapct.cs_CZ') LEFT JOIN ineshop_item_text it13 ON (i.item_code=it13.item_code AND it13.text_name='vysepodesve.cs_CZ') LEFT JOIN ineshop_item_text it14 ON (i.item_code=it14.item_code AND it14.text_name='vysepodpatku.cs_CZ') LEFT JOIN ineshop_item_text it15 ON (i.item_code=it15.item_code AND it15.text_name='sez.cs_CZ') LEFT JOIN ineshop_item_text it16 ON (i.item_code=it16.item_code AND it16.text_name='stelka_z_pametove_peny.cs_CZ') LEFT JOIN ineshop_item_text it17 ON (i.item_code=it17.item_code AND it17.text_name='texova_membrana.cs_CZ') LEFT JOIN ineshop_item_text it18 ON (i.item_code=it18.item_code AND it18.text_name='zateplena.cs_CZ') LEFT JOIN ineshop_item_text it19 ON (i.item_code=it19.item_code AND it19.text_name='prava_ovci_vlna.cs_CZ') LEFT JOIN ineshop_item_text it20 ON (i.item_code=it20.item_code AND it20.text_name='vyjimatelna_stelka.cs_CZ') LEFT JOIN ineshop_item_text it21 ON (i.item_code=it21.item_code AND it21.text_name='stitek.cs_CZ') LEFT JOIN ineshop_item_text it22 ON (i.item_code=it22.item_code AND it22.text_name='typobuvi.cs_CZ') LEFT JOIN ineshop_item_text it23 ON (i.item_code=it23.item_code AND it23.text_name='global_code.cs_CZ') LEFT JOIN ineshop_item_text it24 ON (i.item_code=it24.item_code AND it24.text_name='neprodejne.cs_CZ') LEFT JOIN ineshop_item_text it25 ON (i.item_code=it25.item_code AND it25.text_name='dod_kod.cs_CZ') LEFT JOIN ineshop_item_text it26 ON (i.item_code=it26.item_code AND it26.text_name='vyska_boty.cs_CZ') LEFT JOIN ineshop_item_text it27 ON (i.item_code=it27.item_code AND it27.text_name='vyrobni_zpusob.cs_CZ') LEFT JOIN ineshop_item_text it28 ON (i.item_code=it28.item_code AND it28.text_name='sire_lytka.cs_CZ') LEFT JOIN ineshop_item_text it29 ON (i.item_code=it29.item_code AND it29.text_name='kabelky_vyska.cs_CZ') LEFT JOIN ineshop_item_text it30 ON (i.item_code=it30.item_code AND it30.text_name='kabelky_sirka.cs_CZ') LEFT JOIN ineshop_item_text it31 ON (i.item_code=it31.item_code AND it31.text_name='format_a4.cs_CZ') LEFT JOIN ineshop_item_text it32 ON (i.item_code=it32.item_code AND it32.text_name='vrchni_zip.cs_CZ') LEFT JOIN ineshop_item_text it33 ON (i.item_code=it33.item_code AND it33.text_name='odepinatelny_popruh.cs_CZ') LEFT JOIN ineshop_costs itc ON (i.item_code=itc.item_code AND itc.cost_name='3' ) LEFT JOIN ineshop_enabled_items ei ON ei.item_code=i.item_code LEFT JOIN ineshop_gifts gft ON gft.gift_code=i.item_code LEFT JOIN ineshop_item_promo iprm ON iprm.item_code=i.item_code WHERE ei.enabled=1 AND gft.gift_code IS NULL AND i.item_count>0 AND (iprm.promo_id='sale' ) ORDER BY CAST(item_slevapct AS SIGNED) DESC , item_code
Filtry

Model

  • Dámská (132)
  • Pánská (0)

Typ obuvi

  • Baleríny (9)
  • Kotníkové (29)
  • Kozačky (0)
  • Lodičky (5)
  • Mokasíny (14)
  • Nazouváky (6)
  • Pantofle (6)
  • Polobotky (21)
  • Sandály (53)
  • Tenisky (10)
  • Žabky (0)

Velikost

  • 36 (20)
  • 37 (66)
  • 37,5 (0)
  • 38 (58)
  • 39 (83)
  • 40 (73)
  • 41 (33)
  • 42 (42)
  • 43 (0)
  • 44 (0)
  • 45 (0)
  • 46 (0)
  • 47 (0)
  • 48 (0)
  • 49 (0)
  • 50 (0)
  • -UNI- (0)

Barva

  • béžová
  • bílá
  • bronzová
  • černá
  • červená
  • fialová
  • hnědá
  • modrá
  • multicolor
  • oranžová
  • růžová
  • stříbrná
  • šedá
  • vínová
  • zelená
  • zlatá
  • žlutá

Značka

  • Bugatti (+61)
  • Caprice (+24)
  • Carinii (+15)
  • Cedar (+1)
  • Desigual (+5)
  • Gabor (+2)
  • Geox (+2)
  • Iberius (132)
  • Jana (+64)
  • Josef Seibel (+44)
  • Mustang (+24)
  • Nobo (+1)
  • Pikolinos (+1)
  • Rieker (+2721)
  • Tamaris (+1463)

Sezóna

  • Celoroční (42)
  • Jarní (42)
  • Letní (61)
  • Podzimní (42)
  • Zimní (29)

Typ podešve

  • Bez podpatku (77)
  • Na klínku (40)
  • Na platformě (10)
  • Na podpatku (5)

Šíře boty

  • F (úzká) (0)
  • G (běžná) (132)
  • H (široká) (0)
  • K (extra široká) (0)

Typ kabelky

  • Batoh (0)
  • Crossbody (0)
  • Do ruky (0)
  • Přes rameno (0)

Vlastnosti kabelky

  • Odepínatelný popruh (0)
  • Pojme formát A4 (0)
  • Vrchní zip (0)

Svršek

  • Kůže (132)
  • Syntetika (0)
  • Textil (0)

Typ zateplení

  • Pravá ovčí vlna (0)
  • S kožíškem (0)
  • Zateplená (4)

Vlastnosti stélky

  • Stélka z paměťové pěny (1)
  • Vyjímatelná stélka (4)

Výrobní způsob

  • Lepená obuv (67)
  • Šitá obuv (65)

Ostatní

  • Texová membrána (0)

Cena

-

Výše podešve

-

Výše podpatku

-

+420 575 570 941

Po - Pá 8:00 - 16:00

0 ks
Košík: 0
0 ks