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


Aditiv Lichid Sensas Attractix Roach 75 ml
Exclusiv online!

Aditiv Lichid Sensas Attractix Roach 75 ml

a0.s14991
Livrare 24-48 ore

33,30Lei

Atractant Sensas Atractix 75ML

Atractant Sensas Atractix 75ML

a0.s14971
Livrare imediată!

33,30Lei

ATRACTANT SENSAS ATRACTIX BREAM 75ML

ATRACTANT SENSAS ATRACTIX BREAM 75ML

a0.s14981
Livrare imediată!

33,30Lei

NADA CARP ZOOM ATTRACTOR FITOFAG-SILVER CRAP 1KG

NADA CARP ZOOM ATTRACTOR FITOFAG-SILVER CRAP 1KG

cz1549
Livrare imediată!

17,00Lei

NADA CARP ZOOM ATTRACTOR FITOFAG-SILVER CRAP 3kg
Exclusiv online!

NADA CARP ZOOM ATTRACTOR FITOFAG-SILVER CRAP 3kg

cz8929
Livrare 48-72 ore

43,00Lei

ATTRACTOR SPRAY CARP ZOOM AMUR 50ml

ATTRACTOR SPRAY CARP ZOOM AMUR 50ml

cz4382
Livrare imediată!

17,00Lei

Tronson 01 Trabucco Attractive Mini Bolo 4M
Exclusiv online!

Tronson 01 Trabucco Attractive Mini Bolo 4M

124-82-400-r01
Livrare 48-72 ore

21,50Lei

RATA ARTIFICIALA JAXON ATTRACT HAPPY DUCK 13CM 23G A
Exclusiv online!

RATA ARTIFICIALA JAXON ATTRACT HAPPY DUCK 13CM 23G A

vr-msl01a
Livrare 48-72 ore

85,00Lei

RATA ARTIFICIALA JAXON ATTRACT HAPPY DUCK 13CM 23G B
Exclusiv online!

RATA ARTIFICIALA JAXON ATTRACT HAPPY DUCK 13CM 23G B

vr-msl01b
Livrare 48-72 ore

85,00Lei

RATA ARTIFICIALA JAXON ATTRACT HAPPY DUCK 13CM 23G F
Exclusiv online!

RATA ARTIFICIALA JAXON ATTRACT HAPPY DUCK 13CM 23G F

vr-msl01f
Livrare 48-72 ore

85,00Lei

RATA ARTIFICIALA JAXON ATTRACT HAPPY DUCK 13CM 23G G
Exclusiv online!

RATA ARTIFICIALA JAXON ATTRACT HAPPY DUCK 13CM 23G G

vr-msl01g
Livrare 48-72 ore

85,00Lei

RATA ARTIFICIALA JAXON ATTRACT HAPPY DUCK 13CM 23G H
Exclusiv online!

RATA ARTIFICIALA JAXON ATTRACT HAPPY DUCK 13CM 23G H

vr-msl01h
Livrare 48-72 ore

85,00Lei

RATA ARTIFICIALA JAXON ATTRACT HAPPY DUCK 13CM 23G D
Exclusiv online!

RATA ARTIFICIALA JAXON ATTRACT HAPPY DUCK 13CM 23G D

vr-msl01d
Livrare 48-72 ore

85,00Lei

RATA ARTIFICIALA JAXON ATTRACT HAPPY DUCK 13CM 23G E
Exclusiv online!

RATA ARTIFICIALA JAXON ATTRACT HAPPY DUCK 13CM 23G E

vr-msl01e
Livrare 48-72 ore

85,00Lei

Aditiv Zfish Attractor Bait Spray, Squid & Octopus, 50ml
Exclusiv online!

Aditiv Zfish Attractor Bait Spray, Squid & Octopus, 50ml

zf-6039
Livrare 48-72ore

19,50Lei

Aditiv Zfish Attractor Bait Spray, Squid & Krill, 50ml
Exclusiv online!

Aditiv Zfish Attractor Bait Spray, Squid & Krill, 50ml

zf-6060
Livrare 48-72ore

19,50Lei

LICHID ATTRACT DYNAMITE BAITS XL

LICHID ATTRACT DYNAMITE BAITS XL

dy104
Livrare imediată!

29,00Lei

Wafters MG Dumbell, Attract, 10mm, 40g

Wafters MG Dumbell, Attract, 10mm, 40g

mg5946
Livrare imediată!

25,00Lei

Boilies MG Special Carp Double Boom 15mm ATTRACT

Boilies MG Special Carp Double Boom 15mm ATTRACT

mg6515
Livrare imediată!

25,00Lei

LICHID ATTRACT DYNAMITE BAITS MARINE HALIBUT -20%

LICHID ATTRACT DYNAMITE BAITS MARINE HALIBUT

dy282
Livrare imediată!

49,00Lei(-20%) 39,00Lei

Afişare 1 - 20 din 62 (4 pagini)
Queries: 13, Total time: 3.178 ms [By time] [By id] [By file]
1 (0.114)
SELECT data
FROM `oc_session`
WHERE session_id = 'd22b40c500d277a36f2b49dcaa'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.080)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.165)
CREATE TEMPORARY TABLE oc_bf_tmp_product ( product_id int PRIMARY KEY, sort_order int, quantity int, manufacturer_id int, match_filters int, actual_price DECIMAL(10, 4), sort int, INDEX my_index (match_filters, sort_order, manufacturer_id) ) ENGINE=MEMORY
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:837
4 (0.322)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("68562", "2", "1000", "62", "1", "27.980000000000", "1"),("11695", "2", "1005", "62", "1", "39.104000000000", "2"),("26575", "2", "1001", "62", "1", "39.104000000000", "3"),("36331", "2", "1012", "75", "1", "19.968000000000", "4"),("159033", "2", "1000", "75", "1", "50.496000000000", "5"),("25606", "2", "1001", "75", "1", "19.968000000000", "6"),("107587", "1", "1000", "58", "1", "18.070000000000", "7"),("79794", "2", "1000", "42", "1", "71.430000000000", "8"),("79795", "2", "1000", "42", "1", "71.430000000000", "9"),("79796", "2", "1000", "42", "1", "71.430000000000", "10"),("79797", "2", "1000", "42", "1", "71.430000000000", "11"),("79798", "2", "1000", "42", "1", "71.430000000000", "12"),("79799", "2", "1000", "42", "1", "71.430000000000", "13"),("79800", "2", "1000", "42", "1", "71.430000000000", "14"),("226232", "1", "1000", "370", "1", "16.390000000000", "15"),("226233", "1", "1000", "370", "1", "16.390000000000", "16"),("32529", "2", "1", "178", "1", "34.060800000000", "17"),("199835", "2", "8", "69", "1", "29.363200000000", "18"),("144623", "2", "5", "69", "1", "29.363200000000", "19"),("32191", "2", "5", "178", "1", "45.798400000000", "20"),("32738", "2", "1001", "178", "1", "34.060800000000", "21"),("32527", "2", "1000", "178", "1", "73.984000000000", "22"),("32741", "2", "3", "178", "1", "34.060800000000", "23"),("170090", "1", "8", "69", "1", "35.225600000000", "24"),("32740", "2", "1", "178", "1", "24.370000000000", "25"),("222228", "1", "1000", "342", "1", "21.132800000000", "26"),("97782", "2", "5", "178", "1", "76.326400000000", "27"),("170114", "2", "9", "69", "1", "90.419200000000", "28"),("170115", "2", "8", "69", "1", "90.419200000000", "29"),("204871", "1", "4", "659", "1", "30.528000000000", "30"),("204845", "1", "3", "659", "1", "30.528000000000", "31"),("204825", "1", "3", "659", "1", "30.528000000000", "32"),("204867", "1", "3", "659", "1", "30.528000000000", "33"),("204827", "1", "2", "659", "1", "30.528000000000", "34"),("204883", "1", "5", "659", "1", "31.116800000000", "35"),("204895", "1", "4", "659", "1", "31.116800000000", "36"),("204887", "1", "3", "659", "1", "31.116800000000", "37"),("204875", "1", "4", "659", "1", "30.528000000000", "38"),("204841", "1", "3", "659", "1", "30.528000000000", "39"),("204891", "1", "5", "659", "1", "31.116800000000", "40"),("204847", "1", "4", "659", "1", "30.528000000000", "41"),("204881", "1", "4", "659", "1", "30.528000000000", "42"),("204873", "1", "3", "659", "1", "30.528000000000", "43"),("204839", "1", "3", "659", "1", "30.528000000000", "44"),("204843", "1", "3", "659", "1", "30.528000000000", "45"),("204877", "1", "1", "659", "1", "30.528000000000", "46"),("204889", "1", "5", "659", "1", "31.116800000000", "47"),("204897", "1", "4", "659", "1", "31.116800000000", "48"),("204893", "1", "2", "659", "1", "31.116800000000", "49"),("204899", "1", "7", "659", "1", "31.116800000000", "50"),("243207", "2", "5", "69", "1", "23.488000000000", "51"),("243200", "2", "5", "69", "1", "29.363200000000", "52"),("92548", "2", "0", "62", "1", "20.992000000000", "53"),("226231", "1", "0", "370", "1", "16.390000000000", "54"),("226235", "1", "0", "370", "1", "16.390000000000", "55"),("226234", "1", "0", "370", "1", "16.390000000000", "56"),("162179", "2", "0", "69", "1", "11.744000000000", "57"),("86952", "2", "0", "178", "1", "60.160000000000", "58"),("91861", "2", "0", "178", "1", "60.160000000000", "59"),("32526", "2", "0", "178", "1", "64.000000000000", "60"),("32743", "2", "0", "178", "1", "21.000000000000", "61"),("204879", "1", "0", "659", "1", "20.352000000000", "62")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.195)
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:1593
6 (0.291)
SELECT p.*
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2' LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.144)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.100)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.296)
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:1393
10 (0.089)
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:1415
11 (0.087)
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:1180
12 (1.178)
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:1094
13 (0.117)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37