Berkley


Husa Lanseta Berkley URBN Rod Sock

Husa Lanseta Berkley URBN Rod Sock

1531671
Livrare imediată!

46,72Lei

Fir Flourocarbon BERKLEY Trilene Clear, 50m, 0.35mm, 10.00kg

Fir Flourocarbon BERKLEY Trilene Clear, 50m, 0.35mm, 10.00kg

1391576
Livrare 7-14 zile

40,66Lei

Viermi Berkley Powerbait Honey Grey Pearl, 2.5cm

Viermi Berkley Powerbait Honey Grey Pearl, 2.5cm

1546776
Livrare imediată!

29,48Lei

Agrafa Berkley Fusion19 Finesse Snaps Nr.00 5kg 25buc/plic

Agrafa Berkley Fusion19 Finesse Snaps Nr.00 5kg 25buc/plic

1536490
Livrare imediată!

16,25Lei

Vobler BERKLEY Dex Long Shot, Holo Herring, 10cm, 10.8g, 1buc/pac

Vobler BERKLEY Dex Long Shot, Holo Herring, 10cm, 10.8g, 1buc/pac

1590488
Livrare 7-14 zile

62,01Lei

Fir Fluorocarbon BERKLEY FluoroShield Clear, 17lb/0.38mm, 274m

Fir Fluorocarbon BERKLEY FluoroShield Clear, 17lb/0.38mm, 274m

1521244
Livrare 7-14 zile

40,66Lei

Shad Berkley PowerBait Hollow Belly, Wagasaki, 12.5cm, 4buc/plic -58%

Shad Berkley PowerBait Hollow Belly, Wagasaki, 12.5cm, 4buc/plic

1519536
Livrare imediată!

65,00Lei(-58%) 27,44Lei

Grub Berkley Soft Bait Sick Curl Shad Salt & Pepper, 7g, 8cm -17%

Grub Berkley Soft Bait Sick Curl Shad Salt & Pepper, 7g, 8cm

1531869-bucxxx
Livrare imediată!

6,32Lei(-17%) 5,24Lei

Shad BERKLEY Sick Flanker, Salt-Pepper, 6cm, 40buc/pac

Shad BERKLEY Sick Flanker, Salt-Pepper, 6cm, 40buc/pac

1531773
Livrare 7-14 zile

175,89Lei

Grub BERKLEY Sick Curl, Hot Firetiger, 8cm, 48buc/pac

Grub BERKLEY Sick Curl, Hot Firetiger, 8cm, 48buc/pac

1531865
Livrare 7-14 zile

309,18Lei

Shad BERKLEY Soft Bait Sick Vibe, Bream, 9cm, 60buc/pac

Shad BERKLEY Soft Bait Sick Vibe, Bream, 9cm, 60buc/pac

1536451
Livrare 7-14 zile

345,70Lei

Larve Berkley Powerbait Honeyworm, Yellow/Scales, 2.5cm, 55buc/cutie

Larve Berkley Powerbait Honeyworm, Yellow/Scales, 2.5cm, 55buc/cutie

1596315
Livrare imediată!

29,48Lei

Shad Berkley Sick Swimmer, Bloody Burbot, 11g, 9cm -8%

Shad Berkley Sick Swimmer, Bloody Burbot, 11g, 9cm

1570967-bucxxx
Livrare imediată!

9,37Lei(-8%) 8,62Lei

Cicada Berkley Powerblade, Bleak, 4.4cm, 7g

Cicada Berkley Powerblade, Bleak, 4.4cm, 7g

1595284
Livrare imediată!

37,61Lei

Vobler BERKLEY Dex Mullet Walker, 12cm, 29g, Green Mackerel, 1buc/pac

Vobler BERKLEY Dex Mullet Walker, 12cm, 29g, Green Mackerel, 1buc/pac

1550608
Livrare 7-14 zile

70,14Lei

Spinnertail Berkley Pulse Spintail XL, 8cm, 18g, Blue Silver, 1buc/pac

Spinnertail Berkley Pulse Spintail XL, 8cm, 18g, Blue Silver, 1buc/pac

1572728
Livrare imediată!

57,93Lei

Chatterbait BERKLEY Hard Bait DEX TG, Hot Pink, 9cm, 14g

Chatterbait BERKLEY Hard Bait DEX TG, Hot Pink, 9cm, 14g

1570832
Livrare 7-14 zile

74,42Lei

Fir Textil BERKLEY FireLine Fused Original, Flame Green, 0.25mm, 18.40kg, 150m

Fir Textil BERKLEY FireLine Fused Original, Flame Green, 0.25mm, 18.40kg, 150m

1553685
Livrare 7-14 zile

87,43Lei

Spinnertail Berkley Pulse Realistic Flash, Roach, 58g, 17cm, 1buc/pac

Spinnertail Berkley Pulse Realistic Flash, Roach, 58g, 17cm, 1buc/pac

1560605
Livrare 7-14 zile

82,34Lei

Fir Textil BERKLEY FireLine Fused Original, Crystal, 0.25mm, 1800m

Fir Textil BERKLEY FireLine Fused Original, Crystal, 0.25mm, 1800m

1553725
Livrare 7-14 zile

999,50Lei

Afişare 2361 - 2380 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: 119.002 ms [By time] [By id] [By file]
1 (0.125)
SELECT data
FROM `oc_session`
WHERE session_id = '03e581e4415366ef071f64e93f'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.098)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.090)
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 (39.399)
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 (79.061)
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 2360,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.105)
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