Claumar

Claumar

Sortare după:

Boilies Claumar Fishmeal De Carlig Solubile Squid Pruna 100gr

Boilies Claumar Fishmeal De Carlig Solubile Squid Pruna 100gr

clm90636

Livrare imediată!

12,90Lei(-54%) 5,91Lei

Aditiv Claumar 500gr Miere

Aditiv Claumar 500gr Miere

clm121

Livrare imediată!

24,90Lei

Fir Monofilament Claumar Super Long Cast Yellow Fluo 0.25mm 9.02Kg 300M

Fir Monofilament Claumar Super Long Cast Yellow Fluo 0.25mm 9.02Kg 300M

clm235022

Livrare imediată!

27,90Lei

Carlige Claumar Curve Shank Teflon Technology Nr 4 10Buc/Plic

Carlige Claumar Curve Shank Teflon Technology Nr 4 10Buc/Plic

clm237262-243

Livrare imediată!

15,90Lei

Mamaliga Claumar Patratica 100gr Taiata 10mm PORUMB DULCE

Mamaliga Claumar Patratica 100gr Taiata 10mm PORUMB DULCE

clm206541

Livrare imediată!

6,50Lei

Mamaliga Proaspata Folie Canepa Claumar 1kg

Mamaliga Proaspata Folie Canepa Claumar 1kg

clm215352

Livrare imediată!

11,50Lei

Fir Textil Claumar Pescar 8X Super Braid Strong 20M 15.0Kg 0.14MM

Fir Textil Claumar Pescar 8X Super Braid Strong 20M 15.0Kg 0.14MM

clm238825

Livrare imediată!

14,90Lei

Boilies Claumar Fishmeal Tare Frankfurter 16mm 1Kg

Boilies Claumar Fishmeal Tare Frankfurter 16mm 1Kg

clm236630

Livrare imediată!

59,00Lei(-49%) 29,90Lei

Tub Siliconic Pentru Carlig Claumar 1 Metru 1.2mm

Tub Siliconic Pentru Carlig Claumar 1 Metru 1.2mm

clm239174

Livrare imediată!

5,90Lei

Fir Textil Claumar Pescar SPIN 12X Super Braid Strong 137M 23.00Kg 0.18MM

Fir Textil Claumar Pescar SPIN 12X Super Braid Strong 137M 23.00Kg 0.18MM

clm239341

Livrare imediată!

67,91Lei

Fir Textil Cu Camasa Claumar Medusa 10 Metrii 15 LB

Fir Textil Cu Camasa Claumar Medusa 10 Metrii 15 LB

clm239501

Livrare imediată!

28,89Lei

Vartej Rapid Claumar Speed Swivel SA Nr 8 10Buc/Plic

Vartej Rapid Claumar Speed Swivel SA Nr 8 10Buc/Plic

clm239013

Livrare imediată!

10,90Lei

Sac Ecologic Cu Catarama Claumar Pentru Pastrarea Crapului 130x150

Sac Ecologic Cu Catarama Claumar Pentru Pastrarea Crapului 130x150

clm64-9839

Livrare imediată!

59,00Lei

Hanorac Claumar pentru Copii, 138cm

Hanorac Claumar pentru Copii, 138cm

hanorac-138cm

Livrare imediată!

196,60Lei(-18%) 160,92Lei

Bluza UV Claumar, Marime 3XL

Bluza UV Claumar, Marime 3XL

hanorac-uv-clm-3xl

Livrare imediată!

139,90Lei(-18%) 114,80Lei

Pop Up Claumar Forte Squid & Octopus Color Mix 15Gr 8mm

Pop Up Claumar Forte Squid & Octopus Color Mix 15Gr 8mm

clm264930

Livrare imediată!

16,00Lei

Dip Fluorescent Claumar Nuclear Frankfurter 50ml

Dip Fluorescent Claumar Nuclear Frankfurter 50ml

clm218599

Livrare imediată!

20,00Lei(-36%) 12,90Lei

Tehnoplancton CLAUMAR Fumix Nuclear Usturoi, 120g, 3buc/pac

Tehnoplancton CLAUMAR Fumix Nuclear Usturoi, 120g, 3buc/pac

clm218216

Livrare imediată!

20,00Lei(-65%) 6,90Lei

Porumb Uscat Claumar 1Kg

Porumb Uscat Claumar 1Kg

clm6425898205117

Livrare imediată!

4,00Lei

Momitor Method Claumar Pellet RIVER XL 80Gr

Momitor Method Claumar Pellet RIVER XL 80Gr

clm230119

Livrare imediată!

11,89Lei(-34%) 7,90Lei

Afişare 281 - 300 din 826 (42 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: 84.793 ms [By time] [By id] [By file]

1 (0.157)

SELECT data
FROM `oc_session`
WHERE session_id = '47d2a813a242727f0a01372826'

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

2 (0.111)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.151)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Claumar'

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

4 (0.136)

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

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

5 (37.244)

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

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

6 (46.896)

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 = '26' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 280,20

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

7 (0.098)

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