Maver

Maver

Sortare după:

PLUTA Maver UK MV-R SERIES 2 0.4gr

PLUTA Maver UK MV-R SERIES 2 0.4gr

h2506

Livrare 48-72 ore

17,17Lei

CARLIGE MAVER MATCH THIS MT3 F/BARBLESS NR 18

CARLIGE MAVER MATCH THIS MT3 F/BARBLESS NR 18

g814

Livrare 48-72 ore

12,08Lei

PLUTA Maver UK SIGNATURE SERIES 6 0.4gr

PLUTA Maver UK SIGNATURE SERIES 6 0.4gr

h2648

Livrare 48-72 ore

19,20Lei

WAGLER MAVER TRANSPARENT CU ANTENA MAVER 7BB

WAGLER MAVER TRANSPARENT CU ANTENA MAVER 7BB

h1409

Livrare imediată!

10,06Lei

SET Maver UK HANORAC TRICURI SAPCA MAVER TEAM Marime: XXXL

SET Maver UK HANORAC TRICURI SAPCA MAVER TEAM Marime: XXXL

n1265

Livrare 48-72 ore

479,81Lei

PLUMBI OLIVETA MAVER INLINE 4.0GR

PLUMBI OLIVETA MAVER INLINE 4.0GR

k658

Livrare 48-72 ore

17,17Lei

PLUTA Maver IT MALENA 0.75gr

PLUTA Maver IT MALENA 0.75gr

9095075

Livrare 48-72 ore

18,17Lei

SET CON + BAT EXTRACTOR RAPPA BUNGS L MAVER

SET CON + BAT EXTRACTOR RAPPA BUNGS L MAVER

j666

Livrare 48-72 ore

28,35Lei

PLUTA Maver IT CORSINI PORTSTARLITE 4.0gr 4.5mm

PLUTA Maver IT CORSINI PORTSTARLITE 4.0gr 4.5mm

9097400

Livrare 48-72 ore

15,65Lei

SUPORT FEEDER AJUSTABIL MAVER

SUPORT FEEDER AJUSTABIL MAVER

j516

Livrare imediată!

31,40Lei

Suport Maver Feeder Signature QR Rod Rest 50cm

Suport Maver Feeder Signature QR Rod Rest 50cm

l1071

Livrare 48-72 ore

99,53Lei

FIR MAVER ZERO FLUOROCARBON 50M 0.345MM

FIR MAVER ZERO FLUOROCARBON 50M 0.345MM

732345

Livrare 48-72 ore

61,92Lei

FIR MONOFILAMENT MAVER ARCADIUM SILVER SOFT 100M 0.196MM

FIR MONOFILAMENT MAVER ARCADIUM SILVER SOFT 100M 0.196MM

680196

Livrare 48-72 ore

21,70Lei(-41%) 12,90Lei

FIR MONOFILAMENT MAVER SMART MRT 500M 0.35MM

FIR MONOFILAMENT MAVER SMART MRT 500M 0.35MM

638035

Livrare 48-72 ore

120,00Lei(-48%) 62,92Lei

COSULET MAVER JURASSIC CAGE FEEDER ROTUND MASH 4X12 MESH 15gr

COSULET MAVER JURASSIC CAGE FEEDER ROTUND MASH 4X12 MESH 15gr

00413015

Livrare 48-72 ore

11,00Lei(-10%) 9,95Lei

FIR MONOFILAMENT MAVER SMART RED DEVIL 150M 0.16MM

FIR MONOFILAMENT MAVER SMART RED DEVIL 150M 0.16MM

652016

Livrare 48-72 ore

25,91Lei

COSULET FEEDER MAVER JURASSIC BULLET MESH 25X43MM 30g

COSULET FEEDER MAVER JURASSIC BULLET MESH 25X43MM 30g

00425030

Livrare 48-72 ore

21,01Lei(-14%) 18,08Lei

FIR MONOFILAMENT MAVER SMART X LINE 600M 0.16MM

FIR MONOFILAMENT MAVER SMART X LINE 600M 0.16MM

637016

Livrare 48-72 ore

50,00Lei(-45%) 27,35Lei

CARLIGE LEGATE MAVER JURASSIC J21 NR 6-0.22

CARLIGE LEGATE MAVER JURASSIC J21 NR 6-0.22

j2100622

Livrare 48-72 ore

7,01Lei(-2%) 6,90Lei

Leader Maver Impact Shock Sinking DG 0.50mm 100m 19.5kg

Leader Maver Impact Shock Sinking DG 0.50mm 100m 19.5kg

926050

Livrare 48-72 ore

76,15Lei

Afişare 1001 - 1020 din 1728 (87 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: 111.066 ms [By time] [By id] [By file]

1 (0.176)

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

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

2 (0.080)

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 = 'Maver'

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

4 (0.088)

SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '49' AND m2s.store_id = '2'

/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4

5 (38.714)

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 = '2' AND p.manufacturer_id = '49'

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

6 (71.777)

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 = '2' AND p.manufacturer_id = '49' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 1000,20

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

7 (0.129)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37