Cormoran


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

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

c.29.856023
Livrare imediată!

264,24Lei(-36%) 168,90Lei

MULINETA CORMORAN VEY-COR BR 3000

MULINETA CORMORAN VEY-COR BR 3000

c.19.74300
Livrare imediată!

205,03Lei

ANTI TANGLE 15CM CORMORAN 3BUC/PLIC

ANTI TANGLE 15CM CORMORAN 3BUC/PLIC

a.49.53115
Livrare imediată!

5,63Lei

LANSETA CORMORAN 2 SEG .RAYCOR X 2.40M/10-35G -30%

LANSETA CORMORAN 2 SEG .RAYCOR X 2.40M/10-35G

c.27.8003524
Livrare 24-48 ore

214,03Lei(-30%) 149,82Lei

Lingurita Rotativa Cormoran Spinner Single UL2 Pearl, 2.8g, Carlig Nr.2/0

Lingurita Rotativa Cormoran Spinner Single UL2 Pearl, 2.8g, Carlig Nr.2/0

a.50.87250
Livrare imediată!

23,31Lei

Cleste Cormoran Inele Despicate 16cm

Cleste Cormoran Inele Despicate 16cm

a.84.11002
Livrare imediată!

37,33Lei

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 imediată!

162,19Lei

Lanseta Cormoran Pro Carp XR 3.60m 3lbs 2Seg -30%

Lanseta Cormoran Pro Carp XR 3.60m 3lbs 2Seg

c.20.0630360
Livrare imediată!

209,88Lei(-30%) 146,92Lei

Lingurita Rotativa Cormoran Spinner Single UL2 Red & Blue, 2.8g, Carlig Nr.2/0

Lingurita Rotativa Cormoran Spinner Single UL2 Red & Blue, 2.8g, Carlig Nr.2/0

a.50.87270
Livrare 24-48 ore

23,31Lei

CIZME CORMORAN PIEPT MARIME 42

CIZME CORMORAN PIEPT MARIME 42

a8.95.07442
Livrare imediată!

314,84Lei

SALOPETA CORMORAN NEOPREN MAR.42/43

SALOPETA CORMORAN NEOPREN MAR.42/43

a8.94.03243
Livrare 24-48 ore

692,39Lei

VARGA CORMORAN TELE EUROCOR 4,00M

VARGA CORMORAN TELE EUROCOR 4,00M

c.26.00401
Livrare imediată!

61,04Lei

STRUNA CORMORAN KEVLAR 1X7 20CM 12KG 2BUC

STRUNA CORMORAN KEVLAR 1X7 20CM 12KG 2BUC

a7.75.23120
Livrare imediată!

6,30Lei

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

FIR METALIC CORMORAN PENTRU STRUNA 7X7 5MT 6KG

a7.75.40060
Livrare imediată!

73,57Lei(-8%) 67,33Lei

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

233,97Lei

Prindere Plumb Cormoran Helicopter Culisant 5buc/plic -60%

Prindere Plumb Cormoran Helicopter Culisant 5buc/plic

a.11.00219
Livrare 24-48 ore

27,52Lei(-60%) 11,01Lei

Lingura Rotativa Cormoran Bullet Nr.2/4g Culoare Gold -40%

Lingura Rotativa Cormoran Bullet Nr.2/4g Culoare Gold

f.50.84012
Livrare imediată!

9,31Lei(-40%) 5,58Lei

Lanseta Cormoran Ticora Black Ultra Fast Spin 2.18m 3-15g 2SEG

Lanseta Cormoran Ticora Black Ultra Fast Spin 2.18m 3-15g 2SEG

c.27.1015219
Livrare imediată!

175,35Lei

Lingura oscilanta Cormoran Toro UL3 2.8cm 2.5g Farbe 33 -40%

Lingura oscilanta Cormoran Toro UL3 2.8cm 2.5g Farbe 33

f.50.88333
Livrare 24-48 ore

18,25Lei(-40%) 10,95Lei

AGRAFA+VARTEJ CORMORAN NR.14 / 22KG / 8BUC/PLIC

AGRAFA+VARTEJ CORMORAN NR.14 / 22KG / 8BUC/PLIC

a7.80.00014
Livrare imediată!

7,20Lei

Afişare 21 - 40 din 325 (17 pagini)
Queries: 7, Total time: 76.532 ms [By time] [By id] [By file]
1 (0.086)
SELECT data
FROM `oc_session`
WHERE session_id = '3a4759c206c649842a40cae48f'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.093)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.110)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Cormoran'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.089)
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 = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (34.353)
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 = '3' AND p.manufacturer_id = '12'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (41.671)
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 = '3' AND p.manufacturer_id = '12' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 20,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.130)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37