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

Oferte speciale


Set Cutii Jaxon Riguri Accesorii Crap 35x19x6cm -20%

Set Cutii Jaxon Riguri Accesorii Crap 35x19x6cm

rh-322
Livrare imediată!

169,00Lei(-20%) 135,90Lei

Set Deeper Sonar Smart Pro+2 + Suport Flexibil -48%

Set Deeper Sonar Smart Pro+2 + Suport Flexibil

dp.itgam1080.set
Livrare imediată!

2.860,00Lei(-48%) 1.479,99Lei

Set Delphin Diver 9v 3 Plus Statie -36%

Set Delphin Diver 9v 3 Plus Statie

900022501
Livrare imediată!

507,00Lei(-36%) 327,00Lei

Set Linguri Oscilante Abu Garcia 100 Years Model 1 -72%

Set Linguri Oscilante Abu Garcia 100 Years Model 1

1543405
Livrare imediată!

129,00Lei(-72%) 35,52Lei

Set Linguri Oscilante Abu Garcia 100 Years Model 2 -72%

Set Linguri Oscilante Abu Garcia 100 Years Model 2

1546767
Livrare imediată!

129,00Lei(-72%) 35,52Lei

Set Linguri Oscilante Cormoran Toro Ul Trout Spoon Set 1 -30%
Exclusiv online!

Set Linguri Oscilante Cormoran Toro Ul Trout Spoon Set 1

f.50.88901
Livrare 24-48 ore

103,83Lei(-30%) 72,69Lei

Set Linguri Oscilante Cormoran Toro Ul Trout Spoon Set 2 -30%
Exclusiv online!

Set Linguri Oscilante Cormoran Toro Ul Trout Spoon Set 2

f.50.88902
Livrare 24-48 ore

102,65Lei(-30%) 71,86Lei

Set Linguri Oscilante Cormoran Toro Ul Trout Spoon Set 3 -20%
Exclusiv online!

Set Linguri Oscilante Cormoran Toro Ul Trout Spoon Set 3

f.50.88903
Livrare 24-48 ore

98,00Lei(-20%) 78,40Lei

Set Linguri Oscilante Cormoran Toro Ul Trout Spoon Set 4 -30%
Exclusiv online!

Set Linguri Oscilante Cormoran Toro Ul Trout Spoon Set 4

f.50.88904
Livrare 24-48 ore

100,07Lei(-30%) 70,04Lei

Set Linguri Oscilante Cormoran Toro Ul Trout Spoon Set 5 -30%
Exclusiv online!

Set Linguri Oscilante Cormoran Toro Ul Trout Spoon Set 5

f.50.88905
Livrare 24-48 ore

100,07Lei(-30%) 70,04Lei

Set Matrita Jaxon Momitor Middy Shot Gun 20gr -25%
Exclusiv online!

Set Matrita Jaxon Momitor Middy Shot Gun 20gr

am-2497
Livrare 48-72 ore

65,00Lei(-25%) 48,80Lei

Set Method Feeder Cormoran 2 Buc/set (20g) -24%

Set Method Feeder Cormoran 2 Buc/set (20g)

a.49.67020
Livrare imediată!

19,69Lei(-24%) 14,90Lei

Set Method Feeder Cormoran 30g, 2 Buc/set -27%

Set Method Feeder Cormoran 30g, 2 Buc/set

a.49.67030
Livrare imediată!

21,90Lei(-27%) 15,90Lei

Set Minciog Ngt Combo Specimen 100x100x100 + Maner 1.80m Carbon -26%

Set Minciog Ngt Combo Specimen 100x100x100 + Maner 1.80m Carbon

ngt-fnh-combo-net42-handle-stk
Livrare imediată!

189,00Lei(-26%) 140,00Lei

Set Momitor Drennan In-line Plus Presa Drennan Small 25g -15%

Set Momitor Drennan In-line Plus Presa Drennan Small 25g

tfffsb25
Livrare imediată!

27,00Lei(-15%) 22,96Lei

Set Momitor Method Team Feeder Vario 45gr 2 Plus 1 -20%

Set Momitor Method Team Feeder Vario 45gr 2 Plus 1

7341-245
Livrare imediată!

50,00Lei(-20%) 40,00Lei

Set Momitor Method Team Feeder Vario 65gr 2 Plus 1 -33%

Set Momitor Method Team Feeder Vario 65gr 2 Plus 1

7341-265
Livrare imediată!

66,00Lei(-33%) 43,92Lei

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 3 Round Stillwater -27%

Set Muste Shakespeare Sigma Fly Selection 3 Round Stillwater

1155008
Livrare imediată!

46,70Lei(-27%) 34,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

Afişare 7641 - 7660 din 9601 (481 pagini)
Queries: 22, Total time: 253.005 ms [By time] [By id] [By file]
1 (0.082)
SELECT data
FROM `oc_session`
WHERE session_id = '76b597e689bd79a9f1cb638fa5'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.084)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.100)
SELECT *
FROM `oc_language`
WHERE status = '1'
/var/www/clients/client1/web1/web/index.php:313
4 (0.078)
SELECT *
FROM oc_currency
/var/www/clients/client1/web1/web/system/library/currency.php:17
5 (0.248)
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
6 (0.235)
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
7 (0.116)
SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'
/var/www/clients/client1/web1/web/system/library/weight.php:12
8 (0.111)
SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'
/var/www/clients/client1/web1/web/system/library/length.php:12
9 (0.078)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:414
10 (118.909)
SELECT COUNT(1) AS total
FROM oc_product_special ps
LEFT JOIN oc_product p ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) AND p.quantity > '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1665
11 (131.958)
SELECT DISTINCT ps.product_id
FROM oc_product_special ps
LEFT JOIN oc_product p ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p.quantity > '0' AND p.date_available <= NOW() AND p2s.store_id = '3' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) GROUP BY ps.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 7640,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:580
12 (0.121)
SELECT layout_id
FROM oc_layout_route
WHERE 'product/special' LIKE route AND store_id = '3'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:4
13 (0.095)
SELECT *
FROM oc_layout_module
WHERE layout_id = '16' AND position = 'column_left'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:14
14 (0.092)
SELECT layout_id
FROM oc_layout_route
WHERE 'product/special' LIKE route AND store_id = '3'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:4
15 (0.086)
SELECT *
FROM oc_layout_module
WHERE layout_id = '16' AND position = 'column_right'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:14
16 (0.088)
SELECT layout_id
FROM oc_layout_route
WHERE 'product/special' LIKE route AND store_id = '3'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:4
17 (0.093)
SELECT *
FROM oc_layout_module
WHERE layout_id = '16' AND position = 'content_top'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:14
18 (0.077)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
19 (0.090)
SELECT layout_id
FROM oc_layout_route
WHERE 'product/special' LIKE route AND store_id = '3'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:4
20 (0.086)
SELECT *
FROM oc_layout_module
WHERE layout_id = '16' AND position = 'content_bottom'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:14
21 (0.081)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
22 (0.097)
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