Korda


Plasa Minciog KORDA Landing Net Mesh, Deep Version, 42inch/106cm

Plasa Minciog KORDA Landing Net Mesh, Deep Version, 42inch/106cm

kln004
Livrare 7-14 zile

178,89Lei

Fir Fluorocarbon Korda Boom Stiff Link Low Vis Green 15m, 0.55mm, 11.30kg

Fir Fluorocarbon Korda Boom Stiff Link Low Vis Green 15m, 0.55mm, 11.30kg

kboom55
Livrare imediată!

71,90Lei

Ochelari Polarizati KORDA Shoreditch, Matt Toroise Shell/Brown Lens

Ochelari Polarizati KORDA Shoreditch, Matt Toroise Shell/Brown Lens

k4d13
Livrare 7-14 zile

204,11Lei

Vartej Rapid cu Anou Korda PTFE QC Ring, Nr.11, 8buc/plic

Vartej Rapid cu Anou Korda PTFE QC Ring, Nr.11, 8buc/plic

kmw003
Livrare imediată!

33,92Lei

Plumb KORDA Flat Pear Swivel, 5oz/140g, Blister 2buc/pac

Plumb KORDA Flat Pear Swivel, 5oz/140g, Blister 2buc/pac

fpsb5
Livrare 7-14 zile

31,45Lei

Atractant Korda MOONSHINE SUPREME 115ml -20%

Atractant Korda MOONSHINE SUPREME 115ml

a0.goo44
Livrare imediată!

103,31Lei(-20%) 82,37Lei

Hanorac KORDA Kore Zip, Black, Marime 2XL -22%

Hanorac KORDA Kore Zip, Black, Marime 2XL

a8.kcl233
Livrare imediată!

278,59Lei(-22%) 217,49Lei

MAGNET KORDA PENTRU CUTIE ACCESORII

MAGNET KORDA PENTRU CUTIE ACCESORII

kbox19
Livrare 7-14 zile

17,90Lei

Fir Leadcore KORDA Kable Tight Weave, Weed Silt, 50lbs, 7m

Fir Leadcore KORDA Kable Tight Weave, Weed Silt, 50lbs, 7m

kab001
Livrare imediată!

51,79Lei

PROTECTIE KORDA MONTURI CAUCIUC WEED/SLIT 10BUC/PLIC

PROTECTIE KORDA MONTURI CAUCIUC WEED/SLIT 10BUC/PLIC

knrw
Livrare 7-14 zile

26,86Lei

Carlige Legate KORDA Loop Rigs Klor, Nr.4, 30lbs, 3buc/pac

Carlige Legate KORDA Loop Rigs Klor, Nr.4, 30lbs, 3buc/pac

krr012
Livrare 7-14 zile

29,21Lei

Boilies Korda Artificial Essential Cell Slow Sinking Boilie18mm, 9buc/pac

Boilies Korda Artificial Essential Cell Slow Sinking Boilie18mm, 9buc/pac

kpb53
Livrare imediată!

23,82Lei

Line Aligner KORDA Kicker X-Large, Bloodworm Red, 10buc/pac

Line Aligner KORDA Kicker X-Large, Bloodworm Red, 10buc/pac

kick21
Livrare 7-14 zile

28,27Lei

Plumb KORDA Big Grippa, 6oz/168g

Plumb KORDA Big Grippa, 6oz/168g

bg6
Livrare 7-14 zile

18,74Lei

Plumb cu Vartej KORDA Distance Casting Swivel, 2oz/56g, 1buc/pac

Plumb cu Vartej KORDA Distance Casting Swivel, 2oz/56g, 1buc/pac

dcs2
Livrare 7-14 zile

13,66Lei

Pantaloni KORDA Thermal Leggings, Olive, Marime S

Pantaloni KORDA Thermal Leggings, Olive, Marime S

kcl312
Livrare 7-14 zile

178,89Lei

Hanger KORDA Black & Whites Bobbin, Black, Size XL

Hanger KORDA Black & Whites Bobbin, Black, Size XL

kbxlb
Livrare 7-14 zile

176,35Lei

FIR KORDA SUBLINE VERDE 0,35MM/12LB/1000M

FIR KORDA SUBLINE VERDE 0,35MM/12LB/1000M

sub12g
Livrare imediată!

143,30Lei

PORUMB ARTIFICIAL IB GALBEN 12B/PL KORDA

PORUMB ARTIFICIAL IB GALBEN 12B/PL KORDA

kpb34
Livrare imediată!

22,16Lei

Montura KORDA Carp Rig Dark Matter Wide Gape + Free Extenda Stops, Barbless, 1buc/blister Nr.2/30lbs
Afişare 1341 - 1360 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: 154.889 ms [By time] [By id] [By file]
1 (0.133)
SELECT data
FROM `oc_session`
WHERE session_id = 'd39075075c0bf9fd0046bb7890'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.126)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.131)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.138)
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 (67.541)
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 (86.719)
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 1340,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.101)
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