Lineaeffe

Lineaeffe

Sortare după:

Opritor Lineaeffe Fosfo Oval 20buc/plic 5.0 X 8mm

Opritor Lineaeffe Fosfo Oval 20buc/plic 5.0 X 8mm

a.5671050

Livrare imediată!

3,81Lei

Varga Lineaeffe Tele Cross Carbon 4M

Varga Lineaeffe Tele Cross Carbon 4M

l.2414240

Livrare imediată!

86,73Lei

MULINETA LINEAEFFE VIGOR XTM FREE 6000 3RUL/140MX045MM/5,2:1

MULINETA LINEAEFFE VIGOR XTM FREE 6000 3RUL/140MX045MM/5,2:1

l.1289306

Livrare imediată!

96,78Lei

TAPARINA LINEAEFFE SABIKI HIPERCATCH SHRIMP NR.4

TAPARINA LINEAEFFE SABIKI HIPERCATCH SHRIMP NR.4

a.5648004

Livrare 24-48 ore

10,55Lei

MONTURA MAVER IT JURASSIC FEEDER LINK S 5cm 3/plic

MONTURA MAVER IT JURASSIC FEEDER LINK S 5cm 3/plic

00430001

Livrare 48-72 ore

37,99Lei(-16%) 31,91Lei

Lanseta Bolognesa LINEAEFFE Artistic Superior Bolo Rod 4.00m, 5-25g

Lanseta Bolognesa LINEAEFFE Artistic Superior Bolo Rod 4.00m, 5-25g

l.2518504

Livrare 24-48 ore

188,84Lei

SET LINEAEFE 4 FEEDER DIF.GR.+INCARCATOR PASTA

SET LINEAEFE 4 FEEDER DIF.GR.+INCARCATOR PASTA

a.4926500

Livrare 24-48 ore

36,48Lei

MINCIOG LINEA. CARP 1,80M/2BUC/100X100CM

MINCIOG LINEA. CARP 1,80M/2BUC/100X100CM

a2.m6101875

Livrare imediată!

177,68Lei

SHAD LINEAEFFE NOMURA ORIGINAL CHART YELLOW RED 10CM/7,8G 6BUC/PL

SHAD LINEAEFFE NOMURA ORIGINAL CHART YELLOW RED 10CM/7,8G 6BUC/PL

f1.nm.76301610

Livrare 24-48 ore

33,59Lei

LANSETA SPINNING LINEAEFFE NOMURA AKIRA 2SEG 2,10M/18G

LANSETA SPINNING LINEAEFFE NOMURA AKIRA 2SEG 2,10M/18G

nm.20501821

Livrare 24-48 ore

338,72Lei(-18%) 276,53Lei

TRUSA LINEAEFFE 4 ACCESORII PENTRU BOILIES

TRUSA LINEAEFFE 4 ACCESORII PENTRU BOILIES

a.4990207

Livrare 24-48 ore

29,66Lei

COMBO LINEAEFFE LANSETE 3 BUCATI TOP CARP 3.60M MULINETE 3 BUCATI S 60

COMBO LINEAEFFE LANSETE 3 BUCATI TOP CARP 3.60M MULINETE 3 BUCATI S 60

l.2015363

Livrare imediată!

835,11Lei

SHAD NOMURA ROLLING 7.5CM/4G YELLOW RED GLITTER 10BUC/PL

SHAD NOMURA ROLLING 7.5CM/4G YELLOW RED GLITTER 10BUC/PL

f1.nm.70108707

Livrare 24-48 ore

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

INEL LINEAEFE 1 PICIOR SIC D=25,0MM

INEL LINEAEFE 1 PICIOR SIC D=25,0MM

a9.2999225

Livrare imediată!

5,61Lei(-9%) 5,08Lei

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

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

l.2980062

Livrare imediată!

12,35Lei(-19%) 9,98Lei

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

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

a.4960600

Livrare imediată!

7,21Lei

Juvelnic Lineaeffe Rotund D=40cm 2m

Juvelnic Lineaeffe Rotund D=40cm 2m

a2.j6201441

Livrare imediată!

44,83Lei

MULINETA LINEAEFFE VIGOR PRIME 5000 FD 1RUL/195MX035MM/5,2:1

MULINETA LINEAEFFE VIGOR PRIME 5000 FD 1RUL/195MX035MM/5,2:1

l.1206750

Livrare 24-48 ore

64,07Lei(-17%) 53,12Lei

VARTEJ LINEAEFFE NR.10 12BUC/PLIC

VARTEJ LINEAEFFE NR.10 12BUC/PLIC

a7.8032210

Livrare 24-48 ore

5,17Lei

VARTEJ TRIPLU LINEAEFFE MAR.14 12BUC/PLIC

VARTEJ TRIPLU LINEAEFFE MAR.14 12BUC/PLIC

a.8001504

Livrare 24-48 ore

6,49Lei

Afişare 501 - 520 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: 71.733 ms [By time] [By id] [By file]

1 (0.095)

SELECT data
FROM `oc_session`
WHERE session_id = '2e0b84b5e7a39c8b6c3d504324'

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

2 (0.116)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.109)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Lineaeffe'

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

4 (0.095)

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

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

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

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

7 (0.135)

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