Berkley


Jig BERKLEY Flex Pike Head, Nr.3/0, 10g, 120buc/pac

Jig BERKLEY Flex Pike Head, Nr.3/0, 10g, 120buc/pac

1303823
Livrare 7-14 zile

366,03Lei

Shad Berkley Pulse Realistic Goby, Goby, 7cm

Shad Berkley Pulse Realistic Goby, Goby, 7cm

1543334-bucxxx
Livrare imediată!

9,96Lei

Fir Textil BERKLEY Superline X9 Low vis Green, 2000m, 0.40mm, 45.60kg

Fir Textil BERKLEY Superline X9 Low vis Green, 2000m, 0.40mm, 45.60kg

1486843
Livrare 7-14 zile

1.453,00Lei

Spinnertail Berkley Pulse Spintail XL, Fegis, 10cm, 28g

Spinnertail Berkley Pulse Spintail XL, Fegis, 10cm, 28g

1572741
Livrare imediată!

66,08Lei

Fir Monofilament Inaintas Conic BERKLEY Nautil Tapared Transparent, 0.20-0.57mm, 5X15m/75m -19%

Fir Monofilament Inaintas Conic BERKLEY Nautil Tapared Transparent, 0.20-0.57mm, 5X15m/75m

1560536
Livrare imediată!

55,20Lei(-19%) 44,62Lei

Shad BERKLEY Sick Vamper, Cotton Candy, 14cm, 30buc/pac

Shad BERKLEY Sick Vamper, Cotton Candy, 14cm, 30buc/pac

1531855
Livrare 7-14 zile

309,18Lei

Pasta Berkley PowerBait Glow-in-the-Dark Trout Bait, Sunshine Yellow, 50g

Pasta Berkley PowerBait Glow-in-the-Dark Trout Bait, Sunshine Yellow, 50g

1105178
Livrare imediată!

32,98Lei

Shad BERKLEY Sick Flanker, Motoroil Burbot , 8cm, 60buc/pac

Shad BERKLEY Sick Flanker, Motoroil Burbot , 8cm, 60buc/pac

1536404
Livrare 7-14 zile

418,08Lei

Lanseta Berkley URBN Jigger ML, 5-21g, 2.40m, 2seg

Lanseta Berkley URBN Jigger ML, 5-21g, 2.40m, 2seg

1589686
Livrare imediată!

323,32Lei

Grub BERKLEY Sick Curl, Bream, 8cm, 48buc/pac

Grub BERKLEY Sick Curl, Bream, 8cm, 48buc/pac

1536483
Livrare 7-14 zile

309,18Lei

Spinnertail Berkley Pulse, Dark N Dirty Roach, 14g, 7cm

Spinnertail Berkley Pulse, Dark N Dirty Roach, 14g, 7cm

1519669
Livrare imediată!

39,64Lei

Larve Power Bait Pupa, Milky White, 3.5cm, 10buc/cutie

Larve Power Bait Pupa, Milky White, 3.5cm, 10buc/cutie

1594924
Livrare imediată!

38,62Lei

Vobler BERKLEY Dex Mullet Popper, 14.5cm, 69g, White Chartreuse, 1buc/pac

Vobler BERKLEY Dex Mullet Popper, 14.5cm, 69g, White Chartreuse, 1buc/pac

1550599
Livrare 7-14 zile

82,30Lei

Chatterbait BERKLEY Hard Bait DEX TG, Hot Pink, 8cm, 11g

Chatterbait BERKLEY Hard Bait DEX TG, Hot Pink, 8cm, 11g

1570827
Livrare 7-14 zile

70,10Lei

Fir Textil BERKLEY FireLine Fused Original, Crystal, 0.20mm, 150m

Fir Textil BERKLEY FireLine Fused Original, Crystal, 0.20mm, 150m

1553676
Livrare 7-14 zile

87,43Lei

Chatterbait BERKLEY Hard Bait DEX TG, Wagasaki, 7.5cm, 7g

Chatterbait BERKLEY Hard Bait DEX TG, Wagasaki, 7.5cm, 7g

1570820
Livrare 7-14 zile

68,11Lei

Fir Textil BERKLEY FireLine Fused Original, Smoke, 0.12mm, 1800m

Fir Textil BERKLEY FireLine Fused Original, Smoke, 0.12mm, 1800m

1553713
Livrare 7-14 zile

999,50Lei

Larve Power Bait Pupa, Fluorescent Orange/Sunshine Yellow, 4.5cm, 8buc/cutie

Larve Power Bait Pupa, Fluorescent Orange/Sunshine Yellow, 4.5cm, 8buc/cutie

p.1594932
Livrare 24-48 ore

43,89Lei

Pasta BERKLEY PowerBait EU Glitter Trout Dough, Smoke N Fire Glitter, 50g

Pasta BERKLEY PowerBait EU Glitter Trout Dough, Smoke N Fire Glitter, 50g

1633582
Livrare 7-14 zile

37,61Lei

Shad BERKLEY Sick Smash, Bloody Burbot, 23cm, 12buc/pac

Shad BERKLEY Sick Smash, Bloody Burbot, 23cm, 12buc/pac

1570927
Livrare 7-14 zile

610,07Lei

Afişare 2341 - 2360 din 2439 (122 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: 182.729 ms [By time] [By id] [By file]
1 (0.114)
SELECT data
FROM `oc_session`
WHERE session_id = 'd9d04efcbf455066552b885b1c'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.117)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.124)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Berkley'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.124)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '54' AND m2s.store_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (75.256)
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 = '54'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (106.860)
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 = '54' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 2340,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.134)
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