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

Produse ce potrivesc criteriilor de căutare


SCAUN MODULAR PRESTON INCEPTION
Exclusiv online!

SCAUN MODULAR PRESTON INCEPTION

p0120010
Livrare 7-14 zile

2.159,96Lei

Scaun Nash Indulgence Ultralite 52x50cm

Scaun Nash Indulgence Ultralite 52x50cm

t9477
Livrare imediată!

669,99Lei

Scaun Shakespeare SKP Superlite Chair
Exclusiv online!

Scaun Shakespeare SKP Superlite Chair

1550309
Livrare 7-14 zile

314,96Lei

Scaun Trakker RLX Nano Chair Kaki, 57x47x72cm
Exclusiv online!

Scaun Trakker RLX Nano Chair Kaki, 57x47x72cm

217205
Livrare 7-14 zile

399,95Lei

Scaun Shakespeare SKP Lightweight Chair
Exclusiv online!

Scaun Shakespeare SKP Lightweight Chair

1550311
Livrare 7-14 zile

427,46Lei

Sezut Pliabil Mikado Rotary 51x45x38cm
Exclusiv online!

Sezut Pliabil Mikado Rotary 51x45x38cm

is15-tb050
Livrare 48-72 ore

382,00Lei

Suport Shakespeare Superteam EVA Pole Support Rest
Exclusiv online!

Suport Shakespeare Superteam EVA Pole Support Rest

1564331
Livrare 7-14 zile

89,96Lei

Bucse de Reductie Filex 25 si 30mm, 2buc/pac

Bucse de Reductie Filex 25 si 30mm, 2buc/pac

fil9083
Livrare imediată!

13,49Lei

Scaun, Nash, Bank, Life, Moon, Chair, Camo,, 100x100x40cm, t1250, Scaune, Scaune Nash, Scaune Nash, Nash
Suport Shakespeare Superteam EVA Pole Support Bar
Exclusiv online!

Suport Shakespeare Superteam EVA Pole Support Bar

1564332
Livrare 7-14 zile

224,96Lei

Scaun Feeder Rive D36 Siege, Negru
Exclusiv online!

Scaun Feeder Rive D36 Siege, Negru

90810145010
Livrare 48-72 ore

1.554,12Lei

Scaun Mikado Carp Fine Line 60x50x100cm
Exclusiv online!

Scaun Mikado Carp Fine Line 60x50x100cm

is14-rc008
Livrare 48-72 ore

577,00Lei

Scaun Shakespeare Directors Chair
Exclusiv online!

Scaun Shakespeare Directors Chair

1154483
Livrare 7-14 zile

314,96Lei

Scaun Sonik SK-TEK Pliant Compact, 86x60x44cm

Scaun Sonik SK-TEK Pliant Compact, 86x60x44cm

ec0005
Livrare imediată!

337,67Lei

Scaun Trakker RLX Bedchair Seat, 64x56cm
Exclusiv online!

Scaun Trakker RLX Bedchair Seat, 64x56cm

217300
Livrare 7-14 zile

349,96Lei

Conector Colmic 90°, 15cm, D36/30/25mm
Exclusiv online!

Conector Colmic 90°, 15cm, D36/30/25mm

pa2083c
Livrare 48-72 ore

135,01Lei

Scaun Carp Zoom Super Feeder Competition 55x50x60/100cm

Scaun Carp Zoom Super Feeder Competition 55x50x60/100cm

cz0618
Livrare imediată!

630,00Lei

Scaun Pliabil Nash Banklife Chair, 41x56x42cm

Scaun Pliabil Nash Banklife Chair, 41x56x42cm

t1226
Livrare imediată!

339,99Lei

Sezut Trabucco Modul Genius Box
Exclusiv online!

Sezut Trabucco Modul Genius Box

116-71-070
Livrare 48-72 ore

280,00Lei

Scaun Carp Spirit Blax XL, 65x50x60cm
Exclusiv online!

Scaun Carp Spirit Blax XL, 65x50x60cm

acs520054
Livrare 48-72ore

539,00Lei

Afişare 81 - 100 din 455 (23 pagini)
Queries: 14, Total time: 213.155 ms [By time] [By id] [By file]
1 (0.100)
SELECT data
FROM `oc_session`
WHERE session_id = '1850eaf63e5d31450bbb0fadad'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.110)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (205.065)
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 = '2' AND (pd.tag LIKE "%scaune%") 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:697
5 (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:1547
6 (2.591)
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 80, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
7 (0.137)
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.630)
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:1204
9 (0.110)
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:1223
10 (0.172)
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:982
11 (3.692)
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:904
12 (0.104)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.088)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
14 (0.101)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38