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


Grub Fox Rage Pro, Super Natural Roach, 12cm, 1buc/plic

Grub Fox Rage Pro, Super Natural Roach, 12cm, 1buc/plic

npg097
Stoc epuizat

9,41Lei

Grub Fox Rage Pro, UV Fire Tiger, 16cm, 1buc/plic

Grub Fox Rage Pro, UV Fire Tiger, 16cm, 1buc/plic

npg102
Stoc epuizat

16,87Lei

Hanorac FOX RAGE Pro Series Technical Hoody, Marime XL

Hanorac FOX RAGE Pro Series Technical Hoody, Marime XL

npr594
Stoc epuizat

292,45Lei

Kit Opritoare Prologic Boilies Black

Kit Opritoare Prologic Boilies Black

a.pro.49953
Stoc epuizat

9,48Lei

Lanseta Hardy Zane Pro Fly Rod Zpro 10 Line, 2.74m, 4seg

Lanseta Hardy Zane Pro Fly Rod Zpro 10 Line, 2.74m, 4seg

1511817
Stoc epuizat

4.658,45Lei

Lanseta Hardy Zane Pro Fly Rod Zpro 11 Line, 2.74m, 4seg

Lanseta Hardy Zane Pro Fly Rod Zpro 11 Line, 2.74m, 4seg

1511818
Stoc epuizat

4.658,45Lei

Lanseta Konger Arcus Pro Feeder 3.60m, 120g, 3+3seg

Lanseta Konger Arcus Pro Feeder 3.60m, 120g, 3+3seg

20506130004360
Stoc epuizat

246,13Lei

LANSETA SPINNING PRO FL MURROW 1.80M 0.2-6G

LANSETA SPINNING PRO FL MURROW 1.80M 0.2-6G

64-4102
Stoc epuizat

131,90Lei

Manusi Flying Fisherman Sunbandit Pro Series Gloves Blue Water S-M

Manusi Flying Fisherman Sunbandit Pro Series Gloves Blue Water S-M

g2200s/m
Stoc epuizat

155,00Lei

MULINETA PRO FL ULTRA CAST CARP FLX SPOD MARKER I

MULINETA PRO FL ULTRA CAST CARP FLX SPOD MARKER I

64-13451
Stoc epuizat

349,00Lei

Panou Frontal Impermeabil (T4216) pentru Adapost Nash Titan Hide Camo Pro XL
Pantaloni FOX RAGE Pro Series Soft Shell Trousers, Marime M

Pantaloni FOX RAGE Pro Series Soft Shell Trousers, Marime M

npr586
Stoc epuizat

337,46Lei

Pantaloni FOX RAGE Pro Series Soft Shell Trousers, Marime XL

Pantaloni FOX RAGE Pro Series Soft Shell Trousers, Marime XL

npr588
Stoc epuizat

337,46Lei

Pelete Easybox Method Pellet - Mix Color

Pelete Easybox Method Pellet - Mix Color

ebox-mp-mc
Stoc epuizat

29,00Lei

Plancton Fish Pro -120G Miere

Plancton Fish Pro -120G Miere

fpp-m
Stoc epuizat

13,99Lei

Plancton Fish Pro -120G Original

Plancton Fish Pro -120G Original

fpp-or
Stoc epuizat

13,99Lei

Pluta Fp 451 3G- Balsa

Pluta Fp 451 3G- Balsa

pfp451-3
Stoc epuizat

8,50Lei

Pop Up Pro Line Fluor, Pro Insecto, 12mm, 200ml

Pop Up Pro Line Fluor, Pro Insecto, 12mm, 200ml

pl4978
Stoc epuizat

46,00Lei

Pop-Up Fhp 8Mm White Usturoi 40G

Pop-Up Fhp 8Mm White Usturoi 40G

fppup-8wu
Stoc epuizat

26,00Lei

Pop-Up Fhp 8Mm Yellow -Orange Mango 40G

Pop-Up Fhp 8Mm Yellow -Orange Mango 40G

fppup-8yom
Stoc epuizat

26,00Lei

Afişare 2981 - 3000 din 3891 (195 pagini)
Queries: 5, Total time: 116.923 ms [By time] [By id] [By file]
1 (0.117)
SELECT data
FROM `oc_session`
WHERE session_id = 'b811f4bcbd70d705b386aa5933'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.078)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (95.639)
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('+pro' 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 (20.969)
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 2980, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.120)
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