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

Oferte speciale


Carlige Legate One More Cast Tackle Chods Away Short, Nr.4, 3buc/pac -16%

Carlige Legate One More Cast Tackle Chods Away Short, Nr.4, 3buc/pac

omcca4
Livrare imediată!

32,45Lei(-16%) 27,35Lei

Carlige Legate One More Cast Tackle Chods Away Short, Nr.6, 3buc/pac -16%

Carlige Legate One More Cast Tackle Chods Away Short, Nr.6, 3buc/pac

omcca6
Livrare imediată!

32,45Lei(-16%) 27,35Lei

Carlige Legate One More Cast Tackle Chods Away Short, Nr.8, 3buc/pac -16%

Carlige Legate One More Cast Tackle Chods Away Short, Nr.8, 3buc/pac

omcca8
Livrare imediată!

32,45Lei(-16%) 27,35Lei

Carlige Legate Owner Rl1481 53818 Nr.2 Fir 0.30mm -20%

Carlige Legate Owner Rl1481 53818 Nr.2 Fir 0.30mm

5381802
Livrare imediată!

11,51Lei(-20%) 9,20Lei

Carlige Legate Owner Rl175 53815 Nr.8 Fir 0.18mm -20%

Carlige Legate Owner Rl175 53815 Nr.8 Fir 0.18mm

5381508
Livrare imediată!

11,51Lei(-20%) 9,20Lei

Carlige Legate Owner Rl5100 53812 Nr.1 Fir 0.30mm -20%

Carlige Legate Owner Rl5100 53812 Nr.1 Fir 0.30mm

5381201
Livrare imediată!

11,51Lei(-20%) 9,20Lei

Carlige Legate Pb Kd Rig, 20lbs, Nr.8, 1buc/pac -18%

Carlige Legate Pb Kd Rig, 20lbs, Nr.8, 1buc/pac

kdr08
Livrare imediată!

18,50Lei(-18%) 15,13Lei

Carlige Legate Strategy Chod Rig Medium Nr.4 -31%

Carlige Legate Strategy Chod Rig Medium Nr.4

008036-00203-00000
Livrare imediată!

33,60Lei(-31%) 23,27Lei

Carlige Legate Strategy Chod Rig Medium Nr.6 -31%

Carlige Legate Strategy Chod Rig Medium Nr.6

008036-00204-00000
Livrare imediată!

33,60Lei(-31%) 23,27Lei

Carlige Legate Strategy Chod Rig Medium Nr.8 -19%

Carlige Legate Strategy Chod Rig Medium Nr.8

008036-00205-00000
Livrare imediată!

39,00Lei(-19%) 31,40Lei

Carlige Matrix Carp Baggers Barbless 10bucati Plic Nr.14 -18%

Carlige Matrix Carp Baggers Barbless 10bucati Plic Nr.14

ghk025
Livrare imediată!

9,55Lei(-18%) 7,80Lei

Carlige Maver Jurassic Serie J13 Nr 12 -1%

Carlige Maver Jurassic Serie J13 Nr 12

j1301200
Livrare imediată!

5,51Lei(-1%) 5,47Lei

Carlige Maver Jurassic Serie J22 Nr 10 -1%

Carlige Maver Jurassic Serie J22 Nr 10

j2201000
Livrare imediată!

5,51Lei(-1%) 5,47Lei

Carlige Maver Katana 1231 Bronz Nr 2 -23%
Exclusiv online!

Carlige Maver Katana 1231 Bronz Nr 2

1231a002
Livrare 48-72 ore

12,00Lei(-23%) 9,24Lei

Carlige Maver Katana 1231 Bronz Nr 4 -31%

Carlige Maver Katana 1231 Bronz Nr 4

1231a004
Livrare imediată!

12,00Lei(-31%) 8,32Lei

Carlige Maver Katana Seria Trout Kt4 Nr 4 Bronz -30%

Carlige Maver Katana Seria Trout Kt4 Nr 4 Bronz

kt04a004
Livrare imediată!

11,00Lei(-30%) 7,71Lei

Carlige Maver Katana T180 Tungsten Nr 1 -11%

Carlige Maver Katana T180 Tungsten Nr 1

t180a001
Livrare imediată!

13,00Lei(-11%) 11,57Lei

Carlige Maver Mv2 Long Shank Nr 2 -36%
Exclusiv online!

Carlige Maver Mv2 Long Shank Nr 2

t353
Livrare 48-72 ore

15,00Lei(-36%) 9,53Lei

Carlige Maver Mv2 Long Shank Nr 4 -36%
Exclusiv online!

Carlige Maver Mv2 Long Shank Nr 4

t354
Livrare 48-72 ore

15,00Lei(-36%) 9,53Lei

Carlige Maver Mv2 Long Shank Nr 8 -36%

Carlige Maver Mv2 Long Shank Nr 8

t350
Livrare imediată!

15,00Lei(-36%) 9,53Lei

Afişare 4181 - 4200 din 9249 (463 pagini)
Queries: 5, Total time: 885.943 ms [By time] [By id] [By file]
1 (0.101)
SELECT data
FROM `oc_session`
WHERE session_id = '280126669f5f2743517a325e86'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.118)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (466.308)
SELECT COUNT(1) AS total
FROM oc_product_special ps
LEFT JOIN oc_product p ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p2s.store_id = '2' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) AND p.quantity > '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1714
4 (419.282)
SELECT DISTINCT ps.product_id
FROM oc_product_special ps
LEFT JOIN oc_product p ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p.quantity > '0' AND p2s.store_id = '2' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) GROUP BY ps.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 4180,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.134)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37