Carp Expert


Plumb Culisant Backlead Carp Expert 120g

Plumb Culisant Backlead Carp Expert 120g

79007512
Livrare 24-48 ore

28,27Lei

Montura Crap CARP EXPERT Smart Longcast Rig cu Bait Sting, 40g

Montura Crap CARP EXPERT Smart Longcast Rig cu Bait Sting, 40g

79881040
Livrare imediată!

21,34Lei

Fir Monofilament CARP EXPERT Silver Mono 300m, 0.50mm, 29.33kg

Fir Monofilament CARP EXPERT Silver Mono 300m, 0.50mm, 29.33kg

33211350
Livrare 24-48 ore

29,73Lei

Momitor CARP EXPERT GIGANT INLINE VARIO 25g plus 20g

Momitor CARP EXPERT GIGANT INLINE VARIO 25g plus 20g

58270526
Livrare imediată!

13,10Lei

Fir Monofilament Carp Expert Specialist Score XL, Dark Brown, 0.22mm, 6.73kg, 600m

Fir Monofilament Carp Expert Specialist Score XL, Dark Brown, 0.22mm, 6.73kg, 600m

33554022
Livrare 24-48 ore

57,84Lei

Montura CARP EXPERT Long Shank Boilie Rig, Nr.4, 2buc/pac

Montura CARP EXPERT Long Shank Boilie Rig, Nr.4, 2buc/pac

42860140
Livrare 24-48 ore

10,21Lei

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

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

30147035
Livrare 24-48 ore

50,72Lei

Montura Carp Expert Plumb Pierdut Leadcore Smart Brown, 3buc/pac

Montura Carp Expert Plumb Pierdut Leadcore Smart Brown, 3buc/pac

42775130
Livrare 24-48 ore

24,12Lei

Juvelnic Competitie CARP EXPERT Pro, 3m

Juvelnic Competitie CARP EXPERT Pro, 3m

72097300
Livrare 24-48 ore

252,78Lei

Suport Lansete Carp Expert Catch 2

Suport Lansete Carp Expert Catch 2

79639280
Livrare 24-48 ore

22,78Lei

Lanseta CARP EXPERT Hard River Feeder 3.60m, 90-180g, 3+3seg

Lanseta CARP EXPERT Hard River Feeder 3.60m, 90-180g, 3+3seg

16005360
Livrare 24-48 ore

317,13Lei

Rezerva Plasa Solubila Saculeti CARP EXPERT Micro PVA CXP, 35mm, 5m

Rezerva Plasa Solubila Saculeti CARP EXPERT Micro PVA CXP, 35mm, 5m

30145535
Livrare 24-48 ore

31,40Lei

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

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

33201620
Livrare 24-48 ore

40,72Lei

LANSETA CARP EXPERT FEEDER SMART 3.90m 40-80g

LANSETA CARP EXPERT FEEDER SMART 3.90m 40-80g

14083392
Livrare 24-48 ore

141,22Lei

PORUMB CARP EXPERT SILICORN FLOTANT USTUROI

PORUMB CARP EXPERT SILICORN FLOTANT USTUROI

79466146
Livrare 24-48 ore

14,12Lei

TRIPOD CARP EXPERT METHOD 48x46x55 cm

TRIPOD CARP EXPERT METHOD 48x46x55 cm

77090145
Livrare imediată!

95,57Lei

LANSETA CARP EXPERT FEEDER MAX2 3.60m 30-60g

LANSETA CARP EXPERT FEEDER MAX2 3.60m 30-60g

13322360
Livrare 24-48 ore

357,80Lei

Fotoliu Carp Expert Comfort Camo 50x38x55cm, 5,5kg

Fotoliu Carp Expert Comfort Camo 50x38x55cm, 5,5kg

73701070
Livrare imediată!

463,65Lei

Fir Monofilament Carp Expert Fluorocarbon Coated, Clear, 8.73kg, 0.25mm, 300m

Fir Monofilament Carp Expert Fluorocarbon Coated, Clear, 8.73kg, 0.25mm, 300m

33556025
Livrare 24-48 ore

36,49Lei

Rezerva Plasa Solubila Saculeti CARP EXPERT Anti Fraying, 35mm, 5m

Rezerva Plasa Solubila Saculeti CARP EXPERT Anti Fraying, 35mm, 5m

30147535
Livrare 24-48 ore

39,54Lei

Afişare 21 - 40 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: 81.411 ms [By time] [By id] [By file]
1 (0.143)
SELECT data
FROM `oc_session`
WHERE session_id = '3cbf5f1f965bc5bb1c8c7bc2c1'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.071)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.092)
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.088)
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 (35.986)
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 (44.897)
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 20,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