Konger


Kit Method Feeder Konger 2 Feedere 70-80gr + 1 Matrita

Kit Method Feeder Konger 2 Feedere 70-80gr + 1 Matrita

40806960002009
Livrare imediată!

42,30Lei

Rig Crap Konger Kamatsu Pro Carp Kiji Expert, Nr.2, 25lbs, 25cm, 2buc/pac

Rig Crap Konger Kamatsu Pro Carp Kiji Expert, Nr.2, 25lbs, 25cm, 2buc/pac

120206501120302
Livrare 48-72 ore

10,72Lei

Lanseta KONGER Venom Skipper Spin 2.28m, 10-35g, 2seg

Lanseta KONGER Venom Skipper Spin 2.28m, 10-35g, 2seg

20406165003228
Livrare 48-72 ore

274,37Lei

Varga Konger Grafitex Pole 3.00m, 5-20gr, 3seg

Varga Konger Grafitex Pole 3.00m, 5-20gr, 3seg

10106143002300
Livrare imediată!

47,26Lei

Carlige Konger Carplabs Method Feeder Barbless Titanium Grey Ringed Nr.16, 6buc/pac

Carlige Konger Carplabs Method Feeder Barbless Titanium Grey Ringed Nr.16, 6buc/pac

120506765111916
Livrare 48-72 ore

10,85Lei

Spinnertail Konger Boogie, 007 Golden Perch, 4g

Spinnertail Konger Boogie, 007 Golden Perch, 4g

131606381100007
Livrare imediată!

28,86Lei

Prastie Metal Konger, Nr.5

Prastie Metal Konger, Nr.5

42306950000005
Livrare imediată!

30,27Lei

Rig Crap Konger Kamatsu Pro Carp Matsui, Nr.1, 25lbs, 20cm, 2buc/pac

Rig Crap Konger Kamatsu Pro Carp Matsui, Nr.1, 25lbs, 20cm, 2buc/pac

120206501310301
Livrare 48-72 ore

12,14Lei

Vobler KONGER Crazy Crank 40F, Satsukimasu Salmon, 4cm, 9g

Vobler KONGER Crazy Crank 40F, Satsukimasu Salmon, 4cm, 9g

131206324084005
Livrare imediată!

39,39Lei

Mulineta KONGER Dread Cat Mark I 8000 FD, 4.1:1, 0.60mm/215m, 5+1rul

Mulineta KONGER Dread Cat Mark I 8000 FD, 4.1:1, 0.60mm/215m, 5+1rul

30806005021780
Livrare 48-72 ore

216,74Lei

Carlige Konger Carplabs Stiff Rigger Titanium Grey Ringed Nr.4, 6buc/plic

Carlige Konger Carplabs Stiff Rigger Titanium Grey Ringed Nr.4, 6buc/plic

120506765105904
Livrare 48-72 ore

11,47Lei

Agrafa Rapida Konger Carplabs Quick Snap S 16mm, 10buc/plic

Agrafa Rapida Konger Carplabs Quick Snap S 16mm, 10buc/plic

41406765000052
Livrare imediată!

4,53Lei

Shad Konger Blinky, 005 Starry Night, 7.5cm, 8buc/pac

Shad Konger Blinky, 005 Starry Night, 7.5cm, 8buc/pac

130106337001006
Livrare 48-72 ore

17,19Lei

Mulineta Konger Venom FD 630, 3000, 5.1:1, 0.20mm/230m, 6rul

Mulineta Konger Venom FD 630, 3000, 5.1:1, 0.20mm/230m, 6rul

30206005039630
Livrare 48-72 ore

135,07Lei

Rig Konger Kamatsu Iseama Method Feeder Cu Spin, Monofilament, Nr.10, 0.22mm, 10cm, 5buc/pac

Rig Konger Kamatsu Iseama Method Feeder Cu Spin, Monofilament, Nr.10, 0.22mm, 10cm, 5buc/pac

120306504019310
Livrare 48-72 ore

12,66Lei

Lanseta KONGER Dread Cat Ground Rod, Up To 500g, 3.15m, 2seg

Lanseta KONGER Dread Cat Ground Rod, Up To 500g, 3.15m, 2seg

20306865200315
Livrare 48-72 ore

448,12Lei

Fir Inaintas Konger Kevlar Dread Cat Leader Negru, 10m, 1.24mm, 150kg

Fir Inaintas Konger Kevlar Dread Cat Leader Negru, 10m, 1.24mm, 150kg

110406285011150
Livrare imediată!

43,25Lei

Shad Konger Blinky, 014 Glitter Police, 7.5cm, 8buc/pac

Shad Konger Blinky, 014 Glitter Police, 7.5cm, 8buc/pac

130106337001014
Livrare 48-72 ore

17,19Lei

Lanseta Konger Grafitex Spin 2.40m, 25g, 2seg

Lanseta Konger Grafitex Spin 2.40m, 25g, 2seg

20406143011240
Livrare 48-72 ore

138,38Lei

Lanseta Konger Katmaster Jig Zander Pro 2.50m, 5-24g

Lanseta Konger Katmaster Jig Zander Pro 2.50m, 5-24g

20406163004250
Livrare 48-72 ore

330,68Lei

Afişare 121 - 140 din 382 (20 pagini)
Queries: 7, Total time: 71.754 ms [By time] [By id] [By file]
1 (0.111)
SELECT data
FROM `oc_session`
WHERE session_id = '1c852824ab2fdcff9fe391228a'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.093)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.104)
SELECT *
FROM oc_url_alias
WHERE keyword = 'konger.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.111)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '500' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (34.475)
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 = '500'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (36.735)
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 = '500' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 120,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.125)
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