Climax

Climax

Sortare după:

Fir Textil Climax iBraid Neo X8, Fluo Red, 0.06mm, 3.20kg, 135m

Fir Textil Climax iBraid Neo X8, Fluo Red, 0.06mm, 3.20kg, 135m

9405-10135-006

Livrare imediată!

140,90Lei

FIR TEXTIL CLIMAX CULT FEEDER GRAVILINK 10M CAMOU BROWN 0.16mm 6.2kg

FIR TEXTIL CLIMAX CULT FEEDER GRAVILINK 10M CAMOU BROWN 0.16mm 6.2kg

9920-00012-016

Livrare imediată!

14,90Lei

Fir Textil Climax Cult Feeder Fast Sinking Droplink 10m 0.21mm 10.6kg Dark Grey

Fir Textil Climax Cult Feeder Fast Sinking Droplink 10m 0.21mm 10.6kg Dark Grey

9920-00011-021

Livrare 48-72 ore

15,90Lei

FIR INAINTAS PENTRU STRUNA Climax FLUOROCARBON 10m 5kg

FIR INAINTAS PENTRU STRUNA Climax FLUOROCARBON 10m 5kg

8610-10006-005

Livrare imediată!

30,90Lei

FIR CLIMAX TEXTIL IBRAID DIVE OLIVE GREEN, 0.08mm, 135m

FIR CLIMAX TEXTIL IBRAID DIVE OLIVE GREEN, 0.08mm, 135m

9431-10135-008

Livrare 48-72 ore

113,90Lei

Fir Textil Climax Ibraid Dive Sinking, Fluo Yellow, 135m, 0.18mm, 9.5kg

Fir Textil Climax Ibraid Dive Sinking, Fluo Yellow, 135m, 0.18mm, 9.5kg

9432-10135-018

Livrare imediată!

108,90Lei

Segment Rig CLIMAX Cult Catfish Bungee Elastic Rig Standard, 180kg, 1buc/pac

Segment Rig CLIMAX Cult Catfish Bungee Elastic Rig Standard, 180kg, 1buc/pac

9910-00030-001

Livrare imediată!

81,90Lei

FIR CLIMAX TEXTIL IBRAID DIVE OLIVE GREEN, 0.12mm, 275m

FIR CLIMAX TEXTIL IBRAID DIVE OLIVE GREEN, 0.12mm, 275m

9431-10275-012

Livrare 48-72 ore

185,90Lei

FIR TEXTIL CLIMAX CULT FEEDER BOTTOM BRAID 110M DARK GREY 0.18mm 9.5kg

FIR TEXTIL CLIMAX CULT FEEDER BOTTOM BRAID 110M DARK GREY 0.18mm 9.5kg

9302-10110-018

Livrare imediată!

101,89Lei

Fir Textil Climax iBraid Neo X8, Fluo Chartreuse, 0.08mm, 4.90kg, 135m

Fir Textil Climax iBraid Neo X8, Fluo Chartreuse, 0.08mm, 4.90kg, 135m

9406-10135-008

Livrare imediată!

124,90Lei

Fir Textil Climax iBraid X8 Neo Fluo Chartreuse 135m, 0.18mm, 15.7kg

Fir Textil Climax iBraid X8 Neo Fluo Chartreuse 135m, 0.18mm, 15.7kg

9406-10135-018

Livrare imediată!

101,89Lei

FIR TEXTIL CLIMAX CULT FAST SINKING FEEDER DROPLINK 10M DARK GREY 0.15mm 7.5kg

FIR TEXTIL CLIMAX CULT FAST SINKING FEEDER DROPLINK 10M DARK GREY 0.15mm 7.5kg

9920-00001-015

Livrare imediată!

24,90Lei

Fir Textil Climax Cult Feeder Fast Sinking Droplink 10m 0.09mm 4.1kg Dark Grey

Fir Textil Climax Cult Feeder Fast Sinking Droplink 10m 0.09mm 4.1kg Dark Grey

9920-00011-009

Livrare imediată!

15,90Lei

LEADCORE Climax CULT CRAP 10m 25lb Dark Silt

LEADCORE Climax CULT CRAP 10m 25lb Dark Silt

9900-10014-025

Livrare imediată!

38,90Lei

FIR INAINTAS PENTRU STRUNA Climax HARDMONO ORIGINAL 10m 9.1kg

FIR INAINTAS PENTRU STRUNA Climax HARDMONO ORIGINAL 10m 9.1kg

8610-10007-010

Livrare imediată!

26,90Lei

FIR CLIMAX TEXTIL IBRAID DIVE OLIVE GREEN, 0.18mm, 135m

FIR CLIMAX TEXTIL IBRAID DIVE OLIVE GREEN, 0.18mm, 135m

9431-10135-018

Livrare 48-72 ore

108,90Lei

Montura CLIMAX Catfish Bungee Elastic Rig Complete Soft, Nr.5/0, 1buc/pac

Montura CLIMAX Catfish Bungee Elastic Rig Complete Soft, Nr.5/0, 1buc/pac

9910-00030-005

Livrare imediată!

109,90Lei

FIR CLIMAX TEXTIL IBRAID DIVE FLUO YELLOW, 0.15mm, 275m 7.50 kg

FIR CLIMAX TEXTIL IBRAID DIVE FLUO YELLOW, 0.15mm, 275m 7.50 kg

9432-10275-015

Livrare 48-72 ore

185,90Lei

Fir Textil Climax iBraid Neo X8, Fluo Red, 0.08mm, 4.90kg, 135m

Fir Textil Climax iBraid Neo X8, Fluo Red, 0.08mm, 4.90kg, 135m

9405-10135-008

Livrare imediată!

124,90Lei

FIR TEXTIL CLIMAX CULT FEEDER GRAVILINK 10M CAMOU BROWN 0.19mm 6.9kg

FIR TEXTIL CLIMAX CULT FEEDER GRAVILINK 10M CAMOU BROWN 0.19mm 6.9kg

9920-00012-019

Livrare imediată!

14,90Lei

1
2
3
4
5
6
7
8
9
>
>|

Afişare 1 - 20 din 457 (23 pagini)

💬

WhatsApp Chat

👋 Salut! Cu ce va pot ajuta?

Pot raspunde la intrebari despre:
✅ Comenzi si status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)

Queries: 11, Total time: 75.649 ms [By time] [By id] [By file]

1 (0.136)

SELECT data
FROM `oc_session`
WHERE session_id = '959443ec566314f930ecedfb7e'

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

2 (0.146)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Climax'

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

3 (0.133)

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

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

4 (35.164)

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

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

5 (39.562)

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

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

6 (0.100)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%WATSON AND CO S.R.L.%' AND language_id = '2'

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

7 (0.094)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%WATSON AND CO S.R.L.%' AND language_id = '2'

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

8 (0.084)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%WATSON AND CO S.R.L.%' AND language_id = '2'

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

9 (0.078)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%WATSON AND CO S.R.L.%' AND language_id = '2'

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

10 (0.076)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%WATSON AND CO S.R.L.%' AND language_id = '2'

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

11 (0.076)

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