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 - Senzor

Produse ce potrivesc criteriilor de căutare


Dip MG Special Carp Dip Fluo Led Hot Fish 100ml -30%

Dip MG Special Carp Dip Fluo Led Hot Fish 100ml

mg0018
Stoc epuizat

17,00Lei(-30%) 11,90Lei

ATRACTANT MAINLINE PINEAPPLE JUICE SPRAY 50ML

ATRACTANT MAINLINE PINEAPPLE JUICE SPRAY 50ML

a0.m.m36001
Stoc epuizat

32,68Lei

Aditiv Sonubaits Haze Liquid Wahsed Out

Aditiv Sonubaits Haze Liquid Wahsed Out

s1850053
Stoc epuizat

35,00Lei

ADITIV MAINLINE LINK PENTRU MIX BOILIES 300ML

ADITIV MAINLINE LINK PENTRU MIX BOILIES 300ML

a0.m.m16015
Stoc epuizat

87,00Lei

ADITIV MAINLINE Meta Mino PENTRU MIX BOILIES 250ML

ADITIV MAINLINE Meta Mino PENTRU MIX BOILIES 250ML

a0.m.m16005
Stoc epuizat

86,97Lei

AROMA MAINLINE PROFILE PLUS INDIAN SPICE 60ML

AROMA MAINLINE PROFILE PLUS INDIAN SPICE 60ML

a0.m.m11012
Stoc epuizat

47,01Lei

AROMA MAINLINE RESPONSE BANANA SI PARA 60ML

AROMA MAINLINE RESPONSE BANANA SI PARA 60ML

a0.m.m17012
Stoc epuizat

35,88Lei

ADITIV MAINLINE ACTIV ADES PEACH 100ML

ADITIV MAINLINE ACTIV ADES PEACH 100ML

a0.m.m18004
Stoc epuizat

49,67Lei

Aditiv lichid Benzar Mix Turbo Aroma Capsuna 15ml

Aditiv lichid Benzar Mix Turbo Aroma Capsuna 15ml

98012813
Stoc epuizat

6,50Lei

AROMA MAINLINE RESPONSE FRANKFURTER SAUSAGE 60ML

AROMA MAINLINE RESPONSE FRANKFURTER SAUSAGE 60ML

a0.m.m17014
Stoc epuizat

32,90Lei

ADITIV MAINLINE PARTICLE PELLET BLOODWORM 500ML

ADITIV MAINLINE PARTICLE PELLET BLOODWORM 500ML

a0.m.m09008
Stoc epuizat

54,24Lei

LICHID ATRACTANT DYNAMITE BAITS 500ML Sweet Tiger & Corn

LICHID ATRACTANT DYNAMITE BAITS 500ML Sweet Tiger & Corn

dy1265
Stoc epuizat

59,00Lei

ADITIV MAINLINE CAPTIVE 8 ORANGE CHOCOLATE 100ML

ADITIV MAINLINE CAPTIVE 8 ORANGE CHOCOLATE 100ML

a0.m.mm4004
Stoc epuizat

51,74Lei

Aroma spray Hydrospol PVA Pepper 30ML

Aroma spray Hydrospol PVA Pepper 30ML

pva-3953
Stoc epuizat

8,00Lei

Super Aditiv Fluo Benzar Mix Usturoi 250ML

Super Aditiv Fluo Benzar Mix Usturoi 250ML

98014346
Stoc epuizat

15,00Lei

Aditiv lichid Select Baits Hydro Sweet Roasted Nuts Liquid 500ml

Aditiv lichid Select Baits Hydro Sweet Roasted Nuts Liquid 500ml

sl2650
Stoc epuizat

47,00Lei

Aditiv lichid Select Baits Amino Solutions - 125ml

Aditiv lichid Select Baits Amino Solutions - 125ml

sl2712
Stoc epuizat

48,00Lei

Ulei de Somon Mainline Salmon Oil, 250ml

Ulei de Somon Mainline Salmon Oil, 250ml

a0.m.m20004
Stoc epuizat

56,32Lei

Dip Select Baits Beta Stim 125ml

Dip Select Baits Beta Stim 125ml

sl2412
Stoc epuizat

20,00Lei

Ulei Select Baits esential Cinnamon - 20ml

Ulei Select Baits esential Cinnamon - 20ml

su0420
Stoc epuizat

29,00Lei

Afişare 1021 - 1040 din 1089 (55 pagini)
Queries: 8, Total time: 216.557 ms [By time] [By id] [By file]
1 (0.086)
SELECT data
FROM `oc_session`
WHERE session_id = 'aa54b9d3d11af193eee07b1b7f'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.077)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.096)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (211.872)
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 '%aditivi%' AND pd.tag LIKE '%lichizi%' AND pd.tag LIKE '%/%' AND pd.tag LIKE '%arome%' AND pd.tag LIKE '%/%' AND pd.tag LIKE '%dip-uri%')) 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:698
5 (4.115)
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 1020, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.106)
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
7 (0.096)
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.109)
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