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


ROTATIVA JAXON ORION 3PN 6.5GR
Exclusiv online!

ROTATIVA JAXON ORION 3PN 6.5GR

bl-por3pn
Livrare 48-72 ore

21,00Lei

ROTATIVA JAXON ORION 2OR 4.5GR
Exclusiv online!

ROTATIVA JAXON ORION 2OR 4.5GR

bl-por2or
Livrare 48-72 ore

21,00Lei

ROTATIVA JAXON ORION 3PR 6.5GR
Exclusiv online!

ROTATIVA JAXON ORION 3PR 6.5GR

bl-por3pr
Livrare 48-72 ore

21,00Lei

ROTATIVA JAXON ORION 2ON 4.5GR
Exclusiv online!

ROTATIVA JAXON ORION 2ON 4.5GR

bl-por2on
Livrare 48-72 ore

21,00Lei

LINGURITA JAXON OSCILANTA HR ANTIBRADIS ORION 2A 13GR

LINGURITA JAXON OSCILANTA HR ANTIBRADIS ORION 2A 13GR

bw-hjb1a
Livrare imediată!

10,00Lei

LINGURITA JAXON OSCILANTA HR ANTIBRADIS ORION 2B 13GR

LINGURITA JAXON OSCILANTA HR ANTIBRADIS ORION 2B 13GR

bw-hjb1b
Livrare imediată!

10,00Lei

LINGURITA JAXON OSCILANTA HR ANTIBRADIS ORION 2C 13GR

LINGURITA JAXON OSCILANTA HR ANTIBRADIS ORION 2C 13GR

bw-hjb1c
Livrare imediată!

10,00Lei

ROTATIVA JAXON ORION 3ONA 6.5GR
Exclusiv online!

ROTATIVA JAXON ORION 3ONA 6.5GR

bl-por3ona
Livrare 48-72 ore

23,00Lei

LINGURITA JAXON OSCILANTA HR ANTIBRADIS ORION 2E 13GR

LINGURITA JAXON OSCILANTA HR ANTIBRADIS ORION 2E 13GR

bw-hjb1e
Livrare imediată!

10,00Lei

ROTATIVA JAXON ORION 2ONA 4.5GR
Exclusiv online!

ROTATIVA JAXON ORION 2ONA 4.5GR

bl-por2ona
Livrare 48-72 ore

24,00Lei

ROTATIVA JAXON ORION 2OA 4.5GR
Exclusiv online!

ROTATIVA JAXON ORION 2OA 4.5GR

bl-por2oa
Livrare 48-72 ore

21,00Lei

ROTATIVA JAXON ORION 3OA 6.5GR
Exclusiv online!

ROTATIVA JAXON ORION 3OA 6.5GR

bl-por3oa
Livrare 48-72 ore

21,00Lei

LINGURITA JAXON OSCILANTA HR ANTIBRADIS ORION 2D 13GR

LINGURITA JAXON OSCILANTA HR ANTIBRADIS ORION 2D 13GR

bw-hjb1d
Livrare imediată!

10,00Lei

ROTATIVA JAXON ORION 3C 6.5GR
Exclusiv online!

ROTATIVA JAXON ORION 3C 6.5GR

bl-por3c
Livrare 48-72 ore

21,00Lei

ROTATIVA JAXON ORION 3O 6.5GR
Exclusiv online!

ROTATIVA JAXON ORION 3O 6.5GR

bl-por3o
Livrare 48-72 ore

21,00Lei

Mulineta Colmic Orion FD 2000 7+1BB
Exclusiv online!

Mulineta Colmic Orion FD 2000 7+1BB

mulor20
Livrare 48-72 ore

289,00Lei

Mulineta Colmic Orion FD 1000 7+1BB
Exclusiv online!

Mulineta Colmic Orion FD 1000 7+1BB

mulor10
Livrare 48-72 ore

280,00Lei

Mulineta Colmic Orion FD 3000 7+1BB
Exclusiv online!

Mulineta Colmic Orion FD 3000 7+1BB

mulor30
Livrare 48-72 ore

300,00Lei

Mulineta Colmic Orion FD 5000 7+1BB
Exclusiv online!

Mulineta Colmic Orion FD 5000 7+1BB

mulor50
Livrare 48-72 ore

320,00Lei

Mulineta Zfish Orion Reel, 6000

Mulineta Zfish Orion Reel, 6000

zf-6006
Stoc epuizat

199,05Lei

Afişare 21 - 40 din 54 (3 pagini)
Queries: 11, Total time: 3.995 ms [By time] [By id] [By file]
1 (0.121)
SELECT data
FROM `oc_session`
WHERE session_id = '889f30c87a9dcdcf613ee1ba9d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.078)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (1.917)
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 (MATCH(pd.tag) AGAINST('+orion' 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.079)
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.445)
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 20, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.126)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.199)
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.110)
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.101)
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 (0.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:949
11 (0.117)
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