Korda


Plumb cu Vartej KORDA Distance Casting Swivel, 2.5oz/70g, 1buc/pac

Plumb cu Vartej KORDA Distance Casting Swivel, 2.5oz/70g, 1buc/pac

dcs25
Livrare 7-14 zile

13,66Lei

Pantaloni KORDA Thermal Leggings, Olive, Marime M

Pantaloni KORDA Thermal Leggings, Olive, Marime M

kcl313
Livrare 7-14 zile

178,89Lei

Hanger KORDA Black & Whites Bobbin, White, Size XL

Hanger KORDA Black & Whites Bobbin, White, Size XL

kbxlw
Livrare 7-14 zile

176,35Lei

Carlig Korda CHODDY NR.4 10BUC/PLIC

Carlig Korda CHODDY NR.4 10BUC/PLIC

kch4
Livrare imediată!

33,90Lei

BORCAN ETANS PENTRU DIPUIT KORDA

BORCAN ETANS PENTRU DIPUIT KORDA

kinzl
Livrare imediată!

43,41Lei

Montura KORDA Carp Rig Dark Matter Wide Gape + Free Extenda Stops, Barbless, 1buc/blister Nr.4/20lbs
Lant Rezerva cu Adaptor Hanger KORDA Stow , Long

Lant Rezerva cu Adaptor Hanger KORDA Stow , Long

keb16
Livrare 7-14 zile

46,71Lei

Opritoare Tungsten Korda Green, L, 9buc/plic

Opritoare Tungsten Korda Green, L, 9buc/plic

ksklg
Livrare imediată!

24,50Lei

CIRLIGE KORDA CHODDY NR.8 10BUC/PLIC

CIRLIGE KORDA CHODDY NR.8 10BUC/PLIC

kch8
Livrare imediată!

33,90Lei

Maner Cantar KORDA Singlez T Bar

Maner Cantar KORDA Singlez T Bar

ksing16
Livrare 7-14 zile

168,26Lei

CON PLUMB PIERDUT KORDA CULOARE SILT 10BUC

CON PLUMB PIERDUT KORDA CULOARE SILT 10BUC

krs
Livrare imediată!

26,93Lei

Montura Elicopter KORDA Dark Matter Leader Heli, Gravel, 40lbs, 1m

Montura Elicopter KORDA Dark Matter Leader Heli, Gravel, 40lbs, 1m

ksz46
Livrare 7-14 zile

41,62Lei

Croseta Korda Braid Needle Pentru Monturi

Croseta Korda Braid Needle Pentru Monturi

kbnb
Livrare imediată!

24,03Lei

Carlige KORDA Wide Gape, Barbless, Nr.2, 10buc/plic

Carlige KORDA Wide Gape, Barbless, Nr.2, 10buc/plic

kwgb2
Livrare 7-14 zile

36,54Lei

OCHELARI KORDA OLIVE YELLOW

OCHELARI KORDA OLIVE YELLOW

a8.k4d02
Livrare imediată!

165,85Lei

Plumb KORDA Square Pear Swivel, 1.5oz/42gr, 1buc/pac

Plumb KORDA Square Pear Swivel, 1.5oz/42gr, 1buc/pac

sqps15
Livrare 7-14 zile

13,66Lei

Atractant Korda Goo Scopex Cream Smoke 115 ML

Atractant Korda Goo Scopex Cream Smoke 115 ML

kgoo30
Livrare imediată!

95,15Lei

Pelete Artificiale KORDA Slow Sinking Dumbell, IB, Yellow, 16mm, 5buc/pac

Pelete Artificiale KORDA Slow Sinking Dumbell, IB, Yellow, 16mm, 5buc/pac

kpb37
Livrare 7-14 zile

23,82Lei

Atractant Korda GOO Bait Smoke 115ml KRILL SUPREME

Atractant Korda GOO Bait Smoke 115ml KRILL SUPREME

goo36
Livrare imediată!

98,33Lei

Plumb Casting KORDA Tournament Casting Swivel, 6oz/168g, 1buc/pac

Plumb Casting KORDA Tournament Casting Swivel, 6oz/168g, 1buc/pac

tcs6
Livrare 7-14 zile

19,76Lei

Afişare 1221 - 1240 din 1636 (82 pagini)
💬
WhatsApp Chat
👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)
Queries: 7, Total time: 110.719 ms [By time] [By id] [By file]
1 (0.107)
SELECT data
FROM `oc_session`
WHERE session_id = 'dcb04c2eb2516d0e0fc3c6600c'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.092)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.097)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.112)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '73' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (49.582)
SELECT COUNT(1) AS total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '0' AND p.manufacturer_id = '73'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (60.565)
SELECT p.product_id, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, ps.price AS special, p.viewed, p.price
FROM oc_product p
LEFT JOIN (SELECT pss.price, pss.product_id
FROM oc_product_special pss GROUP BY pss.product_id) ps ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '0' AND p.manufacturer_id = '73' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 1220,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.164)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37