articole de pescuit Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

transport gratuit Transport Gratuit

Comenzile peste 400 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

plata in rate Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

suport Suport 10-18

Suportul telefonic este 10-18. Orice intrebare ai avea, stim ca nu poate astepta. Apeleaza serviciul Suport 10-18! Un consultant asteapta sa iti preia apelul in intervalul orar 10-18 de luni pana vineri.

Vezi mai multe detalii

returnare Returnare simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare - cahkbr54

Produse ce potrivesc criteriilor de căutare


FIR MIMICRY MIRAGE XP 030MM/7,1KG/1000M PRO LOGIC

FIR MIMICRY MIRAGE XP 030MM/7,1KG/1000M PRO LOGIC

a.pro.48434
Livrare imediată!

182,90Lei

FIR MIMICRY MIRAGE XP 033MM/8,3KG/1000M PRO LOGIC
Exclusiv online!

FIR MIMICRY MIRAGE XP 033MM/8,3KG/1000M PRO LOGIC

a.pro.48435
Livrare 24-48 ore

182,90Lei

FIR MIMICRY MIRAGE XP 0.40MM/13,2KG/1000M PRO LOGIC

FIR MIMICRY MIRAGE XP 0.40MM/13,2KG/1000M PRO LOGIC

a.pro.48438
Livrare imediată!

209,01Lei

FIR MIMICRY MIRAGE XP 028MM/6,23KG/1000M PRO LOGIC
Exclusiv online!

FIR MIMICRY MIRAGE XP 028MM/6,23KG/1000M PRO LOGIC

a.pro.48433
Livrare 24-48 ore

156,79Lei

KRUSHER PRO LOGIC BOILIE PELLETS

KRUSHER PRO LOGIC BOILIE PELLETS

a.pro.47338
Livrare imediată!

197,49Lei

FIR MIMICRY MIRAGE XP 025MM/5,2KG/1000M PRO LOGIC

FIR MIMICRY MIRAGE XP 025MM/5,2KG/1000M PRO LOGIC

a.pro.48432
Livrare imediată!

156,79Lei

SUPORT U PRO LOGIC FLEXIBIL DELUXE 2BUC/PLIC

SUPORT U PRO LOGIC FLEXIBIL DELUXE 2BUC/PLIC

a6.pro.37674
Livrare imediată!

39,48Lei

Cutie accesorii Nash Box Logic TT Rig Station & Testing Tank 46cmx30cmx10cm

Cutie accesorii Nash Box Logic TT Rig Station & Testing Tank 46cmx30cmx10cm

t0272
Livrare imediată!

786,00Lei

Cutie NASH Accesorii Box Logic Large Tackle Box 34.5cmx26cmx6cm
Exclusiv online!

Cutie NASH Accesorii Box Logic Large Tackle Box 34.5cmx26cmx6cm

t0271
Livrare 7-14 zile

149,99Lei

Cutie Nash Tackle Box Logic Loaded Medium
Exclusiv online!

Cutie Nash Tackle Box Logic Loaded Medium

t0273
Livrare 7-14 zile

199,99Lei

CUTIE NASH CARLIGE Logic Small -37%

CUTIE NASH CARLIGE Logic Small

t0280
Livrare imediată!

43,99Lei(-37%) 27,88Lei

CUTIE NASH CARLIGE Logic Large -37%

CUTIE NASH CARLIGE Logic Large

t0281
Livrare imediată!

43,99Lei(-37%) 27,88Lei

Cutie NASH Riguri Box Logic Chod m
Exclusiv online!

Cutie NASH Riguri Box Logic Chod m

t0279
Livrare 7-14 zile

77,99Lei

Cutie NASH Accesorii Box Logic Medium Tackle Box 26cm x 20cm x 6cm

Cutie NASH Accesorii Box Logic Medium Tackle Box 26cm x 20cm x 6cm

t0270
Livrare imediată!

97,98Lei

Afişare 1 - 14 din 14 (1 pagini)
Queries: 6, Total time: 2.045 ms [By time] [By id] [By file]
1 (0.175)
SELECT data
FROM `oc_session`
WHERE session_id = '3e1068ebcb9dd905a0b095b519'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.085)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.125)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (1.289)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '3' AND (MATCH(pd.tag) AGAINST('+logic' IN BOOLEAN MODE)) AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:737
5 (0.289)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.082)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38