Trakko


Scaun Pescar Trakko tr201043c

Scaun Pescar Trakko tr201043c

tr201043c
Livrare imediată!

707,68Lei

WAFTERS TRAKKO ESENTIAL ORANGE CHOCOLATE MIX2X2 6mm

WAFTERS TRAKKO ESENTIAL ORANGE CHOCOLATE MIX2X2 6mm

gi84206123
Livrare imediată!

18,22Lei

Coada de Minciog Trakko Method Put Over 3.00m, 290g, 3seg

Coada de Minciog Trakko Method Put Over 3.00m, 290g, 3seg

trpo3003
Livrare 48-72 ore

118,85Lei

Carlige TRAKKO Super Carp, Nr.1/0, 10buc/pac

Carlige TRAKKO Super Carp, Nr.1/0, 10buc/pac

040-08-100
Livrare 48-72 ore

8,91Lei

PLUMB CU TUB ANTITANGLE 40 GR

PLUMB CU TUB ANTITANGLE 40 GR

010-011-40
Livrare 48-72 ore

3,94Lei

Momitor Method Feeder Trakko Flat Feeder Mini + Antitangle, 20g

Momitor Method Feeder Trakko Flat Feeder Mini + Antitangle, 20g

5025m20
Livrare 48-72 ore

28,35Lei

Fir Textil TRAKKO Dyneema, Green, 100m, 0.10mm, 6.50kg

Fir Textil TRAKKO Dyneema, Green, 100m, 0.10mm, 6.50kg

gv010-mm
Livrare 48-72 ore

38,90Lei

POP-UP TRAKKO ESENTIAL PINEAPPLE N-BUTYRIC MIX3 6mm

POP-UP TRAKKO ESENTIAL PINEAPPLE N-BUTYRIC MIX3 6mm

gi82106123
Livrare imediată!

15,16Lei

Momitor Culisant Trakko 4 Ribbed Pellet Feeder cu Tub Antitangle, 60g

Momitor Culisant Trakko 4 Ribbed Pellet Feeder cu Tub Antitangle, 60g

5013060
Livrare imediată!

12,69Lei

Carlige TRAKKO Seamaster Cutting Blade, Nr.8, 10buc/pac

Carlige TRAKKO Seamaster Cutting Blade, Nr.8, 10buc/pac

040-37-008
Livrare 48-72 ore

7,90Lei

POP-UP TRAKKO ESENTIAL MANGO N-BUTYRIC DUMBLE MIX2X3 6+8mm

POP-UP TRAKKO ESENTIAL MANGO N-BUTYRIC DUMBLE MIX2X3 6+8mm

gi82268123
Livrare imediată!

16,17Lei

VARGA TRAKKO LAKE FLOAT 4.00M 4SEG

VARGA TRAKKO LAKE FLOAT 4.00M 4SEG

pl503vtlf4
Livrare 48-72 ore

51,74Lei

Carlige TRAKKO Cutting Blade, Nr.1, 10buc/pac

Carlige TRAKKO Cutting Blade, Nr.1, 10buc/pac

040-35-001
Livrare 48-72 ore

7,90Lei

STRUNA TRAKKO TITAN 1X7 30CM-7KG

STRUNA TRAKKO TITAN 1X7 30CM-7KG

trak.titan 15lbs
Livrare imediată!

24,28Lei

Carlige TRAKKO Cutting Blade Point Profi, Nr.2, 10buc/pac

Carlige TRAKKO Cutting Blade Point Profi, Nr.2, 10buc/pac

040-04-002
Livrare 48-72 ore

4,90Lei

Momitor Method Feeder Trakko Flat Feeder + Antitangle, 30g

Momitor Method Feeder Trakko Flat Feeder + Antitangle, 30g

5025030
Livrare 48-72 ore

28,86Lei

Carlige TRAKKO Seamaster Tri Blade, Nr.8, 10buc/pac

Carlige TRAKKO Seamaster Tri Blade, Nr.8, 10buc/pac

040-38-008
Livrare 48-72 ore

9,90Lei

POP-UP TRAKKO ESENTIAL CORN CLASIC DUMBLE MIX3 8-10mm dumble

POP-UP TRAKKO ESENTIAL CORN CLASIC DUMBLE MIX3 8-10mm dumble

gi82180123
Livrare imediată!

12,71Lei

PAT PESCAR TRAKKO XL CU 8 PICIOARE -18%

PAT PESCAR TRAKKO XL CU 8 PICIOARE

tr202057
Livrare 48-72 ore

990,00Lei(-18%) 814,34Lei

Carlige TRAKKO Seamaster Cutting Blade, Nr.1, 10buc/pac

Carlige TRAKKO Seamaster Cutting Blade, Nr.1, 10buc/pac

040-37-001
Livrare 48-72 ore

7,90Lei

Afişare 1 - 20 din 215 (11 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: 71.002 ms [By time] [By id] [By file]
1 (0.092)
SELECT data
FROM `oc_session`
WHERE session_id = '87b481c76c6072ffea553f2210'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.115)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.140)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Trakko'
/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 = '109' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (29.106)
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 = '3' AND p.manufacturer_id = '109'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (41.274)
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 = '3' AND p.manufacturer_id = '109' 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:440
7 (0.139)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37