Carp Expert


Fir Monofilament Carp Expert Go Green Invisible, Clear, 150m, 0.24mm, 6.36kg

Fir Monofilament Carp Expert Go Green Invisible, Clear, 150m, 0.24mm, 6.36kg

30109024
Livrare 24-48 ore

28,00Lei

Fish Counter Carp Expert

Fish Counter Carp Expert

80650803
Livrare imediată!

41,04Lei

Set Avertizori Carp Expert Max 1 RGA, 3+1

Set Avertizori Carp Expert Max 1 RGA, 3+1

78009031
Livrare 24-48 ore

548,53Lei

Fir Monofilament Carp Expert Specialist Carp, Maro, 5.52kg, 0.20mm, 300m

Fir Monofilament Carp Expert Specialist Carp, Maro, 5.52kg, 0.20mm, 300m

33200120
Livrare 24-48 ore

20,63Lei

Carlige Legate CARP EXPERT Method Feeder Bait Sting Rig, Carlig Nr.10, Spin 7mm, Fir 0.15mm, 6buc/pac

Carlige Legate CARP EXPERT Method Feeder Bait Sting Rig, Carlig Nr.10, Spin 7mm, Fir 0.15mm, 6buc/pac

42865103
Livrare imediată!

21,00Lei

Saltea Cantarire CARP EXPERT Advancer Black 125x100cm cu Ruleta Masurat Pesti

Saltea Cantarire CARP EXPERT Advancer Black 125x100cm cu Ruleta Masurat Pesti

73756670
Livrare 24-48 ore

121,00Lei

Avertizor Carp Expert NG Verde -25%

Avertizor Carp Expert NG Verde

78000120
Livrare imediată!

83,00Lei(-25%) 61,90Lei

SWINGER ILUMINAT CARP EXPERT DELUXE - ALBASTRU

SWINGER ILUMINAT CARP EXPERT DELUXE - ALBASTRU

77090913
Livrare imediată!

39,00Lei

CARP EXPERT PRASTIE VIERMUSI LIGHT 2

CARP EXPERT PRASTIE VIERMUSI LIGHT 2

80253037
Livrare 24-48 ore

19,00Lei

Fir Carp Expert UV 150m 0.35mm

Fir Carp Expert UV 150m 0.35mm

30118035
Livrare imediată!

13,99Lei

MONTURA CARP EXPERT RING SINKING 70CM

MONTURA CARP EXPERT RING SINKING 70CM

42775020
Livrare 24-48 ore

23,00Lei

BILUTE CARP EXPERT DIN CAUCIUC 25BUC/PLIC 6MM MARO

BILUTE CARP EXPERT DIN CAUCIUC 25BUC/PLIC 6MM MARO

79017516
Livrare imediată!

5,00Lei

PIQUET TELESCOPIC CARP EXPERT 100CM

PIQUET TELESCOPIC CARP EXPERT 100CM

72150399
Livrare imediată!

35,00Lei

Fir CARP EXPERT DARK GREEN 0.27 MM 1200M

Fir CARP EXPERT DARK GREEN 0.27 MM 1200M

30104827
Livrare 24-48 ore

54,00Lei

CARP EXPERT METHOD GUM 0,80MM TRANSPARENT

CARP EXPERT METHOD GUM 0,80MM TRANSPARENT

31600086
Livrare 24-48 ore

12,99Lei

CON DE SIGURANTA CARP EXPERT RIG SLEEVES, 10BUC/CUTIE

CON DE SIGURANTA CARP EXPERT RIG SLEEVES, 10BUC/CUTIE

79032140
Livrare imediată!

6,50Lei

Penar Riguri Carp Expert Original Forfac

Penar Riguri Carp Expert Original Forfac

80302305
Livrare 24-48 ore

63,00Lei

Cap Minciog Carp Expert Cadru Carbon Pro 50x40cm

Cap Minciog Carp Expert Cadru Carbon Pro 50x40cm

71027351
Livrare 24-48 ore

134,01Lei

Set Crosete + Burghiu Carp Expert Pro Method Feeder Soft Pellet Master

Set Crosete + Burghiu Carp Expert Pro Method Feeder Soft Pellet Master

80204008
Livrare imediată!

23,30Lei

Mulineta Carp Expert Max2 Long Cast 8000, 4.1:1, 0.30mm/250m, 7+1rul

Mulineta Carp Expert Max2 Long Cast 8000, 4.1:1, 0.30mm/250m, 7+1rul

20205800
Livrare 24-48 ore

382,00Lei

Afişare 621 - 640 din 798 (40 pagini)
Queries: 7, Total time: 103.071 ms [By time] [By id] [By file]
1 (0.094)
SELECT data
FROM `oc_session`
WHERE session_id = '37bcabd6c9af50855e1025f12c'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.077)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.102)
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 (53.548)
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 (49.020)
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 620,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.132)
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