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


Rotativa Kamasaki Spinner 010 Nr.1 3.6g

Rotativa Kamasaki Spinner 010 Nr.1 3.6g

87197010
Livrare imediată!

5,28Lei

MULINETA KAMASAKI SUPER FD1000

MULINETA KAMASAKI SUPER FD1000

20102100
Livrare imediată!

43,79Lei

MULINETA KAMASAKI SUPER FD2000

MULINETA KAMASAKI SUPER FD2000

20102200
Livrare imediată!

52,00Lei

Mulineta Kamasaki Bologneza Super Bolo RD100

Mulineta Kamasaki Bologneza Super Bolo RD100

20441010
Livrare imediată!

42,00Lei

FIR TEXTIL DYNEEMAX KAMASAKI FORFAC 0.10MM 10M

FIR TEXTIL DYNEEMAX KAMASAKI FORFAC 0.10MM 10M

34020010
Livrare imediată!

9,50Lei

Banda Fixare Kamasaki Lansete Pentru Transport Latime 25mm 2buc

Banda Fixare Kamasaki Lansete Pentru Transport Latime 25mm 2buc

71031010
Livrare imediată!

7,00Lei

CUTIE KAMASAKI SUPERBOX 1007 13x6.5x3CM

CUTIE KAMASAKI SUPERBOX 1007 13x6.5x3CM

75010007
Livrare imediată!

6,70Lei

Cutie, Kamasaki, Superbox, M0310A, 11.8x7.5x2.5cm, 75010298, Cutii, Cutii Kamasaki, Kamasaki
Exclusiv online!

Cutie, Kamasaki, Superbox, M0310A, 11.8x7.5x2.5cm, 75010298, Cutii, Cutii Kamasaki, Kamasaki

75010298
Livrare 24-48 ore

6,70Lei

Cutie Kamasaki Superbox M0309 15x8x3cm

Cutie Kamasaki Superbox M0309 15x8x3cm

75010309
Livrare imediată!

8,20Lei

Set inele varf Kamasaki OSEG 5-25 55 BUC

Set inele varf Kamasaki OSEG 5-25 55 BUC

82970010
Livrare imediată!

70,00Lei

Minciog, Cauciucat, Kamasaki, Super, Compact, 1.90m, 55x60x40cm, , , , , 71010195, Mincioguri Complete Crap, Mincioguri Complete Crap Kamasaki, Mincioguri Complete Feeder, Mincioguri Complete Feeder Kamasaki, Kamasaki
CUTIE KAMASAKI SUPERBOX 1011 17x8.5x3CM

CUTIE KAMASAKI SUPERBOX 1011 17x8.5x3CM

75010011
Livrare imediată!

9,50Lei

Cutie Kamasaki Superbox M0310B 11.8x7.5x2.5cm

Cutie Kamasaki Superbox M0310B 11.8x7.5x2.5cm

75010299
Livrare imediată!

6,70Lei

CARLIGE, LEGATE, KAMASAKI, K807G, NR, 01, 45401001, Carlige Legate Stationar, Carlige Legate Stationar Kamasaki, Kamasaki
Exclusiv online!

CARLIGE, LEGATE, KAMASAKI, K807G, NR, 01, 45401001, Carlige Legate Stationar, Carlige Legate Stationar Kamasaki, Kamasaki

45401001
Livrare 24-48 ore

7,50Lei

CARLIGE, LEGATE, KAMASAKI, K807G, NR, 2, 45401002, Carlige Legate Stationar, Carlige Legate Stationar Kamasaki, Kamasaki
Exclusiv online!

CARLIGE, LEGATE, KAMASAKI, K807G, NR, 2, 45401002, Carlige Legate Stationar, Carlige Legate Stationar Kamasaki, Kamasaki

45401002
Livrare 24-48 ore

8,00Lei

MINCIOG KAMASAKI SUPER ALU 190CM

MINCIOG KAMASAKI SUPER ALU 190CM

71010190
Livrare imediată!

53,00Lei

CARLIGE LEGATE KAMASAKI K807G NR 04
Exclusiv online!

CARLIGE LEGATE KAMASAKI K807G NR 04

45401004
Livrare 24-48 ore

10,00Lei

CARLIGE LEGATE KAMASAKI K807BN NR 1/0
Exclusiv online!

CARLIGE LEGATE KAMASAKI K807BN NR 1/0

45400100
Livrare 24-48 ore

7,50Lei

CARLIGE, LEGATE, KAMASAKI, K807G, NR, 08, 45401008, Carlige Legate Stationar, Carlige Legate Stationar Kamasaki, Kamasaki
CARLIGE, LEGATE, KAMASAKI, K807G, NR, 06, 45401006, Carlige Legate Stationar, Carlige Legate Stationar Kamasaki, Kamasaki
Exclusiv online!

CARLIGE, LEGATE, KAMASAKI, K807G, NR, 06, 45401006, Carlige Legate Stationar, Carlige Legate Stationar Kamasaki, Kamasaki

45401006
Livrare 24-48 ore

10,00Lei

Afişare 1 - 20 din 36 (2 pagini)
Queries: 11, Total time: 7.176 ms [By time] [By id] [By file]
1 (0.124)
SELECT data
FROM `oc_session`
WHERE session_id = '68d7254a748f2729023edc2281'
/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:427
3 (5.237)
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, if (SUM(if((f.filter_group = "m0" AND filter_id IN (188)), 1, 0)) > 0, 1, 0) 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 p.manufacturer_id = '188' AND (pd.tag LIKE "%010%") 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:698
4 (0.095)
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 (0.442)
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 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.197)
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:1209
7 (0.132)
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:1231
8 (0.104)
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:996
9 (0.512)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS tp
INNER JOIN `oc_bf_filter` AS f ON (f.product_id = tp.product_id)
WHERE f.language_id = '2' AND tp.match_filters < 1 AND f.filter_group IN ('m0') GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:910
10 (0.160)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS tp
INNER JOIN `oc_bf_filter` AS f ON (f.product_id = tp.product_id)
WHERE f.language_id = '2' AND tp.match_filters < 1 AND f.filter_group IN ('m0') GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:950
11 (0.089)
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