Korda


CIRLIGE KORDA KONTINENTAL NR.2 10BUC/PLIC

CIRLIGE KORDA KONTINENTAL NR.2 10BUC/PLIC

kkh2
Livrare imediată!

33,90Lei

Maner Cantar KORDA Singlez T Bar

Maner Cantar KORDA Singlez T Bar

ksing16
Livrare 7-14 zile

168,26Lei

CARLIGE KORDA KONTINENTAL NR 10 10BUC

CARLIGE KORDA KONTINENTAL NR 10 10BUC

kkh10
Livrare imediată!

33,90Lei

Montura Elicopter KORDA Dark Matter Leader Heli, Gravel, 40lbs, 1m

Montura Elicopter KORDA Dark Matter Leader Heli, Gravel, 40lbs, 1m

ksz46
Livrare 7-14 zile

41,62Lei

Line Aligner KORDA Kicker Rig Aligner, Green, Marime L, 10buc/pac

Line Aligner KORDA Kicker Rig Aligner, Green, Marime L, 10buc/pac

kick03
Livrare 7-14 zile

28,36Lei

Carlige KORDA Wide Gape, Barbless, Nr.2, 10buc/plic

Carlige KORDA Wide Gape, Barbless, Nr.2, 10buc/plic

kwgb2
Livrare 7-14 zile

36,54Lei

CROSETA KORDA PT PORUMB SI PELETE SOFT 7CM MOV

CROSETA KORDA PT PORUMB SI PELETE SOFT 7CM MOV

kbnf
Livrare 7-14 zile

24,03Lei

Plumb KORDA Square Pear Swivel, 1.5oz/42gr, 1buc/pac

Plumb KORDA Square Pear Swivel, 1.5oz/42gr, 1buc/pac

sqps15
Livrare 7-14 zile

13,66Lei

OCHELARI KORDA WRAPS

OCHELARI KORDA WRAPS

k4d10
Livrare 7-14 zile

95,44Lei

Pelete Artificiale KORDA Slow Sinking Dumbell, IB, Yellow, 16mm, 5buc/pac

Pelete Artificiale KORDA Slow Sinking Dumbell, IB, Yellow, 16mm, 5buc/pac

kpb37
Livrare 7-14 zile

23,82Lei

Cutie Multifunctionala Accesorii Korda New Tackle Box

Cutie Multifunctionala Accesorii Korda New Tackle Box

kbox6
Livrare imediată!

274,10Lei

Plumb Casting KORDA Tournament Casting Swivel, 6oz/168g, 1buc/pac

Plumb Casting KORDA Tournament Casting Swivel, 6oz/168g, 1buc/pac

tcs6
Livrare 7-14 zile

19,76Lei

CARLIG KORDA KAMAKURA CHODDY MICROBARBED NR.8 10BUC/PL

CARLIG KORDA KAMAKURA CHODDY MICROBARBED NR.8 10BUC/PL

kam13
Livrare imediată!

45,70Lei

Carlige KORDA Kurv Shank Barbless, Nr. 10, 10buc/pac

Carlige KORDA Kurv Shank Barbless, Nr. 10, 10buc/pac

kksb10
Livrare imediată!

36,54Lei

Carlige Korda Kontinental Nr.1 10buc/plic

Carlige Korda Kontinental Nr.1 10buc/plic

kkh1
Livrare imediată!

33,90Lei

Plumb Inline KORDA Flatliner Pear Inline, 2.5oz/70g, 2buc/pac

Plumb Inline KORDA Flatliner Pear Inline, 2.5oz/70g, 2buc/pac

fpib25
Livrare 7-14 zile

26,37Lei

Carlige Korda Klor Nr.8, 10buc/pac -18%

Carlige Korda Klor Nr.8, 10buc/pac

k.klor8
Livrare imediată!

29,86Lei(-18%) 24,58Lei

Sapca KORDA Boothy Cap, Olive

Sapca KORDA Boothy Cap, Olive

kbc16
Livrare 7-14 zile

85,16Lei

FIR KORDA HIBRID STIFF GRAVEL BROWN 20LBS 20M

FIR KORDA HIBRID STIFF GRAVEL BROWN 20LBS 20M

khy6
Livrare 7-14 zile

93,09Lei

STICK KORDA MAGNETIC HOCKEY

STICK KORDA MAGNETIC HOCKEY

keb14
Livrare imediată!

51,79Lei

Afişare 861 - 880 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: 109.434 ms [By time] [By id] [By file]
1 (0.122)
SELECT data
FROM `oc_session`
WHERE session_id = '2810767b9e431cea2ca76c3aba'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.120)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.126)
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 (39.465)
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 (69.374)
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 860,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.126)
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