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, telescopica, Baracuda, fibra, sticla, 2706, ,, 2.7m,, 60g,, 7seg, lansete 2706, Lansete Universale, Lansete Universale Baracuda, Baracuda
Lanseta, telescopica, Baracuda, Scorpion, Wildcat, fibra, sticla, 3007,, 3.0m,, 60g,, 7seg, lansete 3007, Lansete Universale, Lansete Universale Baracuda, Baracuda
Lanseta Baracuda Atlas T-Strong Tele, 3.00m, 50-120g, 5seg

Lanseta Baracuda Atlas T-Strong Tele, 3.00m, 50-120g, 5seg

atlas t-strong 300
Livrare imediată!

105,01Lei

Lanseta, Telescopica, FL, Fibra, Sticla, 2.70m,, 30-60g, 1255190105748, Lansete Universale, Lansete Universale FL., FL.
Lanseta FL Eternity Tele Carp 3.30m

Lanseta FL Eternity Tele Carp 3.30m

1133175016459
Stoc epuizat

119,10Lei

Lanseta Telescopica DAM Shadow 2.10m 40-60g

Lanseta Telescopica DAM Shadow 2.10m 40-60g

2040970348
Stoc epuizat

224,56Lei

Y Minciog FL Metal Universal

Y Minciog FL Metal Universal

1255190354726
Stoc epuizat

15,20Lei

Lanseta Telescopica DAM Shadow 2.40m 40-60g

Lanseta Telescopica DAM Shadow 2.40m 40-60g

2040970351
Stoc epuizat

240,93Lei

Lanseta FL Rock Fish Tele Spin 3.00M 40-80G Telescopic

Lanseta FL Rock Fish Tele Spin 3.00M 40-80G Telescopic

8153170637278
Stoc epuizat

103,49Lei

Lanseta Telescopica DAM Shadow 2.70m 40-60g

Lanseta Telescopica DAM Shadow 2.70m 40-60g

2040970354
Stoc epuizat

255,73Lei

Geanta Fox Roaba Barrow Front Bag -37%

Geanta Fox Roaba Barrow Front Bag

clu423
Stoc epuizat

196,77Lei(-37%) 124,59Lei

GEANTA GURU EVA FUSION BAIT PRO

GEANTA GURU EVA FUSION BAIT PRO

a4.gu.glg019
Stoc epuizat

417,98Lei

GEANTA K-KARP EVASION DESK CARRYALL

GEANTA K-KARP EVASION DESK CARRYALL

193-10-130
Stoc epuizat

320,00Lei

Geanta Baracuda B15 accesorii 36x14x26cm -38%

Geanta Baracuda B15 accesorii 36x14x26cm

b15 -geanta
Stoc epuizat

85,89Lei(-38%) 52,99Lei

GEANTA SAVAGE GEAR BIG BAG XL 83L

GEANTA SAVAGE GEAR BIG BAG XL 83L

a8.sg.74255
Stoc epuizat

102,49Lei

Geanta Shimano Tactical Large Carryall -31%

Geanta Shimano Tactical Large Carryall

shtxl02
Stoc epuizat

445,00Lei(-31%) 308,00Lei

Geanta Carp Spirit Accesorii Cu Multiple Compartimente 40x24x32 cm

Geanta Carp Spirit Accesorii Cu Multiple Compartimente 40x24x32 cm

acs070008
Stoc epuizat

518,99Lei

GEANTA GURU FUSION FEEDER BOX

GEANTA GURU FUSION FEEDER BOX

a8.gu.glg033
Stoc epuizat

455,50Lei

Geanta Shimano Tactical Compact Carryall

Geanta Shimano Tactical Compact Carryall

shtxl01
Stoc epuizat

230,00Lei

Geanta Delphin Classa CROSSBODY

Geanta Delphin Classa CROSSBODY

101001519
Stoc epuizat

85,89Lei

Afişare 561 - 580 din 729 (37 pagini)
Queries: 18, Total time: 255.889 ms [By time] [By id] [By file]
1 (0.110)
SELECT data
FROM `oc_session`
WHERE session_id = 'e20f66ee59f9ae96aef362e907'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.115)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.111)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.052)
DROP TEMPORARY TABLE IF EXISTS oc_bf_tmp_product
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:692
5 (242.982)
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 = '3' AND (pd.tag LIKE "%universal%") 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
6 (0.164)
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
7 (3.565)
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 560, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
8 (0.144)
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
9 (0.124)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ROM-EUROTRADE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.124)
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
11 (0.126)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ROM-EUROTRADE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
12 (0.836)
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
13 (0.082)
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
14 (0.174)
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
15 (6.885)
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
16 (0.085)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
17 (0.112)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
18 (0.098)
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