Owner


Carlige Legate Owner S-560 No.8, 65cm, 0.16mm

Carlige Legate Owner S-560 No.8, 65cm, 0.16mm

5691608
Livrare 48-72 ore

13,43Lei

Carlige Legate Owner RL340 53816 Nr.6 Fir 0.20mm

Carlige Legate Owner RL340 53816 Nr.6 Fir 0.20mm

5381606
Livrare 48-72 ore

16,95Lei

Carlig Owner C-3 Carp Tsuyoshi Nr.6

Carlig Owner C-3 Carp Tsuyoshi Nr.6

5000026
Livrare imediată!

14,77Lei

Carlig Owner Minnow S-55BLM 51611 Nr.10

Carlig Owner Minnow S-55BLM 51611 Nr.10

5161104
Livrare imediată!

12,41Lei

ANCORA OWNER ST26 BC Nr.10

ANCORA OWNER ST26 BC Nr.10

5626002
Livrare 48-72 ore

39,46Lei

Ancora Owner ST66 TN Nr.4/0

Ancora Owner ST66 TN Nr.4/0

5666149
Livrare imediată!

99,24Lei

Jig Owner Amaz Jig-28 11751 Bend Fine Wire, No.2, 15buc/plic -23%

Jig Owner Amaz Jig-28 11751 Bend Fine Wire, No.2, 15buc/plic

1175102
Livrare imediată!

21,05Lei(-23%) 16,24Lei

Carlig Owner OH SSW 5115 Nr.5/0

Carlig Owner OH SSW 5115 Nr.5/0

5115002
Livrare imediată!

16,27Lei

Carlig Owner Iseama 50046 Nr 14

Carlig Owner Iseama 50046 Nr 14

5004615
Livrare imediată!

12,41Lei

Carlig Owner Chinta 50319 Nr 5

Carlig Owner Chinta 50319 Nr 5

5031905
Livrare imediată!

11,37Lei

Carlige Owner Furansu Paleta 50560, Nr.7, 15buc/plic

Carlige Owner Furansu Paleta 50560, Nr.7, 15buc/plic

5056007
Livrare 48-72 ore

10,90Lei

Carlig Owner Pint-S 53135 Nr 6

Carlig Owner Pint-S 53135 Nr 6

5313502
Livrare 48-72 ore

11,41Lei

Shad Owner Juster JRS82 82mm Koayu

Shad Owner Juster JRS82 82mm Koayu

801025586130
Livrare imediată!

28,06Lei

Vobler Owner Savoy Shad 5279 SS-80S 80mm 14.2gr 32 Golden Shiner

Vobler Owner Savoy Shad 5279 SS-80S 80mm 14.2gr 32 Golden Shiner

804020043
Livrare 48-72 ore

54,07Lei

Vobler Owner Bug Eye Bait 50mm 6.5gr 65 Negru

Vobler Owner Bug Eye Bait 50mm 6.5gr 65 Negru

804020210
Livrare imediată!

61,66Lei

Carlig Owner 50120 Nr.11 Kappa Style 3 15buc/plic

Carlig Owner 50120 Nr.11 Kappa Style 3 15buc/plic

5012011
Livrare 48-72 ore

11,41Lei

Grub Single Tail Owner RB-3 16 G/S Smoke Ring Single Tail 82914 3.8cm

Grub Single Tail Owner RB-3 16 G/S Smoke Ring Single Tail 82914 3.8cm

8291416
Livrare imediată!

16,55Lei

Carlig Owner Mosquito Hook 5177 Nr.12 12buc/plic

Carlig Owner Mosquito Hook 5177 Nr.12 12buc/plic

5177012
Livrare imediată!

12,26Lei

Shad Owner Shirasu 82585 Bait Glow

Shad Owner Shirasu 82585 Bait Glow

8258503
Livrare imediată!

19,19Lei

Rig Feeder Owner 56930 No.12 0.20 FD 03 Q.Stop

Rig Feeder Owner 56930 No.12 0.20 FD 03 Q.Stop

5693212
Livrare imediată!

19,64Lei

Afişare 241 - 260 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: 90.610 ms [By time] [By id] [By file]
1 (0.086)
SELECT data
FROM `oc_session`
WHERE session_id = '0327e3250f75b946307663e5c5'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.081)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.086)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Owner'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.086)
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 (35.263)
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 (54.852)
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 240,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.156)
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