Cormoran


MINCIOG CORMORAN ALUMINIU PLASA CAUCIUCATA 1.90M 50X50CM

MINCIOG CORMORAN ALUMINIU PLASA CAUCIUCATA 1.90M 50X50CM

a2.m62.45192
Livrare imediată!

156,80Lei

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

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

a7.75.84312
Livrare imediată!

18,44Lei

Cap Cormoran Suport Lanseta Longnose Feeder

Cap Cormoran Suport Lanseta Longnose Feeder

a6.63.67001
Livrare 24-48 ore

11,74Lei

Starlita Cormoran 3x25mm 2buc/plic

Starlita Cormoran 3x25mm 2buc/plic

a.49.08009
Livrare 24-48 ore

2,67Lei

Set linguri oscilante Cormoran Toro UL Trout Spoon Set 3 -38%

Set linguri oscilante Cormoran Toro UL Trout Spoon Set 3

f.50.88903
Livrare 24-48 ore

104,08Lei(-38%) 64,51Lei

Husa Lanseta + Mulineta DAIWA D-Vec, Grey, 145cm

Husa Lanseta + Mulineta DAIWA D-Vec, Grey, 145cm

a8.15842.145
Livrare 24-48 ore

114,09Lei

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

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

a7.80.00014
Livrare imediată!

8,32Lei

MONTURA CORMORAN LINE ALIGNER RIG T3 NR.6/2BUC

MONTURA CORMORAN LINE ALIGNER RIG T3 NR.6/2BUC

a.11.02301.6
Livrare imediată!

23,39Lei

ANTI TANGLE CORMORAN 10CM PT.FEEDER 3BUC/PL

ANTI TANGLE CORMORAN 10CM PT.FEEDER 3BUC/PL

a.49.53110
Livrare imediată!

6,46Lei

VOBLER CORMORAN COR F1 3,5CM/2G BABY BROWN TROUT

VOBLER CORMORAN COR F1 3,5CM/2G BABY BROWN TROUT

f3.53.04351
Livrare imediată!

32,07Lei

Kit Cormoran Pro Carp Chod Rig Set Mud -55%

Kit Cormoran Pro Carp Chod Rig Set Mud

a.11.00221
Livrare imediată!

21,90Lei(-55%) 9,91Lei

OSCILANTA CORMORAN CORA-Z 50MM/16G SILVER/RED SC. -30%

OSCILANTA CORMORAN CORA-Z 50MM/16G SILVER/RED SC.

f.50.861016
Stoc epuizat

11,27Lei(-30%) 7,87Lei

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

179,30Lei

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

Lingura oscilanta Cormoran Toro UL5 2.3cm 1.6g Farbe 03

f.50.88503
Livrare 24-48 ore

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

Vobler Cormoran Cor SLS2 Copper Pearl, 3.5cm, 2.0g, 1buc/pac

Vobler Cormoran Cor SLS2 Copper Pearl, 3.5cm, 2.0g, 1buc/pac

f3.53.04462
Livrare 24-48 ore

28,12Lei

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

CIZMA CORMORAN SOLD NYLON MARIME 42

CIZMA CORMORAN SOLD NYLON MARIME 42

a8.95.04542
Livrare imediată!

244,13Lei

Afişare 281 - 297 din 297 (15 pagini)
Queries: 7, Total time: 104.943 ms [By time] [By id] [By file]
1 (0.087)
SELECT data
FROM `oc_session`
WHERE session_id = '0b152e4f69102095d30b53900f'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.098)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.121)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Cormoran'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.144)
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 (59.757)
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 (44.633)
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 280,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.103)
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