Maver


FIR MAVER SMART M1 300m 0.170mm -42%

FIR MAVER SMART M1 300m 0.170mm

692017
Livrare imediată!

29,50Lei(-42%) 17,17Lei

WAGLER Maver UK SIGNATURE PRO 2 2.5gr

WAGLER Maver UK SIGNATURE PRO 2 2.5gr

h2437
Livrare imediată!

23,27Lei

CARLIGE MAVER MATCH THIS MT2 F/BARBLESS NR 10

CARLIGE MAVER MATCH THIS MT2 F/BARBLESS NR 10

g805
Livrare 48-72 ore

12,08Lei

PLUTA Maver UK SIGNATURE SERIES 4 0.5gr

PLUTA Maver UK SIGNATURE SERIES 4 0.5gr

h2633
Livrare imediată!

19,20Lei

CARLIGE MAVER MATCH THIS MT8 F/BARBLESS NR 18

CARLIGE MAVER MATCH THIS MT8 F/BARBLESS NR 18

g839
Livrare 48-72 ore

12,08Lei

BORSETA Maver UK MV-R EVA BAIT WORM 24x24x15cm

BORSETA Maver UK MV-R EVA BAIT WORM 24x24x15cm

n1416
Livrare 48-72 ore

138,17Lei

SET COS FEEDER MAVER INLINE MIC 30 GR + MATRITA -33%

SET COS FEEDER MAVER INLINE MIC 30 GR + MATRITA

k463
Livrare 48-72 ore

32,50Lei(-33%) 21,74Lei

VARGA Maver IT SUPERLITIUM EVO GREEN POWER MX 9M

VARGA Maver IT SUPERLITIUM EVO GREEN POWER MX 9M

8413b900
Livrare 48-72 ore

3.698,01Lei

VARTEJ MICRO MAVER NR 22

VARTEJ MICRO MAVER NR 22

r126
Livrare imediată!

11,07Lei

PLUTA Maver IT ORANGE SKY 0.75gr port starlet 2.2mm

PLUTA Maver IT ORANGE SKY 0.75gr port starlet 2.2mm

9129075
Livrare 48-72 ore

11,07Lei

APICALE VARF EXTERN 5.8 MM MAVER

APICALE VARF EXTERN 5.8 MM MAVER

j755
Livrare 48-72 ore

9,74Lei

PLUTA Maver IT GALLIPOLI PORTSTARLITE 6.0gr 4.5mm

PLUTA Maver IT GALLIPOLI PORTSTARLITE 6.0gr 4.5mm

9100600
Livrare imediată!

12,58Lei

FIR MAVER SMART FLUOROCARBON 50M 0.14MM

FIR MAVER SMART FLUOROCARBON 50M 0.14MM

633014
Livrare imediată!

59,87Lei

Juvelnic Maver IT Jurassic Rotund, 2.50m

Juvelnic Maver IT Jurassic Rotund, 2.50m

8046250
Livrare 48-72 ore

388,30Lei

FIR MONOFILAMENT MAVER SMART EVY 150M 0.260MM -40%

FIR MONOFILAMENT MAVER SMART EVY 150M 0.260MM

656025
Livrare 48-72 ore

21,01Lei(-40%) 12,58Lei

FIR MONOFILAMENT MAVER EXTREME 4x4 500M 0.540MM -47%

FIR MONOFILAMENT MAVER EXTREME 4x4 500M 0.540MM

661540
Livrare 48-72 ore

85,99Lei(-47%) 45,64Lei

FIR MONOFILAMENT MAVER STONE RIVER SINNKING 600M 0.12MM

FIR MONOFILAMENT MAVER STONE RIVER SINNKING 600M 0.12MM

670012
Livrare 48-72 ore

41,58Lei

COSULET MAVER JURASSIC CAGE FEEDER RIVER 200g -15%

COSULET MAVER JURASSIC CAGE FEEDER RIVER 200g

00416200
Livrare imediată!

25,00Lei(-15%) 21,34Lei

FIR MONOFILAMENT MAVER SMART DUAL BAND 600M 0.30MM

FIR MONOFILAMENT MAVER SMART DUAL BAND 600M 0.30MM

626030
Livrare 48-72 ore

97,49Lei

COSULET MAVER JURASSIC DISTANCE FEEDER 30X50mm 50g -14%

COSULET MAVER JURASSIC DISTANCE FEEDER 30X50mm 50g

00422050
Livrare 48-72 ore

20,50Lei(-14%) 17,68Lei

Afişare 661 - 680 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: 100.578 ms [By time] [By id] [By file]
1 (0.086)
SELECT data
FROM `oc_session`
WHERE session_id = '9c956f50664e3443748755baff'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.073)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.087)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Maver'
/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 = '49' AND m2s.store_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (39.643)
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 (60.483)
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 660,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.110)
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