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


Lanseta Bolognesa Mifine Sport Tib 6 M -14%

Lanseta Bolognesa Mifine Sport Tib 6 M

10321-600
Livrare imediată!

210,00Lei(-14%) 179,90Lei

Lanseta Bolognesa Mifine Sport Tib 5 M

Lanseta Bolognesa Mifine Sport Tib 5 M

10321-500
Livrare imediată!

174,89Lei

Prastie Sport Konger Universal L, Nr.10

Prastie Sport Konger Universal L, Nr.10

42306950000010
Livrare imediată!

51,50Lei

Prastie Sport Konger Universal, Nr.7

Prastie Sport Konger Universal, Nr.7

42306950000007
Livrare imediată!

73,28Lei

Prastie Sport Konger Universal S, Nr.11

Prastie Sport Konger Universal S, Nr.11

42306950000011
Livrare imediată!

54,03Lei

Prastie Sport Konge, Nr.6

Prastie Sport Konge, Nr.6

42306950000006
Livrare imediată!

69,28Lei

Prastie Sport Konge, Nr.9

Prastie Sport Konge, Nr.9

42306950000009
Livrare imediată!

54,03Lei

Ochelari De Soare Polaroid PLD 8411 9CA RC Rubber, 63mm, Black Sport -13%

Ochelari De Soare Polaroid PLD 8411 9CA RC Rubber, 63mm, Black Sport

4942106
Livrare imediată!

195,40Lei(-13%) 169,90Lei

Pantofi Casual CoolFit Savage Gear Marimea 43 -23%

Pantofi Casual CoolFit Savage Gear Marimea 43

a8.sg.51147
Livrare imediată!

206,07Lei(-23%) 158,90Lei

Pantofi Casual CoolFit Savage Gear Marime 42 -23%

Pantofi Casual CoolFit Savage Gear Marime 42

a8.sg.51146
Livrare imediată!

206,07Lei(-23%) 158,90Lei

Pantofi Casual CoolFit Savage Gear Marimea 44 -23%

Pantofi Casual CoolFit Savage Gear Marimea 44

a8.sg.51148
Livrare imediată!

206,07Lei(-23%) 158,90Lei

Pantofi Casual CoolFit Savage Gear Marimea 45
Exclusiv online!

Pantofi Casual CoolFit Savage Gear Marimea 45

a8.sg.51149
Livrare 24-48 ore

206,07Lei

Ochelari de soare polarizati Delphin SG Sport

Ochelari de soare polarizati Delphin SG Sport

920121220
Livrare imediată!

75,01Lei

CUTIT UMAREX WALTHER ALPINA SPORT MANER NEGRU

CUTIT UMAREX WALTHER ALPINA SPORT MANER NEGRU

vu.5.0998.2
Livrare imediată!

39,23Lei

OCHELARI POLARIZATI MUSTAD RAMA SPORT LENTILA GRI
Exclusiv online!

OCHELARI POLARIZATI MUSTAD RAMA SPORT LENTILA GRI

a8.mhp101a.02
Livrare 24-48 ore

121,42Lei

Tenisi Navitas Lo Down Lace Up, Marime 41 -22%

Tenisi Navitas Lo Down Lace Up, Marime 41

ntxa4949-41
Livrare imediată!

178,90Lei(-22%) 139,90Lei

Pantofi Savage Sport Gear Sneakers MAR. 44 -50%

Pantofi Savage Sport Gear Sneakers MAR. 44

a8.sg.62318
Livrare imediată!

373,05Lei(-50%) 186,53Lei

Pantofi Savage Sport Gear Sneakers MAR. 45 -50%
Exclusiv online!

Pantofi Savage Sport Gear Sneakers MAR. 45

a8.sg.62319
Livrare 24-48 ore

361,75Lei(-50%) 180,88Lei

Ochelari Mustad Polarizati Sport Lentila Maro
Exclusiv online!

Ochelari Mustad Polarizati Sport Lentila Maro

a8.mhp101a.03
Livrare 24-48 ore

121,42Lei

Pantofi Sport Okuma Light, Marime 44
Exclusiv online!

Pantofi Sport Okuma Light, Marime 44

a8.okr.h001k.44
Livrare 24-48 ore

138,39Lei

Afişare 1 - 20 din 65 (4 pagini)
Queries: 9, Total time: 4.601 ms [By time] [By id] [By file]
1 (0.117)
SELECT data
FROM `oc_session`
WHERE session_id = 'a3e2b9a35166ba8b52190040b8'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.083)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (2.572)
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('+sport' 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 (0.089)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
5 (0.330)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1248
6 (0.107)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1270
7 (0.100)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1035
8 (1.089)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:949
9 (0.114)
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