Korda


Pelete Artificiale KORDA Pop Up Dumbell, Fruity Squid, Pink, 16mm, 5buc/pac

Pelete Artificiale KORDA Pop Up Dumbell, Fruity Squid, Pink, 16mm, 5buc/pac

kpb20
Livrare 7-14 zile

23,82Lei

Tricou Korda Kore Digital Camo TK BLack Mar. XXL -21%

Tricou Korda Kore Digital Camo TK BLack Mar. XXL

a8.kcl267
Livrare imediată!

130,08Lei(-21%) 102,74Lei

Plumb Casting KORDA Tournament Casting Swivel, 1.5oz/42g, 1buc/pac

Plumb Casting KORDA Tournament Casting Swivel, 1.5oz/42g, 1buc/pac

tcs15
Livrare imediată!

13,66Lei

CARLIG KORDA WIDE GAPE X NR.10 10BUC/PLIC

CARLIG KORDA WIDE GAPE X NR.10 10BUC/PLIC

kwgx10
Livrare imediată!

33,90Lei

Plumb KORDA Heli Lead, 3oz/84g, 1buc/pac

Plumb KORDA Heli Lead, 3oz/84g, 1buc/pac

khl3
Livrare 7-14 zile

13,66Lei

Kit Korda Plumb Culisant Flying Back Leads 5buc/blister + 5 Rubber Beads 5g

Kit Korda Plumb Culisant Flying Back Leads 5buc/blister + 5 Rubber Beads 5g

kfb2
Livrare imediată!

43,34Lei

Plumb KORDA Flat Pear Swivel, 1.1oz/30g, 1buc/pac

Plumb KORDA Flat Pear Swivel, 1.1oz/30g, 1buc/pac

fps11
Livrare 7-14 zile

13,66Lei

Line Aligner KORDA Kicker Rig Aligner, Pink / Yellow, Marime S, 10buc/pac

Line Aligner KORDA Kicker Rig Aligner, Pink / Yellow, Marime S, 10buc/pac

kick07
Livrare 7-14 zile

28,36Lei

CARLIG KORDA KRANK BARBLESS NR.10 10BUC/PLIC

CARLIG KORDA KRANK BARBLESS NR.10 10BUC/PLIC

kkrb10
Livrare imediată!

33,90Lei

CUTIE KORDA ACCESORII TACKLE BOX BUNDLE DEAL

CUTIE KORDA ACCESORII TACKLE BOX BUNDLE DEAL

kbox16
Livrare imediată!

413,99Lei

Tub Tungsten Korda Dark Matter Nano 2m, Gravel

Tub Tungsten Korda Dark Matter Nano 2m, Gravel

kdm005
Livrare 7-14 zile

38,62Lei

Cutie pentru Carlige Korda

Cutie pentru Carlige Korda

kbox18
Livrare imediată!

62,17Lei

Galeata KORDA PVA Kontainer System, 10ltr

Galeata KORDA PVA Kontainer System, 10ltr

kbu006
Livrare 7-14 zile

283,52Lei

Plumb KORDA COG Flat Distance, 5oz/140g

Plumb KORDA COG Flat Distance, 5oz/140g

cogd5
Livrare 7-14 zile

16,20Lei

Carlige KORDA Basix Wide Gape Barbless, nr.4, 10buc/pac

Carlige KORDA Basix Wide Gape Barbless, nr.4, 10buc/pac

kbx005
Livrare 7-14 zile

20,27Lei

FIR KORDA TOUCHDOWN 0,30MM/10LB/1000M

FIR KORDA TOUCHDOWN 0,30MM/10LB/1000M

ktdb10
Livrare 7-14 zile

111,65Lei

CLIPS PLUMB PIERDUT KORDA 10BUC/PL CLAY

CLIPS PLUMB PIERDUT KORDA 10BUC/PL CLAY

klcsc
Livrare 7-14 zile

26,93Lei

PUNGI PVA KORDA XS 45X100MM 25BUC/PL+INCARCATOR

PUNGI PVA KORDA XS 45X100MM 25BUC/PL+INCARCATOR

kpva1
Livrare imediată!

24,58Lei

Bara KORDA Buzz Bar Simpla Korda Singlez Upright, 3.5inch/9cm, 1buc/blister

Bara KORDA Buzz Bar Simpla Korda Singlez Upright, 3.5inch/9cm, 1buc/blister

ksing01
Livrare 7-14 zile

122,51Lei

Carlige KORDA MIXA NR.6 BARBLESS 10BUC/PLIC

Carlige KORDA MIXA NR.6 BARBLESS 10BUC/PLIC

kmhb6
Livrare imediată!

33,90Lei

Afişare 1021 - 1040 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: 122.467 ms [By time] [By id] [By file]
1 (0.095)
SELECT data
FROM `oc_session`
WHERE session_id = '7a7365e2323cd81c1ded76daea'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.078)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.088)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.090)
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 (43.920)
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 (78.056)
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 1020,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.140)
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