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 - Extra Carp

Produse ce potrivesc criteriilor de căutare


Forfac Boilie Carp Academy Blowout Rig nr.2

Forfac Boilie Carp Academy Blowout Rig nr.2

8101-202
Livrare imediată!

7,00Lei

Forfac Feeder Cu Fir Textil Nevis cu Carlig nr.12 15LBS

Forfac Feeder Cu Fir Textil Nevis cu Carlig nr.12 15LBS

8103-312
Livrare imediată!

12,10Lei

Fir Textil Dyneemax Kamasaki Forfac 0.30mm 10m

Fir Textil Dyneemax Kamasaki Forfac 0.30mm 10m

34020030
Livrare imediată!

9,50Lei

Forfac Feeder Cu Fir Textil Nevis cu Carlig nr.6 15LBS

Forfac Feeder Cu Fir Textil Nevis cu Carlig nr.6 15LBS

8103-306
Livrare imediată!

12,10Lei

Forfac Feeder Cu Fir Textil Nevis cu Carlig nr.10 15LBS

Forfac Feeder Cu Fir Textil Nevis cu Carlig nr.10 15LBS

8103-310
Livrare imediată!

12,10Lei

Geanta Koos Forface Cu Pungi 35x25x7cm
Exclusiv online!

Geanta Koos Forface Cu Pungi 35x25x7cm

80303350
Livrare 24-48 ore

123,00Lei

Forfac Boilie Strategy Rig Shot On The Pod Nr.6
Exclusiv online!

Forfac Boilie Strategy Rig Shot On The Pod Nr.6

8517-006
Livrare 48-72 ore

10,81Lei

Forfac Black Cat de Sacrificiu Breaking Line 0.30mm
Exclusiv online!

Forfac Black Cat de Sacrificiu Breaking Line 0.30mm

4282030
Livrare 7-14 zile

8,78Lei

Forfac Boilie Strategy Rig Shot On The Pod Nr.10
Exclusiv online!

Forfac Boilie Strategy Rig Shot On The Pod Nr.10

8517-010
Livrare 48-72 ore

10,81Lei

Penar Riguri Carp Expert Original Forfac
Exclusiv online!

Penar Riguri Carp Expert Original Forfac

80302305
Livrare 24-48 ore

63,00Lei

Forfac Boilie Strategy Rig Shot On The Pod Nr.8
Exclusiv online!

Forfac Boilie Strategy Rig Shot On The Pod Nr.8

8517-008
Livrare 48-72 ore

10,81Lei

Forfac Boilie Strategy Special Snag 25lb Nr.8 Barbless

Forfac Boilie Strategy Special Snag 25lb Nr.8 Barbless

8540-208
Livrare imediată!

11,80Lei

Forfac Strategy A1 Specialist Fuzz Weed Rig 15Lbs Nr8
Exclusiv online!

Forfac Strategy A1 Specialist Fuzz Weed Rig 15Lbs Nr8

8535-008
Livrare 48-72 ore

12,70Lei

Forfac, Boilie, Carp, Academy, Hair, Rig, Aligner, nr.6, 8101-706, Monturi Crap, Monturi Crap Carp Academy, Carp Academy
Fir Textil Mivardi Forfac 20cm 20lbs
Exclusiv online!

Fir Textil Mivardi Forfac 20cm 20lbs

m-acrlharb
Livrare 48-72 ore

31,00Lei

Forfac Boilie Carp Academy Hook Link Rig nr.2
Exclusiv online!

Forfac Boilie Carp Academy Hook Link Rig nr.2

8101-602
Livrare 48-72 ore

7,00Lei

Forfac Boilie Carp Academy Superior Rig nr.2

Forfac Boilie Carp Academy Superior Rig nr.2

8101-302
Livrare imediată!

7,00Lei

Forfac Boilie Carp Academy Carp Rig Nr.8 Carlig Teflonat

Forfac Boilie Carp Academy Carp Rig Nr.8 Carlig Teflonat

8104-108
Livrare imediată!

6,00Lei

FIR FORFAC FARA CAMASA EXTRA CARP SCUFANDATOR 35LB/20M/15.90KG

FIR FORFAC FARA CAMASA EXTRA CARP SCUFANDATOR 35LB/20M/15.90KG

ec9962
Livrare imediată!

20,00Lei

FIR DE FORFAC FOX ILLUSION TRANS KAKI SOFT 16lb/0.35mm x 50m

FIR DE FORFAC FOX ILLUSION TRANS KAKI SOFT 16lb/0.35mm x 50m

cac606
Stoc epuizat

53,95Lei

Afişare 41 - 60 din 70 (4 pagini)
Queries: 13, Total time: 213.694 ms [By time] [By id] [By file]
1 (0.359)
SELECT data
FROM `oc_session`
WHERE session_id = 'cd257cdeef37af68c40d743dfb'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.384)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.337)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (210.384)
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 "%forfac%") 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:697
5 (0.156)
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 (0.524)
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 40, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
7 (0.246)
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
8 (0.114)
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
9 (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:982
10 (0.739)
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:904
11 (0.112)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
12 (0.111)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.124)
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