Korda


Montura KORDA Zig Rigs, Barbless, Nr.10, 8ft/240cm, 1buc/pac

Montura KORDA Zig Rigs, Barbless, Nr.10, 8ft/240cm, 1buc/pac

kcr067
Livrare 7-14 zile

39,08Lei

VARTEJ KORDA KWIK NR 8 20BUC/PL

VARTEJ KORDA KWIK NR 8 20BUC/PL

kqs20
Livrare imediată!

26,93Lei

TUB SILICON KORDA VERDE S D=0,5MM/L=1,5M

TUB SILICON KORDA VERDE S D=0,5MM/L=1,5M

ks05g
Livrare 7-14 zile

23,10Lei

MONTURA KORDA KRANK READY RIG BARBED NR 4 20LB

MONTURA KORDA KRANK READY RIG BARBED NR 4 20LB

kcr073
Livrare imediată!

18,39Lei

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

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

kst10
Livrare 7-14 zile

23,56Lei

Line Aligner KORDA Kicker Rig Aligner, Brown, Marime M, 10buc/pac

Line Aligner KORDA Kicker Rig Aligner, Brown, Marime M, 10buc/pac

kick05
Livrare imediată!

29,00Lei

Montura Plumb Pierdut KORDA Dark Matter Leader QC Hybrid Clip, Weed, 30lbs, 1m

Montura Plumb Pierdut KORDA Dark Matter Leader QC Hybrid Clip, Weed, 30lbs, 1m

ksz89
Livrare 7-14 zile

41,62Lei

Montura KORDA Multi Rig Krank Choddy Kamo, Barbed, Nr.6, 30lb, 1buc/pac

Montura KORDA Multi Rig Krank Choddy Kamo, Barbed, Nr.6, 30lb, 1buc/pac

kcr083
Livrare imediată!

18,39Lei

Plumb Inline KORDA Square Pear Lead, 2oz/56gr, 1buc/pac

Plumb Inline KORDA Square Pear Lead, 2oz/56gr, 1buc/pac

sqpi2
Livrare 7-14 zile

13,66Lei

FIR MONOFILAMENT KORDA CARP LINE 1000M 0.43MM

FIR MONOFILAMENT KORDA CARP LINE 1000M 0.43MM

kcm20
Livrare imediată!

95,15Lei

Porumb Artificial KORDA Pop-up Corn, IB, Pink, 12buc/pac

Porumb Artificial KORDA Pop-up Corn, IB, Pink, 12buc/pac

kpb48
Livrare 7-14 zile

23,82Lei

Tricou Korda Kore Digital Camo TK BLack Mar. XL

Tricou Korda Kore Digital Camo TK BLack Mar. XL

kcl266
Livrare imediată!

133,29Lei

Protectie Momeala KORDA Superwrap, Transparent, 12mm

Protectie Momeala KORDA Superwrap, Transparent, 12mm

sw12
Livrare 7-14 zile

39,08Lei

Fir Textil KORDA N-Trap Soft Coated, Weedy Green, 20lbs, 20m

Fir Textil KORDA N-Trap Soft Coated, Weedy Green, 20lbs, 20m

knt02
Livrare 7-14 zile

93,10Lei

Plumb KORDA Heli Lead, 2oz/56g, 1buc/pac

Plumb KORDA Heli Lead, 2oz/56g, 1buc/pac

khl2
Livrare 7-14 zile

13,66Lei

PLUMB KORDA BIG GRIPPA CU VARTEJ 84G

PLUMB KORDA BIG GRIPPA CU VARTEJ 84G

kbgb3
Livrare imediată!

20,13Lei

Plumb Inline KORDA Flatliner Pear Inline, 3.5oz/98g, 1buc/pac

Plumb Inline KORDA Flatliner Pear Inline, 3.5oz/98g, 1buc/pac

fpi35
Livrare 7-14 zile

15,19Lei

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

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

kcr147
Livrare imediată!

18,39Lei

Cutie Multifunctionala Accesorii Korda Basix

Cutie Multifunctionala Accesorii Korda Basix

kbx024
Livrare imediată!

138,99Lei

Vartej cu Anou Korda PTFE, Nr.8, 8buc/plic

Vartej cu Anou Korda PTFE, Nr.8, 8buc/plic

kmw002
Livrare imediată!

33,92Lei

Afişare 1361 - 1380 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: 104.476 ms [By time] [By id] [By file]
1 (0.205)
SELECT data
FROM `oc_session`
WHERE session_id = '81cd211f973e2e37a3b9f0a444'
/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.146)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.130)
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 (46.607)
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 (57.135)
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 1360,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.161)
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