Carp Expert


Juvelnic Carp Expert Feeder Match, 4.00m, 40x50cm

Juvelnic Carp Expert Feeder Match, 4.00m, 40x50cm

72092400
Livrare 24-48 ore

251,03Lei

Plumb Carp Expert Montura Pluta Fitofag Lead Ring, 40g, 1buc/pac

Plumb Carp Expert Montura Pluta Fitofag Lead Ring, 40g, 1buc/pac

53226040
Livrare 24-48 ore

13,90Lei

Set Leduri CARP EXPERT Silver Pentru Plutele De Fitofag

Set Leduri CARP EXPERT Silver Pentru Plutele De Fitofag

74942800
Livrare 24-48 ore

14,91Lei

Fir Carp Expert Carbon 0.25mm 300m

Fir Carp Expert Carbon 0.25mm 300m

30101025
Livrare imediată!

19,30Lei

Coada Minciog Mufabila CXP Method Feeder 300 3m

Coada Minciog Mufabila CXP Method Feeder 300 3m

71731300
Livrare imediată!

74,11Lei

Fir Monofilament Carp Expert Fluorocarbon Coated, Clear, 14.29kg, 0.35mm, 300m

Fir Monofilament Carp Expert Fluorocarbon Coated, Clear, 14.29kg, 0.35mm, 300m

33556035
Livrare 24-48 ore

38,51Lei

Kit PVA System CARP EXPERT Anti Fraying, 35mm, 10m

Kit PVA System CARP EXPERT Anti Fraying, 35mm, 10m

30147235
Livrare 24-48 ore

63,94Lei

Ochelari de Soare CARP EXPERT Polarmax

Ochelari de Soare CARP EXPERT Polarmax

74101503
Livrare 24-48 ore

113,44Lei

Set Opritoare Carp Expert Cauciuc Deluxe 4 Marimi 100buc

Set Opritoare Carp Expert Cauciuc Deluxe 4 Marimi 100buc

79018500
Livrare imediată!

14,12Lei

Cobra Nadire Carp Expert Cobra 20mm

Cobra Nadire Carp Expert Cobra 20mm

79652120
Livrare imediată!

54,79Lei

Lanseta CARP EXPERT Hard River Feeder 3.90m, 100-250g, 3+3seg

Lanseta CARP EXPERT Hard River Feeder 3.90m, 100-250g, 3+3seg

16006390
Livrare imediată!

367,97Lei

Kit PVA System CARP EXPERT 4 Season, 35mm, 5m

Kit PVA System CARP EXPERT 4 Season, 35mm, 5m

30146035
Livrare 24-48 ore

43,60Lei

Montura Crap CARP EXPERT Smart Longcast Rig, 40g

Montura Crap CARP EXPERT Smart Longcast Rig, 40g

79880040
Livrare 24-48 ore

18,51Lei

Fir Monofilament CARP EXPERT Chameleon, Dark Green, 600m, 0.30mm

Fir Monofilament CARP EXPERT Chameleon, Dark Green, 600m, 0.30mm

33201630
Livrare 24-48 ore

43,64Lei

Montura CARP EXPERT Smart Classic Boilie Rig, Nr.2, 2buc/pac

Montura CARP EXPERT Smart Classic Boilie Rig, Nr.2, 2buc/pac

42860020
Livrare imediată!

11,07Lei

Lanseta Carp Expert Starfish Feeder, 3.90m, 80-150g, 3+3seg

Lanseta Carp Expert Starfish Feeder, 3.90m, 80-150g, 3+3seg

12255390
Livrare 24-48 ore

225,60Lei

LANSETA CARP EXPERT FEEDER MAX2 3.60m 100-150g

LANSETA CARP EXPERT FEEDER MAX2 3.60m 100-150g

13324360
Livrare imediată!

400,50Lei

Set Montura Rapid PVA Bomb, 50g+50g

Set Montura Rapid PVA Bomb, 50g+50g

79895050
Livrare imediată!

71,46Lei

Plumb Culisant Backlead Carp Expert 110g

Plumb Culisant Backlead Carp Expert 110g

79007451
Livrare 24-48 ore

25,30Lei

Montura Crap CARP EXPERT Smart Longcast Rig, 80g

Montura Crap CARP EXPERT Smart Longcast Rig, 80g

79880080
Livrare imediată!

24,39Lei

Afişare 81 - 100 din 809 (41 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: 83.205 ms [By time] [By id] [By file]
1 (0.147)
SELECT data
FROM `oc_session`
WHERE session_id = '3cbf5f1f965bc5bb1c8c7bc2c1'
/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.096)
SELECT *
FROM oc_url_alias
WHERE keyword = 'carp-expert.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.098)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '27' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (37.163)
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 = '27'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (45.474)
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 = '27' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 80,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.134)
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