Maver

Maver

Sortare după:

CARLIGE MAVER MATCH THIS MT1 F/BARBLESS NR 18

CARLIGE MAVER MATCH THIS MT1 F/BARBLESS NR 18

g802

Livrare 48-72 ore

12,08Lei

PLUTA Maver UK SIGNATURE SERIES 4 0.2gr

PLUTA Maver UK SIGNATURE SERIES 4 0.2gr

h2630

Livrare imediată!

19,20Lei

CARLIGE MAVER MATCH THIS MT8 F/BARBLESS NR 12

CARLIGE MAVER MATCH THIS MT8 F/BARBLESS NR 12

g836

Livrare 48-72 ore

12,08Lei

BORSETA Maver UK MV-R EVA ACCESORII LARGE 41x27.5x10cm

BORSETA Maver UK MV-R EVA ACCESORII LARGE 41x27.5x10cm

n1402

Livrare imediată!

177,82Lei

SET COS FEEDER MAVER MIC 30 GR + MATRITA

SET COS FEEDER MAVER MIC 30 GR + MATRITA

k458

Livrare 48-72 ore

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

CROSETA MAVER STRINGER

CROSETA MAVER STRINGER

t309

Livrare 48-72 ore

12,71Lei(-14%) 10,96Lei

PLUTA Maver IT GREEN SKY 0.50gr port starlet 2.2mm

PLUTA Maver IT GREEN SKY 0.50gr port starlet 2.2mm

9128050

Livrare 48-72 ore

11,07Lei

APICALE VARF INTERN NR 8 - 5.5 MM MAVER

APICALE VARF INTERN NR 8 - 5.5 MM MAVER

j507

Livrare 48-72 ore

9,74Lei

PLUTA Maver IT GALLIPOLI PORTSTARLITE 3.0gr 4.5mm

PLUTA Maver IT GALLIPOLI PORTSTARLITE 3.0gr 4.5mm

9100300

Livrare 48-72 ore

12,58Lei

FIR MONOFILAMENT MAVER SMART SLR 50M 0.20MM

FIR MONOFILAMENT MAVER SMART SLR 50M 0.20MM

621020

Livrare 48-72 ore

40,55Lei

FIR MONOFILAMENT MAVER SMART EVY 150M 0.187MM

FIR MONOFILAMENT MAVER SMART EVY 150M 0.187MM

656018

Livrare 48-72 ore

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

Lanseta feeder Maver IT POWERLITE F FEEDER 11FT 3.3M 2SEC 60GR

Lanseta feeder Maver IT POWERLITE F FEEDER 11FT 3.3M 2SEC 60GR

5765004

Livrare 48-72 ore

660,81Lei

FIR MONOFILAMENT MAVER EXTREME 4x4 500M 0.246MM

FIR MONOFILAMENT MAVER EXTREME 4x4 500M 0.246MM

661246

Livrare 48-72 ore

34,00Lei(-44%) 19,20Lei

VARGA MAVER IT SUPERLITIUM POWER MX 5M

VARGA MAVER IT SUPERLITIUM POWER MX 5M

8445b500

Livrare 48-72 ore

1.252,59Lei

FIR MONOFILAMENT MAVER STONE RIVER SINNKING 150M 0.22MM

FIR MONOFILAMENT MAVER STONE RIVER SINNKING 150M 0.22MM

654022

Livrare imediată!

35,47Lei

COSULET MAVER JURASSIC CAGE FEEDER RIVER 100g

COSULET MAVER JURASSIC CAGE FEEDER RIVER 100g

00416100

Livrare 48-72 ore

19,00Lei(-13%) 16,46Lei

FIR MONOFILAMENT MAVER SMART DUAL BAND 600M 0.20MM

FIR MONOFILAMENT MAVER SMART DUAL BAND 600M 0.20MM

626020

Livrare 48-72 ore

73,08Lei

COSULET MAVER JURASSIC DISTANCE FEEDER 25X40MM 50g

COSULET MAVER JURASSIC DISTANCE FEEDER 25X40MM 50g

00421050

Livrare 48-72 ore

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

CARLIGE LEGATE MAVER JURASSIC J02 NR 6-0.25

CARLIGE LEGATE MAVER JURASSIC J02 NR 6-0.25

j0200625

Livrare 48-72 ore

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

Lanseta Maver Ultra Boat 1.80m 100g 2seg

Lanseta Maver Ultra Boat 1.80m 100g 2seg

5774001

Livrare 48-72 ore

205,28Lei

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

1 (0.221)

SELECT data
FROM `oc_session`
WHERE session_id = '1efd8f546aa26b82eca17d6768'

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

2 (0.104)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.127)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Maver'

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

4 (0.138)

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

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

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

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

7 (0.165)

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