Bass Assassin


Shad BASS ASSASIN Turbo, Cajun Croak, 10cm, 10buc/pac

Shad BASS ASSASIN Turbo, Cajun Croak, 10cm, 10buc/pac

tsa30303
Livrare imediată!

35,47Lei

SHAD BASS ASSASSIN TURBO SHAD WHITE PINK TAIL 10CM 10BUC/PLIC

SHAD BASS ASSASSIN TURBO SHAD WHITE PINK TAIL 10CM 10BUC/PLIC

091538302537
Livrare imediată!

35,47Lei

SHAD BASS ASSASSIN TURBO SHAD ELECTRIC SHAD 10CM 10BUC/PLIC

SHAD BASS ASSASSIN TURBO SHAD ELECTRIC SHAD 10CM 10BUC/PLIC

091538324492
Livrare imediată!

33,54Lei

SHAD BASS ASSASIN DIE DAPPER 8.9CM

SHAD BASS ASSASIN DIE DAPPER 8.9CM

bsadda
Livrare 48-72 ore

28,25Lei

SHAD BASS ASSASIN LITL BOSS WB31461 BLUEGILL FLASH 9CM 6 BUC PLIC

SHAD BASS ASSASIN LITL BOSS WB31461 BLUEGILL FLASH 9CM 6 BUC PLIC

091538314615
Livrare imediată!

31,50Lei

Shad BASS ASSASIN Turbo Walleye, Butt Naked, 10cm, 10buc/pac

Shad BASS ASSASIN Turbo Walleye, Butt Naked, 10cm, 10buc/pac

wa32275
Livrare imediată!

40,57Lei

SHAD BASS ASSASSIN TURBO 10CM 10BUC ALBINO FIRE TAIL

SHAD BASS ASSASSIN TURBO 10CM 10BUC ALBINO FIRE TAIL

wa32240
Livrare imediată!

35,47Lei

SHAD BASS ASSASSIN TURBO SHAD SHRIMP 10CM 10BUC/PLIC -22%

SHAD BASS ASSASSIN TURBO SHAD SHRIMP 10CM 10BUC/PLIC

091538304098
Livrare imediată!

33,90Lei(-22%) 26,32Lei

Shad BASS ASSASIN Turbo Walleye, Fried Chicken, 10cm, 10buc/pac

Shad BASS ASSASIN Turbo Walleye, Fried Chicken, 10cm, 10buc/pac

wa32274
Livrare imediată!

36,38Lei

SHAD BASS ASSASSIN TURBO SHAD ALBINO HALO 10CM 10BUC/PLIC

SHAD BASS ASSASSIN TURBO SHAD ALBINO HALO 10CM 10BUC/PLIC

091538303282
Livrare 48-72 ore

36,38Lei

Shad Bass Assassin Elite Shiner 10cm Bluegill Flash -12%

Shad Bass Assassin Elite Shiner 10cm Bluegill Flash

bsaes95461
Livrare imediată!

27,00Lei(-12%) 23,89Lei

SHAD BASS ASSASIN LITL BOSS WB31558 LANE S TOAD 9CM 6 BUC PLIC -33%

SHAD BASS ASSASIN LITL BOSS WB31558 LANE S TOAD 9CM 6 BUC PLIC

091538315582
Livrare imediată!

30,00Lei(-33%) 20,24Lei

Shad BASS ASSASIN Turbo, Limetreuse Ghost, 10cm, 10buc/pac

Shad BASS ASSASIN Turbo, Limetreuse Ghost, 10cm, 10buc/pac

tsa30475
Livrare imediată!

36,38Lei

SHAD BASS ASSASIN LITL BOSS WB31312 MAMA S 9CM 6 BUC PLIC

SHAD BASS ASSASIN LITL BOSS WB31312 MAMA S 9CM 6 BUC PLIC

091538313120
Livrare imediată!

31,50Lei

Shad BASS ASSASIN Turbo, Copperhead, 10cm, 10buc/pac

Shad BASS ASSASIN Turbo, Copperhead, 10cm, 10buc/pac

tsa30262
Livrare imediată!

35,47Lei

Shad BASS ASSASIN Turbo Walleye, PT 2000, 10cm, 10buc/pac

Shad BASS ASSASIN Turbo Walleye, PT 2000, 10cm, 10buc/pac

wa32324
Livrare imediată!

35,47Lei

SHAD BASS ASSASSIN TURBO SHAD ELECTRIC CHICKEN 10CM 10BUC/PLIC

SHAD BASS ASSASSIN TURBO SHAD ELECTRIC CHICKEN 10CM 10BUC/PLIC

091538303763
Livrare 48-72 ore

34,45Lei

Shad BASS ASSASIN Turbo, Neon Mercury, 10cm, 10buc/pac

Shad BASS ASSASIN Turbo, Neon Mercury, 10cm, 10buc/pac

tsa30308
Livrare imediată!

35,47Lei

SHAD BASS ASSASSIN TURBO SHAD SEXY SHAD 10CM 10BUC/PLIC -18%

SHAD BASS ASSASSIN TURBO SHAD SEXY SHAD 10CM 10BUC/PLIC

091538302636
Livrare imediată!

32,00Lei(-18%) 26,32Lei

SHAD BASS ASSASSIN TURBO SHAD BLUEGILL FLASH 10CM 10BUC/PLIC

SHAD BASS ASSASSIN TURBO SHAD BLUEGILL FLASH 10CM 10BUC/PLIC

091538324614
Livrare imediată!

35,47Lei

Afişare 61 - 80 din 103 (6 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: 94.275 ms [By time] [By id] [By file]
1 (0.138)
SELECT data
FROM `oc_session`
WHERE session_id = '476686c4a4376592b0d2cfe677'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.106)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.113)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Bass-Assassin'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.118)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '309' AND m2s.store_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (51.387)
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 = '309'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (42.296)
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 = '309' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 60,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.117)
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