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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


Tricou Jackall SQUARE LOGO Negru Marime M

Tricou Jackall SQUARE LOGO Negru Marime M

ja.807176612
Stoc epuizat

301,97Lei

Hanorac Lucky John Hoodie Marime XXL

Hanorac Lucky John Hoodie Marime XXL

am-8001-05xxl
Stoc epuizat

178,00Lei

Cizme Fox Camo neopren marime 43 -20%

Cizme Fox Camo neopren marime 43

cfw128
Stoc epuizat

313,07Lei(-20%) 250,46Lei

Bluza Lucky John Norfin Pro Marime S

Bluza Lucky John Norfin Pro Marime S

am-7001-01s
Stoc epuizat

127,00Lei

Hanorac Nash Lightweight Hoody, Marime XL

Hanorac Nash Lightweight Hoody, Marime XL

c5693
Stoc epuizat

245,98Lei

PANTALONI FOX LW BLACK/CAMO PRINT JOGGERS MARIME XXL

PANTALONI FOX LW BLACK/CAMO PRINT JOGGERS MARIME XXL

cfx144
Stoc epuizat

134,10Lei

Tricou Nash Elasta-Breathe T-Shirt Black Sleeves Marime XXXL

Tricou Nash Elasta-Breathe T-Shirt Black Sleeves Marime XXXL

c5725
Stoc epuizat

105,99Lei

PANTALONI SHORT NASH Cargo Shorts Marime XL

PANTALONI SHORT NASH Cargo Shorts Marime XL

c5613
Stoc epuizat

195,01Lei

PANTALON BLASER CHARGER HOSE MARIME 48

PANTALON BLASER CHARGER HOSE MARIME 48

bl.121010.140.48
Stoc epuizat

1.215,09Lei

Tricou Nash Elasta-Breathe T-Shirt Black Marime XL

Tricou Nash Elasta-Breathe T-Shirt Black Marime XL

c5733
Stoc epuizat

115,89Lei

PANTALONI SHORT NASH Cargo Shorts Marime XXL

PANTALONI SHORT NASH Cargo Shorts Marime XXL

c5614
Stoc epuizat

175,99Lei

Tricou Nash Elasta-Breathe T-Shirt Large Print Marime S

Tricou Nash Elasta-Breathe T-Shirt Large Print Marime S

c5710
Stoc epuizat

115,89Lei

Hanorac Delphin CATCH ME Kapor Marime XXL

Hanorac Delphin CATCH ME Kapor Marime XXL

101000639
Stoc epuizat

200,00Lei

Hanorac Delphin CATCH ME Kapor Marime XXXL

Hanorac Delphin CATCH ME Kapor Marime XXXL

101000640
Stoc epuizat

200,00Lei

Manusi Savage Gear All Weather Marime XL

Manusi Savage Gear All Weather Marime XL

a8.sg.76458
Stoc epuizat

88,49Lei

Cizme Fox Rage Neoprene Boots size 11 Marime 45

Cizme Fox Rage Neoprene Boots size 11 Marime 45

nfw017
Stoc epuizat

337,46Lei

CIORAPI KORDA CAMO MARIME 41-44

CIORAPI KORDA CAMO MARIME 41-44

a8.kcl241
Stoc epuizat

176,52Lei

Hanorac Delphin CATCH ME Kapor Marime XL

Hanorac Delphin CATCH ME Kapor Marime XL

101000638
Stoc epuizat

200,00Lei

Papuci Delphin OCTO Albastru Marime 37

Papuci Delphin OCTO Albastru Marime 37

101002461
Stoc epuizat

61,00Lei

Cizme Fox Camo neopren marime 42 -20%

Cizme Fox Camo neopren marime 42

cfw127
Stoc epuizat

313,07Lei(-20%) 250,46Lei

Afişare 2681 - 2700 din 4136 (207 pagini)
Queries: 8, Total time: 108.769 ms [By time] [By id] [By file]
1 (0.176)
SELECT data
FROM `oc_session`
WHERE session_id = 'e7e6d9dd7ed3c8fc07e3f2d3ff'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.124)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.141)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (91.265)
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('+marime' 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 (16.663)
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 2680, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.136)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.126)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.138)
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