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


Lanseta Shakespeare Oracle 2 River Fly 2.59m, Clasa 4, 4seg

Lanseta Shakespeare Oracle 2 River Fly 2.59m, Clasa 4, 4seg

1542597
Stoc epuizat

337,46Lei

Vobler DUO Realis Jerkbait 100 SP 10cm 14.5g GPA4009 River Bait

Vobler DUO Realis Jerkbait 100 SP 10cm 14.5g GPA4009 River Bait

4525918130381
Stoc epuizat

72,00Lei

Set Varfuri Trabucco Precision RPL River Feeder 3.60m

Set Varfuri Trabucco Precision RPL River Feeder 3.60m

152-36-360-r01
Stoc epuizat

75,01Lei

Tava Laterala Rive D36, XXL, 67x51cm

Tava Laterala Rive D36, XXL, 67x51cm

90810103028
Stoc epuizat

651,77Lei

Geanta Rive Pentru Tava Laterala Desserte XXL 2020, 90x67cm

Geanta Rive Pentru Tava Laterala Desserte XXL 2020, 90x67cm

90410370105
Stoc epuizat

354,99Lei

Lanseta Okuma Custom Black River Feeder 13' 390cm 180g 3seg

Lanseta Okuma Custom Black River Feeder 13' 390cm 180g 3seg

cb-f-1303xxh
Stoc epuizat

476,10Lei

Rotativa Zebco Waterwings River Spinner Silver 8.0g

Rotativa Zebco Waterwings River Spinner Silver 8.0g

803173329204
Livrare imediată!

13,28Lei

Cosulet Filfishing Lex River Camo, 120g

Cosulet Filfishing Lex River Camo, 120g

fil2991
Stoc epuizat

11,00Lei

Bac Nada Rive EVA Patrat, Capac Transparent, Size S,18x18x10cm

Bac Nada Rive EVA Patrat, Capac Transparent, Size S,18x18x10cm

90410370341
Stoc epuizat

109,47Lei

Cosulet Filfishing Lex River Camo, 60g

Cosulet Filfishing Lex River Camo, 60g

fil2823
Stoc epuizat

7,50Lei

Cosulet Filfishing Lex River Camo, 80g

Cosulet Filfishing Lex River Camo, 80g

fil2847
Stoc epuizat

9,31Lei

Cosulet Filfishing Lex River Camo, 90g

Cosulet Filfishing Lex River Camo, 90g

fil2854
Stoc epuizat

9,50Lei

Juvelnic Rive Competitie International 4.00m

Juvelnic Rive Competitie International 4.00m

50510430241
Stoc epuizat

730,03Lei

Cosulet Filfishing Lex River Camo, 100g

Cosulet Filfishing Lex River Camo, 100g

fil2984
Stoc epuizat

10,00Lei

Cosulet Filfishing Lex River Camo, 40g

Cosulet Filfishing Lex River Camo, 40g

fil2809
Stoc epuizat

6,30Lei

Lanseta Shakespeare Oracle 2 River Fly 2.13m, Clasa 4, 4seg

Lanseta Shakespeare Oracle 2 River Fly 2.13m, Clasa 4, 4seg

1542594
Stoc epuizat

314,96Lei

Mulineta Quantum Drive, DR05

Mulineta Quantum Drive, DR05

0370005
Stoc epuizat

108,77Lei

Cosulet Filfishing Lex River Camo, 50g

Cosulet Filfishing Lex River Camo, 50g

fil2816
Stoc epuizat

6,90Lei

Cosulet Filfishing Lex River Camo, 60g

Cosulet Filfishing Lex River Camo, 60g

fil2830
Stoc epuizat

8,29Lei

Pichet Maver UK POWER DRIVE DINSMORES 125cm

Pichet Maver UK POWER DRIVE DINSMORES 125cm

k855
Stoc epuizat

79,00Lei

Afişare 581 - 600 din 602 (31 pagini)
Queries: 14, Total time: 308.931 ms [By time] [By id] [By file]
1 (0.098)
SELECT data
FROM `oc_session`
WHERE session_id = '340aa434b7e4e92e48453101ea'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.104)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.114)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (299.311)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%rive%") 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:693
5 (0.178)
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:1547
6 (2.595)
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 580, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
7 (0.096)
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
8 (0.634)
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:1204
9 (0.112)
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:1223
10 (0.184)
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:978
11 (5.172)
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:900
12 (0.112)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.105)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
14 (0.116)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38