Lineaeffe


Lanseta LINEAEFFE Link Carbon Feeder 3.90m, 120g, 3+3seg

Lanseta LINEAEFFE Link Carbon Feeder 3.90m, 120g, 3+3seg

l.2850539
Livrare 24-48 ore

294,44Lei

AGRAFA+VARTEJ LINEAEFE NR.16/12BUC/PL.

AGRAFA+VARTEJ LINEAEFE NR.16/12BUC/PL.

a7.8002116
Livrare imediată!

4,89Lei

Fir monofilament Lineaeffe Carp Top Smoke Green 0.22mm/5.0kg/1200m

Fir monofilament Lineaeffe Carp Top Smoke Green 0.22mm/5.0kg/1200m

l.3001406
Livrare 24-48 ore

21,83Lei

NALUCA LINEAEFFE NOMURA AKI 3CM/0,17G GLITER GREEN 12BUC/PL

NALUCA LINEAEFFE NOMURA AKI 3CM/0,17G GLITER GREEN 12BUC/PL

f1.nm.71702803
Livrare 24-48 ore

17,86Lei

Suport U flexibil Lineaeffe fosforescent

Suport U flexibil Lineaeffe fosforescent

a6.6313074
Livrare imediată!

10,55Lei

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

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

l.3016012
Livrare imediată!

43,81Lei

MULINETA LINEAEFFE VIGOR MUSTANG FD 2000

MULINETA LINEAEFFE VIGOR MUSTANG FD 2000

l.1229720
Livrare 24-48 ore

52,66Lei

MANER MINCIOG LINEAEFFE 4.20M

MANER MINCIOG LINEAEFFE 4.20M

a2.6300400
Livrare 24-48 ore

112,68Lei

INEL LINEAEFE VIRF SIC TUB=6,0MM/D=16,0MM

INEL LINEAEFE VIRF SIC TUB=6,0MM/D=16,0MM

a9.2999560
Livrare 24-48 ore

5,51Lei

INEL LINEAEFFE 1 PICIOR SIC KTTSG NR.6

INEL LINEAEFFE 1 PICIOR SIC KTTSG NR.6

a9.2998106
Livrare imediată!

5,00Lei

Opritor Lineaeffe Fosfo Oval 20buc/plic 4.0 x 5mm

Opritor Lineaeffe Fosfo Oval 20buc/plic 4.0 x 5mm

a.5671040
Livrare imediată!

3,81Lei

Lanseta Telescopica Lineaeffe Adriatic Tele Surf 4.20M 150-250g

Lanseta Telescopica Lineaeffe Adriatic Tele Surf 4.20M 150-250g

l.2277842
Livrare 24-48 ore

95,54Lei

MULINETA LINEAEFFE VIGOR CARP NEW 6000 1RUL/140MX045MM/5,2:1

MULINETA LINEAEFFE VIGOR CARP NEW 6000 1RUL/140MX045MM/5,2:1

l.1287360
Livrare imediată!

73,43Lei

BULDO LINEAEFFE OVAL TRANSPARENT MAR.50 2buc/plic

BULDO LINEAEFFE OVAL TRANSPARENT MAR.50 2buc/plic

a.4900050
Livrare imediată!

7,18Lei

Lanseta Lineaeffe Vigor Living Rod 2.40m 30g 2seg -17%

Lanseta Lineaeffe Vigor Living Rod 2.40m 30g 2seg

l.2826024
Livrare 24-48 ore

80,94Lei(-17%) 66,84Lei

Mulineta Lineaeffe Shizuka SK14 7000, 2rul, 1GRA+Fir, 0.45mm/310m, 3.9:1

Mulineta Lineaeffe Shizuka SK14 7000, 2rul, 1GRA+Fir, 0.45mm/310m, 3.9:1

l.s1001470
Livrare 24-48 ore

87,62Lei

Lanseta Universala LINEAEFFE Asteroid WTG Tele Rod 3.60m, 100g, 4seg

Lanseta Universala LINEAEFFE Asteroid WTG Tele Rod 3.60m, 100g, 4seg

l.2277136
Livrare 24-48 ore

60,55Lei

SUPORT TELESCOPIC LOCAS LINEAEFFE V L=80-130CM

SUPORT TELESCOPIC LOCAS LINEAEFFE V L=80-130CM

a6.6302100
Livrare 24-48 ore

29,67Lei

COMBO LINEAEFFE LANSETA TELE THUNDER 3,60M+MULINETA SILK LINE 70

COMBO LINEAEFFE LANSETA TELE THUNDER 3,60M+MULINETA SILK LINE 70

combo14
Livrare 24-48 ore

131,76Lei

SHAD LINEAEFFE NOMURA ORIGINAL 7CM/3G CHART YELLOW RED

SHAD LINEAEFFE NOMURA ORIGINAL 7CM/3G CHART YELLOW RED

f1.nm.76301607
Livrare 24-48 ore

34,71Lei

Afişare 541 - 560 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: 131.150 ms [By time] [By id] [By file]
1 (0.107)
SELECT data
FROM `oc_session`
WHERE session_id = 'afdcaeb9019645adf88b67c104'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.086)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.101)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Lineaeffe'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.103)
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 (60.324)
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 (70.306)
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 540,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.123)
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