Sportex


Lanseta Sportex XCLUSIVE FEEDER NT LIGHT 330 40-80gr

Lanseta Sportex XCLUSIVE FEEDER NT LIGHT 330 40-80gr

lf3314
Livrare 48-72 ore

1.090,00Lei

HUSA, SPORTEX, PROTECTIE, LANSETE, NEOPRENE, Medium, s300720, Benzi Fixare / Protectii Lansete, Benzi Fixare / Protectii Lansete Sportex, Sportex
LANSETA SPORTEX CURVE SPIN RS-2 2.70M 40G 2SEG

LANSETA SPORTEX CURVE SPIN RS-2 2.70M 40G 2SEG

ps2712
Livrare 48-72 ore

899,00Lei

Lanseta Sportex Catapult Cs-4 Carp Spod 13ft 3.96m 6.50lbs

Lanseta Sportex Catapult Cs-4 Carp Spod 13ft 3.96m 6.50lbs

ca143650
Livrare 48-72 ore

1.340,00Lei

Lanseta, Sportex, Rapid, Spin, 240, 20g, rp2401, Lansete Rapitori, Lansete Rapitori Sportex, Sportex

Lanseta, Sportex, Rapid, Spin, 240, 20g, rp2401, Lansete Rapitori, Lansete Rapitori Sportex, Sportex

rp2401
Livrare imediată!

620,00Lei

LANSETA SPORTEX HYPERION XT 2.40M 26-48G -30%

LANSETA SPORTEX HYPERION XT 2.40M 26-48G

hp2412
Livrare imediată!

1.868,00Lei(-30%) 1.308,00Lei

Lanseta, Sportex, BLACK, PEARL, GT-3, 240, 20gr, bp2401, Lansete Rapitori, Lansete Rapitori Sportex, Sportex
HUSA Sportex RIGIDA LANSETE V 2 COMPARTIMENTE 190CM Grey

HUSA Sportex RIGIDA LANSETE V 2 COMPARTIMENTE 190CM Grey

s307198
Livrare 48-72 ore

810,00Lei

Lanseta Sportex NEPTOON BOAT 215 20lbs

Lanseta Sportex NEPTOON BOAT 215 20lbs

jo2134
Livrare 48-72 ore

725,00Lei

Lanseta SPORTEX Rapid Feeder Heavy 3.90m, 120-210g, 3+3seg

Lanseta SPORTEX Rapid Feeder Heavy 3.90m, 120-210g, 3+3seg

hf4220
Livrare imediată!

1.170,00Lei

LANSETA, SPORTEX, HYDRA, SPIRIT, 2.10M, 40G, 2SEG, hy2102, Lansete Rapitori, Lansete Rapitori Sportex, Sportex
Lanseta Sportex Morion Stalker Selection 10ft 3.00m 3.00lbs

Lanseta Sportex Morion Stalker Selection 10ft 3.00m 3.00lbs

mo142422
Livrare 48-72 ore

1.480,00Lei

Lanseta Sportex Jig-Xpert Zander 192 19-48g

Lanseta Sportex Jig-Xpert Zander 192 19-48g

jx1802
Livrare imediată!

600,00Lei

Lanseta Sportex Captor Spin 2.70m 72-95g 2seg -25%

Lanseta Sportex Captor Spin 2.70m 72-95g 2seg

cp2704
Livrare 48-72 ore

957,00Lei(-25%) 717,43Lei

Lanseta Sportex ADVANCER CRAP 12FT 3.66M 3.00lbs

Lanseta Sportex ADVANCER CRAP 12FT 3.66M 3.00lbs

ad151300
Livrare 48-72 ore

513,00Lei

Lanseta, Sportex, TIBORON, EXTEND, SPIN, CARBON, 270, 40gr, te2702, Lansete Rapitori, Lansete Rapitori Sportex, Sportex
MINCIOG SPORTEX PREDATOR CAUCIUCAT 70x60cm

MINCIOG SPORTEX PREDATOR CAUCIUCAT 70x60cm

s401002
Livrare imediată!

489,99Lei

LANSETA SPORTEX TOP CAT VERTICAL 198 13-300gr

LANSETA SPORTEX TOP CAT VERTICAL 198 13-300gr

tw1919
Livrare 48-72 ore

1.060,00Lei

LANSETA SPORTEX NOVA VERTICAL RS-2 1.95M 30G 2seg

LANSETA SPORTEX NOVA VERTICAL RS-2 1.95M 30G 2seg

pt1921
Livrare 48-72 ore

720,00Lei

LANSETA SPORTEX D.N.A CS-2 3.96M 3.75LBS 2SEG

LANSETA SPORTEX D.N.A CS-2 3.96M 3.75LBS 2SEG

dn145335
Livrare 48-72 ore

1.870,00Lei

Afişare 141 - 160 din 357 (18 pagini)
Queries: 7, Total time: 64.492 ms [By time] [By id] [By file]
1 (0.130)
SELECT data
FROM `oc_session`
WHERE session_id = '12a960c7a0418d4f59712b4f2a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.107)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.143)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Sportex'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.142)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '192' AND m2s.store_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (30.624)
SELECT COUNT(1) AS total
FROM oc_product p
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 pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '2' AND p.manufacturer_id = '192'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (33.230)
SELECT p.product_id, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id 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()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
FROM oc_product p
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 pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '2' AND p.manufacturer_id = '192' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 140,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.116)
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