Cormoran


MULINETA CORMORAN VEY-COR FEEDER 6000

MULINETA CORMORAN VEY-COR FEEDER 6000

c.14.40600
Livrare 24-48 ore

210,52Lei

CIZME CORMORAN PIEPT MARIME 42

CIZME CORMORAN PIEPT MARIME 42

a8.95.07442
Livrare imediată!

321,13Lei

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

Lanseta Cormoran Pro Carp XR 3.60m 3lbs 2Seg

c.20.0630360
Livrare 24-48 ore

209,87Lei(-28%) 150,39Lei

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

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

c.29.856023
Livrare imediată!

264,24Lei(-35%) 172,74Lei

Taparina CORMORAN XX Seacore Herring Glow, Nr.12

Taparina CORMORAN XX Seacore Herring Glow, Nr.12

a.55.65012
Livrare imediată!

7,71Lei

BOCANCI CORMORAN ASTRO-THERMO 42/43

BOCANCI CORMORAN ASTRO-THERMO 42/43

a8.91.77243
Livrare 24-48 ore

285,60Lei

VARGA CORMORAN TELE EUROCOR 7,00M

VARGA CORMORAN TELE EUROCOR 7,00M

c.26.00701
Livrare 24-48 ore

139,68Lei

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

Suport Tubular pentru Incarcare Lanseta CORMORAN Tube Rod Holder, Yellow, 42cm

Suport Tubular pentru Incarcare Lanseta CORMORAN Tube Rod Holder, Yellow, 42cm

a6.63.10007
Livrare imediată!

14,96Lei

HUSA CORMORAN 5124 PENTRU LANSETE 155CM

HUSA CORMORAN 5124 PENTRU LANSETE 155CM

a8.65.12455
Livrare imediată!

138,12Lei

Lanseta Cormoran BIG CAT LONG RANGE 3.00M/200-600G 2SEG

Lanseta Cormoran BIG CAT LONG RANGE 3.00M/200-600G 2SEG

c.20.1600305
Livrare imediată!

349,17Lei

Lingura oscilanta Cormoran Toro UL4 2.5cm 1.6g Fabre 29 -33%

Lingura oscilanta Cormoran Toro UL4 2.5cm 1.6g Fabre 29

f.50.88429
Livrare 24-48 ore

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

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

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

a7.80.00012
Livrare 24-48 ore

7,93Lei

LANSETA CORMORAN TELE BLACK MASTER 40 2,40M/10-40G

LANSETA CORMORAN TELE BLACK MASTER 40 2,40M/10-40G

c.28.840241
Livrare imediată!

183,80Lei

Vobler Team Cormoran ME-RA Roach, Green Roach, 11cm, 18g -23%

Vobler Team Cormoran ME-RA Roach, Green Roach, 11cm, 18g

f3.53.59211
Livrare imediată!

55,21Lei(-23%) 42,59Lei

STRUNA CORMORAN TITANIUM 20CM/8KG 2BUC/PL

STRUNA CORMORAN TITANIUM 20CM/8KG 2BUC/PL

a7.75.84308
Livrare imediată!

18,44Lei

Fir Cormoran Textil CoraStrong 8Braid, Green, 014MM/9,4KG/135M

Fir Cormoran Textil CoraStrong 8Braid, Green, 014MM/9,4KG/135M

c.32.8013514
Livrare 24-48 ore

33,08Lei

CANTAR CORMORAN DIGITAL MODEL 601/25KG -17%

CANTAR CORMORAN DIGITAL MODEL 601/25KG

a.85.52601
Livrare imediată!

87,10Lei(-17%) 72,07Lei

Minciog Telescopic Cormoran 220cm, 60x60cm

Minciog Telescopic Cormoran 220cm, 60x60cm

a2.62.42222
Livrare 24-48 ore

149,00Lei

Suport Tubular pentru Incarcare Lanseta CORMORAN Tube Rod Holder, Yellow

Suport Tubular pentru Incarcare Lanseta CORMORAN Tube Rod Holder, Yellow

a6.63.10008
Livrare imediată!

15,40Lei

Afişare 21 - 40 din 279 (14 pagini)
Queries: 7, Total time: 79.163 ms [By time] [By id] [By file]
1 (0.143)
SELECT data
FROM `oc_session`
WHERE session_id = '3c0279b76cfed0a83d80c6e2e0'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.140)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.151)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Cormoran'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.142)
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 (32.128)
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 (46.320)
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.139)
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