Carp Zoom

Carp Zoom

Sortare după:

ADITIV CARP ZOOM SUPERB BRITISH BREAD CRUMBS FLOATING 250gr Orange

ADITIV CARP ZOOM SUPERB BRITISH BREAD CRUMBS FLOATING 250gr Orange

cz8677

Livrare 48-72 ore

13,63Lei

BOILIE CARP ZOOM AMUR-GRASS CARP 20mm 800gr Spice

BOILIE CARP ZOOM AMUR-GRASS CARP 20mm 800gr Spice

cz9377

Livrare 48-72 ore

43,67Lei

FIR MONOFILAMENT CARP ZOOM MAXIMAL CARP 600m 0.28mm 10.3kg Fluo Green

FIR MONOFILAMENT CARP ZOOM MAXIMAL CARP 600m 0.28mm 10.3kg Fluo Green

cz7809

Livrare imediată!

52,76Lei

Fir Textil Carp Zoom Catfish 8X, Fluo Green, 61kg, 0.60mm, 300m

Fir Textil Carp Zoom Catfish 8X, Fluo Green, 61kg, 0.60mm, 300m

cz2179

Livrare 48-72 ore

85,29Lei

Wafters Carp Zoom Duo Dumbel, Lemon-Biscuit, 10-14mm, 15g

Wafters Carp Zoom Duo Dumbel, Lemon-Biscuit, 10-14mm, 15g

cz3220

Livrare 48-72 ore

17,19Lei

Alune Tigrate Flotante Carp Zoom Art-X Balance Duo Color, 10buc/borcan

Alune Tigrate Flotante Carp Zoom Art-X Balance Duo Color, 10buc/borcan

cz0472

Livrare 48-72 ore

22,25Lei

Nada Carp Zoom Method Feeder Orange Chocolate 1kg

Nada Carp Zoom Method Feeder Orange Chocolate 1kg

cz3979

Livrare imediată!

20,86Lei

Carp Zoom DIP BOILIE 80ml Spice Mix

Carp Zoom DIP BOILIE 80ml Spice Mix

cz4396

Livrare imediată!

15,66Lei

Carp Zoom WAFTERS GALACTIC DUO 10mm 15gr Porumb Dulce & Capsuna

Carp Zoom WAFTERS GALACTIC DUO 10mm 15gr Porumb Dulce & Capsuna

cz6925

Livrare 48-72 ore

17,70Lei

BORSETA CARP ZOOM ACCESORII CU TOP TRANSPARENT 27X16X9CM

BORSETA CARP ZOOM ACCESORII CU TOP TRANSPARENT 27X16X9CM

cz7908

Livrare 48-72 ore

89,36Lei

Spinnertail Predator Z Metal Viber Red Head 3.4cm 20g

Spinnertail Predator Z Metal Viber Red Head 3.4cm 20g

cz8219

Livrare 48-72 ore

38,51Lei

Montura Carp Zoom Ronnie Rig Nr.6, 3buc/pac

Montura Carp Zoom Ronnie Rig Nr.6, 3buc/pac

cz0335

Livrare imediată!

23,37Lei

Fir Textil Carp Zoom Serious 8x Green, 23.75kg, 0.30mm, 120m

Fir Textil Carp Zoom Serious 8x Green, 23.75kg, 0.30mm, 120m

cz0441

Livrare 48-72 ore

96,49Lei

Fir Monofilament Carp Zoom Competition Osmium Feeder, Brown, 4.7kg, 0.28mm, 800m

Fir Monofilament Carp Zoom Competition Osmium Feeder, Brown, 4.7kg, 0.28mm, 800m

cz2575

Livrare 48-72 ore

36,49Lei

Wafters Carp Zoom Dumbel, Paprika-Bread, 8-12mm, 15g

Wafters Carp Zoom Dumbel, Paprika-Bread, 8-12mm, 15g

cz3497

Livrare 48-72 ore

20,25Lei

Inel Dublu CARP ZOOM Catzoom Heavy Duty Double Ring, Size M, 300kg, 6buc/pac

Inel Dublu CARP ZOOM Catzoom Heavy Duty Double Ring, Size M, 300kg, 6buc/pac

cz5071

Livrare 48-72 ore

17,17Lei

Carp Zoom PORUMB SUPER SWEET 425ml 340gr

Carp Zoom PORUMB SUPER SWEET 425ml 340gr

cz5164

Livrare imediată!

13,63Lei

Carp Zoom PELETE SOFT 12mm 30gr Chocolate

Carp Zoom PELETE SOFT 12mm 30gr Chocolate

cz3924

Livrare 48-72 ore

12,50Lei(-13%) 10,88Lei

Carp Zoom WAFTERS DUO DUMBEL 8x12mm 15gr Porumb Dulce & Capsuna

Carp Zoom WAFTERS DUO DUMBEL 8x12mm 15gr Porumb Dulce & Capsuna

cz6697

Livrare 48-72 ore

17,19Lei

JUVELNIC CARPZOOM BASIC-N 40x150cm

JUVELNIC CARPZOOM BASIC-N 40x150cm

cz5683

Livrare imediată!

30,49Lei

Afişare 301 - 320 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: 104.874 ms [By time] [By id] [By file]

1 (0.146)

SELECT data
FROM `oc_session`
WHERE session_id = '7949596ce8436ee9566d011284'

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

2 (0.104)

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-Zoom'

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

4 (0.088)

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 (42.019)

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 (62.221)

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 300,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440

7 (0.160)

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