Bass Assassin


SHAD BASS ASSASSIN TURBO SHAD WALLEYE ELECTRIC BLUE WHITE TAIL 10CM 10BUC/PLIC

SHAD BASS ASSASSIN TURBO SHAD WALLEYE ELECTRIC BLUE WHITE TAIL 10CM 10BUC/PLIC

tsa30236
Livrare imediată!

33,54Lei

SHAD BASS ASSASSIN TURBO SHAD WALLEYE CROWN ICE 10CM 10BUC/PLIC -34%

SHAD BASS ASSASSIN TURBO SHAD WALLEYE CROWN ICE 10CM 10BUC/PLIC

091538323488
Livrare imediată!

32,00Lei(-34%) 21,24Lei

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

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

tsa30516
Livrare imediată!

35,47Lei

Shad Shad Bass Assassin Turbo Shad 10cm Glow Fire Tail

Shad Shad Bass Assassin Turbo Shad 10cm Glow Fire Tail

bsatsa30249
Livrare imediată!

41,58Lei

SHAD BASS ASSASIN LITL BOSS WB31423 SILVER FLASH MIMMOW 9CM 6 BUC PLIC

SHAD BASS ASSASIN LITL BOSS WB31423 SILVER FLASH MIMMOW 9CM 6 BUC PLIC

091538314233
Livrare 48-72 ore

32,42Lei

Shad Bass Assasin Curly, Culoare Albino Shad, 5cm, 10buc/plic

Shad Bass Assasin Curly, Culoare Albino Shad, 5cm, 10buc/plic

csa35330
Livrare imediată!

21,34Lei

SHAD BASS ASSASIN TURBO 10CM 10BUC SMOKE WAHON

SHAD BASS ASSASIN TURBO 10CM 10BUC SMOKE WAHON

tsa30339
Livrare imediată!

34,45Lei

SHAD BASS ASSASSIN TURBO SHAD CHARTREUSE WOODPECKER 10CM 10BUC/PLIC

SHAD BASS ASSASSIN TURBO SHAD CHARTREUSE WOODPECKER 10CM 10BUC/PLIC

091538303916
Livrare 48-72 ore

34,45Lei

Shad BASS ASSASIN Turbo Walleye, Albino Shad, 10cm, 10buc/pac

Shad BASS ASSASIN Turbo Walleye, Albino Shad, 10cm, 10buc/pac

wa32330
Livrare imediată!

42,50Lei

SHAD BASS ASSASSIN TURBO SHAD CALCASIEU BREW 10CM 10BUC/PLIC

SHAD BASS ASSASSIN TURBO SHAD CALCASIEU BREW 10CM 10BUC/PLIC

091538303268
Livrare imediată!

35,47Lei

Shad BASS ASSASIN Turbo, Violet Moon, 10cm, 10buc/pac

Shad BASS ASSASIN Turbo, Violet Moon, 10cm, 10buc/pac

tsa30433
Livrare imediată!

35,47Lei

SHAD BASS ASSASIN TURBO 10CM SMOKE WAGON

SHAD BASS ASSASIN TURBO 10CM SMOKE WAGON

wa32339
Livrare imediată!

40,57Lei

SHAD BASS ASSASIN LITL BOSS WB31540 CHICO S RED EAR 9CM 6 BUC PLIC -33%

SHAD BASS ASSASIN LITL BOSS WB31540 CHICO S RED EAR 9CM 6 BUC PLIC

091538315407
Livrare imediată!

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

SHAD BASS ASSASSIN SPLIT TAIL SHAD 10CM 8BUC CHARTREAUSE WOODPECKER

SHAD BASS ASSASSIN SPLIT TAIL SHAD 10CM 8BUC CHARTREAUSE WOODPECKER

sts39391
Livrare imediată!

22,25Lei

SHAD BASS ASSASIN LITL BOSS WB31312 BLACH SHAD 9CM 6 BUC PLIC -33%

SHAD BASS ASSASIN LITL BOSS WB31312 BLACH SHAD 9CM 6 BUC PLIC

091538313007
Livrare imediată!

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

Shad Bass Assassin Elite Shiner Wakasagi 10cm -15%

Shad Bass Assassin Elite Shiner Wakasagi 10cm

bsaes95311
Livrare imediată!

27,00Lei(-15%) 22,97Lei

SHAD BASS ASSASIN TURBO TSA30374 PINK DIAMOND 10 cm 10 buc plic

SHAD BASS ASSASIN TURBO TSA30374 PINK DIAMOND 10 cm 10 buc plic

091538303749
Livrare imediată!

34,45Lei

Shad BASS ASSASIN Turbo Walleye, Pimp Daddy, 10cm, 10buc/pac

Shad BASS ASSASIN Turbo Walleye, Pimp Daddy, 10cm, 10buc/pac

wa32569
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

Afişare 81 - 100 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: 58.516 ms [By time] [By id] [By file]
1 (0.147)
SELECT data
FROM `oc_session`
WHERE session_id = '476686c4a4376592b0d2cfe677'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.095)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.096)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Bass-Assassin'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.087)
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 (28.245)
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 (29.728)
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 80,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.118)
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