Cormoran


OPRITOR SILICON CORMORAN TRANSPARENT PT PLUTA MARIME L

OPRITOR SILICON CORMORAN TRANSPARENT PT PLUTA MARIME L

a.49.02013
Livrare imediată!

3,40Lei

FIR TEXTIL CORMORAN CORASTRONG VERDE 030MM/21,1KG/135M

FIR TEXTIL CORMORAN CORASTRONG VERDE 030MM/21,1KG/135M

c.32.013530
Livrare 24-48 ore

21,95Lei

STRUNA CORMORAN BROWN 7X7 30CM/6KG 2BUC/PL -20%

STRUNA CORMORAN BROWN 7X7 30CM/6KG 2BUC/PL

a7.75.44060
Livrare imediată!

22,70Lei(-20%) 18,17Lei

CUTIE CORMORAN PENTRU ACCESORII 38x28x11cm

CUTIE CORMORAN PENTRU ACCESORII 38x28x11cm

a4.66.10016
Livrare 24-48 ore

92,87Lei

HUSA CORMORAN 5124 PENTRU LANSETE 130CM -18%

HUSA CORMORAN 5124 PENTRU LANSETE 130CM

a8.65.12430
Livrare 24-48 ore

126,71Lei(-18%) 104,07Lei

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

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

c.24.0120335
Livrare imediată!

151,56Lei

CANTAR CORMORAN MECANIC MODEL 600/100KG

CANTAR CORMORAN MECANIC MODEL 600/100KG

a.85.52600
Livrare imediată!

107,28Lei

AVERTIZOR CORMORAN ELECTRONIC PRO CARP X2000

AVERTIZOR CORMORAN ELECTRONIC PRO CARP X2000

a.11.80101
Livrare 24-48 ore

57,60Lei

Stinger Cormoran Leader 8cm 12kg 2buc/plic

Stinger Cormoran Leader 8cm 12kg 2buc/plic

a7.75.37120
Livrare imediată!

11,52Lei

MINCIOG CORMORAN DE LUXE 1,80M 100X100CM -39%

MINCIOG CORMORAN DE LUXE 1,80M 100X100CM

a2.m61.09307
Livrare 24-48 ore

288,06Lei(-39%) 176,74Lei

VARGA CORMORAN TELE EUROCOR 6,00M

VARGA CORMORAN TELE EUROCOR 6,00M

c.26.00601
Livrare imediată!

101,33Lei

VARF CORMORAN PT.FEEDER PRO GREEN 2,05OZ Model 2 -18%

VARF CORMORAN PT.FEEDER PRO GREEN 2,05OZ Model 2

c.25.2180390g
Livrare 24-48 ore

51,30Lei(-18%) 42,05Lei

Momitor Cormoran Feeder Lestat 55MM D41MM 60G -53%

Momitor Cormoran Feeder Lestat 55MM D41MM 60G

a.49.63060
Livrare 24-48 ore

16,64Lei(-53%) 7,77Lei

Fir Cormoran Textil CoraStrong 8Braid, Green, 016MM/11,4KG/135M

Fir Cormoran Textil CoraStrong 8Braid, Green, 016MM/11,4KG/135M

c.32.8013516
Livrare 24-48 ore

33,08Lei

Mulineta Cormoran Veycor BR 4PIF 3000

Mulineta Cormoran Veycor BR 4PIF 3000

c.19.46300
Livrare imediată!

172,67Lei

AGRAFA+VARTEJ CORMORAN NR.6 / 37KG / 6BUC/PLIC

AGRAFA+VARTEJ CORMORAN NR.6 / 37KG / 6BUC/PLIC

a7.80.00006
Livrare imediată!

6,46Lei

Cleste Sertizor Cormoran pentru Monturi Rapitor 15cm

Cleste Sertizor Cormoran pentru Monturi Rapitor 15cm

a.84.12013
Livrare imediată!

44,15Lei

Vobler Cormoran Minnow N35 Dying Roach 8.5cm, 7g -27%

Vobler Cormoran Minnow N35 Dying Roach 8.5cm, 7g

f3.53.001857
Livrare 24-48 ore

37,52Lei(-27%) 27,26Lei

FIR METALIC CORMORAN PENTRU STRUNA 7X7 5MT 6KG -6%

FIR METALIC CORMORAN PENTRU STRUNA 7X7 5MT 6KG

a7.75.40060
Livrare imediată!

73,56Lei(-6%) 69,45Lei

Avertizor Cormoran Pro Carp X8000 -38%

Avertizor Cormoran Pro Carp X8000

a.11.80850
Livrare 24-48 ore

92,42Lei(-38%) 57,38Lei

Afişare 101 - 120 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: 71.201 ms [By time] [By id] [By file]
1 (0.121)
SELECT data
FROM `oc_session`
WHERE session_id = 'de6379f381b9ca5ef64f59607d'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.113)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.134)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Cormoran'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.134)
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 (35.482)
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.116)
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 100,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.101)
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