Korum


Carlige Legate KORUM Big Fish Hair Rigs with Quickstop 38cm, Nr.10 Barbless, 8buc/pac -45%

Carlige Legate KORUM Big Fish Hair Rigs with Quickstop 38cm, Nr.10 Barbless, 8buc/pac

k0310053
Livrare 7-14 zile

15,99Lei(-45%) 8,75Lei

Cap Minciog Pliabil Korum Folding Spoon 30" 75x65

Cap Minciog Pliabil Korum Folding Spoon 30" 75x65

k0380011
Livrare imediată!

134,96Lei

LANSETA KORUM BIG WATER 3.65M 2.25LBS 2seg

LANSETA KORUM BIG WATER 3.65M 2.25LBS 2seg

k0330040
Livrare imediată!

674,96Lei

Bilute Antisoc Korum Camo Quick Change Bead L, 8buc/plic

Bilute Antisoc Korum Camo Quick Change Bead L, 8buc/plic

k0310219
Livrare 7-14 zile

15,76Lei

Cosulet Naditor Korum Open End Feeder, Medium, 75g, 1buc/pac

Cosulet Naditor Korum Open End Feeder, Medium, 75g, 1buc/pac

k0320079
Livrare 7-14 zile

17,96Lei

Lanseta Korum Limitless Feeder Rods, 220g, 4.20m, 3+2seg

Lanseta Korum Limitless Feeder Rods, 220g, 4.20m, 3+2seg

k0330062
Livrare imediată!

427,46Lei

Cosulet Naditor KORUM Combi Feeder, Medium, 30g, 1buc/pac

Cosulet Naditor KORUM Combi Feeder, Medium, 30g, 1buc/pac

k0320086
Livrare imediată!

14,63Lei

Fir Monofilament KORUM Smokeshield Mono Hooklink, 10lbs/4.50kg, 0.28mm, 50m -40%

Fir Monofilament KORUM Smokeshield Mono Hooklink, 10lbs/4.50kg, 0.28mm, 50m

k0390013
Livrare 7-14 zile

24,95Lei(-40%) 14,97Lei

Geanta KORUM Progress Bait & Bits Bag, 55x24x40cm, 25ltr -30%

Geanta KORUM Progress Bait & Bits Bag, 55x24x40cm, 25ltr

k0290105
Livrare 7-14 zile

249,95Lei(-30%) 174,97Lei

Carlige Legate KORUM Hair Rigs Barbless, 8lbs, Nr.14, 10cm, 8buc/pac

Carlige Legate KORUM Hair Rigs Barbless, 8lbs, Nr.14, 10cm, 8buc/pac

k0310309
Livrare 7-14 zile

16,87Lei

Cap Minciog Korum Speci Square Net, 22" 55x45cm

Cap Minciog Korum Speci Square Net, 22" 55x45cm

k0380017
Livrare 7-14 zile

107,96Lei

LANSETA KORUM SNAPPER ZT SPIN RODS 2.30M 3-18G 2SEG

LANSETA KORUM SNAPPER ZT SPIN RODS 2.30M 3-18G 2SEG

z0680018
Livrare imediată!

400,91Lei

Carlige KORUM Xpert Power Hook Micro-Barbed Nr.6, 10buc/plic

Carlige KORUM Xpert Power Hook Micro-Barbed Nr.6, 10buc/plic

khxpb/06
Livrare imediată!

11,25Lei

Picheti Korum Power Banksticks, 45cm

Picheti Korum Power Banksticks, 45cm

k0360062
Livrare 7-14 zile

62,96Lei

Plumbi Cu Schimbare Rapida Korum Quick Change Squolivettes, 6g, 6buc/pac

Plumbi Cu Schimbare Rapida Korum Quick Change Squolivettes, 6g, 6buc/pac

k0310232
Livrare 7-14 zile

15,76Lei

Jacheta Korum Thermashell Jacket, Green-Black, Marimea XXXXL

Jacheta Korum Thermashell Jacket, Green-Black, Marimea XXXXL

k0350130
Livrare 7-14 zile

269,96Lei

Carlige KORUM Supersteel Penetrator Hooks Barbless, Nr.12, 10buc/pac -50%

Carlige KORUM Supersteel Penetrator Hooks Barbless, Nr.12, 10buc/pac

k0310085
Livrare imediată!

12,50Lei(-50%) 6,25Lei

Suport cu Bac Nada KORUM Any Chair Groundbait Bowl

Suport cu Bac Nada KORUM Any Chair Groundbait Bowl

k0300017
Livrare 7-14 zile

188,96Lei

HUSA NEOPREN KORUM PROTECTIE VARF / TALON SUPA LITE ROD SAVER 2 ROD

HUSA NEOPREN KORUM PROTECTIE VARF / TALON SUPA LITE ROD SAVER 2 ROD

k0290069
Livrare imediată!

80,96Lei

Set Korum Camo Method Twin Pack - Large

Set Korum Camo Method Twin Pack - Large

k0320051
Livrare imediată!

38,25Lei

Afişare 161 - 180 din 435 (22 pagini)
Queries: 7, Total time: 74.040 ms [By time] [By id] [By file]
1 (0.125)
SELECT data
FROM `oc_session`
WHERE session_id = 'd5bae04b5703f9d4a5e095c342'
/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.107)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Korum'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.088)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '357' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (36.376)
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 = '357'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (37.054)
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 = '357' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 160,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.202)
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