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


Swinger Carp Academy V-Head Albastru

Swinger Carp Academy V-Head Albastru

6363-403
Livrare imediată!

55,13Lei

Swinger Carp Academy Endless Galben

Swinger Carp Academy Endless Galben

6363-204
Livrare imediată!

75,60Lei

CROSETA LEADCORE CARP ACADEMY SPLICE NEEDLE

CROSETA LEADCORE CARP ACADEMY SPLICE NEEDLE

8100-208
Livrare imediată!

6,00Lei

Buzzbar Carp Academy 2 Posturi 30cm

Buzzbar Carp Academy 2 Posturi 30cm

6227-600
Livrare imediată!

24,80Lei

Swinger Carp Academy Mojo Rosu

Swinger Carp Academy Mojo Rosu

6363-102
Livrare imediată!

76,30Lei

Buzzbar Carp Academy 3 Posturi 30cm

Buzzbar Carp Academy 3 Posturi 30cm

6227-608
Livrare imediată!

24,80Lei

Swinger Carp Academy V-Head Verde -28%

Swinger Carp Academy V-Head Verde

6363-401
Livrare imediată!

85,00Lei(-28%) 60,90Lei

Tub Silicon Carp Academy 0.5mm

Tub Silicon Carp Academy 0.5mm

8100-251
Livrare imediată!

7,10Lei

Swinger Carp Academy V-Head Rosu -28%

Swinger Carp Academy V-Head Rosu

6363-402
Livrare imediată!

85,00Lei(-28%) 60,90Lei

Spuma flotanta Carp Academy 6mm

Spuma flotanta Carp Academy 6mm

8100-162
Livrare imediată!

9,70Lei

Spuma flotanta Carp Academy 8mm

Spuma flotanta Carp Academy 8mm

8100-167
Livrare imediată!

9,70Lei

INDICATOR CARP ACADEMY LINE BITER 2BUC/PLIC
Exclusiv online!

INDICATOR CARP ACADEMY LINE BITER 2BUC/PLIC

8100-196
Livrare 48-72 ore

17,50Lei

Tub Silicon Carp Academy 0.3mm

Tub Silicon Carp Academy 0.3mm

8100-250
Livrare imediată!

7,10Lei

Tub Silicon Carp Academy 1mm

Tub Silicon Carp Academy 1mm

8100-253
Livrare imediată!

7,50Lei

Tub Silicon Carp Academy 0.75mm

Tub Silicon Carp Academy 0.75mm

8100-252
Livrare imediată!

7,10Lei

Cap Suport Carp Academy Lanseta Cu Siguranta

Cap Suport Carp Academy Lanseta Cu Siguranta

8100-106
Livrare imediată!

21,00Lei

SWINGER CARP ACADEMY THUNDER

SWINGER CARP ACADEMY THUNDER

6362-001
Livrare imediată!

18,00Lei

Croseta Carp Academy Boilies Fluorescent -10%

Croseta Carp Academy Boilies Fluorescent

8100-238
Livrare imediată!

7,20Lei(-10%) 6,50Lei

Rod Pod Carp Academy Deluxe
Exclusiv online!

Rod Pod Carp Academy Deluxe

6133-002
Livrare 48-72 ore

660,00Lei

Pichet Carp Academy EX Strong, 70-120cm
Exclusiv online!

Pichet Carp Academy EX Strong, 70-120cm

6129-110
Livrare 48-72 ore

32,50Lei

Afişare 301 - 320 din 451 (23 pagini)
Queries: 5, Total time: 20.769 ms [By time] [By id] [By file]
1 (0.148)
SELECT data
FROM `oc_session`
WHERE session_id = '54e0bef7b45f6751bd2c42bc28'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.093)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (17.175)
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 = '2' AND (MATCH(pd.tag) AGAINST('+academy' 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 (3.222)
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 300, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.131)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38