Pescamania


Set Buzzbar Cu Pichet + Geanta 40-60cm/22cm

Set Buzzbar Cu Pichet + Geanta 40-60cm/22cm

6124-102
Livrare imediată!

194,19Lei

Cutie Pescamania Adanca 35.5x23x9.5cm 5 compartimente

Cutie Pescamania Adanca 35.5x23x9.5cm 5 compartimente

t-sf381
Livrare imediată!

56,92Lei

Buzz Bar Smart DLX 30cm 3 Posturi

Buzz Bar Smart DLX 30cm 3 Posturi

6231-330
Livrare imediată!

59,97Lei

Spin Pentru Momeala Carp Academy ,10mm, 10buc/plic

Spin Pentru Momeala Carp Academy ,10mm, 10buc/plic

8100-222
Livrare 48-72 ore

9,14Lei

Buzz Bar Smart DLX 20cm 2 Posturi

Buzz Bar Smart DLX 20cm 2 Posturi

6231-220
Livrare imediată!

44,72Lei

Buzz Bar Smart DLX 30cm 2 Posturi

Buzz Bar Smart DLX 30cm 2 Posturi

6231-230
Livrare 48-72 ore

53,87Lei

Saltea De Cantarire Wayback Cu Flotor -20%

Saltea De Cantarire Wayback Cu Flotor

5122-200
Livrare imediată!

299,00Lei(-20%) 237,81Lei

Scaun F2 Feeder Cu Spatar Si Picioare Reglabile

Scaun F2 Feeder Cu Spatar Si Picioare Reglabile

kl-f2
Livrare imediată!

529,74Lei

Spin Pentru Momeala Carp Academy 7mm

Spin Pentru Momeala Carp Academy 7mm

8100-270
Livrare 48-72 ore

11,07Lei

Buzz Bar Smart DLX 40cm 2 Posturi

Buzz Bar Smart DLX 40cm 2 Posturi

6231-240
Livrare imediată!

59,97Lei

Saltea Masurare Capturi Reiva 1.3m

Saltea Masurare Capturi Reiva 1.3m

5220-012
Livrare imediată!

100,65Lei

RIGLA SPORTEX MASURA CAPTURI SPORTEX 140cm

RIGLA SPORTEX MASURA CAPTURI SPORTEX 140cm

s300710
Livrare 48-72 ore

113,76Lei

Carlige Legate Barbless cu Spin Steg, Nr.6, 4buc/pac

Carlige Legate Barbless cu Spin Steg, Nr.6, 4buc/pac

8103-906
Livrare 48-72 ore

11,89Lei

Rod Pod Euro Nou 360 (6113-360)

Rod Pod Euro Nou 360 (6113-360)

6113-360
Livrare imediată!

672,09Lei

Set Buzzbar Cu Pichet + Geanta 40-60cm/25cm

Set Buzzbar Cu Pichet + Geanta 40-60cm/25cm

6124-101
Livrare imediată!

199,27Lei

BUZZ BAR SMART DLX 25CM 2 POSTURI

BUZZ BAR SMART DLX 25CM 2 POSTURI

6231-225
Livrare imediată!

44,72Lei

Masuta Cuzo ST 5, 60x40x4cm

Masuta Cuzo ST 5, 60x40x4cm

kl-st5
Livrare 48-72 ore

224,70Lei

Geanta Transport Buzzbar Carp Academy

Geanta Transport Buzzbar Carp Academy

5292-001
Livrare imediată!

59,97Lei

Pluta Pescamania River2 4G

Pluta Pescamania River2 4G

pesc2-40
Livrare imediată!

5,98Lei

Pluta Pescamania A-13 1g 3mm

Pluta Pescamania A-13 1g 3mm

p-a13-1
Livrare imediată!

4,97Lei

Afişare 1 - 20 din 29 (2 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: 48.728 ms [By time] [By id] [By file]
1 (0.129)
SELECT data
FROM `oc_session`
WHERE session_id = 'e15875a84079289c500cea33cc'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.125)
SELECT *
FROM oc_url_alias
WHERE keyword = 'pescamania.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.125)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '428' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (25.493)
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 = '3' AND p.manufacturer_id = '428'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (22.637)
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 = '3' AND p.manufacturer_id = '428' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.118)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37