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


POP-UP MAINLINE MINI CELL 10MM
Exclusiv online!

POP-UP MAINLINE MINI CELL 10MM

a0.m.m21020
Livrare 24-48 ore

52,11Lei

Boilies Mainline High Visual Mini Pop-ups Yellow Pineapple Juice 10mm
Exclusiv online!

Boilies Mainline High Visual Mini Pop-ups Yellow Pineapple Juice 10mm

a0.m.m13007
Livrare 24-48 ore

54,12Lei

POP-UP MAINLINE MINI NEW GRANGE 10MM
Exclusiv online!

POP-UP MAINLINE MINI NEW GRANGE 10MM

a0.m.m21021
Livrare 24-48 ore

49,36Lei

POP-UP FLUO TUTTI FRUTTI 10MM MAINLINE
Exclusiv online!

POP-UP FLUO TUTTI FRUTTI 10MM MAINLINE

a0.m.m13009
Livrare 24-48 ore

54,12Lei

Aditiv Lichid Mainline Syrup Match Strawberry Tutti 250ml
Exclusiv online!

Aditiv Lichid Mainline Syrup Match Strawberry Tutti 250ml

a0.m.mm2710
Livrare 24-48 ore

35,24Lei

POP-UP, MAINLINE, WAFTER, BARRELS, CRANBERRY, ORANGE, 12X15MM, a0.m.m35001, Critic Echilibrate - Wafters, Critic Echilibrate - Wafters Mainline, Mainline
Aditiv Lichid Mainline Syrup Match Activ 8 250ml
Exclusiv online!

Aditiv Lichid Mainline Syrup Match Activ 8 250ml

a0.m.mm2707
Livrare 24-48 ore

35,24Lei

Pelete, Mainline, Match, Coarse, 6MM, 1KG, a0.m.mm3203, Pelete Pentru Nadit, Pelete Pentru Nadit Mainline, Mainline
POP-UP, MAINLINE, HIGT, IMPACT, , DIAMOND, WHITES, , 15MM, a0.m.m23063, Critic Echilibrate - Wafters, Critic Echilibrate - Wafters Mainline, Critic Mainline, Echilibrate Mainline, Wafters Mainline, Mainline
POP-UP MAINLINE WAFTER BARRELS MULBERRY JUICE 12X15MM
Exclusiv online!

POP-UP MAINLINE WAFTER BARRELS MULBERRY JUICE 12X15MM

a0.m.m35003
Livrare 24-48 ore

42,08Lei

ADITIV MAINLINE SMART LIQUID FISH 250ML
Exclusiv online!

ADITIV MAINLINE SMART LIQUID FISH 250ML

a0.m.m10005
Livrare 24-48 ore

73,90Lei

ADITIV MAINLINE SYRUP MATCH PELLET ENHANCER OIL 250ML
Exclusiv online!

ADITIV MAINLINE SYRUP MATCH PELLET ENHANCER OIL 250ML

a0.m.mm2711
Livrare 24-48 ore

35,24Lei

POP-UP, MAINLINE, WAFTER, BARRELS, PEACH, 12X15MM, a0.m.m35002, Critic Echilibrate - Wafters, Critic Echilibrate - Wafters Mainline, Mainline
POP-UP, MAINLINE, WAFTER, BARRELS, BLACKCURRANT, 12X15MM, a0.m.m35004, Critic Echilibrate - Wafters, Critic Echilibrate - Wafters Mainline, Mainline
Pop up Mainline Hi Visual Pink Shellfish Black Pepper 12mm
Exclusiv online!

Pop up Mainline Hi Visual Pink Shellfish Black Pepper 12mm

a0.m.m13030
Livrare 24-48 ore

54,12Lei

ADITIV MAINLINE SMART LIQUID CREAM 250ML

ADITIV MAINLINE SMART LIQUID CREAM 250ML

a0.m.m10007
Livrare imediată!

84,69Lei

NADA MAINLINE MIX MATCH FINE METHOD 1KG

NADA MAINLINE MIX MATCH FINE METHOD 1KG

a0.m.mm2901
Livrare imediată!

32,77Lei

ADITIV MAINLINE MATCH PELLET YELLOW SCOPEX PINEAPPLE 100ML
Exclusiv online!

ADITIV MAINLINE MATCH PELLET YELLOW SCOPEX PINEAPPLE 100ML

a0.m.mm4002
Livrare 24-48 ore

51,74Lei

ADITIV MAINLINE SMART LIQUID FRUIT 250ML

ADITIV MAINLINE SMART LIQUID FRUIT 250ML

a0.m.m10006
Livrare imediată!

84,69Lei

Pop, Up, Mainline, Wafter, Cell, 12mm,, 250ml, a0.m.m21036, Critic Echilibrate / Wafters, Critic Echilibrate / Wafters Mainline, Critic Mainline, Echilibrate Mainline, Wafters Mainline, Mainline
Afişare 61 - 80 din 160 (8 pagini)
Queries: 14, Total time: 9.492 ms [By time] [By id] [By file]
1 (0.113)
SELECT data
FROM `oc_session`
WHERE session_id = '9634dc89a963f19576fbc8d016'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.116)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.080)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (5.521)
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, if (SUM(if((f.filter_group = "m0" AND filter_id IN (162)), 1, 0)) > 0, 1, 0) 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 p.manufacturer_id = '162' AND (pd.tag LIKE "%mainline%") 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:698
5 (0.153)
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:1555
6 (1.146)
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 60, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.232)
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:1209
8 (0.117)
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:1231
9 (0.116)
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:996
10 (1.493)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS tp
INNER JOIN `oc_bf_filter` AS f ON (f.product_id = tp.product_id)
WHERE f.language_id = '2' AND tp.match_filters < 1 AND f.filter_group IN ('m0') GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:910
11 (0.100)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS tp
INNER JOIN `oc_bf_filter` AS f ON (f.product_id = tp.product_id)
WHERE f.language_id = '2' AND tp.match_filters < 1 AND f.filter_group IN ('m0') GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:950
12 (0.090)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.110)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
14 (0.105)
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