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

Produse ce potrivesc criteriilor de căutare


Manusi Fox Camo masura XL -30%

Manusi Fox Camo masura XL

cfx127
Stoc epuizat

111,78Lei(-30%) 78,00Lei

LANSETA FOX RAGE Predator Elite Pro Boat XS 10ft, 3.5lb, 2seg

LANSETA FOX RAGE Predator Elite Pro Boat XS 10ft, 3.5lb, 2seg

frd012
Stoc epuizat

764,96Lei

Swimbait Fox Rage GIANT PIKE REPLICANT 32cm 240g Super Natural Hot Pike
Papuci Fox Sliders Black marime 44 -40%

Papuci Fox Sliders Black marime 44

cfw135
Stoc epuizat

103,49Lei(-40%) 62,00Lei

GEANTA FOX AQUAS CAMOLITE 50L

GEANTA FOX AQUAS CAMOLITE 50L

cev004
Stoc epuizat

322,00Lei

GEANTA FOX AQUAS CAMOLITE 40L

GEANTA FOX AQUAS CAMOLITE 40L

cev003
Stoc epuizat

292,45Lei

Costum termic Fox Rage Base Layer Marime S

Costum termic Fox Rage Base Layer Marime S

npr373
Stoc epuizat

202,45Lei

Papuci Fox Flip Flops Marime 44 -40%

Papuci Fox Flip Flops Marime 44

cfw141
Stoc epuizat

134,96Lei(-40%) 80,98Lei

Costum termic Fox Rage Base Layer Marime XXXXL

Costum termic Fox Rage Base Layer Marime XXXXL

npr379
Stoc epuizat

202,45Lei

Cizme-sold Fox Rage Breathable Lightweight Chest Waders Nr.46

Cizme-sold Fox Rage Breathable Lightweight Chest Waders Nr.46

nfw006
Stoc epuizat

967,46Lei

Costum termic Fox Rage Base Layer Marime XL

Costum termic Fox Rage Base Layer Marime XL

npr376
Stoc epuizat

202,45Lei

Pichet FOX Black Label Bankstick 36 Quick Release Powerpoint 91.44cm

Pichet FOX Black Label Bankstick 36 Quick Release Powerpoint 91.44cm

cbs057
Stoc epuizat

179,96Lei

Papuci Fox Flip Flops Marime 46 -40%

Papuci Fox Flip Flops Marime 46

cfw143
Stoc epuizat

134,96Lei(-40%) 80,98Lei

Geanta Impermeabila Fox Cool Bags 15tr, 38x25x29.5cm

Geanta Impermeabila Fox Cool Bags 15tr, 38x25x29.5cm

cev024
Stoc epuizat

472,47Lei

Papuci Fox Flip Flops Marime 45 -40%

Papuci Fox Flip Flops Marime 45

cfw142
Stoc epuizat

134,96Lei(-40%) 80,98Lei

Costum termic Fox Rage Base Layer Marime XXXL

Costum termic Fox Rage Base Layer Marime XXXL

npr378
Stoc epuizat

202,45Lei

STATIE FOX MINIMICORN X LIMITED EDITION CAMO

STATIE FOX MINIMICORN X LIMITED EDITION CAMO

cei216
Stoc epuizat

382,45Lei

Papuci Fox Flip Flops Marime 41 -40%

Papuci Fox Flip Flops Marime 41

cfw138
Stoc epuizat

134,96Lei(-40%) 80,98Lei

Cizme sold Fox Rage Neoprene Waders 8 Marime 42

Cizme sold Fox Rage Neoprene Waders 8 Marime 42

nfw008
Stoc epuizat

584,96Lei

Swimbait Fox Rage GIANT PIKE REPLICANT 32cm 240g Super Natural Pike

Swimbait Fox Rage GIANT PIKE REPLICANT 32cm 240g Super Natural Pike

nre064
Stoc epuizat

94,46Lei

Afişare 2521 - 2540 din 2725 (137 pagini)
Queries: 5, Total time: 75.302 ms [By time] [By id] [By file]
1 (0.132)
SELECT data
FROM `oc_session`
WHERE session_id = '177fea9d3944930ad5ff03cdc5'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.146)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (64.354)
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 = '2' AND (MATCH(pd.tag) AGAINST('+fox' 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
4 (10.520)
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 2520, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.150)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38