Lineaeffe

Lineaeffe

Sortare după:

CONECTOR PENTRU VARGA LINEAEFFE CIMA D2.00MM 1BUC/PLIC

CONECTOR PENTRU VARGA LINEAEFFE CIMA D2.00MM 1BUC/PLIC

a.4995200

Livrare 24-48 ore

4,39Lei

LANSETA LINEAEFFE MUSTANG CATFISH 2.70M, 100-250G

LANSETA LINEAEFFE MUSTANG CATFISH 2.70M, 100-250G

l.2240027

Livrare imediată!

149,79Lei(-21%) 118,85Lei

SHAD NOMURA ROLLING 7.5CM/4G LIGHT BLUE SILVER GLITTER 10BUC/PL

SHAD NOMURA ROLLING 7.5CM/4G LIGHT BLUE SILVER GLITTER 10BUC/PL

f1.nm.70104307

Livrare 24-48 ore

37,59Lei

INEL LINEAEFE 1 PICIOR SIC D=20,0MM

INEL LINEAEFE 1 PICIOR SIC D=20,0MM

a9.2999220

Livrare 24-48 ore

5,51Lei

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

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

l.2980061

Livrare 24-48 ore

8,31Lei

Opritor Lineaeffe Din Cauciuc 10buc/plic D=4mm

Opritor Lineaeffe Din Cauciuc 10buc/plic D=4mm

a.4960500

Livrare imediată!

7,21Lei

Juvelnic Lineaeffe Rotund D=40cm 1.5m

Juvelnic Lineaeffe Rotund D=40cm 1.5m

a2.j6201440

Livrare 24-48 ore

38,57Lei

MULINETA LINEAEFFE VIGOR PRIME 3000 FD 1RUL/215MX025MM/5,2:1

MULINETA LINEAEFFE VIGOR PRIME 3000 FD 1RUL/215MX025MM/5,2:1

l.1206730

Livrare 24-48 ore

60,39Lei(-13%) 52,57Lei

VARTEJ LINEAEFFE NR.8 12BUC/PLIC

VARTEJ LINEAEFFE NR.8 12BUC/PLIC

a7.8032208

Livrare 24-48 ore

4,37Lei

VARTEJ TRIPLU LINEAEFFE MAR.12 12BUC/PLIC

VARTEJ TRIPLU LINEAEFFE MAR.12 12BUC/PLIC

a.8001503

Livrare 24-48 ore

8,83Lei

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

MULINETA LINEAEFE VIGOR SILK LINE 1000 FD

MULINETA LINEAEFE VIGOR SILK LINE 1000 FD

l.1206410

Livrare imediată!

54,28Lei

VARGA LINEAEFE NEXT 4,00M

VARGA LINEAEFE NEXT 4,00M

l.2050400

Livrare 24-48 ore

49,30Lei(-13%) 42,75Lei

FIR LINEAEFFE FLUOROCARBON COATED HIKARU ULTRA 0,14MM/3KG/150M

FIR LINEAEFFE FLUOROCARBON COATED HIKARU ULTRA 0,14MM/3KG/150M

l.3400014

Livrare 24-48 ore

21,33Lei

INEL LINEAEFFE CULISANT TITAN D=2,2/6MM

INEL LINEAEFFE CULISANT TITAN D=2,2/6MM

a9.3000422

Livrare imediată!

5,51Lei

Lanseta Lineaeffe Carp Camou 3.90m, 3.5lb, 2seg

Lanseta Lineaeffe Carp Camou 3.90m, 3.5lb, 2seg

l.2720739

Livrare 24-48 ore

430,24Lei(-18%) 350,98Lei

VARGA LINEAEFFE CARBON 4.00M 25G

VARGA LINEAEFFE CARBON 4.00M 25G

l.2518304

Livrare 24-48 ore

117,73Lei

FIR LINEAEFFE MONOFILAMENT SPECIMEN SILICONE 0.50MM/29.60KG 300M

FIR LINEAEFFE MONOFILAMENT SPECIMEN SILICONE 0.50MM/29.60KG 300M

l.3600550

Livrare 24-48 ore

35,71Lei

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

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

a9.2999110

Livrare imediată!

3,81Lei

Afişare 301 - 320 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.528 ms [By time] [By id] [By file]

1 (0.181)

SELECT data
FROM `oc_session`
WHERE session_id = 'd7072b550ef74c982044617d4d'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.082)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.102)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Lineaeffe'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.096)

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.974)

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 (39.932)

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 300,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440

7 (0.161)

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