Lineaeffe


Lanseta Lineaeffe Tele HD Boat 2.70m/150g

Lanseta Lineaeffe Tele HD Boat 2.70m/150g

l.2280827
Livrare imediată!

83,49Lei

MULINETA LINEAEFFE MATCH LINE RD 3000

MULINETA LINEAEFFE MATCH LINE RD 3000

l.1207430
Livrare imediată!

64,18Lei

LANSETA BOLOGNESE LINEAEFFE ARTISTIC 5.00M 5 25G

LANSETA BOLOGNESE LINEAEFFE ARTISTIC 5.00M 5 25G

l.2517805
Livrare 24-48 ore

344,06Lei

MULINETA LINEAEFFE VIGOR MUSTANG FD 3000

MULINETA LINEAEFFE VIGOR MUSTANG FD 3000

l.1229730
Livrare imediată!

58,52Lei

Vobler Lineaeffe Nomura Floater Minn Culoare Green Yellow Red 7cm 4.3g -30%

Vobler Lineaeffe Nomura Floater Minn Culoare Green Yellow Red 7cm 4.3g

nm.60116807
Livrare 24-48 ore

37,22Lei(-30%) 26,05Lei

INEL, LINEAEFE, 1, PICIOR, SIC, D=20,0MM, a9.2999220, Inele de Lanseta, Inele de Lanseta Lineaeffe, Lineaeffe
VIRF LINEAEFE CARBON L100CM D4.75/1.4MM

VIRF LINEAEFE CARBON L100CM D4.75/1.4MM

l.2979951
Livrare imediată!

33,92Lei

Cosulet Lineaeffe Feeder Cilindric Lestat Mediu 20 g

Cosulet Lineaeffe Feeder Cilindric Lestat Mediu 20 g

a.4922620
Livrare imediată!

5,62Lei

Opritoare, Lineaeffe, Flotante,, Multicolor,, 6buc/plic, Marime:, S, 10x17.9mm, a.4945001, Opritoare Porumb Boilies, Opritoare Porumb Boilies Lineaeffe, Lineaeffe
Varga Lineaeffe Tele Dream Carbon Evolution Pole 7M -20%

Varga Lineaeffe Tele Dream Carbon Evolution Pole 7M

l.2516770
Livrare 24-48 ore

456,81Lei(-20%) 365,45Lei

ANTI TANGLE LINEAEFFE FLUO CURBAT CU AGRAFA 15CM 3BUC/PLIC NEGRU

ANTI TANGLE LINEAEFFE FLUO CURBAT CU AGRAFA 15CM 3BUC/PLIC NEGRU

a.4990284
Livrare imediată!

5,62Lei

SET, PLUMBI, LINEAEFFE, CUTIE, TORPILLE, 3.00G, a3.8166030, Plumbi Stationar, Plumbi Stationar Lineaeffe, Lineaeffe
BULDO LINEAEFFE OVAL TRANSPARENT MEDIUM 30g

BULDO LINEAEFFE OVAL TRANSPARENT MEDIUM 30g

a.4900010
Livrare imediată!

4,76Lei

INEL, LINEAEFFE, VARF, TITAN, TUB=1.6MM, D=4MM, A9.3000216, Inele de Lanseta, Inele de Lanseta Lineaeffe, Lineaeffe
Mulineta Lineaeffe Shizuka SK14 7000, 2rul, 1GRA+Fir, 0.45mm/310m, 3.9:1

Mulineta Lineaeffe Shizuka SK14 7000, 2rul, 1GRA+Fir, 0.45mm/310m, 3.9:1

l.s1001470
Livrare 24-48 ore

86,62Lei

MANER CARBON LINEAEFFE TELE PENTRU MINCIOG 3M

MANER CARBON LINEAEFFE TELE PENTRU MINCIOG 3M

a2.6300630
Livrare imediată!

173,24Lei

MINCIOG LINEAEFFE 2,00M.PLASA RARA

MINCIOG LINEAEFFE 2,00M.PLASA RARA

a2.m6100550
Livrare imediată!

89,24Lei

Lanseta telescopica Lineaeffe Drago/Pro Lord 3.00m/20-50g

Lanseta telescopica Lineaeffe Drago/Pro Lord 3.00m/20-50g

l.2024300
Livrare 24-48 ore

67,84Lei

SHAD LINEAEFFE NOMURA GATOR 7,5CM/2,5G CHART GREEN 10BUC/PL -30%

SHAD LINEAEFFE NOMURA GATOR 7,5CM/2,5G CHART GREEN 10BUC/PL

f1.nm.70001407
Livrare 24-48 ore

35,60Lei(-30%) 24,92Lei

INEL LINEAEFFE CULISANT TITAN D=2,8/6MM

INEL LINEAEFFE CULISANT TITAN D=2,8/6MM

a9.3000428
Livrare imediată!

4,50Lei

Afişare 141 - 160 din 623 (32 pagini)
Queries: 7, Total time: 66.502 ms [By time] [By id] [By file]
1 (0.135)
SELECT data
FROM `oc_session`
WHERE session_id = 'f45f7276cbbe71f0a251e41fd6'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.105)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.132)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Lineaeffe'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.129)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '163' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (28.835)
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 = '3' AND p.manufacturer_id = '163'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (37.064)
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 = '3' AND p.manufacturer_id = '163' 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.102)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38