Cormoran


LANSETA, SPINNING, CORMORAN, RAYCOR, X, 2.05M,, 3-10G,, 2SEG, c.27.8001020, Lansete Rapitori, Lansete Rapitori Cormoran, Lansete Cormoran, Rapitori Cormoran, Cormoran -23%
Lingura oscilanta Cormoran Toro UL4 2.5cm 1.6g Farbe 35 -20%

Lingura oscilanta Cormoran Toro UL4 2.5cm 1.6g Farbe 35

f.50.88435
Livrare 24-48 ore

16,20Lei(-20%) 12,95Lei

LANSETA, CORMORAN, POWER, CREEK, 2.70M, 10-40G, 2SEG, c.27.8540270, Lansete Rapitori, Lansete Rapitori Cormoran, Cormoran -10%

LANSETA, CORMORAN, POWER, CREEK, 2.70M, 10-40G, 2SEG, c.27.8540270, Lansete Rapitori, Lansete Rapitori Cormoran, Cormoran

c.27.8540270
Livrare 24-48 ore

189,57Lei(-10%) 170,61Lei

Struna Cormoran 7x7, 50cm, 6kg, 1buc/pac

Struna Cormoran 7x7, 50cm, 6kg, 1buc/pac

a7.75.46060
Livrare 24-48 ore

16,51Lei

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

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

a7.80.07012
Livrare imediată!

4,80Lei

FEEDER FARA PLUMB CORMORAN PREMIUM ROTUND 57MM/20G

FEEDER FARA PLUMB CORMORAN PREMIUM ROTUND 57MM/20G

a.49.37420
Livrare 24-48 ore

8,48Lei

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

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

c.32.013530
Livrare imediată!

20,96Lei

VARF CORMORAN PT.FEEDER SHORT TRACK YELLOW 1,05OZ -20%

VARF CORMORAN PT.FEEDER SHORT TRACK YELLOW 1,05OZ

c.25.2120300y
Livrare 24-48 ore

27,82Lei(-20%) 22,26Lei

AGRAFA CORMORAN CORLOCK NR.11 12KG 10BUC PLIC

AGRAFA CORMORAN CORLOCK NR.11 12KG 10BUC PLIC

a7.80.70211
Livrare imediată!

6,30Lei

UMBRELA CU PARASOLAR CORMORAN 2.5M

UMBRELA CU PARASOLAR CORMORAN 2.5M

a8.68.35250
Livrare imediată!

367,23Lei

Cap, Cormoran, Suport, Lanseta, Longnose, Feeder, a6.63.67001, Capete Suport Feeder, Capete Suport Feeder Cormoran, Cormoran
Struna Cormoran cu Vartej si Agrafa 1x19 30cm 2buc/plic

Struna Cormoran cu Vartej si Agrafa 1x19 30cm 2buc/plic

a7.75.34090
Livrare 24-48 ore

11,26Lei

OSCILANTA, CORMORAN, CORA-Z, 35MM/6G, SILVER/RED, SC., f.50.861006, Linguri Oscilante, Linguri Oscilante Cormoran, Cormoran
CUTIT CORMORAN PENTRU FILETAT MODEL 004 L=20CM

CUTIT CORMORAN PENTRU FILETAT MODEL 004 L=20CM

h.c.82.13004
Livrare imediată!

32,97Lei

MULINETA CORMORAN PRO CARP SLO 5PIF 5500 4RUL

MULINETA CORMORAN PRO CARP SLO 5PIF 5500 4RUL

c.19.51550
Livrare 24-48 ore

218,86Lei

Lingura Oscilanta Cormoran Cora-X Black Red 7cm 15g

Lingura Oscilanta Cormoran Cora-X Black Red 7cm 15g

f.50.870515
Livrare 24-48 ore

20,44Lei

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

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

a7.80.00004
Livrare imediată!

5,91Lei

PICHET TELEESCOPIC CORMORAN PRO CARP L=60-110CM

PICHET TELEESCOPIC CORMORAN PRO CARP L=60-110CM

a6.11.09060
Livrare imediată!

46,30Lei

VARGA CORMORAN TELE EUROCOR 3,00M

VARGA CORMORAN TELE EUROCOR 3,00M

c.26.00301
Livrare imediată!

43,41Lei

MINCIOG CORMORAN ALUMINIU PLASA CAUCIUCATA 2.40M 70X70CM

MINCIOG CORMORAN ALUMINIU PLASA CAUCIUCATA 2.40M 70X70CM

a2.m62.45242
Livrare imediată!

187,02Lei

Afişare 81 - 100 din 511 (26 pagini)
Queries: 9, Total time: 71.809 ms [By time] [By id] [By file]
1 (0.122)
SELECT data
FROM `oc_session`
WHERE session_id = '927754e182d5404bf71a98e72b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.139)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.148)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Cormoran'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.133)
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
6 (30.964)
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:1661
7 (39.940)
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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 80,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
8 (0.137)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.123)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38