Korda


FIR TEXTIL KORDA DARK MATTER 30LB/20M

FIR TEXTIL KORDA DARK MATTER 30LB/20M

kdmb30
Livrare imediată!

93,10Lei

FIR FLUOROCARBON KORDA IQ EXTRA SOFT 10LBS/20MT

FIR FLUOROCARBON KORDA IQ EXTRA SOFT 10LBS/20MT

kiqs10
Livrare imediată!

69,24Lei

Montura cu Vartej KORDA Dark Matter Leader Ring Swivel, Silt, 30lbs, 1m

Montura cu Vartej KORDA Dark Matter Leader Ring Swivel, Silt, 30lbs, 1m

ksz33
Livrare 7-14 zile

36,32Lei

REZERVA KORDA PLASA PVA FUNNEL L=20M

REZERVA KORDA PLASA PVA FUNNEL L=20M

kohr20
Livrare 7-14 zile

119,08Lei

Montura Plumb Pierdut KORDA Dark Matter Leader QC Hybrid Clip, Gravel, 30lbs, 50cm

Montura Plumb Pierdut KORDA Dark Matter Leader QC Hybrid Clip, Gravel, 30lbs, 50cm

ksz93
Livrare 7-14 zile

41,62Lei

MONTURA KORDA DARK MATTER NR 6 20LB

MONTURA KORDA DARK MATTER NR 6 20LB

kcr096
Livrare imediată!

19,76Lei

Plumb Inline KORDA Square Pear Lead, 4oz/112gr, 1buc/pac

Plumb Inline KORDA Square Pear Lead, 4oz/112gr, 1buc/pac

sqpi4
Livrare 7-14 zile

15,19Lei

Carlige Korda Krank Barbless Nr. 4

Carlige Korda Krank Barbless Nr. 4

kkrb4
Livrare imediată!

33,90Lei

ANTISEPTIC KORDA PROPOLIS

ANTISEPTIC KORDA PROPOLIS

kcc2
Livrare 7-14 zile

69,25Lei

Plumb Casting KORDA Tournament Casting Swivel, 2.5oz/70g, 1buc/pac

Plumb Casting KORDA Tournament Casting Swivel, 2.5oz/70g, 1buc/pac

tcs25
Livrare 7-14 zile

13,66Lei

SET KORDA MONTURA LEDCORE+PLUMB PIERDUT WEED 3BUC/PL

SET KORDA MONTURA LEDCORE+PLUMB PIERDUT WEED 3BUC/PL

llhqw
Livrare imediată!

48,06Lei

Plumb KORDA Heli Lead, 4oz/112g, 1buc/pac

Plumb KORDA Heli Lead, 4oz/112g, 1buc/pac

khl4
Livrare 7-14 zile

15,19Lei

MONTURA KORDA SPINNER RIG KURV BOOM NR.4 25LB

MONTURA KORDA SPINNER RIG KURV BOOM NR.4 25LB

kcr134
Livrare imediată!

18,38Lei

Plumb KORDA Flat Pear Swivel, 1.5oz/42g, 1buc/pac

Plumb KORDA Flat Pear Swivel, 1.5oz/42g, 1buc/pac

fps15
Livrare 7-14 zile

13,66Lei

Fir Monofilament Korda Basix Mainline 0.40mm, 15lb, 1000m

Fir Monofilament Korda Basix Mainline 0.40mm, 15lb, 1000m

kbx045
Livrare imediată!

71,83Lei

MONTURA Korda RING SWIVEL 50CM/ WEED

MONTURA Korda RING SWIVEL 50CM/ WEED

ksz68
Livrare 7-14 zile

31,36Lei

SET KORDA MONTURA HELICOPTER 3BUC/PLIC GRAVEL

SET KORDA MONTURA HELICOPTER 3BUC/PLIC GRAVEL

llhg
Livrare imediată!

43,48Lei

Pelete artificial Korda Pop-Up Dumbell 8mm Banofee Alb 10buc/plic

Pelete artificial Korda Pop-Up Dumbell 8mm Banofee Alb 10buc/plic

kpb28
Livrare 7-14 zile

22,16Lei

TUB TUNGSTEN KORDA GRAVEL PT. MONTURI 2M

TUB TUNGSTEN KORDA GRAVEL PT. MONTURI 2M

kdmtg
Livrare 7-14 zile

38,74Lei

Clips pentru Monturi Korda Hook Klips 10buc/pac

Clips pentru Monturi Korda Hook Klips 10buc/pac

kmw010
Livrare imediată!

31,45Lei

Afişare 761 - 780 din 1641 (83 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: 113.452 ms [By time] [By id] [By file]
1 (0.074)
SELECT data
FROM `oc_session`
WHERE session_id = '8cb24b3b8947b3748e2c1bd7c1'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.081)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.107)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.098)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (45.435)
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 = '2' AND p.manufacturer_id = '73'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (67.527)
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 = '2' AND p.manufacturer_id = '73' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 760,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.129)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37