Korda


MONTURA PLUMB PIERDUT KORDA HELI SAFE

MONTURA PLUMB PIERDUT KORDA HELI SAFE

khdg
Livrare imediată!

40,98Lei

Montura KORDA Carp Rig Dark Matter Wide Gape + Free Extenda Stops, Barbless, 1buc/blister Nr.10/15lbs
PROTECTIE CAUCIUC KORDA ANTI TANGLE 25BUC/PL CLAY

PROTECTIE CAUCIUC KORDA ANTI TANGLE 25BUC/PL CLAY

katsc
Livrare 7-14 zile

25,58Lei

Greutati Suplimentare Hanger KORDA Stow , 8g, 3buc/pac

Greutati Suplimentare Hanger KORDA Stow , 8g, 3buc/pac

keb18
Livrare 7-14 zile

46,71Lei

TUB SHOCK LEADER KORDA PT PB IN LINE 10BUC/PL

TUB SHOCK LEADER KORDA PT PB IN LINE 10BUC/PL

kss
Livrare imediată!

31,84Lei

Carlige KORDA KRANK NR.2 10BUC/PLIC

Carlige KORDA KRANK NR.2 10BUC/PLIC

kkr2
Livrare imediată!

31,67Lei

FIR TEXTIL KORDA DARK MATTER 20LB/20M

FIR TEXTIL KORDA DARK MATTER 20LB/20M

kdmb20
Livrare imediată!

93,10Lei

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

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

ksz48
Livrare 7-14 zile

40,45Lei

VARTEJ KORDA NR8 CU PRINDERE RAPIDA 8BUC PL

VARTEJ KORDA NR8 CU PRINDERE RAPIDA 8BUC PL

kqr8
Livrare imediată!

26,93Lei

Plumb cu Vartej KORDA Distance Casting Swivel, Gravel, 5oz/140g, 2buc/pac

Plumb cu Vartej KORDA Distance Casting Swivel, Gravel, 5oz/140g, 2buc/pac

dcsg5
Livrare imediată!

31,45Lei

ATRACTANT KORDA GOO SUPREME SPICY SQUID 115ML

ATRACTANT KORDA GOO SUPREME SPICY SQUID 115ML

kgoo15
Livrare imediată!

95,15Lei

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

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

sqps25
Livrare 7-14 zile

13,66Lei

MONTURA KORDA BOOMS QC 14CM, 25LB

MONTURA KORDA BOOMS QC 14CM, 25LB

kcr110
Livrare imediată!

23,55Lei

Pelete Artificiale KORDA Slow Sinking Dumbell, IB, Yellow, 8mm, 10buc/pac

Pelete Artificiale KORDA Slow Sinking Dumbell, IB, Yellow, 8mm, 10buc/pac

kpb35
Livrare 7-14 zile

23,82Lei

Cutie Accesorii Korda Mini Compartment Boxes 6 Compartimente

Cutie Accesorii Korda Mini Compartment Boxes 6 Compartimente

kbox8
Livrare imediată!

50,40Lei

Plumb Texturat KORDA Textured Distance Casting Swivel, 2.5oz/70g, 1buc/pac

Plumb Texturat KORDA Textured Distance Casting Swivel, 2.5oz/70g, 1buc/pac

tdcs25
Livrare 7-14 zile

13,66Lei

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

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

kam15
Livrare imediată!

45,70Lei

ATRACTANT KORDA OUTRAGEOUS ORANGE SUPREME 115ML

ATRACTANT KORDA OUTRAGEOUS ORANGE SUPREME 115ML

goo41
Livrare imediată!

98,19Lei

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

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

fpib35
Livrare 7-14 zile

28,91Lei

Carlige Korda Kamakura Wide Gape X Nr 8 10buc/cutie

Carlige Korda Kamakura Wide Gape X Nr 8 10buc/cutie

kam28
Livrare imediată!

45,70Lei

Afişare 981 - 1000 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: 94.453 ms [By time] [By id] [By file]
1 (0.120)
SELECT data
FROM `oc_session`
WHERE session_id = '963f1f8f631773cca24dbf51d4'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.089)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.089)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.086)
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 (37.058)
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 (56.753)
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 980,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.258)
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