Carp Expert

Carp Expert

Sortare după:

Cobra Nadire Carp Expert Cobra 25mm

Cobra Nadire Carp Expert Cobra 25mm

79652125

Livrare 24-48 ore

58,90Lei

Cantar Digital Carp Expert

Cantar Digital Carp Expert

80213128

Livrare 24-48 ore

72,90Lei

Set Momitoare Carp Expert Heavy Duty Method Feeder Compactor Go, Green, 50g, 2buc/set

Set Momitoare Carp Expert Heavy Duty Method Feeder Compactor Go, Green, 50g, 2buc/set

58706050

Livrare imediată!

36,91Lei

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

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

33201330

Livrare 24-48 ore

29,90Lei

Fir CARP EXPERT Smart Monster Carp Monofilament, Dark Green, 0.25mm, 8.87kg, 150 m

Fir CARP EXPERT Smart Monster Carp Monofilament, Dark Green, 0.25mm, 8.87kg, 150 m

30106025

Livrare 24-48 ore

15,90Lei

Fir Monofilament CARP EXPERT Neo Camou Line Green + Brown (Camou), 0.35mm, 14.047kg, 150m

Fir Monofilament CARP EXPERT Neo Camou Line Green + Brown (Camou), 0.35mm, 14.047kg, 150m

33102035

Livrare 24-48 ore

24,90Lei

Fir Monofilament CARP EXPERT Smart Carbon Black Mono, 0.23mm, 6.57kg, 300m

Fir Monofilament CARP EXPERT Smart Carbon Black Mono, 0.23mm, 6.57kg, 300m

30100323

Livrare 24-48 ore

26,90Lei

Lanterna Cap CARP EXPERT Lumen, 230 lumeni

Lanterna Cap CARP EXPERT Lumen, 230 lumeni

74991900

Livrare 24-48 ore

57,90Lei

Fir Monofilament CARP EXPERT Premium Pro Fluo, Monofilament, Galben 0,30mm, 12.65kg, 300m

Fir Monofilament CARP EXPERT Premium Pro Fluo, Monofilament, Galben 0,30mm, 12.65kg, 300m

30130030

Livrare 24-48 ore

54,90Lei

Fir Monofilament Carp Expert Specialist Score XL, Dark Brown, 0.25mm, 7.92kg, 600m

Fir Monofilament Carp Expert Specialist Score XL, Dark Brown, 0.25mm, 7.92kg, 600m

33554025

Livrare 24-48 ore

58,90Lei

Fir Monofilament Carp Expert Fluorocarbon Coated, Clear, 11.24kg, 0.30mm, 300m

Fir Monofilament Carp Expert Fluorocarbon Coated, Clear, 11.24kg, 0.30mm, 300m

33556030

Livrare imediată!

36,91Lei

Montura Crap CARP EXPERT Smart Longcast Rig, 60g

Montura Crap CARP EXPERT Smart Longcast Rig, 60g

79880060

Livrare imediată!

22,91Lei

Set Leduri CARP EXPERT Silver Pentru Plutele De Fitofag

Set Leduri CARP EXPERT Silver Pentru Plutele De Fitofag

74942800

Livrare 24-48 ore

14,90Lei

Fir Monofilament CARP EXPERT Neo Fluo Carp Yellow, 0,40mm, 22.23kg, 150m

Fir Monofilament CARP EXPERT Neo Fluo Carp Yellow, 0,40mm, 22.23kg, 150m

30113040

Livrare 24-48 ore

15,90Lei

Fir Monofilament CARP EXPERT Smart Carbon Black Mono, 0.23mm, 6.57kg, 150m

Fir Monofilament CARP EXPERT Smart Carbon Black Mono, 0.23mm, 6.57kg, 150m

30100123

Livrare 24-48 ore

13,90Lei

Lanterna Cap CARP EXPERT Outdoor Eris

Lanterna Cap CARP EXPERT Outdoor Eris

74991506

Livrare 24-48 ore

64,90Lei

Fir Monofilament CARP EXPERT Prestige, Multicolor, Mono, 0.35mm, 15.8kg, 300m

Fir Monofilament CARP EXPERT Prestige, Multicolor, Mono, 0.35mm, 15.8kg, 300m

30126035

Livrare 24-48 ore

30,90Lei

Fir Monofilament CARP EXPERT Neo Fluo Carp Duo Fluo Galben + Fluo Portocaliu, 0,40mm, 22.41kg, 600m

Fir Monofilament CARP EXPERT Neo Fluo Carp Duo Fluo Galben + Fluo Portocaliu, 0,40mm, 22.41kg, 600m

33104640

Livrare 24-48 ore

115,91Lei

Saltea Receptie CARP EXPERT Smart, 102x63x39cm

Saltea Receptie CARP EXPERT Smart, 102x63x39cm

73756603

Livrare 24-48 ore

260,90Lei

LANSETA CARP EXPERT FEEDER MAX2 4.20m 100-150g

LANSETA CARP EXPERT FEEDER MAX2 4.20m 100-150g

13324420

Livrare imediată!

481,89Lei

1
2
3
4
5
6
7
8
9
>
>|

Afişare 1 - 20 din 955 (48 pagini)

💬

WhatsApp Chat

👋 Salut! Cu ce va pot ajuta?

Pot raspunde la intrebari despre:
✅ Comenzi si status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)

Queries: 6, Total time: 87.328 ms [By time] [By id] [By file]

1 (0.124)

SELECT data
FROM `oc_session`
WHERE session_id = 'ebbb0cd3e983f827fae9d0eb84'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.130)

SELECT *
FROM oc_url_alias
WHERE keyword = 'carp-expert.html'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

3 (0.132)

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

4 (39.534)

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:1723

5 (47.277)

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:454

6 (0.131)

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