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


Agrafe Spro Freestyle Fluorocarbon Snaps Stainless Steel, 3.5mm/7.3mm, 10buc/plic

Agrafe Spro Freestyle Fluorocarbon Snaps Stainless Steel, 3.5mm/7.3mm, 10buc/plic

004590-00027-00000
Livrare imediată!

12,60Lei

Broasca Live Target Freestyle Frog, Albino / White, 9cm, 2buc/pac
Exclusiv online!

Broasca Live Target Freestyle Frog, Albino / White, 9cm, 2buc/pac

f1.lt.fsf90t516
Livrare 24-48 ore

42,88Lei

Broasca Live Target Freestyle Frog, Emerald / Brown, 7.5cm, 2buc/pac
Exclusiv online!

Broasca Live Target Freestyle Frog, Emerald / Brown, 7.5cm, 2buc/pac

f1.lt.fsf75t514
Livrare 24-48 ore

42,88Lei

Broasca Live Target Freestyle Frog, Fire Tip Orange, 9cm, 2buc/pac
Exclusiv online!

Broasca Live Target Freestyle Frog, Fire Tip Orange, 9cm, 2buc/pac

f1.lt.fsf90t524
Livrare 24-48 ore

42,88Lei

Broasca Live Target Freestyle Frog, Green / Yellow, 7.5cm, 2buc/pac
Exclusiv online!

Broasca Live Target Freestyle Frog, Green / Yellow, 7.5cm, 2buc/pac

f1.lt.fsf75t500
Livrare 24-48 ore

42,88Lei

Broasca Live Target Freestyle Frog, Green / Yellow, 9cm, 2buc/pac
Exclusiv online!

Broasca Live Target Freestyle Frog, Green / Yellow, 9cm, 2buc/pac

f1.lt.fsf90t500
Livrare 24-48 ore

42,88Lei

Broasca Live Target Freestyle Frog, Pearlescent / Brown, 9cm, 2buc/pac
Exclusiv online!

Broasca Live Target Freestyle Frog, Pearlescent / Brown, 9cm, 2buc/pac

f1.lt.fsf90t523
Livrare 24-48 ore

42,88Lei

Borseta Spro Freestyle Chest Pouch 07, 30x12x4cm

Borseta Spro Freestyle Chest Pouch 07, 30x12x4cm

006205-01900-00000
Livrare imediată!

179,00Lei

Broasca Live Target Freestyle Frog, Tan / Brown 9cm, 2buc/pac
Exclusiv online!

Broasca Live Target Freestyle Frog, Tan / Brown 9cm, 2buc/pac

f1.lt.fsf90t502
Livrare 24-48 ore

42,88Lei

Agrafa, Spro, Freestyle, Fluorocarbon, Snaps, 4mm,, 12kg,, 10buc/plic, 004590-00024-00000, Agrafe Rapitor, Agrafe Rapitor Spro, Agrafe Spro, Rapitor Spro, Spro
Caciula de Iarna Spro FreeStyle, Neagra, Marime Universala

Caciula de Iarna Spro FreeStyle, Neagra, Marime Universala

007020-00065-00000
Livrare imediată!

48,00Lei

Agrafa Spro Freestyle Fluorocarbon Snaps, 4.5mm, 14kg, 10buc/plic
Exclusiv online!

Agrafa Spro Freestyle Fluorocarbon Snaps, 4.5mm, 14kg, 10buc/plic

004590-00025-00000
Livrare 48-72 ore

5,00Lei

Agrafe Spro Freestyle Fluorocarbon Snaps Stainless Steel, 3mm/6.75mm, 10buc/plic

Agrafe Spro Freestyle Fluorocarbon Snaps Stainless Steel, 3mm/6.75mm, 10buc/plic

004590-00026-00000
Livrare imediată!

12,60Lei

Lanseta Spro Freestyle Litz Dropshot, 2.10m, 18g, 2 Tronsoane

Lanseta Spro Freestyle Litz Dropshot, 2.10m, 18g, 2 Tronsoane

002109-00212-00000
Livrare imediată!

239,80Lei

Ruleta Spro Freestyle Service Ruler 100cm

Ruleta Spro Freestyle Service Ruler 100cm

004702-00314-00000
Livrare imediată!

45,01Lei

GEANTA FREESTYLE CU 2 COMPARTIMENTE  19X13X4 CM

GEANTA FREESTYLE CU 2 COMPARTIMENTE  19X13X4 CM

006205-00600-00000
Livrare imediată!

109,00Lei

LANSETA SPRO FREESTYLE SOLIDZ 1.80 TITAN X 15 GR
Exclusiv online!

LANSETA SPRO FREESTYLE SOLIDZ 1.80 TITAN X 15 GR

002929-00184-00000
Livrare 48-72 ore

348,00Lei

GEANTA SPRO FREESTYLE SHOULDER 2 CUTII TWISTERE INCLUSE 25X11X27CM
Exclusiv online!

GEANTA SPRO FREESTYLE SHOULDER 2 CUTII TWISTERE INCLUSE 25X11X27CM

006205-00300-00000
Livrare 48-72ore

188,00Lei

Mulineta, Spro, FreeStyle, Skillz, Pepper, 1000, 001323-00101-00000, Mulinete Rapitori, Mulinete Rapitori Spro, Spro
Exclusiv online!

Mulineta, Spro, FreeStyle, Skillz, Pepper, 1000, 001323-00101-00000, Mulinete Rapitori, Mulinete Rapitori Spro, Spro

001323-00101-00000
Livrare 48-72 ore

298,00Lei

SUPORT SPRO FREESTYLE PTR PLUMB DROPSHOT BLACK 1 BUC

SUPORT SPRO FREESTYLE PTR PLUMB DROPSHOT BLACK 1 BUC

004702-00306-00000-1
Livrare imediată!

10,90Lei

Afişare 41 - 60 din 162 (9 pagini)
Queries: 19, Total time: 219.326 ms [By time] [By id] [By file]
1 (0.086)
SELECT data
FROM `oc_session`
WHERE session_id = '11eaeef2d5b35e3033d49c5a33'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.082)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.261)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC
/var/www/clients/client1/web1/web/system/library/tax.php:32
4 (0.247)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC
/var/www/clients/client1/web1/web/system/library/tax.php:60
5 (0.071)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
6 (0.036)
DROP TEMPORARY TABLE IF EXISTS oc_bf_tmp_product
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:692
7 (214.726)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%freestyle%") 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:693
8 (0.229)
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:1547
9 (0.956)
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 40, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
10 (0.131)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
11 (0.233)
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:1204
12 (0.074)
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:1223
13 (0.079)
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:978
14 (1.702)
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:900
15 (0.085)
SELECT *
FROM oc_layout_module
WHERE layout_id = '13' AND position = 'column_right'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:28
16 (0.061)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
17 (0.118)
SELECT *
FROM oc_layout_module
WHERE layout_id = '13' AND position = 'content_bottom'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:28
18 (0.076)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
19 (0.073)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:32