Carp Expert


SALTEA PRIMIRE CARP EXPERT CARP WISE 105X50CM

SALTEA PRIMIRE CARP EXPERT CARP WISE 105X50CM

73756604
Livrare 24-48 ore

280,51Lei

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

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

16006360
Livrare 24-48 ore

347,63Lei

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

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

30146025
Livrare 24-48 ore

41,58Lei

Juvelnic CARP EXPERT Advancer Keepnet 4m, 50cm

Juvelnic CARP EXPERT Advancer Keepnet 4m, 50cm

72095400
Livrare 24-48 ore

197,02Lei

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

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

33201628
Livrare 24-48 ore

42,18Lei

Degetar Carp Expert Neopren

Degetar Carp Expert Neopren

74300911
Livrare 24-48 ore

36,49Lei

Set de accesorii Carp Expert Rapid All-In Feeder

Set de accesorii Carp Expert Rapid All-In Feeder

79020790
Livrare 24-48 ore

43,64Lei

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

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

12255360
Livrare 24-48 ore

215,44Lei

Mulineta Carp Expert Score, 6500

Mulineta Carp Expert Score, 6500

20211650
Livrare 24-48 ore

265,27Lei

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

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

17312400
Livrare 24-48 ore

112,91Lei

LANSETA CARP EXPERT FEEDER MAX2 3.90m 60-100g

LANSETA CARP EXPERT FEEDER MAX2 3.90m 60-100g

13323390
Livrare imediată!

374,07Lei

Set Montura Rapid PVA Bomb, 40g+40g

Set Montura Rapid PVA Bomb, 40g+40g

79895040
Livrare 24-48 ore

71,46Lei

Plumb Culisant Backlead Carp Expert 100g

Plumb Culisant Backlead Carp Expert 100g

79007510
Livrare 24-48 ore

24,12Lei

Montura Crap CARP EXPERT Smart Longcast Rig, 60g

Montura Crap CARP EXPERT Smart Longcast Rig, 60g

79880060
Livrare imediată!

21,34Lei

Fir Monofilament CARP EXPERT Silver Mono 300m, 0.35mm, 15.33kg

Fir Monofilament CARP EXPERT Silver Mono 300m, 0.35mm, 15.33kg

33211335
Livrare 24-48 ore

28,27Lei

Momitor CARP EXPERT LONG-CAST GIGANT VARIO 25 + 20 gr

Momitor CARP EXPERT LONG-CAST GIGANT VARIO 25 + 20 gr

58270426
Livrare imediată!

13,10Lei

Saltea Receptie Carp Expert 85x40x20cm

Saltea Receptie Carp Expert 85x40x20cm

73756607
Livrare 24-48 ore

221,55Lei

Fir Monofilament Carp Expert Specialist Pelso, Multicolor, 0.30mm, 11.35kg, 300m

Fir Monofilament Carp Expert Specialist Pelso, Multicolor, 0.30mm, 11.35kg, 300m

33552030
Livrare 24-48 ore

38,51Lei

Opritoare Boilies Carp Expert V Stopper

Opritoare Boilies Carp Expert V Stopper

79630363
Livrare imediată!

6,06Lei

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

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

16015390
Livrare 24-48 ore

398,47Lei

Afişare 1 - 20 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: 77.871 ms [By time] [By id] [By file]
1 (0.151)
SELECT data
FROM `oc_session`
WHERE session_id = '9aedb06df29763b97788aa8a67'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.118)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.136)
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.130)
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 (32.747)
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.424)
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 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.165)
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