Lineaeffe


CROSETA LUNGA BOILIES LINEAEFFE

CROSETA LUNGA BOILIES LINEAEFFE

a.4990210
Livrare imediată!

7,76Lei

COMBO LINEAEFFE LANSETA CARP BEATER 3BUC 3,60M+MULINETA VIGOR CARP

COMBO LINEAEFFE LANSETA CARP BEATER 3BUC 3,60M+MULINETA VIGOR CARP

combo07
Livrare 24-48 ore

202,41Lei

SHAD LINEAEFFE NOMURA GATOR 7,5CM/2,5G BEE COLOR 10BUC/PL -26%

SHAD LINEAEFFE NOMURA GATOR 7,5CM/2,5G BEE COLOR 10BUC/PL

f1.nm.70000107
Livrare 24-48 ore

36,60Lei(-26%) 27,06Lei

Lanseta Lineaeffe Tele HD Boat 2.70m/150g

Lanseta Lineaeffe Tele HD Boat 2.70m/150g

l.2280827
Livrare imediată!

84,49Lei

CONECTOR PENTRU VARGA LINEAEFFE CIMA D1.50MM 1BUC/PLIC

CONECTOR PENTRU VARGA LINEAEFFE CIMA D1.50MM 1BUC/PLIC

a.4995150
Livrare imediată!

3,81Lei

VARGA LINEAEFFE ORION FISSA 6.00M 25G -13%

VARGA LINEAEFFE ORION FISSA 6.00M 25G

l.2520406
Livrare 24-48 ore

238,29Lei(-13%) 207,27Lei

TAPARINA LINEAEFFE RAINBOW NI NR.6 8BUC/PL

TAPARINA LINEAEFFE RAINBOW NI NR.6 8BUC/PL

a.5639306
Livrare 24-48 ore

29,77Lei

INEL LINEAEFE 1 PICIOR SIC D=12,0MM

INEL LINEAEFE 1 PICIOR SIC D=12,0MM

a9.2999212
Livrare 24-48 ore

3,81Lei

INEL LINEAEFE VIRF TITAN TUB=3,5MM/D=10,0MM

INEL LINEAEFE VIRF TITAN TUB=3,5MM/D=10,0MM

a9.3000637
Livrare 24-48 ore

4,37Lei

STARLITA LINEAEFFE 4,5X39MM 1BUC/PL

STARLITA LINEAEFFE 4,5X39MM 1BUC/PL

a.4922045
Livrare 24-48 ore

2,12Lei

OPRITOARE LINEAEFFE CAUCIUC PENTRU PLUTA 6BUC/PLIC MAR.L

OPRITOARE LINEAEFFE CAUCIUC PENTRU PLUTA 6BUC/PLIC MAR.L

a.4950020
Livrare 24-48 ore

3,25Lei

VOBLER NOMURA TROUTY 2.5CM 2.50G PUSSY PINK

VOBLER NOMURA TROUTY 2.5CM 2.50G PUSSY PINK

nm.54753502
Livrare 24-48 ore

36,48Lei

OPRITOARE LINEAEFFE SILICON M

OPRITOARE LINEAEFFE SILICON M

a.4940100
Livrare imediată!

2,87Lei

MOMITOR FEEDER LINEAEFFE SPYRAL MAR.S

MOMITOR FEEDER LINEAEFFE SPYRAL MAR.S

a.4922400
Livrare imediată!

3,81Lei

Fir Monofilament LINEAEFFE Deep Flow, Dark Brown, 0.25m, 6.7kg, 150m

Fir Monofilament LINEAEFFE Deep Flow, Dark Brown, 0.25m, 6.7kg, 150m

l.3509025
Livrare 24-48 ore

15,38Lei

Lanseta LINEAEFFE FF GT Spin 2.13m, 10-30g, 2seg

Lanseta LINEAEFFE FF GT Spin 2.13m, 10-30g, 2seg

l.2833721
Livrare 24-48 ore

172,68Lei

MULINETA LINEAEFE VIGOR 2000 SL.FD

MULINETA LINEAEFE VIGOR 2000 SL.FD

l.1360220
Livrare 24-48 ore

36,40Lei

JUVELNIC LINEAEFFE PLASA D=32CM/L=1,00M

JUVELNIC LINEAEFFE PLASA D=32CM/L=1,00M

a2.j6202300
Livrare 24-48 ore

35,34Lei

FIR LINEAEFFE FLUOROCARBON AKASHI 0,14MM/3KG/50M

FIR LINEAEFFE FLUOROCARBON AKASHI 0,14MM/3KG/50M

l.3042114
Livrare 24-48 ore

19,35Lei

INEL LINEAEFFE 2 PICIOARE SIC D=25,0MM

INEL LINEAEFFE 2 PICIOARE SIC D=25,0MM

a9.2999425
Livrare imediată!

9,03Lei

Afişare 441 - 460 din 593 (30 pagini)
💬
WhatsApp Chat
👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)
Queries: 7, Total time: 77.358 ms [By time] [By id] [By file]
1 (0.147)
SELECT data
FROM `oc_session`
WHERE session_id = '2e0b84b5e7a39c8b6c3d504324'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.124)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Lineaeffe'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.122)
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 (36.596)
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:1699
6 (40.121)
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 = '163' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 440,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.146)
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