FL.


Mulineta FL SF 4000

Mulineta FL SF 4000

7262195359612
Livrare imediată!

88,00Lei

LANSETA, SPINNING, PRO, FL, MEBARU, 2.08M, 0.5-5G, , 64-7410, Lansete Rapitori, Lansete Rapitori FL., Lansete FL., Rapitori FL., FL.
Maner Minciog FL Strategist 200K 2 Segmente 2M

Maner Minciog FL Strategist 200K 2 Segmente 2M

7153210957350
Livrare imediată!

158,70Lei

Vobler, FL, FL504, Floating, 40mm, 5.5g, Depth, 1.5m, Colour, 117, fl504-floating-1.5m-40mm-5.5g-117, Voblere Floating, Voblere Floating FL., FL.
FIR, TEXTIL, FEEDER, PRO, FL, SINKNKING, X8, 0.16MM, 150M, 19KG, 64-4519, Fire Textile Monofilament Feeder, Fire Textile Monofilament Feeder FL., Fire FL., Textile FL., Monofilament FL., Feeder FL., FL.
Vobler FL FL601 Sinking 70mm 16.0g Depth Deepwater Colour 06

Vobler FL FL601 Sinking 70mm 16.0g Depth Deepwater Colour 06

fl601-sinking-deepwater-70mm-16.0g-06
Livrare imediată!

17,10Lei

SPINI MOMEALA PRO FL 7MM 25buc/plic

SPINI MOMEALA PRO FL 7MM 25buc/plic

64-26727
Livrare imediată!

8,90Lei

Montura, FL, Leadcore, Plumb, Pierdut, Long, Cast, Plumb, 100, Gr, Carlig, BNR, Nr, 6, 64-0192, Monturi Crap, Monturi Crap FL., FL.
Mulineta FL Zero-X 1000

Mulineta FL Zero-X 1000

64-8004
Livrare imediată!

107,00Lei

SISTEM COMPLET ZIG RIG PRO FL PT LICHID ORANGE ROZ

SISTEM COMPLET ZIG RIG PRO FL PT LICHID ORANGE ROZ

64-65900
Livrare imediată!

20,90Lei

Carlige Legate FL Method Feeder Cu Spin 7mm Carlig Power Nr 12 6Buc/Set

Carlige Legate FL Method Feeder Cu Spin 7mm Carlig Power Nr 12 6Buc/Set

64-0772
Livrare imediată!

12,38Lei

Porumb, Artificial, Flotant, FL, 20Buc/Plic, Marime, M, Mix, Color, 6427559019538, Porumb Artificial, Porumb Artificial FL., Porumb FL., Artificial FL., FL.
Varga FL Tele Success 5 M

Varga FL Tele Success 5 M

309-500
Livrare imediată!

149,90Lei

MONTURA, FEEDER, FL, METHOD, FARA, TIJA, 80G, CARLIG, NR, 10, SPIN, 10MM, CU, PORUMB, FLOTANT, E, V, 64-1967-80-10, Monturi Complete Feeder, Monturi Complete Feeder FL., Monturi FL., Complete FL., Feeder FL., FL.
MULINETA, PRO, FL, BLACK, CUSTOM, STRATEGIST, 14000, 64-1811, Mulinete Crap, Mulinete Crap FL., Mulinete FL., Crap FL., FL. -22%

MULINETA, PRO, FL, BLACK, CUSTOM, STRATEGIST, 14000, 64-1811, Mulinete Crap, Mulinete Crap FL., Mulinete FL., Crap FL., FL.

64-1811
Livrare imediată!

489,90Lei(-22%) 379,90Lei

Minciog FL Predator Telescopic Cauciucat 85 x 70 CM -20%

Minciog FL Predator Telescopic Cauciucat 85 x 70 CM

64-2302
Livrare imediată!

250,00Lei(-20%) 199,90Lei

Undita Chinezeasca FL STR Strong King 5 H, 7.20m

Undita Chinezeasca FL STR Strong King 5 H, 7.20m

2642325261759
Livrare imediată!

303,40Lei

MULINETA FL QC 4000 7RULMENTI 4.9:1

MULINETA FL QC 4000 7RULMENTI 4.9:1

64-1330
Livrare imediată!

79,90Lei

PLUTA, CHINEZASCA, INTELIGENTA, FL, CU, BATERIE, 3G,, 40CM,, CULOARE, ALBA, A002, 64-45049, Plute Stationar, Plute Stationar FL., Plute FL., Stationar FL., FL.
Set 5 Varfuri Feeder FL Carbon, Grosime 3.1mm, 120g/150g/180g/200g/250g

Set 5 Varfuri Feeder FL Carbon, Grosime 3.1mm, 120g/150g/180g/200g/250g

64-1337
Livrare imediată!

85,89Lei

Afişare 101 - 120 din 1620 (81 pagini)
Queries: 7, Total time: 92.663 ms [By time] [By id] [By file]
1 (0.112)
SELECT data
FROM `oc_session`
WHERE session_id = '63beab041e0b36fb0ccb656a23'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.110)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.141)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.135)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '13' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (36.659)
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 = '0' AND p.manufacturer_id = '13'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (55.326)
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 = '0' AND p.manufacturer_id = '13' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 100,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.180)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38