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


Set aragaz Campingaz Bleuet Micro plus cartus CV 300

Set aragaz Campingaz Bleuet Micro plus cartus CV 300

204186s
Stoc epuizat

129,00Lei

MINCIOG JAXON STRONG B1 ALU 300

MINCIOG JAXON STRONG B1 ALU 300

pl-acb1300f
Livrare imediată!

153,00Lei

LANSETA DAIWA TELE MEGAFORCE 3.00M/70-150G

LANSETA DAIWA TELE MEGAFORCE 3.00M/70-150G

d.11494.300
Stoc epuizat

259,27Lei

Husa 2 Compartimente Delphin PORTA 300

Husa 2 Compartimente Delphin PORTA 300

430406170
Stoc epuizat

195,01Lei

MULINETA DAIWA NINJA MATCH 3000-C 4BB/150X028MM/5,3:1

MULINETA DAIWA NINJA MATCH 3000-C 4BB/150X028MM/5,3:1

d.10217.300
Stoc epuizat

413,91Lei

CPK BOILIES CARLIG NEXT 300 GR SOLL 20MM -27%

CPK BOILIES CARLIG NEXT 300 GR SOLL 20MM

999284
Stoc epuizat

19,02Lei(-27%) 13,88Lei

CPK BOILIES CARLIG STINKY FISH 300 GR SOL 16/20MM

CPK BOILIES CARLIG STINKY FISH 300 GR SOL 16/20MM

999277
Stoc epuizat

28,00Lei

PICHET INOX CARP SPIRIT BORA POINT 300 - 12 -35%

PICHET INOX CARP SPIRIT BORA POINT 300 - 12

acs370031
Stoc epuizat

199,00Lei(-35%) 129,35Lei

Set Hangere Carp Academy Flash 3buc

Set Hangere Carp Academy Flash 3buc

6356-300
Stoc epuizat

220,00Lei

CPK BOILIES CARLIG STINKY FISH 300 GR SOL 20MM

CPK BOILIES CARLIG STINKY FISH 300 GR SOL 20MM

999279
Stoc epuizat

19,02Lei

Lanseta Nevis Trinity Short Carp 3.00m 3.00lbs

Lanseta Nevis Trinity Short Carp 3.00m 3.00lbs

1452-300
Stoc epuizat

195,01Lei

CPK BOILIES CARLIG STINKY FISH 300 GR 20MM

CPK BOILIES CARLIG STINKY FISH 300 GR 20MM

999275
Stoc epuizat

19,02Lei

Bluza Rapture Pro Team, Marime XL

Bluza Rapture Pro Team, Marime XL

044-01-300
Stoc epuizat

140,00Lei

MULINETA DAIWA LEGALIS LT 3000-C 5RUL

MULINETA DAIWA LEGALIS LT 3000-C 5RUL

d.10425.300
Stoc epuizat

368,85Lei

Lanseta Lineaeffe Deep Walker Extreme Deep 300 2.10M 300g 2SEG

Lanseta Lineaeffe Deep Walker Extreme Deep 300 2.10M 300g 2SEG

l.2230121
Stoc epuizat

187,27Lei

LANSETA RAPTURE FLIT MASTER 2.13M 11-28G 2BUC

LANSETA RAPTURE FLIT MASTER 2.13M 11-28G 2BUC

126-35-300
Stoc epuizat

530,00Lei

Lanseta Sportex BLACK PEARL GT-3 300 40gr

Lanseta Sportex BLACK PEARL GT-3 300 40gr

bp3002
Stoc epuizat

800,00Lei

Lanterna Lineaeffe de Cap Black 300 Lumeni

Lanterna Lineaeffe de Cap Black 300 Lumeni

a8.7599382
Stoc epuizat

40,41Lei

MULINETA TRABUCCO VIDAR 3000

MULINETA TRABUCCO VIDAR 3000

034-45-300
Stoc epuizat

225,01Lei

Hanorac Gamakatsu Black marime L

Hanorac Gamakatsu Black marime L

a8.gk.7241.300
Stoc epuizat

194,17Lei

Afişare 361 - 380 din 398 (20 pagini)
Queries: 15, Total time: 18.884 ms [By time] [By id] [By file]
1 (0.123)
SELECT data
FROM `oc_session`
WHERE session_id = '5a5852e420e97239b30506b7cb'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.080)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (10.896)
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 = '3' AND (MATCH(pd.tag) AGAINST('+300-600gr' 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:724
4 (0.154)
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:1561
5 (1.839)
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 360, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.127)
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.127)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"CPK CARP & MORE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.125)
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.120)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"CPK CARP & MORE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.118)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"CPK CARP & MORE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
11 (0.513)
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:1235
12 (0.113)
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:1257
13 (0.157)
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:1022
14 (4.271)
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:936
15 (0.121)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38