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 - WTF

Produse ce potrivesc criteriilor de căutare


Fir Textil Golden Catch Hooklink G Carp Strong X6, Dark Green, 20lbs, 20m

Fir Textil Golden Catch Hooklink G Carp Strong X6, Dark Green, 20lbs, 20m

gcz-4165206
Livrare imediată!

16,01Lei

Lanseta Bolognesa Kamasaki Rubin Strong, 15-35g, 4m, 4seg
Exclusiv online!

Lanseta Bolognesa Kamasaki Rubin Strong, 15-35g, 4m, 4seg

11063400
Livrare 24-48 ore

144,00Lei

Lanseta Bolognesa Kamasaki Rubin Strong, 15-35g, 5m, 5seg
Exclusiv online!

Lanseta Bolognesa Kamasaki Rubin Strong, 15-35g, 5m, 5seg

11063500
Livrare 24-48 ore

158,00Lei

Lanseta Bolognesa Kamasaki Rubin Strong, 15-35g, 6m, 6seg
Exclusiv online!

Lanseta Bolognesa Kamasaki Rubin Strong, 15-35g, 6m, 6seg

11063600
Livrare 24-48 ore

185,00Lei

Carlige Carp Spirit Continental Xtra Strong, Nr.2, 10buc/pac

Carlige Carp Spirit Continental Xtra Strong, Nr.2, 10buc/pac

acs350082
Livrare imediată!

27,00Lei

Fir, Trabucco, Spinning, Super, Strong, 0.18mm/150m, 053-55-180, Fire Monofilament Rapitori, Fire Monofilament Rapitori Trabucco, Trabucco
Fir Cormoran Textil CoraStrong 8Braid, Green, 018MM/13,2KG/135M

Fir Cormoran Textil CoraStrong 8Braid, Green, 018MM/13,2KG/135M

c.32.8013518
Livrare imediată!

35,14Lei

Scaun, Fotoliu, Carp, Expert, cu, Maner, Extra, Strong, 73701150, Scaune, Scaune Carp Expert, Carp Expert

Scaun, Fotoliu, Carp, Expert, cu, Maner, Extra, Strong, 73701150, Scaune, Scaune Carp Expert, Carp Expert

73701150
Livrare imediată!

559,00Lei

MINCIOG JAXON ALU EXTRA STRONG 55x65CM 300CM 28MM

MINCIOG JAXON ALU EXTRA STRONG 55x65CM 300CM 28MM

pl-agh300
Livrare imediată!

202,00Lei

BUZZ BAR CARP ZOOM STRONG 2 LANSETE 30CM
Exclusiv online!

BUZZ BAR CARP ZOOM STRONG 2 LANSETE 30CM

cz1239
Livrare 48-72 ore

63,00Lei

Ancore Profi Blinker XXX Strong, Red, Nr.2, 5buc/plic

Ancore Profi Blinker XXX Strong, Red, Nr.2, 5buc/plic

70c2
Livrare imediată!

22,90Lei

Fir Toray Super Strong Olive Green 0.210mm

Fir Toray Super Strong Olive Green 0.210mm

602210020
Livrare imediată!

79,63Lei

FIR TEXTIL CORMORAN CORASTRONG VERDE 030MM/21,1KG/135M

FIR TEXTIL CORMORAN CORASTRONG VERDE 030MM/21,1KG/135M

c.32.013530
Livrare imediată!

20,96Lei

BRAT SWINGER NASH STRONG ARM LOADED
Exclusiv online!

BRAT SWINGER NASH STRONG ARM LOADED

t4994
Livrare 7-14 zile

115,99Lei

FIR PVA EXTRA STRONG CARP ZOOM 20m
Exclusiv online!

FIR PVA EXTRA STRONG CARP ZOOM 20m

cz8993
Livrare 48-72 ore

23,00Lei

FIR TEXTIL CORMORAN CORASTRONG VERDE 025MM/14,3KG/135M

FIR TEXTIL CORMORAN CORASTRONG VERDE 025MM/14,3KG/135M

c.32.013525
Livrare imediată!

20,96Lei

FIR TEXTIL CORMORAN CORASTRONG VERDE 028MM/18,2KG/135M

FIR TEXTIL CORMORAN CORASTRONG VERDE 028MM/18,2KG/135M

c.32.013528
Livrare imediată!

20,96Lei

Fir, Toray, Super, Strong, Olive, Green, 0.240mm, 602210021, Fire Monofilament Crap, Fire Monofilament Crap Toray, Toray
Carlige Carp Spirit Continental Xtra Strong, Nr.6, 10buc/pac

Carlige Carp Spirit Continental Xtra Strong, Nr.6, 10buc/pac

acs350084
Livrare imediată!

27,00Lei

Ancore Profi Blinker XXX Strong, Red, Nr.1/0, 5buc/plic
Exclusiv online!

Ancore Profi Blinker XXX Strong, Red, Nr.1/0, 5buc/plic

70c1-0
Livrare 48-72 ore

28,80Lei

Afişare 161 - 180 din 562 (29 pagini)
Queries: 14, Total time: 252.668 ms [By time] [By id] [By file]
1 (0.081)
SELECT data
FROM `oc_session`
WHERE session_id = '5fa56959872b0760a516e71c2a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.078)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.071)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.036)
DROP TEMPORARY TABLE IF EXISTS oc_bf_tmp_product
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:692
5 (237.875)
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 "%strong%") 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.186)
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 (4.195)
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 160, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
8 (0.937)
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.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:1223
10 (0.252)
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 (8.546)
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.099)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.096)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
14 (0.106)
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