Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

Transport Gratuit

Comenzile peste 400 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

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

Retur simplu in 90 zile.

Vezi mai multe detalii

Căutare - Aviator

Filtreaza

Produse ce potrivesc criteriilor de căutare

Sortare după:

-43%

PLUTA MOSTIRO FIXA VICTOR N 4GR

2420210240000-bucxxx

Stoc epuizat

5,58Lei(-43%) 3,18Lei

-43%

PLUTA MOSTIRO FIXA VICTOR N 3GR

2420210230000-bucxxx

Stoc epuizat

5,58Lei(-43%) 3,18Lei

-43%

PLUTA MOSTIRO FIXA VICTOR N 1GR

2420210210000-bucxxx

Stoc epuizat

5,58Lei(-43%) 3,18Lei

-43%

PLUTA MOSTIRO FIXA VICTOR N 1.5GR

2420210215000-bucxxx

Stoc epuizat

5,58Lei(-43%) 3,18Lei

-43%

PLUTA MOSTIRO FIXA VICTOR G 5GR

2420210350000-bucxxx

Stoc epuizat

5,58Lei(-43%) 3,18Lei

-43%

PLUTA MOSTIRO FIXA VICTOR G 4GR

2420210340000-bucxxx

Stoc epuizat

5,58Lei(-43%) 3,18Lei

-43%

PLUTA MOSTIRO FIXA VICTOR G 3GR

2420210330000-bucxxx

Stoc epuizat

5,58Lei(-43%) 3,18Lei

-43%

PLUTA MOSTIRO FIXA VICTOR G 2GR

2420210320000-bucxxx

Stoc epuizat

5,58Lei(-43%) 3,18Lei

-43%

PLUTA MOSTIRO FIXA VICTOR G 1GR

2420210310000-bucxxx

Stoc epuizat

5,58Lei(-43%) 3,18Lei

-43%

PLUTA MOSTIRO FIXA VICTOR G 1.5GR

2420210315000-bucxxx

Stoc epuizat

5,58Lei(-43%) 3,18Lei

-43%

PLUTA MOSTIRO FIXA VICTOR A 5GR

2420210150000-bucxxx

Stoc epuizat

5,58Lei(-43%) 3,18Lei

-43%

PLUTA MOSTIRO FIXA VICTOR A 4GR

2420210140000-bucxxx

Stoc epuizat

5,58Lei(-43%) 3,18Lei

-43%

PLUTA MOSTIRO FIXA VICTOR A 3GR

2420210130000-bucxxx

Stoc epuizat

5,58Lei(-43%) 3,18Lei

-43%

PLUTA MOSTIRO FIXA VICTOR A 2GR

2420210120000-bucxxx

Stoc epuizat

5,58Lei(-43%) 3,18Lei

-43%

PLUTA MOSTIRO FIXA VICTOR A 1.5GR

2420210115000-bucxxx

Stoc epuizat

5,58Lei(-43%) 3,18Lei

-36%

Pluta Mostiro Victor G, 2.00g, 2buc

2420210320000-2

Stoc epuizat

10,35Lei(-36%) 6,66Lei

-21%

VESTA BLASER VICTOR DARK BROWN MAR. 2XL

bl.122046.136.2xl

Stoc epuizat

770,66Lei(-21%) 610,84Lei

-21%

VESTA BLASER VICTOR DARK BROWN MAR.L

bl.122046.136.l

Stoc epuizat

806,86Lei(-21%) 639,58Lei

-21%

VESTA BLASER VICTOR DARK BROWN MAR.M

bl.122046.136.m

Stoc epuizat

806,86Lei(-21%) 639,58Lei

-21%

VESTA BLASER VICTOR DARK BROWN MAR.XL

bl.122046.136.xl

Stoc epuizat

806,86Lei(-21%) 639,58Lei

Afişare 101 - 120 din 131 (7 pagini)

Queries: 8, Total time: 1.628 ms [By time] [By id] [By file]

1 (0.087)

SELECT data
FROM `oc_session`
WHERE session_id = '6d157172cbbf64976833bd44f9'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.066)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.079)

SELECT *
FROM oc_url_alias
WHERE keyword = 'search'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.156)

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.489)

INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("168888", "2", "1000", "643", "1", "1004.690000000000", "1"),("168893", "2", "1000", "643", "1", "1026.880000000000", "2"),("168895", "2", "1000", "643", "1", "1079.560000000000", "3"),("168898", "2", "1000", "643", "1", "1133.180000000000", "4"),("94879", "2", "1000", "73", "1", "195.700000000000", "5"),("168902", "2", "1000", "643", "1", "1415.120000000000", "6"),("168905", "2", "1000", "643", "1", "1478.890000000000", "7"),("168907", "2", "1000", "643", "1", "1424.360000000000", "8"),("168918", "2", "1000", "643", "1", "1426.210000000000", "9"),("233070", "2", "1004", "643", "1", "1428.550000000000", "10"),("189879", "2", "3", "643", "1", "1574.270000000000", "11"),("168875", "2", "1001", "643", "1", "1492.760000000000", "12"),("168885", "2", "1000", "643", "1", "1500.160000000000", "13"),("189877", "2", "21", "643", "1", "1535.330000000000", "14"),("168866", "2", "1000", "643", "1", "1426.210000000000", "15"),("168872", "2", "1000", "643", "1", "1492.760000000000", "16"),("168877", "1", "1000", "643", "1", "1758.050000000000", "17"),("168892", "1", "1000", "643", "1", "1781.170000000000", "18"),("168894", "1", "1000", "643", "1", "1833.850000000000", "19"),("168897", "1", "1000", "643", "1", "1888.390000000000", "20"),("169563", "1", "1000", "643", "1", "1848.640000000000", "21"),("162828", "1", "1007", "643", "1", "2696.290000000000", "22"),("168900", "1", "1000", "643", "1", "2319.150000000000", "23"),("168903", "1", "1000", "643", "1", "2319.150000000000", "24"),("168906", "1", "1000", "643", "1", "2319.150000000000", "25"),("168919", "1", "1000", "643", "1", "2341.330000000000", "26"),("162843", "1", "1000", "643", "1", "2261.210000000000", "27"),("205739", "1", "3", "643", "1", "2400.490000000000", "28"),("168806", "1", "1011", "643", "1", "2495.700000000000", "29"),("188649", "1", "1009", "643", "1", "2400.490000000000", "30"),("168869", "1", "1000", "643", "1", "2430.070000000000", "31"),("168874", "1", "1000", "643", "1", "2430.070000000000", "32"),("168883", "1", "1000", "643", "1", "2416.210000000000", "33"),("168858", "1", "1000", "643", "1", "2341.330000000000", "34"),("211073", "1", "3", "643", "1", "4622.680000000000", "35"),("221059", "1", "2", "767", "1", "162.930000000000", "36"),("221061", "1", "0", "767", "1", "135.200000000000", "37"),("96584", "2", "1000", "117", "1", "143.600000000000", "38"),("101017", "2", "1000", "117", "1", "126.790000000000", "39"),("62147", "2", "1000", "187", "1", "10.830000000000", "40"),("10747", "2", "2", "187", "1", "10.830000000000", "41"),("10746", "2", "1", "187", "1", "10.070000000000", "42"),("23877", "2", "1000", "250", "1", "555.890000000000", "43"),("23878", "2", "1000", "250", "1", "555.890000000000", "44"),("23875", "10", "1", "250", "1", "539.730000000000", "45"),("53075", "2", "1", "67", "1", "5.530000000000", "46"),("178318", "2", "1010", "45", "1", "8.550000000000", "47"),("41369", "2", "9", "45", "1", "3.770000000000", "48"),("41392", "2", "4", "45", "1", "4.610000000000", "49"),("178321", "2", "4", "45", "1", "8.550000000000", "50"),("178319", "2", "1", "45", "1", "8.550000000000", "51"),("178322", "2", "1", "45", "1", "8.550000000000", "52"),("178323", "2", "1", "45", "1", "8.550000000000", "53"),("206163", "1", "1002", "476", "1", "126.830000000000", "54"),("180001", "2", "1000", "364", "1", "43.600000000000", "55"),("178359", "1", "1010", "85", "1", "44.520000000000", "56"),("243052", "1", "1000", "85", "1", "68.050000000000", "57"),("243066", "1", "1000", "85", "1", "82.340000000000", "58"),("243054", "1", "1000", "85", "1", "68.050000000000", "59"),("243079", "1", "1000", "85", "1", "82.340000000000", "60"),("243084", "1", "1000", "85", "1", "82.340000000000", "61"),("113251", "2", "1000", "187", "1", "76.370000000000", "62"),("243068", "1", "1000", "85", "1", "82.340000000000", "63"),("243082", "1", "1000", "85", "1", "82.340000000000", "64"),("243062", "1", "1000", "85", "1", "68.050000000000", "65"),("243063", "1", "1000", "85", "1", "68.050000000000", "66"),("243083", "1", "1000", "85", "1", "82.340000000000", "67"),("243085", "1", "1000", "85", "1", "82.340000000000", "68"),("178361", "1", "1000", "85", "1", "42.050000000000", "69"),("178365", "1", "1000", "85", "1", "31.930000000000", "70"),("178363", "1", "1000", "85", "1", "42.050000000000", "71"),("239679", "1", "4", "103", "1", "25.570000000000", "72"),("236120", "1", "1005", "85", "1", "54.610000000000", "73"),("236303", "1", "1000", "85", "1", "54.610000000000", "74"),("243055", "1", "1000", "85", "1", "68.050000000000", "75"),("243081", "1", "1000", "85", "1", "82.340000000000", "76"),("236301", "1", "1000", "85", "1", "44.520000000000", "77"),("236305", "1", "1000", "85", "1", "61.330000000000", "78"),("236868", "1", "1000", "85", "1", "61.330000000000", "79"),("236869", "1", "1000", "85", "1", "54.610000000000", "80"),("178362", "1", "1000", "85", "1", "29.690000000000", "81"),("178364", "1", "1000", "85", "1", "42.050000000000", "82"),("240319", "1", "1010", "85", "1", "54.610000000000", "83"),("236119", "1", "1005", "85", "1", "44.520000000000", "84"),("236121", "1", "1005", "85", "1", "61.330000000000", "85"),("236122", "1", "1005", "85", "1", "61.330000000000", "86"),("236118", "1", "1000", "85", "1", "44.520000000000", "87"),("236304", "1", "1000", "85", "1", "54.610000000000", "88"),("236306", "1", "1000", "85", "1", "61.330000000000", "89"),("236307", "1", "1000", "85", "1", "61.330000000000", "90"),("243281", "1", "1005", "85", "1", "54.610000000000", "91"),("243275", "1", "1000", "85", "1", "61.330000000000", "92"),("243277", "1", "1000", "85", "1", "61.330000000000", "93"),("243279", "1", "1000", "85", "1", "54.610000000000", "94"),("251483", "2", "0", "294", "1", "125.140000000000", "95"),("23874", "10", "0", "250", "1", "411.380000000000", "96"),("23876", "10", "0", "250", "1", "411.380000000000", "97"),("69952", "10", "0", "250", "1", "249.740000000000", "98"),("69954", "10", "0", "250", "1", "249.740000000000", "99"),("41366", "2", "0", "45", "1", "2.624000000000", "100"),("41367", "2", "0", "45", "1", "2.624000000000", "101"),("41368", "2", "0", "45", "1", "2.624000000000", "102"),("41370", "2", "0", "45", "1", "2.624000000000", "103"),("41371", "2", "0", "45", "1", "2.624000000000", "104"),("41372", "2", "0", "45", "1", "2.624000000000", "105"),("41373", "2", "0", "45", "1", "2.624000000000", "106"),("41376", "2", "0", "45", "1", "2.624000000000", "107"),("41378", "2", "0", "45", "1", "2.624000000000", "108"),("41379", "2", "0", "45", "1", "2.624000000000", "109"),("41380", "2", "0", "45", "1", "2.624000000000", "110"),("41383", "2", "0", "45", "1", "2.624000000000", "111"),("41384", "2", "0", "45", "1", "2.624000000000", "112"),("41385", "2", "0", "45", "1", "2.624000000000", "113"),("41391", "2", "0", "45", "1", "2.624000000000", "114"),("41393", "2", "0", "45", "1", "2.624000000000", "115"),("178320", "2", "0", "45", "1", "5.500000000000", "116"),("160453", "10", "0", "238", "1", "504.830000000000", "117"),("160457", "10", "0", "238", "1", "528.580000000000", "118"),("160459", "10", "0", "238", "1", "528.580000000000", "119"),("160463", "10", "0", "238", "1", "528.580000000000", "120"),("160461", "10", "0", "238", "1", "549.880000000000", "121"),("243064", "1", "0", "85", "1", "51.460000000000", "122"),("243053", "1", "0", "85", "1", "51.460000000000", "123"),("243058", "1", "0", "85", "1", "51.460000000000", "124"),("242397", "2", "0", "807", "1", "1240.320000000000", "125"),("236302", "1", "0", "85", "1", "33.420000000000", "126"),("178366", "1", "0", "85", "1", "31.930000000000", "127"),("178360", "1", "0", "85", "1", "32.980000000000", "128"),("236870", "1", "0", "85", "1", "33.420000000000", "129"),("243286", "1", "0", "85", "1", "33.420000000000", "130"),("243283", "1", "0", "85", "1", "33.420000000000", "131")

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846

6 (0.106)

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.522)

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 100, 20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184

8 (0.123)

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

Produsul a fost adăugat în coș

Anunță-mă când intră în stoc!

Căutare - Aviator

Produse ce potrivesc criteriilor de căutare