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


CIZME JAXON PVC WELLINGTONS 45

CIZME JAXON PVC WELLINGTONS 45

ab-sta45
Stoc epuizat

145,00Lei

Ancora Black Cat No.1/0 Treble Hook DG Coating

Ancora Black Cat No.1/0 Treble Hook DG Coating

4551100
Stoc epuizat

44,78Lei

VOBLER SALMO THRILL TH9 HBL, 9CM, 22G

VOBLER SALMO THRILL TH9 HBL, 9CM, 22G

84539575
Stoc epuizat

48,00Lei

VOBLER CORMORAN COR F4 DYING ROACH 5.5CM 4.5G

VOBLER CORMORAN COR F4 DYING ROACH 5.5CM 4.5G

f3.53.04552
Stoc epuizat

28,52Lei

Carlige Maruto 9624-BN Nr 10 10buc/plic

Carlige Maruto 9624-BN Nr 10 10buc/plic

43452010
Stoc epuizat

9,50Lei

Carlig Black Cat No.6/0 Rigging Hook DG Coating

Carlig Black Cat No.6/0 Rigging Hook DG Coating

4552600
Stoc epuizat

40,28Lei

FIR PROLOGIC AKUA GREEN CAMO 30LBS/10M

FIR PROLOGIC AKUA GREEN CAMO 30LBS/10M

a.pro.54459
Stoc epuizat

21,99Lei

Mulineta Delphin ELIXIR 4T 4000

Mulineta Delphin ELIXIR 4T 4000

101001245
Stoc epuizat

81,71Lei

SHAD PONTOON21 PLASTIC AWARUNA 3.5INCH 403

SHAD PONTOON21 PLASTIC AWARUNA 3.5INCH 403

4571115361653
Stoc epuizat

24,00Lei

VOBLER SALMO SLIDER SD6S RSH 6CM/13G

VOBLER SALMO SLIDER SD6S RSH 6CM/13G

84576505
Stoc epuizat

46,01Lei

Lanseta FL Aqua Tele Spin 2.40M 15-45g

Lanseta FL Aqua Tele Spin 2.40M 15-45g

2255198686613
Stoc epuizat

119,90Lei

VOBLER SALMO TINY IT3S HGS, 3CM, 2.5G

VOBLER SALMO TINY IT3S HGS, 3CM, 2.5G

84503533
Stoc epuizat

38,00Lei

Vobler Storm Gomoku Flutter Slim Culoare HGR 4.8cm 2g

Vobler Storm Gomoku Flutter Slim Culoare HGR 4.8cm 2g

gfls45 hgr
Stoc epuizat

22,00Lei

Oscilanta 16gr 45mm DAM Effzett Scales Spoon Silver Silver

Oscilanta 16gr 45mm DAM Effzett Scales Spoon Silver Silver

f.dam.5020016
Stoc epuizat

19,54Lei

VOBLER SALMO RATTLIN STING RS9 TRS 9CM 11G -20%

VOBLER SALMO RATTLIN STING RS9 TRS 9CM 11G

84459083
Stoc epuizat

51,00Lei(-20%) 40,81Lei

Struna din titan Delphin BOMB cu agrafa si agrafa rapida 45cm 17kg

Struna din titan Delphin BOMB cu agrafa si agrafa rapida 45cm 17kg

917401745
Stoc epuizat

46,01Lei

Shad Pontoon21 Plastic Awaruna 3.5inch, 123

Shad Pontoon21 Plastic Awaruna 3.5inch, 123

4571115386052
Stoc epuizat

24,00Lei

Lingura Oscilanta 16gr 45mm DAM Effzett Standard Gold

Lingura Oscilanta 16gr 45mm DAM Effzett Standard Gold

802090030
Stoc epuizat

17,86Lei

SHAD BASS ASSASSIN TURBO SHAD FIRE TIGER 10CM 10BUC/PLIC

SHAD BASS ASSASSIN TURBO SHAD FIRE TIGER 10CM 10BUC/PLIC

091538302452
Stoc epuizat

33,90Lei

Vobler Storm Gomoku Flutter Slim Culoare FT 4.8cm 2g

Vobler Storm Gomoku Flutter Slim Culoare FT 4.8cm 2g

gfls45 ft
Stoc epuizat

22,00Lei

Afişare 4281 - 4300 din 5025 (252 pagini)
Queries: 13, Total time: 687.439 ms [By time] [By id] [By file]
1 (0.149)
SELECT data
FROM `oc_session`
WHERE session_id = '18124e293fc6d25b10f5d4e25c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (615.183)
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 (pd.tag LIKE "%45%") 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.464)
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 (22.055)
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 4280, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.153)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.127)
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
8 (0.127)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (4.259)
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
10 (0.122)
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
11 (0.850)
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
12 (43.625)
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
13 (0.216)
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