Korda


Vartej Korda cu Agrafa Rapida Spinner Swivel Nr.11 12buc/plic

Vartej Korda cu Agrafa Rapida Spinner Swivel Nr.11 12buc/plic

kspin3
Livrare imediată!

26,93Lei

ATRACTANT KORDA GOO Garlic POWER SMOKE 115ML

ATRACTANT KORDA GOO Garlic POWER SMOKE 115ML

kgoo13
Livrare imediată!

98,33Lei

Plumb Inline KORDA Flatliner Pear Inline, 3oz/84g, 1buc/pac

Plumb Inline KORDA Flatliner Pear Inline, 3oz/84g, 1buc/pac

fpi3
Livrare 7-14 zile

15,19Lei

Carlige legate Korda Spinner Rig Krank Boom Barbed Nr.4

Carlige legate Korda Spinner Rig Krank Boom Barbed Nr.4

kcr146
Livrare imediată!

18,39Lei

KIT MONTURA KORDA PLUMB PIERDUT HELI SAFE 2BUC/BLISTER GREEN

KIT MONTURA KORDA PLUMB PIERDUT HELI SAFE 2BUC/BLISTER GREEN

khdtg
Livrare imediată!

29,21Lei

CARLIGE KORDA KAMAKURA KRANK BARBLESS Nr. 8 10BUC/PLIC

CARLIGE KORDA KAMAKURA KRANK BARBLESS Nr. 8 10BUC/PLIC

kam10
Livrare imediată!

45,70Lei

Baton Pluta KORDA Cork Stick 6mm, 10buc/pac

Baton Pluta KORDA Cork Stick 6mm, 10buc/pac

krt006
Livrare imediată!

36,40Lei

Con Plumb Pierdut Korda NanoTail Rubber 10buc/pac, Weed

Con Plumb Pierdut Korda NanoTail Rubber 10buc/pac, Weed

krnw
Livrare 7-14 zile

26,86Lei

Fir Fluorocarbon Korda Boom Stiff Link Low Vis Green 15m, 0.50mm, 9.10kg

Fir Fluorocarbon Korda Boom Stiff Link Low Vis Green 15m, 0.50mm, 9.10kg

kboom50
Livrare imediată!

71,60Lei

Line Aligner KORDA D-Rig Kicker, Brown, Marime L, pentru Carlige Nr. 2-4, 10buc/pac

Line Aligner KORDA D-Rig Kicker, Brown, Marime L, pentru Carlige Nr. 2-4, 10buc/pac

kick27
Livrare 7-14 zile

31,56Lei

Sac Uscare Boilies KORDA Compac Air Dry Bag, Marime L

Sac Uscare Boilies KORDA Compac Air Dry Bag, Marime L

klug10
Livrare 7-14 zile

107,71Lei

Plumb KORDA COG Flat Distance, 3.5oz/100g

Plumb KORDA COG Flat Distance, 3.5oz/100g

cogd35
Livrare imediată!

15,69Lei

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

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

ktdb10
Livrare 7-14 zile

111,65Lei

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

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

kcr080
Livrare 7-14 zile

19,76Lei

Plumb Culisant KORDA Intelligent Backleads, 45g, 3buc/pac

Plumb Culisant KORDA Intelligent Backleads, 45g, 3buc/pac

kib15
Livrare imediată!

38,64Lei

Fir Fluorocarbon KORDA Kontour, Trasparent, 0.35mm, 200m

Fir Fluorocarbon KORDA Kontour, Trasparent, 0.35mm, 200m

kflu02
Livrare 7-14 zile

153,46Lei

Rezerva plasa solubila KORDA Boilie Funnel Web Hexmesh Refill, 20m

Rezerva plasa solubila KORDA Boilie Funnel Web Hexmesh Refill, 20m

kbhr20
Livrare 7-14 zile

119,05Lei

Carlige KORDA LONG SHANK NR.4 10B/PLIC

Carlige KORDA LONG SHANK NR.4 10B/PLIC

klsx4
Livrare 7-14 zile

32,37Lei

FIR KORDA TEXTIL SUPERNATURAL SOFT VERDE 25LBS/20M

FIR KORDA TEXTIL SUPERNATURAL SOFT VERDE 25LBS/20M

ksng25
Livrare imediată!

72,22Lei

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

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

ksz58
Livrare 7-14 zile

39,08Lei

Afişare 701 - 720 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: 92.789 ms [By time] [By id] [By file]
1 (0.124)
SELECT data
FROM `oc_session`
WHERE session_id = '754f46b0ab09b281adc059b137'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.137)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.117)
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 (38.081)
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 (54.092)
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 700,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.135)
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