Cormoran


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

Vartej Cormoran Corlock NR.12/10KG/8BUC/PL

Vartej Cormoran Corlock NR.12/10KG/8BUC/PL

a7.80.70012
Livrare 24-48 ore

9,40Lei

OSCILANTA CORMORAN CORA-Z 58MM/22G SILVER/RED SC. -31%

OSCILANTA CORMORAN CORA-Z 58MM/22G SILVER/RED SC.

f.50.861022
Livrare 24-48 ore

12,71Lei(-31%) 8,75Lei

Lingura oscilanta Cormoran Toro UL5 2.3cm 1.6g Farbe 25 -33%

Lingura oscilanta Cormoran Toro UL5 2.3cm 1.6g Farbe 25

f.50.88525
Livrare 24-48 ore

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

Vobler Cormoran Cor F16 Yellow Pellet, 2.7cm, 2.5g, 1buc/pac

Vobler Cormoran Cor F16 Yellow Pellet, 2.7cm, 2.5g, 1buc/pac

f3.53.04441
Livrare imediată!

27,07Lei

OPRITOR CORMORAN SOFT FLUO OVAL DIV.MARIMI

OPRITOR CORMORAN SOFT FLUO OVAL DIV.MARIMI

a.49.09200
Livrare imediată!

12,71Lei

Afişare 141 - 160 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: 69.213 ms [By time] [By id] [By file]
1 (0.079)
SELECT data
FROM `oc_session`
WHERE session_id = '2e818092fca385b6e62ba74b7f'
/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.097)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Cormoran'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.093)
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 (30.884)
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 (37.827)
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 140,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.139)
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