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 Rapala X-Rap Culoare RT 6cm 4g

Vobler Rapala X-Rap Culoare RT 6cm 4g

xr06 rt
Stoc epuizat

51,00Lei

Vobler Rapala X-Rap Shad Shallow 6cm 9gr

Vobler Rapala X-Rap Shad Shallow 6cm 9gr

xrsh06 ggh
Stoc epuizat

59,00Lei

Crank Sakura SCB 100 F 53mm 10.70gr A06 Aurora Minnow

Crank Sakura SCB 100 F 53mm 10.70gr A06 Aurora Minnow

131234saple500353-a06
Stoc epuizat

49,83Lei

VOBLER RAPALA MAXRAP CULOARE FRH 15CM 23G

VOBLER RAPALA MAXRAP CULOARE FRH 15CM 23G

mxr15 frh
Stoc epuizat

75,01Lei

VOBLER RAPALA DOWN DEEP HUSKY JERK CULOARE HT 10CM 11G

VOBLER RAPALA DOWN DEEP HUSKY JERK CULOARE HT 10CM 11G

dhj10 ht
Stoc epuizat

47,01Lei

Vobler Sakura Chopsy Minnow 50 SP 50mm 4.50gr RL19 Real Life Spawning Vairon

Vobler Sakura Chopsy Minnow 50 SP 50mm 4.50gr RL19 Real Life Spawning Vairon

130234saplh500950-rl19
Stoc epuizat

52,00Lei

Vobler Rapala Scatter Rap Deep Husky Jerk, Culoare SB, 10cm, 10g

Vobler Rapala Scatter Rap Deep Husky Jerk, Culoare SB, 10cm, 10g

scrdhj10 sb
Stoc epuizat

41,00Lei

Vobler DUO Realis Jerkbait 120 SP 12cm 18g ADA3121 Phoenix

Vobler DUO Realis Jerkbait 120 SP 12cm 18g ADA3121 Phoenix

duo66055
Stoc epuizat

83,00Lei

Crank Sakura SCB Micro 39mm 4.10gr A06 Aurora Minnow

Crank Sakura SCB Micro 39mm 4.10gr A06 Aurora Minnow

131234saplg501539-a06
Stoc epuizat

43,93Lei

Vobler Rapala X-Rap Culoare ROL 6cm 4g

Vobler Rapala X-Rap Culoare ROL 6cm 4g

xr06 rol
Stoc epuizat

51,00Lei

VOBLER STRIKE PRO MONTERO 9CM/8,6G Culoare713 -20%

VOBLER STRIKE PRO MONTERO 9CM/8,6G Culoare713

sp.eg190a.a70.713
Stoc epuizat

44,01Lei(-20%) 35,21Lei

VOBLER RAPALA SHAD DANCER CULOARE BTR 5CM 8G

VOBLER RAPALA SHAD DANCER CULOARE BTR 5CM 8G

sdd05 btr
Stoc epuizat

43,99Lei

Vobler Rapala X-Rap MD 6cm 4g

Vobler Rapala X-Rap MD 6cm 4g

xr06 md
Stoc epuizat

51,00Lei

Vobler Rapala X-Rap Saltwater Culoare G 10cm 13g

Vobler Rapala X-Rap Saltwater Culoare G 10cm 13g

sxr10 g
Stoc epuizat

65,00Lei

VOBLER RAPALA X-RAP SHAD SHALLOW CULOARE SB 6CM 9G

VOBLER RAPALA X-RAP SHAD SHALLOW CULOARE SB 6CM 9G

xrsh06 sb
Stoc epuizat

59,00Lei

VOBLER RAPALA MAXRAP CULOARE DOL 11CM 13G

VOBLER RAPALA MAXRAP CULOARE DOL 11CM 13G

mxr11 dol
Stoc epuizat

63,00Lei

VOBLER RAPALA DIVES-TO CULOARE P 5CM 9G

VOBLER RAPALA DIVES-TO CULOARE P 5CM 9G

dt04 p
Stoc epuizat

49,00Lei

Vobler Sakura Chopsy Minnow 50 SP 50mm 4.50gr RL07 Real Life Vairon

Vobler Sakura Chopsy Minnow 50 SP 50mm 4.50gr RL07 Real Life Vairon

130234saplh500950-rl07
Stoc epuizat

52,00Lei

VOBLER RAPALA DOWN DEEP HUSKY JERK CULOARE RH 10CM 11G

VOBLER RAPALA DOWN DEEP HUSKY JERK CULOARE RH 10CM 11G

dhj10 rh
Stoc epuizat

42,99Lei

Vobler Sakura Chopsy Minnow 50 SP 50mm 4.50gr T07 Ghost Natural Trout

Vobler Sakura Chopsy Minnow 50 SP 50mm 4.50gr T07 Ghost Natural Trout

130234saplh500950-t07
Stoc epuizat

52,00Lei

Afişare 561 - 580 din 742 (38 pagini)
Queries: 20, Total time: 33.218 ms [By time] [By id] [By file]
1 (0.068)
SELECT data
FROM `oc_session`
WHERE session_id = 'a942a82c50a4768faa42032666'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.113)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (31.455)
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('+voblere +suspending' 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 (0.138)
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
5 (0.118)
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
6 (0.079)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=11854'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
7 (0.084)
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
8 (0.071)
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
9 (0.069)
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
10 (0.067)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
11 (0.068)
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
12 (0.070)
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
13 (0.067)
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
14 (0.066)
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
15 (0.118)
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
16 (0.116)
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
17 (0.120)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=98701'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
18 (0.119)
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
19 (0.116)
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
20 (0.095)
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