Korda


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

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

knt20
Livrare 7-14 zile

93,09Lei

Plumb KORDA Original Big Grippa, 6oz/168g

Plumb KORDA Original Big Grippa, 6oz/168g

bog6
Livrare 7-14 zile

18,74Lei

Plumb cu Vartej KORDA Distance Casting Swivel, Weed, 3oz/84g, 2buc/pac

Plumb cu Vartej KORDA Distance Casting Swivel, Weed, 3oz/84g, 2buc/pac

dcsb3
Livrare 7-14 zile

26,37Lei

Carlige KORDA Kamakura Choddy Barbless, Nr. 6, 10buc/pac

Carlige KORDA Kamakura Choddy Barbless, Nr. 6, 10buc/pac

kam17
Livrare 7-14 zile

49,25Lei

CIRLIGE KORDA WIDE GAPE NR.6 10BUC/PLIC

CIRLIGE KORDA WIDE GAPE NR.6 10BUC/PLIC

kwg6
Livrare imediată!

33,90Lei

CARLIGE KORDA KRANK CHODY NR 6 /10BUC

CARLIGE KORDA KRANK CHODY NR 6 /10BUC

krch6
Livrare imediată!

33,90Lei

Montura KORDA Loop Rigs Wide Gape, Barbless, Nr.6, 18lb, 3buc/pac

Montura KORDA Loop Rigs Wide Gape, Barbless, Nr.6, 18lb, 3buc/pac

kcr124
Livrare 7-14 zile

31,45Lei

OPRITOARE KORDA HAIR RIG EXTENDA S

OPRITOARE KORDA HAIR RIG EXTENDA S

kexss
Livrare imediată!

19,80Lei

Cap Rezerva Hanger KORDA Stow Head, Orange

Cap Rezerva Hanger KORDA Stow Head, Orange

keb24
Livrare 7-14 zile

51,79Lei

TUB ANTI TANGLE KORDA SCUFUNDATOR D=0,75MM 2M WEED

TUB ANTI TANGLE KORDA SCUFUNDATOR D=0,75MM 2M WEED

ktw
Livrare imediată!

17,48Lei

Burghiu KORDA Bait Drill, 8mm

Burghiu KORDA Bait Drill, 8mm

krt004
Livrare imediată!

44,17Lei

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

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

kksxx2
Livrare imediată!

33,90Lei

BuzzBar KORDA Singlez Black, 2 posturi, 4.5inch/11cm

BuzzBar KORDA Singlez Black, 2 posturi, 4.5inch/11cm

ksing27
Livrare 7-14 zile

214,02Lei

CARLIG KORDA KURV SHANK XX NR.1 10BUC/PLIC

CARLIG KORDA KURV SHANK XX NR.1 10BUC/PLIC

kksxx1
Livrare imediată!

33,90Lei

Montura cu Vartej KORDA Dark Matter Leader Ring Swivel, Gravel, 30lbs, 30cm

Montura cu Vartej KORDA Dark Matter Leader Ring Swivel, Gravel, 30lbs, 30cm

ksz54
Livrare 7-14 zile

39,08Lei

FIR KORDA FLUOROCARBON IQ 15LBS/20M

FIR KORDA FLUOROCARBON IQ 15LBS/20M

kiq15
Livrare 7-14 zile

69,24Lei

Plumb Para KORDA Pear Swivel, 3oz/84gr, 1buc/pac

Plumb Para KORDA Pear Swivel, 3oz/84gr, 1buc/pac

ps3
Livrare 7-14 zile

15,19Lei

PROTECTIE CAUCIUC ANTI TANGLE 25BUC/PL SILT KORDA

PROTECTIE CAUCIUC ANTI TANGLE 25BUC/PL SILT KORDA

katss
Livrare imediată!

25,58Lei

Plumb KORDA Square Pear Swivel, 2.5oz/70gr, 2buc/pac

Plumb KORDA Square Pear Swivel, 2.5oz/70gr, 2buc/pac

sqpsb25
Livrare 7-14 zile

26,37Lei

Sapca Korda Kore TK Digital Kamo

Sapca Korda Kore TK Digital Kamo

kbc11
Livrare imediată!

86,01Lei

Afişare 1301 - 1320 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: 105.237 ms [By time] [By id] [By file]
1 (0.086)
SELECT data
FROM `oc_session`
WHERE session_id = 'a78fda3750864f2443e08a9f1d'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.138)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.133)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.099)
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 (43.230)
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 (61.424)
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 1300,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.127)
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