Cormoran


LINGURITA ROTATIVA CORMORAN ORAN. BULLET NR.3 COOPER 7G -30%

LINGURITA ROTATIVA CORMORAN ORAN. BULLET NR.3 COOPER 7G

f.50.84023
Livrare imediată!

10,74Lei(-30%) 7,55Lei

CLESTE CORMORAN RAPITOR 17.5 CM

CLESTE CORMORAN RAPITOR 17.5 CM

a.84.11004
Livrare imediată!

47,99Lei

Lanseta Cormoran Power Creek Jigger 2.10m 5-25g 2SEG

Lanseta Cormoran Power Creek Jigger 2.10m 5-25g 2SEG

c.27.8525211
Livrare imediată!

152,84Lei

Lanseta Spinning Cormoran TopFish 2.10m, 50-100g, 2seg -34%

Lanseta Spinning Cormoran TopFish 2.10m, 50-100g, 2seg

c.26.1010210
Livrare imediată!

149,57Lei(-34%) 98,51Lei

ANTI TANGLE 15CM CORMORAN 3BUC/PLIC

ANTI TANGLE 15CM CORMORAN 3BUC/PLIC

a.49.53115
Livrare imediată!

6,72Lei

MULINETA CORMORAN VEY-COR FEEDER 6000

MULINETA CORMORAN VEY-COR FEEDER 6000

c.14.40600
Livrare 24-48 ore

210,52Lei

LANTERNA CAP CORMORAN COR 3

LANTERNA CAP CORMORAN COR 3

a8.85.45203
Livrare imediată!

32,90Lei

Mulineta Cormoran Cross Water 5PiF 2500

Mulineta Cormoran Cross Water 5PiF 2500

c.12.59250
Livrare 24-48 ore

127,61Lei

Lanseta Cormoran Seacor Pilk Power 2.70m, 10-200g, 2seg

Lanseta Cormoran Seacor Pilk Power 2.70m, 10-200g, 2seg

c.29.852027
Livrare imediată!

239,94Lei

MULINETA CORMORAN CORCRAFT BR 4000 -28%

MULINETA CORMORAN CORCRAFT BR 4000

c.19.51400
Livrare 24-48 ore

213,41Lei(-28%) 152,90Lei

PORTOFEL CORMORAN CU PLICURI TRANSP. PT.DOCUMENTE M2041

PORTOFEL CORMORAN CU PLICURI TRANSP. PT.DOCUMENTE M2041

a8.65.03041
Livrare 24-48 ore

23,63Lei

Lanseta Cormoran Power Creek, 2.40m, 10-40g, 2buc -8%

Lanseta Cormoran Power Creek, 2.40m, 10-40g, 2buc

c.27.8540240
Livrare 24-48 ore

174,13Lei(-8%) 160,35Lei

Benzi CORMORAN pentru Prindere Lansete, 2buc/pac

Benzi CORMORAN pentru Prindere Lansete, 2buc/pac

a8.94.19999
Livrare imediată!

23,00Lei

SET VOBLERE CORMORAN DIVERSE PASTRAV 4 BUC

SET VOBLERE CORMORAN DIVERSE PASTRAV 4 BUC

f3.53.00102
Livrare 24-48 ore

66,76Lei

Lanseta Cormoran Seacor Deep Zone 2.35m, 400-600g, 2seg -35%

Lanseta Cormoran Seacor Deep Zone 2.35m, 400-600g, 2seg

c.29.856023
Livrare imediată!

264,24Lei(-35%) 172,74Lei

LINGURITA ROTATIVA CORMORAN BULLET NR.1/3G COOPER -28%

LINGURITA ROTATIVA CORMORAN BULLET NR.1/3G COOPER

f.50.84021
Livrare imediată!

9,30Lei(-28%) 6,67Lei

LANSETA CORMORAN 3SEG PLUS 3VARFURI SPORTLINE FEEDER 3.60M 50-150G 3+3seg

LANSETA CORMORAN 3SEG PLUS 3VARFURI SPORTLINE FEEDER 3.60M 50-150G 3+3seg

c.24.0150365
Livrare 24-48 ore

165,92Lei

Lanseta CORMORAN 2BUC BC V SHORT RANGE 2.80M, 100-400G -18%

Lanseta CORMORAN 2BUC BC V SHORT RANGE 2.80M, 100-400G

c.20.1400285
Livrare imediată!

312,26Lei(-18%) 255,02Lei

Cleste Cormoran Inele Despicate 16cm

Cleste Cormoran Inele Despicate 16cm

a.84.11002
Livrare imediată!

38,96Lei

Taparina CORMORAN XX Seacore Herring Glow, Nr.12

Taparina CORMORAN XX Seacore Herring Glow, Nr.12

a.55.65012
Livrare imediată!

7,71Lei

Afişare 1 - 20 din 288 (15 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: 67.604 ms [By time] [By id] [By file]
1 (0.096)
SELECT data
FROM `oc_session`
WHERE session_id = '6cafbdcf7a8160b7723868f18e'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.107)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.138)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Cormoran'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.133)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '12' AND m2s.store_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (31.643)
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 = '2' AND p.manufacturer_id = '12'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (35.339)
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 = '2' AND p.manufacturer_id = '12' 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:440
7 (0.148)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37