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


Clonc DAM Madcat Klong Black Pastila 45mm

Clonc DAM Madcat Klong Black Pastila 45mm

a.mad.8421002
Livrare imediată!

112,09Lei

Dus Portabil pentru Camping Coghlans C9965
Exclusiv online!

Dus Portabil pentru Camping Coghlans C9965

c9965
Livrare 24-48 ore

112,00Lei

Filtru pentru Apa Sawyer Mini, Portocaliu
Exclusiv online!

Filtru pentru Apa Sawyer Mini, Portocaliu

sp103
Livrare 24-48 ore

199,00Lei

Foarfeca Dubla Cresta Pentru Rame -28%

Foarfeca Dubla Cresta Pentru Rame

004720-03000-00000
Livrare imediată!

73,90Lei(-28%) 52,90Lei

Fox Cookware Coffee Makers 450ml, 9cups

Fox Cookware Coffee Makers 450ml, 9cups

ccw030
Livrare imediată!

107,96Lei

Set Cordeline Elastice de Tensionare Bushmen Orange
Exclusiv online!

Set Cordeline Elastice de Tensionare Bushmen Orange

5902194521420
Livrare 24-48 ore

35,00Lei

Set Muste Shakespeare Sigma Fly Selection No5 Stillwater -25%

Set Muste Shakespeare Sigma Fly Selection No5 Stillwater

1155011
Livrare imediată!

46,70Lei(-25%) 35,00Lei

Set Muste Shakespeare Sigma Fly Selection No7 Buzzers -23%

Set Muste Shakespeare Sigma Fly Selection No7 Buzzers

1155015
Livrare imediată!

46,70Lei(-23%) 35,90Lei

Unealta Multifunctionala Skateboarding Kershaw KickFlip
Exclusiv online!

Unealta Multifunctionala Skateboarding Kershaw KickFlip

kssk8tool
Livrare 24-48 ore

99,00Lei

Wc Ridge Mokey CoZee Toilet Seat Full Kit Bundle, 42x30x27cm -10%

Wc Ridge Mokey CoZee Toilet Seat Full Kit Bundle, 42x30x27cm

rm595
Livrare imediată!

359,95Lei(-10%) 323,97Lei

Clipsuri Tip Ancora C2070 Coghlans
Exclusiv online!

Clipsuri Tip Ancora C2070 Coghlans

c2070
Livrare 24-48 ore

45,01Lei

Filtru Apa pentru Robinet Sawyer
Exclusiv online!

Filtru Apa pentru Robinet Sawyer

sp134
Livrare 24-48 ore

379,00Lei

Indicator de Semnalizare Stonfo din Spuma, Marime 2

Indicator de Semnalizare Stonfo din Spuma, Marime 2

8028651016845
Livrare imediată!

28,00Lei

Placheta pentru Muste Stonfo Fly
Exclusiv online!

Placheta pentru Muste Stonfo Fly

8028651013844
Livrare 48-72 ore

34,00Lei

PLIORI FISH PRO PLASTIC CM 24
Exclusiv online!

PLIORI FISH PRO PLASTIC CM 24

fp-pli-24
Livrare 48-72 ore

2,00Lei

Prosop Brau Colmic Cu Curea
Exclusiv online!

Prosop Brau Colmic Cu Curea

ashb002
Livrare 48-72 ore

204,00Lei

Set Muste Shakespeare Sigma Dry Flies -25%

Set Muste Shakespeare Sigma Dry Flies

1155005
Livrare imediată!

46,70Lei(-25%) 35,00Lei

Set Muste Shakespeare Sigma Fly Selection No2 Classic Wets

Set Muste Shakespeare Sigma Fly Selection No2 Classic Wets

1155007
Livrare imediată!

46,70Lei

Set Pungi Resigilabile Coghlans
Exclusiv online!

Set Pungi Resigilabile Coghlans

c2235
Livrare 24-48 ore

73,99Lei

Tub Pentru Plute H614, 6.5x30cm
Exclusiv online!

Tub Pentru Plute H614, 6.5x30cm

uac-h614
Livrare 48-72 ore

18,00Lei

Afişare 501 - 520 din 863 (44 pagini)
Queries: 10, Total time: 27.394 ms [By time] [By id] [By file]
1 (0.073)
SELECT data
FROM `oc_session`
WHERE session_id = '9d6dd49594f5140b0e899020d2'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.122)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (17.740)
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('+diverse' 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.199)
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 (3.578)
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 500, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.939)
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
7 (0.120)
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
8 (0.226)
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
9 (4.276)
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
10 (0.121)
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