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 - cahkbr54

Produse ce potrivesc criteriilor de căutare


Jacheta Prologic Storm Safe Forest Night, Marime 3XL

Jacheta Prologic Storm Safe Forest Night, Marime 3XL

a8.pro.76526
Livrare imediată!

360,97Lei

Pantaloni Prologic Storm Safe Forest Night, Marime 2XL

Pantaloni Prologic Storm Safe Forest Night, Marime 2XL

a8.pro.76530
Livrare imediată!

211,02Lei

Cap Minciog Rive Carp Safe L, 45x35x40cm

Cap Minciog Rive Carp Safe L, 45x35x40cm

50310420121
Livrare imediată!

142,25Lei

PB HIT RUN X-SAFE LEAD CLIPS SILT

PB HIT RUN X-SAFE LEAD CLIPS SILT

pb22101
Livrare imediată!

17,50Lei

Cos Pellet Feeder Guru X-Safe S 28Gr

Cos Pellet Feeder Guru X-Safe S 28Gr

a.gu.glpx
Livrare imediată!

18,04Lei

METHOD FEEDER GURU IN LINE X-SAFE L 45G

METHOD FEEDER GURU IN LINE X-SAFE L 45G

a.gu.glmx45
Livrare imediată!

18,04Lei

Cos Pellet Feeder Guru X-Safe S 24Gr

Cos Pellet Feeder Guru X-Safe S 24Gr

a.gu.gspx
Livrare imediată!

18,04Lei

METHOD FEEDER GURU IN LINE X-SAFE L 28G
Exclusiv online!

METHOD FEEDER GURU IN LINE X-SAFE L 28G

a.gu.glmx
Livrare 24-48 ore

18,04Lei

PB HIT RUN X-SAFE LEAD CLIPS GRAVEL -26%

PB HIT RUN X-SAFE LEAD CLIPS GRAVEL

pb22102
Livrare imediată!

17,50Lei(-26%) 12,90Lei

PB HIT RUN X-SAFE LEAD CLIPS WEED -26%

PB HIT RUN X-SAFE LEAD CLIPS WEED

pb22100
Livrare imediată!

17,50Lei(-26%) 12,90Lei

METHOD FEEDER GURU IN LINE X-SAFE S 24G

METHOD FEEDER GURU IN LINE X-SAFE S 24G

a.gu.gsmx
Livrare imediată!

18,04Lei

MINCIOG JAXON SAFE ALU 300F
Exclusiv online!

MINCIOG JAXON SAFE ALU 300F

pl-axb300f
Livrare 48-72 ore

129,00Lei

CUTIE CARP ZOOM TACKLE SAFE 24x12x3.5cm

CUTIE CARP ZOOM TACKLE SAFE 24x12x3.5cm

cz9699
Livrare imediată!

71,00Lei

CRESTA FEEDER SWIVELS SAFE-BEAD NR. 12 8BUC

CRESTA FEEDER SWIVELS SAFE-BEAD NR. 12 8BUC

004723-00162-00000
Livrare imediată!

11,70Lei

MINCIOG JAXON METAL SAFE 300F PLASA 12MM
Exclusiv online!

MINCIOG JAXON METAL SAFE 300F PLASA 12MM

pl-axmb300f
Livrare 48-72 ore

150,00Lei

METHOD FEEDER GURU IN LINE X-SAFE S 36G

METHOD FEEDER GURU IN LINE X-SAFE S 36G

a.gu.gsmx36
Livrare imediată!

18,04Lei

MINCIOG JAXON METAL SAFE 210F PLASA 12MM
Exclusiv online!

MINCIOG JAXON METAL SAFE 210F PLASA 12MM

pl-axmb210f
Livrare 48-72 ore

129,00Lei

MINCIOG JAXON METAL SAFE T PLASA 30MM 200F
Exclusiv online!

MINCIOG JAXON METAL SAFE T PLASA 30MM 200F

pl-axmt200f
Livrare 48-72 ore

159,00Lei

MINCIOG JAXON SAFE ALU 190F
Exclusiv online!

MINCIOG JAXON SAFE ALU 190F

pl-axb190f
Livrare 48-72 ore

93,00Lei

Cutie Riguri Monturi Korda Leader Safe Large
Exclusiv online!

Cutie Riguri Monturi Korda Leader Safe Large

a4.kbox12
Livrare 24-48 ore

51,07Lei

Afişare 21 - 40 din 114 (6 pagini)
Queries: 11, Total time: 5.754 ms [By time] [By id] [By file]
1 (0.109)
SELECT data
FROM `oc_session`
WHERE session_id = 'cd331c65aa793fd0dd354f01da'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.111)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.127)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (2.904)
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('+safe' 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 (0.127)
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
6 (0.662)
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 20, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.295)
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
8 (0.126)
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
9 (0.078)
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
10 (1.092)
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
11 (0.123)
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