Lineaeffe


FIR LINEAEFFE MONOFILAMENT SPECIMEN SILICONE 0.35MM/15.8KG 300M

FIR LINEAEFFE MONOFILAMENT SPECIMEN SILICONE 0.35MM/15.8KG 300M

l.3600535
Livrare imediată!

35,71Lei

Lanseta Lineaeffe Nomura Aichi 1.95m 1-10g 2seg -18%

Lanseta Lineaeffe Nomura Aichi 1.95m 1-10g 2seg

nm.20101019
Livrare 24-48 ore

489,13Lei(-18%) 398,88Lei

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

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

AGRAFA+VARTEJ LINEAEFE NR.18/12BUC/PLIC

AGRAFA+VARTEJ LINEAEFE NR.18/12BUC/PLIC

a7.8032118
Livrare 24-48 ore

5,64Lei

Fir monofilament Lineaeffe Carp Top Smoke Green 0.30MM/7.9KG 800M

Fir monofilament Lineaeffe Carp Top Smoke Green 0.30MM/7.9KG 800M

l.3001410
Livrare 24-48 ore

19,35Lei

VOBLER LINEAEFFE NOMURA RANGER MINNOW 7CM/13G NATURAL LIGHT BLUE

VOBLER LINEAEFFE NOMURA RANGER MINNOW 7CM/13G NATURAL LIGHT BLUE

nm.52208307
Livrare 24-48 ore

43,27Lei

VARTEJ LINEAEFFE CU OPRITOR 5BUC/PL

VARTEJ LINEAEFFE CU OPRITOR 5BUC/PL

a.4990301
Livrare 24-48 ore

6,62Lei

FIR TEXTIL LINEAEFFE JAPAN BRAID 4X VERDE 150M 0.16MM

FIR TEXTIL LINEAEFFE JAPAN BRAID 4X VERDE 150M 0.16MM

l.3016016
Livrare 24-48 ore

43,81Lei

Mulineta Nomura Haru FD 3000 -18%

Mulineta Nomura Haru FD 3000

nm.10620930
Livrare 24-48 ore

343,04Lei(-18%) 280,03Lei

LANSETA TELESCOPICA LINEAEFFE LONG BEACH WWG 200G 3.60M

LANSETA TELESCOPICA LINEAEFFE LONG BEACH WWG 200G 3.60M

l.2285436
Livrare imediată!

100,45Lei

INEL LINEAEFE 1 PICIOR TITAN D=16,0MM

INEL LINEAEFE 1 PICIOR TITAN D=16,0MM

a9.3000316
Livrare 24-48 ore

4,37Lei

INEL LINEAEFFE 1 PICIOR SIC KLTSG-H NR.16

INEL LINEAEFFE 1 PICIOR SIC KLTSG-H NR.16

a9.2998316
Livrare 24-48 ore

12,25Lei

Vartej Lineaeffe Culisant cu Margele 12buc/plic Marime:L

Vartej Lineaeffe Culisant cu Margele 12buc/plic Marime:L

a7.4990306
Livrare 24-48 ore

19,54Lei

Lanseta Telescopica Lineaeffe Personal Caster Tele Surf 4.20m 200g

Lanseta Telescopica Lineaeffe Personal Caster Tele Surf 4.20m 200g

l.2270142
Livrare 24-48 ore

217,09Lei

Afişare 501 - 520 din 583 (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: 97.227 ms [By time] [By id] [By file]
1 (0.149)
SELECT data
FROM `oc_session`
WHERE session_id = '1d5f9b80443f091e6f13cde017'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.134)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
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.123)
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 = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (48.527)
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 = '163'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (48.019)
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 = '163' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 500,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.144)
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