Lineaeffe


JUVELNIC LINEAEFFE OVAL DIN SARMA 33cmx45cm

JUVELNIC LINEAEFFE OVAL DIN SARMA 33cmx45cm

a2.j7580035
Livrare 24-48 ore

89,75Lei

Mulineta Lineaeffe Shizuka SK13 FD 3000, 1ALU+1GRA+Fir, 0.30mm/170m, 5.2:1

Mulineta Lineaeffe Shizuka SK13 FD 3000, 1ALU+1GRA+Fir, 0.30mm/170m, 5.2:1

l.s1001330
Livrare 24-48 ore

93,40Lei

LANSETA BOLOGNEZA LINEAEFE TELE EXCELLENT BOLO 6,00M

LANSETA BOLOGNEZA LINEAEFE TELE EXCELLENT BOLO 6,00M

l.2520516
Livrare 24-48 ore

214,87Lei

VARGA LINEAEFE CARBON DREAM 6,00M/5-30G -23%

VARGA LINEAEFE CARBON DREAM 6,00M/5-30G

l.2516760
Livrare imediată!

372,35Lei(-23%) 286,90Lei

LINEAEFFE VARF PLIN CARBON L=60CM;D=2,2/0,7MM

LINEAEFFE VARF PLIN CARBON L=60CM;D=2,2/0,7MM

l.2979909
Livrare imediată!

17,42Lei

VOBLER, LINEAEFFE, NOMURA, RANGER, MINNOW, 7CM/13G, REAL, nm.52210807, Voblere Sinking, Voblere Sinking Lineaeffe, Lineaeffe
LANSETA SPINNING LINEAEFFE NOMURA HARU 2SEG 2,10M/10-30G -20%

LANSETA SPINNING LINEAEFFE NOMURA HARU 2SEG 2,10M/10-30G

nm.21103021
Livrare 24-48 ore

302,70Lei(-20%) 242,17Lei

LANSETA LINEAEFFE IMPULSE II FEEDER 3.90M 70 150G 3 3SEGMENTE

LANSETA LINEAEFFE IMPULSE II FEEDER 3.90M 70 150G 3 3SEGMENTE

l.2852639
Livrare 24-48 ore

244,33Lei

VARGA, LINEAEFFE, STANDARD, MASTER, CARBON, 4.00M, 25G, l.2518204, Vergi 4 Metri, Vergi 4 Metri Lineaeffe, Lineaeffe
, LANSETA, LINEAEFFE, TELESCOPICA, ORION, BOLO/WWG, 5.00M, 25G, l.2520415, Lansete Bolognese 5 Metri, Lansete Bolognese 5 Metri Lineaeffe, Lineaeffe
MANER MINCIOG LINEAEFFE 4.20M

MANER MINCIOG LINEAEFFE 4.20M

a2.6300400
Livrare 24-48 ore

111,67Lei

INEL LINEAEFE VIRF SIC TUB=3,0MM/D=8,0MM

INEL LINEAEFE VIRF SIC TUB=3,0MM/D=8,0MM

a9.2999530
Livrare 24-48 ore

2,81Lei

VIRF LINEAEFE FIBRA L=60CM D=6,0/0,7MM

VIRF LINEAEFE FIBRA L=60CM D=6,0/0,7MM

l.2980063
Livrare imediată!

16,86Lei

Opritoare, Lineaeffe, Flotante, ,, Multicolor,, 6buc/plic, Marime:, XL, 18x25.5mm, , , , a.4945004, Opritoare Porumb Boilies, Opritoare Porumb Boilies Lineaeffe, Lineaeffe
Croseta, Lineaeffe, Profesionala, Boilies, a.4990223, Crosete si Burghie , Crosete si Burghie Lineaeffe, Lineaeffe
Adaptor LINEAEFFE Nylon Forks Busta, 2buc/pac

Adaptor LINEAEFFE Nylon Forks Busta, 2buc/pac

a.4990257
Livrare imediată!

3,42Lei

MULINETA LINEAEFFE VIGOR PRIME 2000 FD 1RUL/235MX018MM/5,5:1 -20%

MULINETA LINEAEFFE VIGOR PRIME 2000 FD 1RUL/235MX018MM/5,5:1

l.1206720
Livrare 24-48 ore

57,92Lei(-20%) 46,34Lei

AGRAFA LINEAEFFE HELICOPTER 5BUC/PLIC

AGRAFA LINEAEFFE HELICOPTER 5BUC/PLIC

a.4990258
Livrare 24-48 ore

11,84Lei

MOMITOR FEEDER LINEAEFFE SPYRAL MAR.XL

MOMITOR FEEDER LINEAEFFE SPYRAL MAR.XL

a.4922430
Livrare imediată!

2,81Lei

MULINETA, LINEAEFE, VIGOR, 2000, SL.FD, l.1360220, Mulinete Bolognese, Mulinete Bolognese Lineaeffe, Lineaeffe
Afişare 221 - 240 din 623 (32 pagini)
Queries: 7, Total time: 72.553 ms [By time] [By id] [By file]
1 (0.066)
SELECT data
FROM `oc_session`
WHERE session_id = '971b7174dccd192d5e62eaf67d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.118)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.131)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Lineaeffe'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.125)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '163' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (35.182)
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 = '163'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (36.823)
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 = '0' AND p.manufacturer_id = '163' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 220,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.108)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38