Carp Zoom


LANSETA CARP ZOOM FEEDER COMPETITION DS METHOD 3.60M 150gr -28%

LANSETA CARP ZOOM FEEDER COMPETITION DS METHOD 3.60M 150gr

cz9972
Livrare 48-72 ore

460,01Lei(-28%) 329,33Lei

Lanseta Carp Zoom Predator-Z Dropshot Intense DSI 2.10m 5-20g

Lanseta Carp Zoom Predator-Z Dropshot Intense DSI 2.10m 5-20g

cz6445
Livrare 48-72 ore

195,11Lei

CARLIGE CARP ZOOM FEEDER COMPETITION KO.5 CARP METHOD nr 14

CARLIGE CARP ZOOM FEEDER COMPETITION KO.5 CARP METHOD nr 14

cz0206
Livrare 48-72 ore

13,61Lei

Hanger Carp Zoom Slim S6 Rosu

Hanger Carp Zoom Slim S6 Rosu

cz8111
Livrare 48-72 ore

25,30Lei

CARLIGE CARP ZOOM MARSHAL CURVE SHANK nr 4 Barbless

CARLIGE CARP ZOOM MARSHAL CURVE SHANK nr 4 Barbless

cz0596
Livrare 48-72 ore

13,61Lei

FIR CARP ZOOM SERIA EXTREME AMUR-GRASS CARP 250m 0.35mm Green

FIR CARP ZOOM SERIA EXTREME AMUR-GRASS CARP 250m 0.35mm Green

cz2125
Livrare imediată!

13,71Lei

SHAD CARP ZOOM PREDATOR-Z OPLUS KILLER 12cm CZ7992 -21%

SHAD CARP ZOOM PREDATOR-Z OPLUS KILLER 12cm CZ7992

cz7992
Livrare 48-72 ore

25,00Lei(-21%) 19,71Lei

Boilies Carp Zoom Catfish Mega 30mm 50g Blood-Liver

Boilies Carp Zoom Catfish Mega 30mm 50g Blood-Liver

cz2095
Livrare imediată!

24,42Lei

FOAM Carp Zoom BARA ZIG RIG COLOR MIX

FOAM Carp Zoom BARA ZIG RIG COLOR MIX

cz3696
Livrare imediată!

23,37Lei

Naluca Carp Zoom PREDATOR-Z DANCING FROG 5cm 13gr Pink

Naluca Carp Zoom PREDATOR-Z DANCING FROG 5cm 13gr Pink

cz3351
Livrare 48-72 ore

29,37Lei

MOMITOR Maver IT MV-R METHOD FEEDER L 70gr

MOMITOR Maver IT MV-R METHOD FEEDER L 70gr

0040370l
Livrare 48-72 ore

45,64Lei

Agrafa Cu Blocaj Carp Zoom + Vartej nr.4 negru 10/set

Agrafa Cu Blocaj Carp Zoom + Vartej nr.4 negru 10/set

cz2042
Livrare imediată!

20,32Lei

NADA CARP ZOOM CARP FIESTA 1KG AROMA VANILIE

NADA CARP ZOOM CARP FIESTA 1KG AROMA VANILIE

cz3620
Livrare 48-72 ore

18,22Lei

VARTEJ HELI CU ANOU CARP ZOOM FEEDER COMPETITION Nr 7 TEFLONAT

VARTEJ HELI CU ANOU CARP ZOOM FEEDER COMPETITION Nr 7 TEFLONAT

cz8557
Livrare 48-72 ore

16,15Lei

LANSETA CARP ZOOM WILD CARP FEEDER 360 150gr 3+3SEG

LANSETA CARP ZOOM WILD CARP FEEDER 360 150gr 3+3SEG

cz7830
Livrare 48-72 ore

366,94Lei

SUPORT LANSETA CARP ZOOM FIX 50cm

SUPORT LANSETA CARP ZOOM FIX 50cm

cz8627
Livrare imediată!

12,18Lei

CUTIE ACCESORII CARP ZOOM 12.2x10.5x3.4cm

CUTIE ACCESORII CARP ZOOM 12.2x10.5x3.4cm

cz4269
Livrare imediată!

21,34Lei

STOPERE PELETE MIC MARO CARP ZOOM

STOPERE PELETE MIC MARO CARP ZOOM

cz1700
Livrare 48-72 ore

13,10Lei

Minciog Zeck Rubber Bait Catcher 25x25x20cm

Minciog Zeck Rubber Bait Catcher 25x25x20cm

50105180502
Livrare 48-72 ore

166,35Lei

MONTURA CARP ZOOM ANTI EJECT NR.4 20LB 20CM

MONTURA CARP ZOOM ANTI EJECT NR.4 20LB 20CM

cz1015
Livrare imediată!

21,24Lei

Afişare 541 - 560 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: 168.465 ms [By time] [By id] [By file]
1 (0.113)
SELECT data
FROM `oc_session`
WHERE session_id = '2aa8ffc9b4854c75f94789594d'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.127)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.115)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Carp-Zoom'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.141)
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 (70.225)
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 (97.606)
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 540,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.138)
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