Maver

Maver

Sortare după:

FIR MONOFILAMENT MAVER DYNASTY GREEN 150m 0.20mm

FIR MONOFILAMENT MAVER DYNASTY GREEN 150m 0.20mm

605020

Livrare 48-72 ore

25,00Lei(-21%) 19,71Lei

CARLIGE MAVER SERIA INVINCIBLE CS23 CARP WIDE GAPE NR 18

CARLIGE MAVER SERIA INVINCIBLE CS23 CARP WIDE GAPE NR 18

g1018

Livrare 48-72 ore

12,08Lei

Fir monofilament Maver MV-R Hooklenght Mono 0.16mm/2.5kg/50m

Fir monofilament Maver MV-R Hooklenght Mono 0.16mm/2.5kg/50m

f606

Livrare imediată!

29,00Lei(-44%) 16,15Lei

Lanseta Maver IT OSTELLATTO TP FEEDER 13FT 3.9M 100-250GR

Lanseta Maver IT OSTELLATTO TP FEEDER 13FT 3.9M 100-250GR

5737004

Livrare 48-72 ore

1.035,00Lei(-24%) 790,96Lei

Varga Maver IT LEGEND SL 7M

Varga Maver IT LEGEND SL 7M

8424b700

Livrare 48-72 ore

2.227,69Lei

Lanseta Maver UK REALITY PLUS MATCH 11FT 3.3M 25gr 2sec

Lanseta Maver UK REALITY PLUS MATCH 11FT 3.3M 25gr 2sec

a2955

Livrare 48-72 ore

559,13Lei

MONTURA MAVER HAIR RIG MV2 LONG SHANK NR 6 F/BARBLESS

MONTURA MAVER HAIR RIG MV2 LONG SHANK NR 6 F/BARBLESS

t361

Livrare 48-72 ore

9,99Lei(-30%) 7,01Lei

PLUTA Maver UK MV-R SERIES 3 0.6gr

PLUTA Maver UK MV-R SERIES 3 0.6gr

h2513

Livrare 48-72 ore

17,17Lei

CARLIGE MAVER MATCH THIS MT5 F/BARBLESS NR 10

CARLIGE MAVER MATCH THIS MT5 F/BARBLESS NR 10

g821

Livrare 48-72 ore

12,08Lei

PLUTA Maver UK MV-R FINESSE SERIES 1 0.5gr

PLUTA Maver UK MV-R FINESSE SERIES 1 0.5gr

h2554

Livrare 48-72 ore

19,20Lei

WAGLER MAVER TRANSPARENT PLUMBAT CU ANTENA MAVER 5BB

WAGLER MAVER TRANSPARENT PLUMBAT CU ANTENA MAVER 5BB

h1429

Livrare 48-72 ore

12,58Lei

PLUMBI ALICE MAVER SUPER SOFT Nr 4 refill

PLUMBI ALICE MAVER SUPER SOFT Nr 4 refill

k615

Livrare 48-72 ore

13,10Lei

PLUTA Maver IT REID 0.10gr

PLUTA Maver IT REID 0.10gr

9096010

Livrare imediată!

17,17Lei

CONECTOR MAVER JUMBO GALBEN

CONECTOR MAVER JUMBO GALBEN

j105

Livrare imediată!

16,15Lei

PLUTA Maver IT ORTONA PORTSTARLITE 3.0gr 4.5mm

PLUTA Maver IT ORTONA PORTSTARLITE 3.0gr 4.5mm

9098300

Livrare 48-72 ore

12,58Lei

GEACA MAVER POLAR MATCH THIS XXXL

GEACA MAVER POLAR MATCH THIS XXXL

n964

Livrare 48-72 ore

372,99Lei(-28%) 267,30Lei

Vartej Maver cu Carabina Rapida si Blocaj Nr.16 10buc/plic

Vartej Maver cu Carabina Rapida si Blocaj Nr.16 10buc/plic

1537016

Livrare 48-72 ore

32,42Lei

FIR MONOFILAMENT MAVER SMART TT 100M 0.10MM

FIR MONOFILAMENT MAVER SMART TT 100M 0.10MM

731010

Livrare 48-72 ore

32,42Lei

FIR MONOFILAMENT MAVER LENZA MADRE 2.0 150M 0.135MM

FIR MONOFILAMENT MAVER LENZA MADRE 2.0 150M 0.135MM

664137

Livrare 48-72 ore

23,27Lei

LANSETA SPINNING Maver IT AREA SPOON 5.9 1.80M 0.3-5GR

LANSETA SPINNING Maver IT AREA SPOON 5.9 1.80M 0.3-5GR

5769001

Livrare 48-72 ore

326,28Lei

Afişare 761 - 780 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: 114.323 ms [By time] [By id] [By file]

1 (0.177)

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

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

2 (0.102)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.130)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Maver'

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

4 (0.122)

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

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

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

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

7 (0.105)

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