Carp Zoom


SET CUIE CORT CARP ZOOM 0.7 20cm

SET CUIE CORT CARP ZOOM 0.7 20cm

cz6031
Livrare 48-72 ore

61,92Lei

BOILIES CARP ZOOM PREMIUM NATURAL BALANCED 18mm 100gr Fruit Essence -20%

BOILIES CARP ZOOM PREMIUM NATURAL BALANCED 18mm 100gr Fruit Essence

cz9254
Livrare 48-72 ore

21,50Lei(-20%) 17,29Lei

VARGA CARP ZOOM INTERCEPTOR 7.00M

VARGA CARP ZOOM INTERCEPTOR 7.00M

cz8134
Livrare imediată!

305,94Lei

POP UP CARP ZOOM FANATI-X 16mm 40gr Pineapple-Squid

POP UP CARP ZOOM FANATI-X 16mm 40gr Pineapple-Squid

cz9070
Livrare 48-72 ore

23,30Lei

Carp Zoom Tungsten Quick Change Sinker - M, 0.3g, 10buc

Carp Zoom Tungsten Quick Change Sinker - M, 0.3g, 10buc

cz8388
Livrare imediată!

21,34Lei

Lanseta Carp Zoom Competition Osmium Feeder, 50-140g, 3.60m, 3+3seg

Lanseta Carp Zoom Competition Osmium Feeder, 50-140g, 3.60m, 3+3seg

cz3091
Livrare 48-72 ore

407,62Lei

Fir Monofilament CARP ZOOM Pitbull Extreme Carp, Black, 700m, 0.46mm, 23.15kg

Fir Monofilament CARP ZOOM Pitbull Extreme Carp, Black, 700m, 0.46mm, 23.15kg

cz5026
Livrare 48-72 ore

46,65Lei

Carp Zoom TURBO SEED PLUS 1kg Tigernuts

Carp Zoom TURBO SEED PLUS 1kg Tigernuts

cz4983
Livrare imediată!

48,76Lei

Carp Zoom DIP BOILIE 80ml Vanilia

Carp Zoom DIP BOILIE 80ml Vanilia

cz4372
Livrare 48-72 ore

15,66Lei

Carp Zoom WAFTERS GALACTIC DUO 10mm 15gr Chocolate-Orange

Carp Zoom WAFTERS GALACTIC DUO 10mm 15gr Chocolate-Orange

cz6901
Livrare 48-72 ore

17,70Lei

JUVELNIC MIKADO BASIC 35cmx150cm

JUVELNIC MIKADO BASIC 35cmx150cm

s22-3535-150
Livrare imediată!

44,62Lei

Pop up Carp Zoom Amur Grass Carp 40gr 16mm

Pop up Carp Zoom Amur Grass Carp 40gr 16mm

cz8899
Livrare 48-72 ore

25,34Lei

FIR MONOFILAMENT CARP ZOOM MAXIMAL CARP 600m 0.35mm 15.1kg Fluo Yellow

FIR MONOFILAMENT CARP ZOOM MAXIMAL CARP 600m 0.35mm 15.1kg Fluo Yellow

cz7786
Livrare imediată!

63,94Lei

Cap Minciog Feeder Competition FCR1, 50x40x30cm

Cap Minciog Feeder Competition FCR1, 50x40x30cm

cz1413
Livrare imediată!

76,15Lei

Atractant Lichid Carp Zoom R2 PVA Green Booster, Amur, 75ml

Atractant Lichid Carp Zoom R2 PVA Green Booster, Amur, 75ml

cz0892
Livrare imediată!

21,37Lei

Fir Textil Carp Zoom Serious 8x Green, 6.16kg, 0.10mm, 120m

Fir Textil Carp Zoom Serious 8x Green, 6.16kg, 0.10mm, 120m

cz0373
Livrare 48-72 ore

106,65Lei

Wafters Carp Zoom Duo Dumbel, NBC-Pineapple, 10-14mm, 15g

Wafters Carp Zoom Duo Dumbel, NBC-Pineapple, 10-14mm, 15g

cz3251
Livrare 48-72 ore

17,19Lei

Penar Monturi CARP ZOOM Feeder Competition Rig Box, Blue, 55x14x3cm

Penar Monturi CARP ZOOM Feeder Competition Rig Box, Blue, 55x14x3cm

cz4142
Livrare 48-72 ore

129,02Lei

Pop Up CARP ZOOM Mulberry, 10mm, 15g

Pop Up CARP ZOOM Mulberry, 10mm, 15g

cz5910
Livrare 48-72 ore

17,19Lei

Montura Plumb Pierdut Carp Zoom 75cm 3buc/plic

Montura Plumb Pierdut Carp Zoom 75cm 3buc/plic

cz9637
Livrare imediată!

23,37Lei

Afişare 21 - 40 din 1706 (86 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: 170.510 ms [By time] [By id] [By file]
1 (0.144)
SELECT data
FROM `oc_session`
WHERE session_id = 'e15f9cc002c0d66f93c3b912d3'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.106)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.128)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Carp-Zoom'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.114)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '75' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (71.272)
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 = '75'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (98.609)
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 = '75' 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.137)
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