Cormoran


STRUNA CORMORAN TITANIUM 20CM/12KG 2BUC/PL

STRUNA CORMORAN TITANIUM 20CM/12KG 2BUC/PL

a7.75.84312
Livrare imediată!

18,44Lei

SUPORT CORMORAN TELE L=60CM

SUPORT CORMORAN TELE L=60CM

a6.63.61003
Livrare imediată!

36,49Lei

Starlite Cormoran, 37x4.5mm, 2buc/plic Rosu

Starlite Cormoran, 37x4.5mm, 2buc/plic Rosu

a.49.08006
Livrare imediată!

2,83Lei

Lingura Rotativa Cormoran Bullet Nr.1/3g Culoare Silver Holo -28%

Lingura Rotativa Cormoran Bullet Nr.1/3g Culoare Silver Holo

f.50.84031
Livrare 24-48 ore

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

Lanseta Cormoran GF Feeder Pro MH 3.90m, 40-120g, 3+3SEG -18%

Lanseta Cormoran GF Feeder Pro MH 3.90m, 40-120g, 3+3SEG

c.25.2120397
Livrare imediată!

308,88Lei(-18%) 252,25Lei

Lingura oscilanta Cormoran Toro UL6 2.8cm 1.8g Fabre 11 -33%

Lingura oscilanta Cormoran Toro UL6 2.8cm 1.8g Fabre 11

f.50.88611
Livrare 24-48 ore

16,14Lei(-33%) 10,84Lei

Vobler Cormoran Cor SLS2 Pale Ayu, 3.5cm, 2.0g, 1buc/pac

Vobler Cormoran Cor SLS2 Pale Ayu, 3.5cm, 2.0g, 1buc/pac

f3.53.04463
Livrare 24-48 ore

26,77Lei

Suport Tubular pentru Incarcare Lanseta CORMORAN Tube Rod Holder, Yellow

Suport Tubular pentru Incarcare Lanseta CORMORAN Tube Rod Holder, Yellow

a6.63.10008
Livrare imediată!

15,40Lei

MONTURA CORMORAN CLASIC RIG T4 NR.4/2BUC -24%

MONTURA CORMORAN CLASIC RIG T4 NR.4/2BUC

a.11.02303.4
Livrare 24-48 ore

21,86Lei(-24%) 16,56Lei

STRUNA CORMORAN 7X7 30CM 9KG 2BUC PL

STRUNA CORMORAN 7X7 30CM 9KG 2BUC PL

a7.75.44090
Livrare 24-48 ore

20,32Lei

LANSETA CORMORAN SPINNING 2BUC.BLACK MASTER SPIN 2,70M /35-80G

LANSETA CORMORAN SPINNING 2BUC.BLACK MASTER SPIN 2,70M /35-80G

c.27.2125270
Livrare 24-48 ore

234,96Lei

Struna Cormoran cu Vartej si Agrafa 1X19 30CM/12KG 2BUC/PL

Struna Cormoran cu Vartej si Agrafa 1X19 30CM/12KG 2BUC/PL

a7.75.34120
Livrare imediată!

12,45Lei

Vobler Cormoran Cor F14 Crank Culoare Chocolate 4.5cm 7.1g

Vobler Cormoran Cor F14 Crank Culoare Chocolate 4.5cm 7.1g

f3.53.04421
Livrare 24-48 ore

24,97Lei

SHAD CORMORAN CRAZY FIN RTF 10CM UV HERRING 6G 2BUC/PLIC

SHAD CORMORAN CRAZY FIN RTF 10CM UV HERRING 6G 2BUC/PLIC

f1.51.890910
Livrare imediată!

18,19Lei

Lingura oscilanta Cormoran Toro UL4 2.5cm 1.6g Fabre 14 -33%

Lingura oscilanta Cormoran Toro UL4 2.5cm 1.6g Fabre 14

f.50.88414
Livrare 24-48 ore

16,14Lei(-33%) 10,84Lei

Minciog Telescopic Cormoran 220cm, 60x60cm

Minciog Telescopic Cormoran 220cm, 60x60cm

a2.62.42222
Livrare 24-48 ore

149,00Lei

OPRITOR SILICON CORMORAN TRANSPARENT PT PLUTA MARIME M

OPRITOR SILICON CORMORAN TRANSPARENT PT PLUTA MARIME M

a.49.02012
Livrare imediată!

3,40Lei

FIR TEXTIL CORMORAN CORASTRONG VERDE 028MM/18,2KG/135M

FIR TEXTIL CORMORAN CORASTRONG VERDE 028MM/18,2KG/135M

c.32.013528
Livrare 24-48 ore

21,95Lei

CORMORAN MONTURA CLASIC RIG T4 NR.2/2BUC -45%

CORMORAN MONTURA CLASIC RIG T4 NR.2/2BUC

a.11.02303.2
Livrare 24-48 ore

21,86Lei(-45%) 12,12Lei

LANSETA CORMORAN BIG CAT LONG RANGE 3.00M 200 500G 2SEGMENTE

LANSETA CORMORAN BIG CAT LONG RANGE 3.00M 200 500G 2SEGMENTE

c.20.1500304
Livrare imediată!

295,97Lei

Afişare 61 - 80 din 304 (16 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: 76.165 ms [By time] [By id] [By file]
1 (0.092)
SELECT data
FROM `oc_session`
WHERE session_id = '08b3d6833f82c87c56074492d9'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.095)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.116)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Cormoran'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.107)
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 (33.338)
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 (42.318)
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 60,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.099)
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