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


Vobler Yo-Zuri 3DS Flat Crank Floating, 5.5cm, 7.5gr Culoare SSH 1 buc/pac

Vobler Yo-Zuri 3DS Flat Crank Floating, 5.5cm, 7.5gr Culoare SSH 1 buc/pac

f1141-ssh
Livrare imediată!

39,00Lei

VOBLER COLMIC KRYPTO CRANK F 7.5cm 14gr Red Craw
Exclusiv online!

VOBLER COLMIC KRYPTO CRANK F 7.5cm 14gr Red Craw

arhkfa04
Livrare 48-72 ore

34,00Lei

GRUB COLMIC HERAKLES MATO WORM 16.5cm Smoke Silver Clear -30%

GRUB COLMIC HERAKLES MATO WORM 16.5cm Smoke Silver Clear

arhkmat18
Livrare imediată!

22,00Lei(-30%) 15,40Lei

Shad Biwaa Ultra Hog 7.5cm culoare Okeechobee -23%

Shad Biwaa Ultra Hog 7.5cm culoare Okeechobee

b001114
Livrare imediată!

26,00Lei(-23%) 19,90Lei

VOBLER RAPTURE NEO CRANK SQR 5CM 8GR BLS
Exclusiv online!

VOBLER RAPTURE NEO CRANK SQR 5CM 8GR BLS

180-17-853
Livrare 48-72 ore

26,00Lei

NALUCA STORM GOMOKU SPINTAIL 4.5CM 6GR CULOARE P
Exclusiv online!

NALUCA STORM GOMOKU SPINTAIL 4.5CM 6GR CULOARE P

gsp06 p
Livrare 48-72ore

35,00Lei

Shad Biwaa Deus 7.5cm culoare 310 Neon Scale Minnow
Exclusiv online!

Shad Biwaa Deus 7.5cm culoare 310 Neon Scale Minnow

b001184
Livrare 48-72 ore

26,00Lei

VOBLER STRIKE PRO BABY PRO 2,5CM/1,9G A17

VOBLER STRIKE PRO BABY PRO 2,5CM/1,9G A17

sp.sp100.a17
Livrare imediată!

29,68Lei

VOBLER SALMO RATTLIN HORNET FLOATING, SILVER HOLOGRAPHIC SHAD, 4.5CM, 6G

VOBLER SALMO RATTLIN HORNET FLOATING, SILVER HOLOGRAPHIC SHAD, 4.5CM, 6G

qrh008
Livrare imediată!

51,71Lei

VOBLER COLMIC HERAKLES SNAKE 95F 9.5cm 8.8gr Smoke Gold
Exclusiv online!

VOBLER COLMIC HERAKLES SNAKE 95F 9.5cm 8.8gr Smoke Gold

arhkfq02
Livrare 48-72 ore

38,00Lei

MAGIC FISH JAXON 8.5CM 16GR I -30%
Exclusiv online!

MAGIC FISH JAXON 8.5CM 16GR I

tx-g85i
Livrare 48-72 ore

54,00Lei(-30%) 37,79Lei

VOBLER RAPALA DIVES-TO FAT CULOARE PGS 5CM 9G

VOBLER RAPALA DIVES-TO FAT CULOARE PGS 5CM 9G

dt04 pgs
Livrare imediată!

49,00Lei

VOBLER STRIKE PRO BABY PRO 2,5CM/2G 046
Exclusiv online!

VOBLER STRIKE PRO BABY PRO 2,5CM/2G 046

sp.eg036.046
Livrare 24-48 ore

30,71Lei

Lingurita Oscilanta Colmic Herakles Monster Keeper, Gold, 6.5cm, 15g -22%

Lingurita Oscilanta Colmic Herakles Monster Keeper, Gold, 6.5cm, 15g

arhkio05
Livrare imediată!

32,00Lei(-22%) 24,89Lei

VOBLER DAIWA PROREX MINI POPPER, SETSUKI AYU, 5.5CM, 5.7G
Exclusiv online!

VOBLER DAIWA PROREX MINI POPPER, SETSUKI AYU, 5.5CM, 5.7G

f3.d15208.003
Livrare 24-48 ore

40,63Lei

Vobler Salmo Hornet H2S BT, 2.5cm, 1.5g

Vobler Salmo Hornet H2S BT, 2.5cm, 1.5g

84412503
Livrare imediată!

37,00Lei

VOBLER CARP ZOOM PREDATOR-Z HARD MINNOW 8.5cm 4.5gr FLOATING 1358 -20%

VOBLER CARP ZOOM PREDATOR-Z HARD MINNOW 8.5cm 4.5gr FLOATING 1358

cz1358
Livrare imediată!

12,00Lei(-20%) 9,60Lei

SHAD JAXON EXTREME SOFT DROP SHOT 1B 8.5CM

SHAD JAXON EXTREME SOFT DROP SHOT 1B 8.5CM

td-01b
Livrare imediată!

11,00Lei

Vobler Salmo Hornet H2S CB, 2.5cm, 1.5g

Vobler Salmo Hornet H2S CB, 2.5cm, 1.5g

84412582
Livrare imediată!

37,00Lei

Lingura Oscilanta 21g 6.5cm Zebco Laxus Blinker Silver

Lingura Oscilanta 21g 6.5cm Zebco Laxus Blinker Silver

3394006
Livrare imediată!

13,28Lei

Afişare 2381 - 2400 din 6934 (347 pagini)
Queries: 11, Total time: 258.496 ms [By time] [By id] [By file]
1 (0.115)
SELECT data
FROM `oc_session`
WHERE session_id = '23df2973ced543766baaa549e9'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.115)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (158.166)
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 = '3' AND (MATCH(pd.tag) AGAINST('+5cm/6.5g' 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:724
4 (0.578)
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:1561
5 (27.920)
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 2380, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.145)
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
7 (4.119)
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:1235
8 (0.111)
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:1257
9 (1.200)
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:1022
10 (65.889)
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:936
11 (0.138)
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