Cormoran


CLESTE CORMORAN RAPITOR 17.5 CM

CLESTE CORMORAN RAPITOR 17.5 CM

a.84.11004
Livrare imediată!

46,21Lei

Lanseta Cormoran Power Creek Jigger 2.10m 5-25g 2SEG

Lanseta Cormoran Power Creek Jigger 2.10m 5-25g 2SEG

c.27.8525211
Livrare imediată!

149,32Lei

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

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

a.50.87230
Livrare 24-48 ore

23,31Lei

LINGURITA ROTATIVA CORMORAN ORAN. BULLET NR.3 COOPER 7G -40%

LINGURITA ROTATIVA CORMORAN ORAN. BULLET NR.3 COOPER 7G

f.50.84023
Livrare imediată!

10,75Lei(-40%) 6,44Lei

LANTERNA CAP CORMORAN COR 3

LANTERNA CAP CORMORAN COR 3

a8.85.45203
Livrare imediată!

31,37Lei

Lanseta Cormoran Power Creek, 2.40m, 10-40g, 2buc -10%

Lanseta Cormoran Power Creek, 2.40m, 10-40g, 2buc

c.27.8540240
Livrare imediată!

174,13Lei(-10%) 156,72Lei

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

PORTOFEL CORMORAN CU PLICURI TRANSP. PT.DOCUMENTE M2041

PORTOFEL CORMORAN CU PLICURI TRANSP. PT.DOCUMENTE M2041

a8.65.03041
Livrare 24-48 ore

22,26Lei

Benzi CORMORAN pentru Prindere Lansete, 2buc/pac

Benzi CORMORAN pentru Prindere Lansete, 2buc/pac

a8.94.19999
Livrare imediată!

21,63Lei

LANSETA CORMORAN 3SEG PLUS 2VARFURI BULL FIGHTER E-HEAVY FEEDER 3.90M 50-150G -20%

LANSETA CORMORAN 3SEG PLUS 2VARFURI BULL FIGHTER E-HEAVY FEEDER 3.90M 50-150G

c.25.9150397
Livrare imediată!

282,11Lei(-20%) 225,70Lei

LINGURITA ROTATIVA CORMORAN BULLET NR.1/3G COOPER -40%

LINGURITA ROTATIVA CORMORAN BULLET NR.1/3G COOPER

f.50.84021
Livrare imediată!

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

Afişare 1 - 20 din 325 (17 pagini)
Queries: 7, Total time: 73.712 ms [By time] [By id] [By file]
1 (0.104)
SELECT data
FROM `oc_session`
WHERE session_id = '63a49a88613af1477921571d7e'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.079)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.101)
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 = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (31.844)
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.355)
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 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.136)
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