Korda


Line Aligner KORDA D-Rig Kicker, Brown, Marime S, pentru Carlige Nr.6-8, 10buc/pac

Line Aligner KORDA D-Rig Kicker, Brown, Marime S, pentru Carlige Nr.6-8, 10buc/pac

kick25
Livrare imediată!

34,00Lei

Fir Textil KORDA N-Trap Semi Stiff Coated, Silt, 15lbs, 20m

Fir Textil KORDA N-Trap Semi Stiff Coated, Silt, 15lbs, 20m

knt22
Livrare 7-14 zile

93,09Lei

Set Cutii Accesorii KORDA Tackle Box Large Collection

Set Cutii Accesorii KORDA Tackle Box Large Collection

kbox22
Livrare imediată!

613,22Lei

Plumb KORDA COG Flat Distance, 2.5oz/70g

Plumb KORDA COG Flat Distance, 2.5oz/70g

cogd25
Livrare 7-14 zile

15,69Lei

Plumb cu Vartej KORDA Distance Casting Swivel, Weed, 4.5oz/126g, 2buc/pac

Plumb cu Vartej KORDA Distance Casting Swivel, Weed, 4.5oz/126g, 2buc/pac

dcsb45
Livrare 7-14 zile

31,45Lei

Bait Crusher KORDA Krusha L, D=120mm

Bait Crusher KORDA Krusha L, D=120mm

kks120
Livrare imediată!

100,27Lei

Montura KORDA Krank Ready Rig, Barbless, Nr.4, 30lbs, 1buc/pac

Montura KORDA Krank Ready Rig, Barbless, Nr.4, 30lbs, 1buc/pac

kcr078
Livrare 7-14 zile

19,76Lei

Tub Termo KORDA Shrink Tube, Clear, 1.2mm, 8buc/pac

Tub Termo KORDA Shrink Tube, Clear, 1.2mm, 8buc/pac

kst12
Livrare imediată!

23,56Lei

Montura KORDA Spinner Rig Kurv Boom, Barbed, Nr.6, 25lb, 1buc/pac

Montura KORDA Spinner Rig Kurv Boom, Barbed, Nr.6, 25lb, 1buc/pac

kcr135
Livrare 7-14 zile

19,76Lei

ANOU LINK LOOP KORDA 15BUC/PL

ANOU LINK LOOP KORDA 15BUC/PL

khll
Livrare 7-14 zile

27,56Lei

Cutie Hangere KORDA Stowaway Case, 2 rod

Cutie Hangere KORDA Stowaway Case, 2 rod

kebc2
Livrare 7-14 zile

37,86Lei

SET KORDA MONTURI LEDCORE+RING 3BUC/PL GRAVEL

SET KORDA MONTURI LEDCORE+RING 3BUC/PL GRAVEL

llrsg
Livrare imediată!

40,98Lei

Carlige KORDA KURV SHANK XX NR.8 10BUC/PLIC

Carlige KORDA KURV SHANK XX NR.8 10BUC/PLIC

kksxx8
Livrare imediată!

33,90Lei

FIR KORDA CARP 030MM/10LB/1000M

FIR KORDA CARP 030MM/10LB/1000M

kcm10
Livrare imediată!

95,15Lei

Montura cu Vartej Rapid KORDA Dark Matter Leader QC Swivel, Weed, 30lbs, 30cm

Montura cu Vartej Rapid KORDA Dark Matter Leader QC Swivel, Weed, 30lbs, 30cm

ksz56
Livrare 7-14 zile

39,08Lei

PUNGI KORDA PVA M 70X100MM PLUS INCARCATOR 20BUC/PL.

PUNGI KORDA PVA M 70X100MM PLUS INCARCATOR 20BUC/PL.

kpva3
Livrare imediată!

24,58Lei

Plumb Para KORDA Pear Swivel, 4oz/112gr, 1buc/pac

Plumb Para KORDA Pear Swivel, 4oz/112gr, 1buc/pac

ps4
Livrare 7-14 zile

15,19Lei

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

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

ksz30
Livrare 7-14 zile

33,84Lei

Plumb KORDA Square Pear Swivel, 3.5oz/98gr, 2buc/pac

Plumb KORDA Square Pear Swivel, 3.5oz/98gr, 2buc/pac

sqpsb35
Livrare 7-14 zile

28,91Lei

LEAD CORE KORDA 50LB 25M ROLA GRAVEL

LEAD CORE KORDA 50LB 25M ROLA GRAVEL

kabgb
Livrare imediată!

109,64Lei

Afişare 821 - 840 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: 102.658 ms [By time] [By id] [By file]
1 (0.097)
SELECT data
FROM `oc_session`
WHERE session_id = '5f3458c2574325a396fc7ef1b0'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.085)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.100)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.093)
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 (42.209)
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 (59.953)
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 820,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.120)
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