Cormoran


MONTURA CORMORAN CLASIC BOILIE RIG T4 NR.4/2BUC

MONTURA CORMORAN CLASIC BOILIE RIG T4 NR.4/2BUC

a.11.02300.4
Livrare 24-48 ore

18,15Lei

Sonda Cormoran cu neopren 5gr 10gr 15gr set 3buc

Sonda Cormoran cu neopren 5gr 10gr 15gr set 3buc

a3.81.47001
Livrare 24-48 ore

13,52Lei

Lanseta Cormoran Black Master Spin, 2.70m, 35-80g, 2seg -21%

Lanseta Cormoran Black Master Spin, 2.70m, 35-80g, 2seg

c.27.2080270
Livrare imediată!

261,32Lei(-21%) 206,29Lei

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

OSCILANTA CORMORAN CORA-Z 35MM/6G GOLD/GOLD -19%

OSCILANTA CORMORAN CORA-Z 35MM/6G GOLD/GOLD

f.50.860406
Stoc epuizat

9,69Lei(-19%) 7,82Lei

Lingura oscilanta Cormoran Toro UL4 2.5cm 1.6g Farbe 35 -33%

Lingura oscilanta Cormoran Toro UL4 2.5cm 1.6g Farbe 35

f.50.88435
Livrare 24-48 ore

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

Mulineta Cormoran Veycor BR 4PIF 6000

Mulineta Cormoran Veycor BR 4PIF 6000

c.19.46600
Livrare 24-48 ore

194,87Lei

OPRITOR SILICON CORMORAN TRANSPARENT PT PLUTA MARIME S

OPRITOR SILICON CORMORAN TRANSPARENT PT PLUTA MARIME S

a.49.02011
Livrare imediată!

3,36Lei

FIR TEXTIL CORMORAN CORASTRONG VERDE 020MM/11,2KG/135M

FIR TEXTIL CORMORAN CORASTRONG VERDE 020MM/11,2KG/135M

c.32.013520
Livrare 24-48 ore

21,95Lei

FIR CORMORAN CAT FISH L=20M 060M/54,5KG

FIR CORMORAN CAT FISH L=20M 060M/54,5KG

a.78.02063
Livrare imediată!

25,36Lei

PENSA CURBATA FOARFECA CORMORAN 19 CM

PENSA CURBATA FOARFECA CORMORAN 19 CM

a.84.10019
Livrare imediată!

33,64Lei

VOBLER CORMORAN COR F12 PERCH 4.00CM 4.2G

VOBLER CORMORAN COR F12 PERCH 4.00CM 4.2G

f3.53.04412
Livrare 24-48 ore

30,10Lei

LANSETA CORMORAN SPORTLINE FEEDER 3.60M/40-120G 3+3SEG

LANSETA CORMORAN SPORTLINE FEEDER 3.60M/40-120G 3+3SEG

c.24.0120365
Livrare imediată!

176,35Lei

Struna Cormoran Titanium Leader 30cm 2buc/plic 12kg

Struna Cormoran Titanium Leader 30cm 2buc/plic 12kg

a7.75.84412
Livrare 24-48 ore

20,99Lei

Lingura oscilanta Cormoran Cora-X Spoon 9cm 28g Black Red -35%

Lingura oscilanta Cormoran Cora-X Spoon 9cm 28g Black Red

f.50.870528
Livrare 24-48 ore

24,36Lei(-35%) 15,88Lei

Lingura oscilanta Cormoran Cora Z 3.5cm 6g Silver Chartreuse

Lingura oscilanta Cormoran Cora Z 3.5cm 6g Silver Chartreuse

f.50.860306
Livrare 24-48 ore

10,85Lei

VARTEJ CORMORAN NR.10 / 30KG / 7BUC/PLIC

VARTEJ CORMORAN NR.10 / 30KG / 7BUC/PLIC

a7.80.07010
Livrare imediată!

5,46Lei

GEANTA UMAR CORMORAN 3032 36X30X17CM

GEANTA UMAR CORMORAN 3032 36X30X17CM

a8.65.03032
Livrare 24-48 ore

76,05Lei

MULINETA CORMORAN I-COR 2000 2PIF

MULINETA CORMORAN I-COR 2000 2PIF

c.16.21200
Livrare imediată!

96,75Lei

SET METHOD FEEDER CORMORAN 2 BUC/SET (20G) -18%

SET METHOD FEEDER CORMORAN 2 BUC/SET (20G)

a.49.67020
Livrare imediată!

19,70Lei(-18%) 16,15Lei

Afişare 241 - 260 din 296 (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: 73.284 ms [By time] [By id] [By file]
1 (0.083)
SELECT data
FROM `oc_session`
WHERE session_id = 'f4050172d65333c0ca6e529ca3'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.094)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.092)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Cormoran'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.090)
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 = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (31.549)
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 = '12'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (41.263)
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 = '12' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 240,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.113)
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