Korda


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

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

kcr077
Livrare 7-14 zile

19,76Lei

ATRACTANT KORDA GOO TUTTI FRUTTI SMOKE 115ML

ATRACTANT KORDA GOO TUTTI FRUTTI SMOKE 115ML

goo01
Livrare imediată!

98,33Lei

Montura KORDA Spinner Rig Kurv Boom, Barbless, Nr.4, 25lb, 1buc/pac

Montura KORDA Spinner Rig Kurv Boom, Barbless, Nr.4, 25lb, 1buc/pac

kcr136
Livrare 7-14 zile

19,76Lei

CLIPS PLUMB PIERDUT + VARTEJ KORDA 10BUC/PL

CLIPS PLUMB PIERDUT + VARTEJ KORDA 10BUC/PL

khcs
Livrare imediată!

36,28Lei

Cutie Hangere KORDA Stowaway Case, 2 rod

Cutie Hangere KORDA Stowaway Case, 2 rod

kebc2
Livrare 7-14 zile

37,86Lei

AGRAFA KWIK LINKS KORDA STANDARD 20BUC/PL

AGRAFA KWIK LINKS KORDA STANDARD 20BUC/PL

kwl
Livrare imediată!

26,93Lei

Carlige KORDA KURV SHANK XX NR.6 10BUC/PLIC

Carlige KORDA KURV SHANK XX NR.6 10BUC/PLIC

kksxx6
Livrare imediată!

33,90Lei

FIR KORDA CARP 028MM/8LB/1000M

FIR KORDA CARP 028MM/8LB/1000M

kcm08
Livrare imediată!

95,15Lei

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

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

ksz56
Livrare 7-14 zile

39,08Lei

PUNGI PVA KORDA S 55X100MM 25BUC/PL PLUS INCARCATOR

PUNGI PVA KORDA S 55X100MM 25BUC/PL PLUS INCARCATOR

kpva2
Livrare imediată!

24,58Lei

Plumb Para KORDA Pear Swivel, 4oz/112gr, 1buc/pac

Plumb Para KORDA Pear Swivel, 4oz/112gr, 1buc/pac

ps4
Livrare 7-14 zile

15,19Lei

OPRITOR CAUCIUC KORDA CU PROTECTIE NOD D=4MM/25BUCATI/PLIC

OPRITOR CAUCIUC KORDA CU PROTECTIE NOD D=4MM/25BUCATI/PLIC

k4rbg
Livrare imediată!

19,80Lei

Plumb KORDA Square Pear Swivel, 3.5oz/98gr, 2buc/pac

Plumb KORDA Square Pear Swivel, 3.5oz/98gr, 2buc/pac

sqpsb35
Livrare 7-14 zile

28,91Lei

Carlige Korda Krank Choddy Nr10 10buc/plic

Carlige Korda Krank Choddy Nr10 10buc/plic

krch10
Livrare imediată!

33,90Lei

Boilies Artificial KORDA Slow Sinking Boilie, ISO Fish, 18mm, 6buc/pac

Boilies Artificial KORDA Slow Sinking Boilie, ISO Fish, 18mm, 6buc/pac

kpb56
Livrare 7-14 zile

22,18Lei

Riguri Korda Wide Gape X Loops Micro-Barbed NR4 18lbs 3buc/blister

Riguri Korda Wide Gape X Loops Micro-Barbed NR4 18lbs 3buc/blister

kcr120
Livrare imediată!

29,21Lei

Plumb Texturat KORDA Textured Flat Pear Swivel, 2.5oz/70g, 1buc/pac

Plumb Texturat KORDA Textured Flat Pear Swivel, 2.5oz/70g, 1buc/pac

tfps25
Livrare 7-14 zile

13,66Lei

Montura Korda IQ D-Rig Kurv Shank Barbed + Free Extenda Stops, 1buc/blister Nr.4/15lbs

Montura Korda IQ D-Rig Kurv Shank Barbed + Free Extenda Stops, 1buc/blister Nr.4/15lbs

kcr056
Livrare 7-14 zile

16,56Lei

Plasa Minciog KORDA Landing Net Mesh, Deep Version, 46inch/116cm

Plasa Minciog KORDA Landing Net Mesh, Deep Version, 46inch/116cm

kln005
Livrare 7-14 zile

183,97Lei

Montura Korda Ronnie Rig Sections Kurv Shank Nr.4 3buc/plic

Montura Korda Ronnie Rig Sections Kurv Shank Nr.4 3buc/plic

kcr130
Livrare imediată!

31,57Lei

Afişare 661 - 680 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: 87.995 ms [By time] [By id] [By file]
1 (0.189)
SELECT data
FROM `oc_session`
WHERE session_id = '7e77e668f0f588bfe550e85fcc'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.072)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.099)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.091)
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 (36.445)
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 (50.995)
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 660,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.104)
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