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


MANUSI SAVAGE GEAR NEOPREN CU DEGETE TAIATE BLACK MAR.M

MANUSI SAVAGE GEAR NEOPREN CU DEGETE TAIATE BLACK MAR.M

a8.sg.76462
Stoc epuizat

66,47Lei

JACHETA BLASER KOMBI JOGI MAR.2XL

JACHETA BLASER KOMBI JOGI MAR.2XL

bl.121047.008.2xl
Stoc epuizat

809,19Lei

JACHETA BLASER FLEECE JONATHAN MAR.2XL

JACHETA BLASER FLEECE JONATHAN MAR.2XL

bl.121045.008.2xl
Stoc epuizat

756,94Lei

TRICOU KORDA LIGHT KAMO, MAR.S

TRICOU KORDA LIGHT KAMO, MAR.S

a8.kcl352
Stoc epuizat

148,65Lei

TRICOU KORDA LOYAL MAR.M

TRICOU KORDA LOYAL MAR.M

a8.kcl553
Stoc epuizat

130,10Lei

TRICOU KORDA LIGHT KAMO MAR.L

TRICOU KORDA LIGHT KAMO MAR.L

a8.kcl354
Livrare imediată!

148,65Lei

JACHETA BLASER LEECE KUNO MAR.L

JACHETA BLASER LEECE KUNO MAR.L

bl.121048.112.l
Stoc epuizat

602,98Lei

MANUSI PROLOGIC WINTER IMPERMEABILE GREEN/BLACK MAR.M

MANUSI PROLOGIC WINTER IMPERMEABILE GREEN/BLACK MAR.M

a8.pro.76652
Stoc epuizat

114,93Lei

JACHETA BLASER FLEECE JONATHAN MAR.L

JACHETA BLASER FLEECE JONATHAN MAR.L

bl.121045.008.l
Stoc epuizat

756,94Lei

MANUSI PROLOGIC WINTER IMPERMEABILE GREEN/BLACK MAR.XL

MANUSI PROLOGIC WINTER IMPERMEABILE GREEN/BLACK MAR.XL

a8.pro.76654
Stoc epuizat

114,93Lei

HANORAC DAIWA D-VEC NEGRU MAR.L

HANORAC DAIWA D-VEC NEGRU MAR.L

d.18295.830
Stoc epuizat

259,87Lei

JACHETA KORDA KORE THERMOLITE OLIVE, MAR.XXL

JACHETA KORDA KORE THERMOLITE OLIVE, MAR.XXL

a8.kcl464
Stoc epuizat

708,79Lei

PANTALON SCURT BLASER SUMMER BRUCE MARO MAR.58

PANTALON SCURT BLASER SUMMER BRUCE MARO MAR.58

bl.121022.113.58
Stoc epuizat

406,80Lei

JACHETA KORDA KORE THERMOLITE OLIVE, MAR.XL

JACHETA KORDA KORE THERMOLITE OLIVE, MAR.XL

a8.kcl463
Stoc epuizat

599,47Lei

MANUSI SAVAGE GEAR MARINE CU DEGETE TAIATE SEA BLUE MAR.XL

MANUSI SAVAGE GEAR MARINE CU DEGETE TAIATE SEA BLUE MAR.XL

a8.sg.76482
Stoc epuizat

48,50Lei

MANUSI SAVAGE GEAR THERMO PRO GREY/BLACK MAR.XL

MANUSI SAVAGE GEAR THERMO PRO GREY/BLACK MAR.XL

a8.sg.76470
Stoc epuizat

112,59Lei

CAMASA BLASER AIRFLOW DARK OLIVE MAR.3XL

CAMASA BLASER AIRFLOW DARK OLIVE MAR.3XL

bl.122013.087.3xl
Stoc epuizat

416,32Lei

PANTALONI JACKALL SOFTSHELL BLACK MAR.XL

PANTALONI JACKALL SOFTSHELL BLACK MAR.XL

ja.807204445
Stoc epuizat

647,90Lei

PANTALON VERNEY-CARRON SUPER GROUSE KAKI MAR.52

PANTALON VERNEY-CARRON SUPER GROUSE KAKI MAR.52

lvc.phpn010.48
Stoc epuizat

327,56Lei

TRICOU FOX RAGE LIMITED EDITION PERCH T-SHIRT BLACK MAR S -30%

TRICOU FOX RAGE LIMITED EDITION PERCH T-SHIRT BLACK MAR S

npr392
Stoc epuizat

139,96Lei(-30%) 97,97Lei

Afişare 421 - 440 din 571 (29 pagini)
Queries: 6, Total time: 17.052 ms [By time] [By id] [By file]
1 (0.118)
SELECT data
FROM `oc_session`
WHERE session_id = '63cb9829c93412cc0744e21800'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.096)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (14.206)
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('+mar' 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 (2.418)
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 420, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.112)
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