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 90 zile

Retur simplu in 90 zile.

Vezi mai multe detalii

Căutare - Coghlans

Produse ce potrivesc criteriilor de căutare


Protectie Coghlans pentru capac toaleta -49%

Protectie Coghlans pentru capac toaleta

c8915
Stoc epuizat

16,15Lei(-49%) 8,26Lei

Fluier Coghlans Metalic -29%

Fluier Coghlans Metalic

c9425
Stoc epuizat

37,50Lei(-29%) 26,60Lei

Set Capace Silicon Protectie Periuta de Dinti Coghlans -46%

Set Capace Silicon Protectie Periuta de Dinti Coghlans

c2094-ddn
Stoc epuizat

20,22Lei(-46%) 10,89Lei

Set Pungi Resigilabile Coghlans -37%

Set Pungi Resigilabile Coghlans

c2235-ddn
Stoc epuizat

77,16Lei(-37%) 48,40Lei

Kit Coghlans reparatie bete de cort -50%

Kit Coghlans reparatie bete de cort

c0194
Stoc epuizat

30,40Lei(-50%) 15,34Lei

Busola Coghlans de buzunar cu lichid -41%

Busola Coghlans de buzunar cu lichid

c8160
Stoc epuizat

34,45Lei(-41%) 20,24Lei

Cuie Coghlans pentru cort 15cm din plastic ABS -49%

Cuie Coghlans pentru cort 15cm din plastic ABS

c9306
Stoc epuizat

25,30Lei(-49%) 12,78Lei

Fluier Coghlans din plastic -44%

Fluier Coghlans din plastic

c9420
Stoc epuizat

19,20Lei(-44%) 10,66Lei

Topor Coghlans C2060 -1%

Topor Coghlans C2060

c2060-ddn
Stoc epuizat

177,82Lei(-1%) 175,91Lei

Cui Coghlans ancorare cu insurubare din plastic -10%

Cui Coghlans ancorare cu insurubare din plastic

c1803
Stoc epuizat

20,22Lei(-10%) 18,30Lei

Organizator pentru Calatorie Coghlans Cub Expandabil, Marime M -39%

Organizator pentru Calatorie Coghlans Cub Expandabil, Marime M

c2020-ddn
Stoc epuizat

98,51Lei(-39%) 60,50Lei

Fata de Masa Picnic/ Camping Coghlans -40%

Fata de Masa Picnic/ Camping Coghlans

c2320-ddn
Stoc epuizat

151,40Lei(-40%) 90,75Lei

Fierastrau Coghlans de Buzunar -39%

Fierastrau Coghlans de Buzunar

c2227-ddn
Stoc epuizat

98,51Lei(-39%) 60,50Lei

Set Vesela pentru Camping Coghlans, 1pers -42%

Set Vesela pentru Camping Coghlans, 1pers

c2315-ddn
Stoc epuizat

124,94Lei(-42%) 72,60Lei

Organizator Calatorie Coglans, 25.4x38.1x10cm -42%

Organizator Calatorie Coglans, 25.4x38.1x10cm

c2025-ddn
Stoc epuizat

165,62Lei(-42%) 96,80Lei

Pelerina Transparenta pentru Ploaie Coghlans Poncho -50%

Pelerina Transparenta pentru Ploaie Coghlans Poncho

c9173
Stoc epuizat

12,08Lei(-50%) 6,05Lei

Piatra Coghlans pentru ascutit cutite -36%

Piatra Coghlans pentru ascutit cutite

c7945
Stoc epuizat

45,64Lei(-36%) 29,35Lei

Perna Gonflabila pentru Calatorii si Camping Coghlans C2135 -2%

Perna Gonflabila pentru Calatorii si Camping Coghlans C2135

c2135-ddn
Stoc epuizat

88,34Lei(-2%) 86,43Lei

Forma din Fonta pentru Gatit la Foc Coghlans -40%

Forma din Fonta pentru Gatit la Foc Coghlans

c2045-ddn
Stoc epuizat

142,24Lei(-40%) 84,70Lei

Mini Cos de Gunoi Pliabil Coghlans Pop Up -43%

Mini Cos de Gunoi Pliabil Coghlans Pop Up

c2213-ddn
Stoc epuizat

54,79Lei(-43%) 31,46Lei

Afişare 141 - 160 din 166 (9 pagini)
Queries: 8, Total time: 2.044 ms [By time] [By id] [By file]
1 (0.149)
SELECT data
FROM `oc_session`
WHERE session_id = '061149a53cb0d57d9d2fe52882'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.078)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.089)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.141)
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
5 (0.767)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("73209", "2", "1000", "464", "1", "291.500000000000", "1"),("73094", "2", "1", "464", "1", "39.400000000000", "2"),("73208", "2", "1000", "464", "1", "52.840000000000", "3"),("73212", "2", "1000", "464", "1", "349.480000000000", "4"),("73214", "2", "1000", "464", "1", "136.880000000000", "5"),("73227", "2", "1000", "464", "1", "47.800000000000", "6"),("180354", "2", "1000", "464", "1", "18.390000000000", "7"),("180204", "1", "1000", "464", "1", "63.770000000000", "8"),("73194", "2", "1003", "464", "1", "23.430000000000", "9"),("73238", "2", "1000", "464", "1", "27.640000000000", "10"),("179784", "2", "1000", "464", "1", "25.950000000000", "11"),("180405", "2", "1000", "464", "1", "93.180000000000", "12"),("180485", "2", "1000", "464", "1", "13.350000000000", "13"),("72804", "2", "2", "464", "1", "42.760000000000", "14"),("179785", "2", "2", "464", "1", "41.170000000000", "15"),("73093", "2", "1", "464", "1", "12.500000000000", "16"),("73196", "2", "1", "464", "1", "73.100000000000", "17"),("180827", "2", "1000", "464", "1", "45.280000000000", "18"),("73004", "2", "1002", "464", "1", "25.950000000000", "19"),("73001", "2", "1001", "464", "1", "71.330000000000", "20"),("72809", "2", "1000", "464", "1", "52.840000000000", "21"),("73096", "2", "1000", "464", "1", "24.270000000000", "22"),("73107", "2", "1000", "464", "1", "51.170000000000", "23"),("73199", "2", "1000", "464", "1", "34.360000000000", "24"),("73206", "2", "1000", "464", "1", "52.840000000000", "25"),("180307", "2", "1000", "464", "1", "20.910000000000", "26"),("180383", "1", "1000", "464", "1", "26.790000000000", "27"),("73223", "2", "1", "464", "1", "161.250000000000", "28"),("73230", "2", "1", "464", "1", "91.590000000000", "29"),("73204", "2", "1002", "464", "1", "99.980000000000", "30"),("72798", "2", "1001", "464", "1", "36.880000000000", "31"),("73000", "2", "1001", "464", "1", "45.280000000000", "32"),("73090", "2", "1001", "464", "1", "7.460000000000", "33"),("73092", "2", "1001", "464", "1", "12.500000000000", "34"),("73098", "2", "1001", "464", "1", "26.790000000000", "35"),("73243", "2", "1001", "464", "1", "25.950000000000", "36"),("164384", "2", "1001", "464", "1", "52.840000000000", "37"),("179777", "1", "1001", "464", "1", "36.880000000000", "38"),("179779", "2", "1001", "464", "1", "114.270000000000", "39"),("72998", "2", "1000", "464", "1", "16.710000000000", "40"),("73005", "2", "1000", "464", "1", "14.190000000000", "41"),("73006", "2", "1000", "464", "1", "18.390000000000", "42"),("73008", "2", "1000", "464", "1", "219.230000000000", "43"),("73110", "2", "1000", "464", "1", "57.040000000000", "44"),("73226", "2", "1000", "464", "1", "37.720000000000", "45"),("73244", "2", "1000", "464", "1", "25.950000000000", "46"),("179775", "2", "1000", "464", "1", "15.020000000000", "47"),("180208", "2", "1000", "464", "1", "25.950000000000", "48"),("180210", "2", "1000", "464", "1", "25.950000000000", "49"),("180214", "2", "1000", "464", "1", "139.400000000000", "50"),("180486", "2", "1000", "464", "1", "45.280000000000", "51"),("180487", "2", "1000", "464", "1", "45.280000000000", "52"),("180617", "1", "1000", "464", "1", "47.800000000000", "53"),("72816", "2", "1002", "464", "1", "174.780000000000", "54"),("72996", "2", "1002", "464", "1", "14.190000000000", "55"),("72799", "2", "1001", "464", "1", "30.990000000000", "56"),("72830", "2", "1001", "464", "1", "18.390000000000", "57"),("73097", "2", "1001", "464", "1", "78.140000000000", "58"),("73202", "2", "1001", "464", "1", "20.910000000000", "59"),("73218", "2", "1001", "464", "1", "37.720000000000", "60"),("73220", "2", "1001", "464", "1", "27.640000000000", "61"),("73229", "2", "1001", "464", "1", "22.680000000000", "62"),("179813", "1", "1001", "464", "1", "196.630000000000", "63"),("72819", "2", "1000", "464", "1", "35.200000000000", "64"),("73112", "2", "1000", "464", "1", "123.430000000000", "65"),("73217", "2", "1000", "464", "1", "30.990000000000", "66"),("73221", "2", "1000", "464", "1", "26.790000000000", "67"),("73228", "2", "1000", "464", "1", "94.020000000000", "68"),("179787", "2", "1000", "464", "1", "32.680000000000", "69"),("179809", "1", "1000", "464", "1", "81.410000000000", "70"),("179810", "1", "1000", "464", "1", "99.900000000000", "71"),("180209", "2", "1000", "464", "1", "36.030000000000", "72"),("180309", "2", "1000", "464", "1", "39.400000000000", "73"),("180310", "2", "1000", "464", "1", "53.690000000000", "74"),("180319", "1", "1000", "464", "1", "63.770000000000", "75"),("180403", "2", "1000", "464", "1", "288.140000000000", "76"),("180811", "2", "1000", "464", "1", "57.770000000000", "77"),("72818", "2", "1", "464", "1", "95.700000000000", "78"),("72829", "2", "1", "464", "1", "146.210000000000", "79"),("73103", "2", "1", "464", "1", "13.180000000000", "80"),("73241", "2", "1", "464", "1", "49.480000000000", "81"),("72822", "2", "1009", "464", "1", "39.400000000000", "82"),("72801", "2", "1001", "464", "1", "33.510000000000", "83"),("72835", "2", "1001", "464", "1", "27.640000000000", "84"),("73205", "2", "1001", "464", "1", "90.660000000000", "85"),("73222", "2", "1001", "464", "1", "55.360000000000", "86"),("73242", "2", "1001", "464", "1", "27.640000000000", "87"),("72817", "2", "1000", "464", "1", "146.960000000000", "88"),("73201", "2", "1000", "464", "1", "47.800000000000", "89"),("73219", "2", "1000", "464", "1", "146.960000000000", "90"),("73224", "2", "1000", "464", "1", "60.400000000000", "91"),("179773", "2", "1000", "464", "1", "95.700000000000", "92"),("179812", "1", "1000", "464", "1", "123.430000000000", "93"),("180265", "2", "1000", "464", "1", "436.030000000000", "94"),("180266", "2", "1000", "464", "1", "335.200000000000", "95"),("180322", "2", "1000", "464", "1", "69.650000000000", "96"),("180465", "2", "1000", "464", "1", "148.640000000000", "97"),("180537", "1", "1000", "464", "1", "35.200000000000", "98"),("180813", "2", "1000", "464", "1", "189.820000000000", "99"),("73010", "2", "1000", "464", "1", "33.510000000000", "100"),("179778", "2", "1000", "464", "1", "96.630000000000", "101"),("73106", "2", "3", "464", "1", "71.330000000000", "102"),("179811", "1", "1", "464", "1", "100.830000000000", "103"),("72802", "2", "1001", "464", "1", "20.490000000000", "104"),("179772", "2", "1001", "464", "1", "102.500000000000", "105"),("72826", "2", "1000", "464", "1", "23.430000000000", "106"),("72827", "2", "1000", "464", "1", "30.160000000000", "107"),("73002", "2", "1000", "464", "1", "26.790000000000", "108"),("73240", "2", "1000", "464", "1", "97.380000000000", "109"),("180464", "1", "1000", "464", "1", "64.610000000000", "110"),("180815", "2", "1000", "464", "1", "144.440000000000", "111"),("73111", "2", "1", "464", "1", "93.260000000000", "112"),("72828", "2", "1001", "464", "1", "36.880000000000", "113"),("72999", "2", "1000", "464", "1", "43.600000000000", "114"),("180459", "2", "1000", "464", "1", "173.850000000000", "115"),("180799", "2", "1000", "464", "1", "494.020000000000", "116"),("180801", "2", "1000", "464", "1", "522.600000000000", "117"),("180356", "2", "1000", "464", "1", "161.250000000000", "118"),("237762", "2", "1003", "464", "1", "126.830000000000", "119"),("180469", "2", "1000", "464", "1", "23.430000000000", "120"),("179969", "2", "4", "464", "1", "47.040000000000", "121"),("73100", "2", "1000", "464", "1", "45.280000000000", "122"),("180374", "2", "1000", "364", "1", "146.960000000000", "123"),("180509", "2", "1000", "676", "1", "103.260000000000", "124"),("180278", "1", "1000", "59", "1", "30.990000000000", "125"),("180279", "1", "1000", "59", "1", "26.790000000000", "126"),("180281", "1", "1000", "59", "1", "52.840000000000", "127"),("180280", "1", "1", "59", "1", "20.070000000000", "128"),("73193", "2", "0", "464", "1", "20.170000000000", "129"),("180777", "1", "0", "464", "1", "9.150000000000", "130"),("179788", "2", "0", "464", "1", "15.130000000000", "131"),("180338", "2", "0", "464", "1", "10.000000000000", "132"),("73203", "2", "0", "464", "1", "29.600000000000", "133"),("179776", "1", "0", "464", "1", "17.640000000000", "134"),("180267", "2", "0", "464", "1", "40.000000000000", "135"),("72833", "2", "0", "464", "1", "29.600000000000", "136"),("73231", "2", "0", "464", "1", "16.430000000000", "137"),("179780", "2", "0", "464", "1", "120.170000000000", "138"),("72823", "2", "0", "464", "1", "26.240000000000", "139"),("72997", "2", "0", "464", "1", "22.690000000000", "140"),("73099", "2", "0", "464", "1", "6.830000000000", "141"),("73237", "2", "0", "464", "1", "21.980000000000", "142"),("180795", "1", "0", "464", "1", "9.000000000000", "143"),("180809", "2", "0", "464", "1", "40.000000000000", "144"),("72797", "2", "0", "464", "1", "12.680000000000", "145"),("72824", "2", "0", "464", "1", "16.730000000000", "146"),("73233", "2", "0", "464", "1", "10.560000000000", "147"),("73236", "2", "0", "464", "1", "8.810000000000", "148"),("179774", "2", "0", "464", "1", "145.380000000000", "149"),("73215", "2", "0", "464", "1", "15.120000000000", "150"),("180321", "2", "0", "464", "1", "50.000000000000", "151"),("180339", "2", "0", "464", "1", "75.000000000000", "152"),("180340", "2", "0", "464", "1", "50.000000000000", "153"),("180817", "2", "0", "464", "1", "60.000000000000", "154"),("180763", "1", "0", "464", "1", "80.000000000000", "155"),("180535", "2", "0", "464", "1", "5.000000000000", "156"),("73009", "2", "0", "464", "1", "24.260000000000", "157"),("179781", "2", "0", "464", "1", "71.430000000000", "158"),("180355", "2", "0", "464", "1", "70.000000000000", "159"),("180475", "2", "0", "464", "1", "26.000000000000", "160"),("180206", "2", "0", "464", "1", "25.000000000000", "161"),("180207", "2", "0", "464", "1", "25.000000000000", "162"),("180797", "2", "0", "464", "1", "50.000000000000", "163"),("180277", "2", "0", "464", "1", "45.000000000000", "164"),("207787", "2", "0", "464", "1", "64.610000000000", "165"),("180511", "2", "0", "676", "1", "15.000000000000", "166")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
6 (0.155)
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
7 (0.555)
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 140, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
8 (0.110)
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