Korda


Fir Textil KORDA N-Trap Soft Coated, Weedy Green, 20lbs, 20m

Fir Textil KORDA N-Trap Soft Coated, Weedy Green, 20lbs, 20m

knt02
Livrare 7-14 zile

93,10Lei

Plumb KORDA Heli Lead, 2oz/56g, 1buc/pac

Plumb KORDA Heli Lead, 2oz/56g, 1buc/pac

khl2
Livrare 7-14 zile

13,66Lei

PLUMB KORDA BIG GRIPPA CU VARTEJ 84G

PLUMB KORDA BIG GRIPPA CU VARTEJ 84G

kbgb3
Livrare imediată!

20,13Lei

Plumb Inline KORDA Flatliner Pear Inline, 3.5oz/98g, 1buc/pac

Plumb Inline KORDA Flatliner Pear Inline, 3.5oz/98g, 1buc/pac

fpi35
Livrare 7-14 zile

15,19Lei

Montura KORDA Spinner Rig Krank Boom, Barbed, Nr.6, 25lb, 1buc/pac

Montura KORDA Spinner Rig Krank Boom, Barbed, Nr.6, 25lb, 1buc/pac

kcr147
Livrare imediată!

18,39Lei

Cutie Multifunctionala Accesorii Korda Basix

Cutie Multifunctionala Accesorii Korda Basix

kbx024
Livrare imediată!

138,99Lei

Vartej cu Anou Korda PTFE, Nr.8, 8buc/plic

Vartej cu Anou Korda PTFE, Nr.8, 8buc/plic

kmw002
Livrare imediată!

33,92Lei

Pelete Korda Pop Up Dumbell 12mm Fish 8buc/plic

Pelete Korda Pop Up Dumbell 12mm Fish 8buc/plic

kpb09
Livrare 7-14 zile

22,16Lei

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

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

krt005
Livrare 7-14 zile

36,40Lei

Montura Korda Krank Microbarbed Nr.4 3 Buc/Plic

Montura Korda Krank Microbarbed Nr.4 3 Buc/Plic

kcr126
Livrare imediată!

29,27Lei

Galeata Korda Compac 17litri

Galeata Korda Compac 17litri

kbu003
Livrare 7-14 zile

71,85Lei

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

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

kick28
Livrare 7-14 zile

34,00Lei

Sac Uscare Boilies KORDA Compac Air Dry Bag, Marime S

Sac Uscare Boilies KORDA Compac Air Dry Bag, Marime S

klug09
Livrare 7-14 zile

87,37Lei

Plumb KORDA COG Flat Distance, 4oz/112g

Plumb KORDA COG Flat Distance, 4oz/112g

cogd4
Livrare imediată!

16,20Lei

FIR KORDA TOUCHDOWN 0,35MM/12LB/1000M

FIR KORDA TOUCHDOWN 0,35MM/12LB/1000M

ktdb12
Livrare 7-14 zile

129,78Lei

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

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

kcr081
Livrare 7-14 zile

19,76Lei

RECIPIENT KORDA MIC PT DIPUIRE BOILIES INFUZA

RECIPIENT KORDA MIC PT DIPUIRE BOILIES INFUZA

kinzs
Livrare imediată!

36,43Lei

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

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

kflu03
Livrare 7-14 zile

153,46Lei

BANDA PVA SOLUBIL KORDA 3MM/5M/ROLA

BANDA PVA SOLUBIL KORDA 3MM/5M/ROLA

kpt
Livrare imediată!

31,57Lei

Carlige KORDA MIXA NR.10 10BUC/PLIC

Carlige KORDA MIXA NR.10 10BUC/PLIC

kmh10
Livrare imediată!

33,90Lei

Afişare 841 - 860 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: 105.302 ms [By time] [By id] [By file]
1 (0.096)
SELECT data
FROM `oc_session`
WHERE session_id = 'c9490766c19c4c1485f8771b8e'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.088)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.092)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.109)
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 (46.397)
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 (58.379)
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 840,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.142)
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