Korda


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

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

kick08
Livrare 7-14 zile

28,36Lei

Plumb KORDA Big Grippa, 1.5oz/42g

Plumb KORDA Big Grippa, 1.5oz/42g

bg15
Livrare 7-14 zile

13,66Lei

Kit montura KORDA COG Boom Flat Pear, 2oz/2.5oz

Kit montura KORDA COG Boom Flat Pear, 2oz/2.5oz

kcog3
Livrare 7-14 zile

37,86Lei

Ghete KORDA Kore Kombat Boots, Brown, Marime UK8/EU42

Ghete KORDA Kore Kombat Boots, Brown, Marime UK8/EU42

kcl511
Livrare 7-14 zile

656,84Lei

Hanger KORDA Black & Whites Bobbin, White, Size M

Hanger KORDA Black & Whites Bobbin, White, Size M

kbmw
Livrare 7-14 zile

163,64Lei

SET MONTURI KORDA HELICOPTER 3BUC/PLIC

SET MONTURI KORDA HELICOPTER 3BUC/PLIC

llhw
Livrare imediată!

43,48Lei

Cap Rezerva Hanger KORDA Stow Head, Green

Cap Rezerva Hanger KORDA Stow Head, Green

keb08
Livrare 7-14 zile

51,79Lei

ANOU OVAL KORDA PT RIG 20BUC/PL

ANOU OVAL KORDA PT RIG 20BUC/PL

krro
Livrare 7-14 zile

26,93Lei

Carlige Legate KORDA Loop Rigs Klor, Barbless, Nr.6, 30lb, 3buc/pac

Carlige Legate KORDA Loop Rigs Klor, Barbless, Nr.6, 30lb, 3buc/pac

krr017
Livrare 7-14 zile

31,45Lei

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, Clear, 40lbs, 1m

Montura cu Vartej KORDA Dark Matter Leader Ring Swivel, Clear, 40lbs, 1m

ksz34
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, Clear, 30lbs, 50cm

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

ksz94
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, 5oz/140gr, 1buc/pac

Plumb Inline KORDA Square Pear Lead, 5oz/140gr, 1buc/pac

sqpi5
Livrare 7-14 zile

16,20Lei

Carlige Korda Krank Barbless Nr. 4

Carlige Korda Krank Barbless Nr. 4

kkrb4
Livrare imediată!

33,90Lei

Pelete Artificiale KORDA Slow Sinking Dumbell, Banoffee, White, 12mm, 8buc/pac

Pelete Artificiale KORDA Slow Sinking Dumbell, Banoffee, White, 12mm, 8buc/pac

kpb26
Livrare imediată!

23,82Lei

ANTISEPTIC KORDA PROPOLIS

ANTISEPTIC KORDA PROPOLIS

kcc2
Livrare 7-14 zile

69,25Lei

Plumb Casting KORDA Tournament Casting Swivel, 3oz/84g, 1buc/pac

Plumb Casting KORDA Tournament Casting Swivel, 3oz/84g, 1buc/pac

tcs3
Livrare imediată!

13,66Lei

Afişare 1441 - 1460 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: 159.654 ms [By time] [By id] [By file]
1 (0.136)
SELECT data
FROM `oc_session`
WHERE session_id = 'd9610f25ca98e8a9b79714ba6c'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.173)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.151)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.159)
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.441)
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 (91.472)
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 1440,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.122)
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