Owner


Carlig Owner Chika 50354 Nr 12

Carlig Owner Chika 50354 Nr 12

5035403
Livrare 48-72 ore

11,58Lei

Carlig Owner Yamame 50702 Nr 4

Carlig Owner Yamame 50702 Nr 4

5070202
Livrare 48-72 ore

12,08Lei

Carlig Owner Spring CCN With Eye 53125 Nr 12

Carlig Owner Spring CCN With Eye 53125 Nr 12

5312506
Livrare imediată!

15,44Lei

Shad Owner Jr Minnow JRM88 88mm Purple Weenie

Shad Owner Jr Minnow JRM88 88mm Purple Weenie

801025587140
Livrare 48-72 ore

25,88Lei

Vobler Owner Tango Dancer 5249 TD-95 95mm 11gr 13 Baby Bass

Vobler Owner Tango Dancer 5249 TD-95 95mm 11gr 13 Baby Bass

804020102
Livrare 48-72 ore

48,51Lei

CARLIG OWNER CP 50367 Nr.3 Argintiu Rotund CP

CARLIG OWNER CP 50367 Nr.3 Argintiu Rotund CP

5036706
Livrare 48-72 ore

10,91Lei

Carlig Owner 50335 Nr.12 Chinta 16buc/plic

Carlig Owner 50335 Nr.12 Chinta 16buc/plic

5033509
Livrare 48-72 ore

13,09Lei

Carlig Owner Nr.2 Carp DRig -23%

Carlig Owner Nr.2 Carp DRig

565592
Livrare imediată!

22,93Lei(-23%) 17,55Lei

Jig Lestat OWNER Mebaru Shot 11566 JH-82G No.8 3.5gr 5 buc/pac

Jig Lestat OWNER Mebaru Shot 11566 JH-82G No.8 3.5gr 5 buc/pac

1156602
Livrare 48-72 ore

27,03Lei

Kick Tail Owner RB2 13 Ring Kick Tail 82906 Pearl

Kick Tail Owner RB2 13 Ring Kick Tail 82906 Pearl

8290613
Livrare imediată!

16,55Lei

Carlig Owner 5177 No.8 Mosquito Red Hook

Carlig Owner 5177 No.8 Mosquito Red Hook

5177033
Livrare imediată!

12,08Lei

Carlige Offset Owner 5139 Nr.3/0 Wide Gap Plus

Carlige Offset Owner 5139 Nr.3/0 Wide Gap Plus

5139131
Livrare 48-72 ore

26,37Lei

JIG Owner Nelestat No.4/0 Jig-57 253987 White 9buc

JIG Owner Nelestat No.4/0 Jig-57 253987 White 9buc

122539870040
Livrare imediată!

22,07Lei

Ancora Owner CF-66 No.2

Ancora Owner CF-66 No.2

12070256967-2
Livrare imediată!

78,26Lei

Carlig Owner 50281 No.14 Sode Light

Carlig Owner 50281 No.14 Sode Light

5000705
Livrare imediată!

11,58Lei

Fir Owner Broad Fluorine Treated 0.20mm 150m

Fir Owner Broad Fluorine Treated 0.20mm 150m

11070256045-020
Livrare imediată!

46,56Lei

Carlig Owner 50061 Auriu Semirotund Nr 4 - 11buc/plic -12%

Carlig Owner 50061 Auriu Semirotund Nr 4 - 11buc/plic

5006101
Livrare imediată!

8,29Lei(-12%) 7,32Lei

Vierme Owner Shiver Tail 115mm 16 Green Weenie

Vierme Owner Shiver Tail 115mm 16 Green Weenie

1301375597-16
Livrare 48-72 ore

20,75Lei

Carlige Owner Sode 50286, Nr.14, 13buc/plic -22%

Carlige Owner Sode 50286, Nr.14, 13buc/plic

5028611
Livrare imediată!

10,24Lei(-22%) 8,02Lei

Jig Lestat Owner 5149 No.1 1/8Oz Ultra Head Finesse Type 3.54g 5buc/plic

Jig Lestat Owner 5149 No.1 1/8Oz Ultra Head Finesse Type 3.54g 5buc/plic

1209025149021
Livrare 48-72 ore

34,26Lei

Afişare 221 - 240 din 1550 (78 pagini)
💬
WhatsApp Chat
👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)
Queries: 7, Total time: 102.185 ms [By time] [By id] [By file]
1 (0.090)
SELECT data
FROM `oc_session`
WHERE session_id = '5882fbd20c0858a5c81bcadaee'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.089)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.141)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Owner'
/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 = '15' AND m2s.store_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (44.985)
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 = '15'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (56.604)
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, ps.price AS special, p.viewed, p.price
FROM oc_product p
LEFT JOIN (SELECT pss.price, pss.product_id
FROM oc_product_special pss GROUP BY pss.product_id) ps 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 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 = '15' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 220,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.147)
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