Korda


CIRLIGE KORDA CHODDY NR.8 10BUC/PLIC

CIRLIGE KORDA CHODDY NR.8 10BUC/PLIC

kch8
Livrare imediată!

33,90Lei

Opritoare Carlig CARP ZOOM Hook Beads, Light Brown, 20buc/pac

Opritoare Carlig CARP ZOOM Hook Beads, Light Brown, 20buc/pac

cz4753
Livrare 48-72 ore

13,61Lei

CON PLUMB PIERDUT KORDA CULOARE SILT 10BUC

CON PLUMB PIERDUT KORDA CULOARE SILT 10BUC

krs
Livrare imediată!

26,93Lei

Croseta Korda Braid Needle Pentru Monturi

Croseta Korda Braid Needle Pentru Monturi

kbnb
Livrare 7-14 zile

24,03Lei

OCHELARI KORDA OLIVE YELLOW

OCHELARI KORDA OLIVE YELLOW

a8.k4d02
Livrare imediată!

165,85Lei

Plumb KORDA Square Pear Swivel, 1.1oz/30gr, 1buc/pac

Plumb KORDA Square Pear Swivel, 1.1oz/30gr, 1buc/pac

sqps11
Livrare 7-14 zile

13,66Lei

Atractant Korda Goo Scopex Cream Smoke 115 ML

Atractant Korda Goo Scopex Cream Smoke 115 ML

kgoo30
Livrare imediată!

95,15Lei

Atractant Korda GOO Bait Smoke 115ml KRILL SUPREME

Atractant Korda GOO Bait Smoke 115ml KRILL SUPREME

goo36
Livrare imediată!

98,33Lei

Plumb Casting KORDA Tournament Casting Swivel, 5.5oz/154g, 1buc/pac

Plumb Casting KORDA Tournament Casting Swivel, 5.5oz/154g, 1buc/pac

tcs55
Livrare 7-14 zile

17,73Lei

Jacheta Fleece KORDA Kore Polar, Olive, Marime L

Jacheta Fleece KORDA Kore Polar, Olive, Marime L

kcl324
Livrare imediată!

354,15Lei

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

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

kksb1
Livrare 7-14 zile

36,54Lei

Montura KORDA Wide Gape N-Trap Nr.2/30Lb

Montura KORDA Wide Gape N-Trap Nr.2/30Lb

kcr138
Livrare 7-14 zile

16,56Lei

Plumb KORDA Flat Pear Swivel, 5oz/140g, 1buc/pac

Plumb KORDA Flat Pear Swivel, 5oz/140g, 1buc/pac

fps5
Livrare 7-14 zile

16,20Lei

Set ceai Korda Compac Tea

Set ceai Korda Compac Tea

klug13
Livrare 7-14 zile

213,57Lei

Carlige Korda Klor Nr.6, 10buc/pac

Carlige Korda Klor Nr.6, 10buc/pac

klor6
Livrare imediată!

33,90Lei

TUB CONIC KORDA SIGURANTA TAIL RUBER 10BUC/PLIC GRAVEL

TUB CONIC KORDA SIGURANTA TAIL RUBER 10BUC/PLIC GRAVEL

krgr
Livrare 7-14 zile

26,93Lei

Pelete Korda Pop-up Dumbell 8mm Fruity Squid Roz 10buc/plic

Pelete Korda Pop-up Dumbell 8mm Fruity Squid Roz 10buc/plic

kpb18
Livrare imediată!

22,16Lei

SNAG KORDA BAR BLACK

SNAG KORDA BAR BLACK

ksbb
Livrare imediată!

104,56Lei

Degetar Korda, Marime S

Degetar Korda, Marime S

kda008
Livrare 7-14 zile

43,34Lei

Galeata Korda Compac 10litri

Galeata Korda Compac 10litri

kbu002
Livrare 7-14 zile

57,50Lei

Afişare 961 - 980 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: 90.718 ms [By time] [By id] [By file]
1 (0.354)
SELECT data
FROM `oc_session`
WHERE session_id = '6df852abbfb88abc93ae5d04b8'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.080)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.121)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.100)
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 (36.661)
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 (53.174)
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 960,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.228)
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