Carp Expert


Montura Carp Expert Heli Chod Leadcore Cu Agrafa Rapida, 3buc/pac

Montura Carp Expert Heli Chod Leadcore Cu Agrafa Rapida, 3buc/pac

42775150
Livrare 24-48 ore

24,12Lei

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

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

16005390
Livrare imediată!

336,55Lei

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

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

30145545
Livrare 24-48 ore

32,42Lei

Juvelnic CARP EXPERT Advancer Keepnet 3m, 50cm

Juvelnic CARP EXPERT Advancer Keepnet 3m, 50cm

72095300
Livrare 24-48 ore

183,12Lei

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

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

33201625
Livrare 24-48 ore

42,18Lei

Mulineta Carp Expert Advancer Runner 6000

Mulineta Carp Expert Advancer Runner 6000

20231600
Livrare 24-48 ore

107,67Lei

Mulineta Carp Expert Score, 5500

Mulineta Carp Expert Score, 5500

20211550
Livrare 24-48 ore

281,54Lei

Lanseta Bolognesa CARP EXPER Specialist Bolo, 5-25g, 5m, 5seg

Lanseta Bolognesa CARP EXPER Specialist Bolo, 5-25g, 5m, 5seg

17312500
Livrare 24-48 ore

128,90Lei

LANSETA CARP EXPERT FEEDER MAX2 3.60m 60-100g

LANSETA CARP EXPERT FEEDER MAX2 3.60m 60-100g

13323360
Livrare imediată!

357,80Lei

Lanseta Carp Expert Smart Spod 3.75m, 5lb, 3seg

Lanseta Carp Expert Smart Spod 3.75m, 5lb, 3seg

12565376
Livrare imediată!

183,92Lei

Set Montura Rapid PVA Bomb, 30g+30g

Set Montura Rapid PVA Bomb, 30g+30g

79895030
Livrare imediată!

71,46Lei

Plumb Culisant Backlead Carp Expert 70g

Plumb Culisant Backlead Carp Expert 70g

79007507
Livrare 24-48 ore

24,12Lei

Fir Monofilament Carp Expert Fluorocarbon Coated, Clear, 5.35kg, 0.20mm, 300m

Fir Monofilament Carp Expert Fluorocarbon Coated, Clear, 5.35kg, 0.20mm, 300m

33556020
Livrare 24-48 ore

32,66Lei

Rezerva Plasa Solubila Saculeti CARP EXPERT Anti Fraying, 45mm, 10m

Rezerva Plasa Solubila Saculeti CARP EXPERT Anti Fraying, 45mm, 10m

30147645
Livrare 24-48 ore

56,82Lei

Mulineta CARP EXPERT Purple Feeder 6000, 5.5:1, 0.30mm/155m, 7+1rul

Mulineta CARP EXPERT Purple Feeder 6000, 5.5:1, 0.30mm/155m, 7+1rul

20930600
Livrare 24-48 ore

238,87Lei

Fir Monofilament CARP EXPERT Silver Mono 300m, 0.30mm, 12.08kg

Fir Monofilament CARP EXPERT Silver Mono 300m, 0.30mm, 12.08kg

33211330
Livrare 24-48 ore

28,27Lei

MINCIOG CARP EXPERT LIGHT 2.5M 55x60x40 cm

MINCIOG CARP EXPERT LIGHT 2.5M 55x60x40 cm

71050250
Livrare imediată!

75,23Lei

Cantar Digital Carp Expert

Cantar Digital Carp Expert

80213128
Livrare 24-48 ore

71,06Lei

Fir Monofilament Carp Expert Specialist Pelso, Multicolor, 0.25mm, 8.63kg, 300m

Fir Monofilament Carp Expert Specialist Pelso, Multicolor, 0.25mm, 8.63kg, 300m

33552025
Livrare 24-48 ore

35,47Lei

Lanseta CARP EXPERT Fine Method Feeder 3.60m, 40-90g, 3+3seg

Lanseta CARP EXPERT Fine Method Feeder 3.60m, 40-90g, 3+3seg

16015360
Livrare 24-48 ore

357,80Lei

Afişare 41 - 60 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: 74.914 ms [By time] [By id] [By file]
1 (0.163)
SELECT data
FROM `oc_session`
WHERE session_id = '3cbf5f1f965bc5bb1c8c7bc2c1'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.100)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.135)
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.108)
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 (33.371)
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 (40.912)
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 40,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.124)
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