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


Turbotail Sakura Slash Blade 076 Rudd, 7.5cm, 13.7g
Exclusiv online!

Turbotail Sakura Slash Blade 076 Rudd, 7.5cm, 13.7g

131634saplj500275-076
Livrare 48-72 ore

31,73Lei

Turbotail Sakura Slash Blade 080 Orange Belly, 7.5cm, 13.7g
Exclusiv online!

Turbotail Sakura Slash Blade 080 Orange Belly, 7.5cm, 13.7g

131634saplj500275-080
Livrare 48-72 ore

31,73Lei

Spinnerbait Sakura Cajun 10.5g Hot Chartreuse
Exclusiv online!

Spinnerbait Sakura Cajun 10.5g Hot Chartreuse

130334saplf50043/8-jc8
Livrare 48-72 ore

38,90Lei

Spinnerbait Sakura Cajun 14g Fire Tiger
Exclusiv online!

Spinnerbait Sakura Cajun 14g Fire Tiger

130334saplf50041/2-jc6
Livrare 48-72 ore

38,90Lei

Spinnerbait Sakura Cajun 7g Hot Chartreuse
Exclusiv online!

Spinnerbait Sakura Cajun 7g Hot Chartreuse

130334saplf50041/4-jc8
Livrare 48-72 ore

34,80Lei

Spinnerbait Sakura Cajun Full Gold 14g 11.5cm -28%

Spinnerbait Sakura Cajun Full Gold 14g 11.5cm

130334saplf50041/2-jc4
Livrare imediată!

31,86Lei(-28%) 22,90Lei

Spinnerbait Sakura Cajun June Craw 14g 11.5cm -28%

Spinnerbait Sakura Cajun June Craw 14g 11.5cm

130334saplf50041/2-jc7
Livrare imediată!

37,34Lei(-28%) 26,91Lei

Spinnerbait Sakura Cajun Black Jack 14g 11.5cm -29%

Spinnerbait Sakura Cajun Black Jack 14g 11.5cm

130334saplf50041/2-jc5
Livrare imediată!

42,07Lei(-29%) 29,90Lei

Lanseta Sakura Speciz Spinning SPES 2.74m 14-60g 2seg

Lanseta Sakura Speciz Spinning SPES 2.74m 14-60g 2seg

20434saprj800390-2mhs
Stoc epuizat

466,54Lei

Caciula Sakura Bonnet

Caciula Sakura Bonnet

81134sapch2001-b1
Stoc epuizat

63,09Lei

Jig Streamer Sakura R Bucktail 14gr Red Trauma

Jig Streamer Sakura R Bucktail 14gr Red Trauma

130734saplh500314-rt
Stoc epuizat

32,12Lei

LINGURITA OSCILANTA YARIE 702 PIRICA MORE Y77 SAKURA 1.5G

LINGURITA OSCILANTA YARIE 702 PIRICA MORE Y77 SAKURA 1.5G

y70215y77
Stoc epuizat

25,00Lei

LINGURITA OSCILANTA YARIE 710T T-FRESH EVO Y77 Sakura 1.5G

LINGURITA OSCILANTA YARIE 710T T-FRESH EVO Y77 Sakura 1.5G

y710t15y77
Stoc epuizat

25,00Lei

LINGURITA OSCILANTA YARIE 702 PIRICA MORE Y77 SAKURA 1.8G

LINGURITA OSCILANTA YARIE 702 PIRICA MORE Y77 SAKURA 1.8G

y70218y77
Stoc epuizat

25,00Lei

LINGURITA OSCILANTA YARIE 710T T-FRESH EVO Y77 Sakura 2G

LINGURITA OSCILANTA YARIE 710T T-FRESH EVO Y77 Sakura 2G

y710t20y77
Stoc epuizat

25,00Lei

Jig Sakura cu Paleta Spinhead Gunsmoke, 7gr, Nr.1

Jig Sakura cu Paleta Spinhead Gunsmoke, 7gr, Nr.1

120934sapab00477-gun
Stoc epuizat

9,81Lei

NALUCA SAKURA NOTOBUG 30F 3CM / 3.5GR 05

NALUCA SAKURA NOTOBUG 30F 3CM / 3.5GR 05

saplb50393005
Stoc epuizat

51,32Lei

Lingura Oscilanta 30mm 2.4g Sakura Skoon Fat RL07 Real Life Vairon

Lingura Oscilanta 30mm 2.4g Sakura Skoon Fat RL07 Real Life Vairon

802sapld500430-rl07
Stoc epuizat

20,30Lei

Lingura Rotativa 2 4gr Sakura Imara 06 Black Yellow Dots

Lingura Rotativa 2 4gr Sakura Imara 06 Black Yellow Dots

sapld50062-i06
Stoc epuizat

12,69Lei

Chatterbait Sakura Cajun 10.5gr Kicker White

Chatterbait Sakura Cajun 10.5gr Kicker White

131134saplg50163/8-jc11
Stoc epuizat

32,50Lei

Afişare 261 - 280 din 344 (18 pagini)
Queries: 11, Total time: 14.814 ms [By time] [By id] [By file]
1 (0.160)
SELECT data
FROM `oc_session`
WHERE session_id = '38054cd484ef17a3728525b005'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.084)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (8.582)
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('+sakura' 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.173)
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 (1.522)
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 260, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.136)
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
7 (0.338)
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.109)
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.146)
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 (3.436)
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.128)
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