products_description(string) => A unique kahle style hook that sets quick and holds'em. It's deadly on crappie and walleye and is easily seen on electronics. It's avaiable in 5 brilliant colors that attract fish day or night–even in stained or muddy water. Tip with minnow or grub.
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
1(array)
products_image(string) => BE_Yellow.jpg
products_name(string) => BIG EYE EASY-TIE GLOW JIGS
products_quantity(string) => 9866
products_id(string) => 68
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => Big Eye, Easy-Tie UV Glow Jig; there’s no place for ‘em to hide–not even in dark, murky waters. These outweigh anything on the market today: Easy tie means stronger, more resilient knots for better action and fewer snags. Plus, no holes to clean out and now, our UV Glow. Tip with your favorite artificial bait, minnow, leech or crawler.
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
2(array)
products_image(string) => dgj.jpg
products_name(string) => Dakota Gold Jigs
products_quantity(string) => 9889
products_id(string) => 73
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.3000
products_tax_class_id(string) => 1
products_description(string) => With it’s black pupil surrounded by our distintive Neon Lites, glow red eye set on a shimmering, 24 gold plated jig, this proven combination promises to deliver. All you need do is tip with your favorite live or artificial bait and prepare to catch your limit. Available in sizes #4, #6, #8 and #10.
specials_new_products_price(NULL) =>
final_price(string) => 1.3000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
3(array)
products_image(string) => ffglow_blue.jpg
products_name(string) => Fire Fry Glow Jigs
products_quantity(string) => 9927
products_id(string) => 69
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => The Fire Fry jig has a center-balance body for a horizontal presentation. This jig imitates tiny bait fish and dynamite for panfish, crappie and walleye. it's also easily seen on electronics. It's available in 5 brilliant NEON LITES colors and sizes #6, #8 and #10. Attract fish day or night–even in stained or muddy water.
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
4(array)
products_image(string) => FT glow blue.jpg
products_name(string) => Flickertail Glow Jigs
products_quantity(string) => 9903
products_id(string) => 70
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.3000
products_tax_class_id(string) => 1
products_description(string) => The Flickertail Jig is designed with a center-balance jig head for a horizontal presentation. It's painted with brilliant 5 brilliant NEON LITES super glow colors then tied with 'crystal-flash' tinsel that imitates tiny scales from baitfish–and drives fish wild! Available in sizes 1/16oz. #4, 1/32oz. #6 and 1/64oz. #8. For best results use camera flash or LED to excite jig, tip with minnow, waxworm or leech then cast in and around weeds of timber.
products_description(string) => You can bet that this year’s entry is sure to be a favorite, summer or winter. Our most effective glass rattle, combined with our Wonder Bread glow, all on a spoon jig. Along with it’s lifelike holographic feature and it’s ability to flutter, simulating a distressed minnow, make it a game-changer. Add your favorite live or artificial bait for even greater effectiveness.
products_description(string) => You can bet that this year’s entry is sure to be a favorite, summer or winter. Our most effective glass rattle, combined with our NEON LITES glow, all on a spoon jig. Along with it’s lifelike holographic feature and it’s ability to flutter, simulating a distressed minnow, make it a game-changer. Add your favorite live or artificial bait for even greater effectiveness. Available in 10 NEON LITES color combinations, including 24K gold plate in 1/4oz.
specials_new_products_price(NULL) =>
final_price(string) => 4.2000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
7(array)
products_image(string) => RS-chrt-grn.jpg
products_name(string) => Glass Rat'lr Jigs
products_quantity(string) => 884
products_id(string) => 79
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.2000
products_tax_class_id(string) => 1
products_description(string) => The Glass Rat'lr Jig has a extra short shank, wide gap hook that provides a compact natural presentation for a "Deadly" hook set. It also has a venom glass rattle molded into the head which produces a loud enticing rattle "That triggers fish to strike." The Glass Rat'lr Jig is extremely effective in stained and muddy water. For best results, tip with minnow, leech or crawler.
specials_new_products_price(NULL) =>
final_price(string) => 1.2000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
8(array)
products_image(string) => Grubbie glow blue.jpg
products_name(string) => Grubby Glow Jigs
products_quantity(string) => 9886
products_id(string) => 72
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => The Grubby Jig is one of our most popular jigs, It's grub-shaped body resembles larva–and sends fish into a 'feeding frenzy'. Available in 5 brilliant NEON LITES colors in sizes #6, #8 and #10. Attract fish day or night–even in stained or muddy water. For best results use a camera flash to excite jig, then tip with minnow or waxworm.
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
listing_sql(string) => SELECT p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description,
IF(s.status = 1, s.specials_new_products_price, NULL) AS specials_new_products_price,
IF(s.status = 1, s.specials_new_products_price, p.products_price) AS final_price,
p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status
FROM products p
LEFT JOIN specials s ON s.products_id = p.products_id
LEFT JOIN products_description pd ON pd.products_id = p.products_id
AND pd.language_id = 1
LEFT JOIN products_to_categories p2c ON p2c.products_id = p.products_id
LEFT JOIN manufacturers m ON m.manufacturers_id = p.manufacturers_id
WHERE p.products_status = 1
AND m.manufacturers_id = 2 AND p2c.categories_id = p.master_categories_id
ORDER BY p.products_sort_order, pd.products_name
order_by(string) => order by c.sort_order, cd.categories_name
categories_tab_query(string) => select c.sort_order, c.categories_id, cd.categories_name from categories c, categories_description cd
where c.categories_id=cd.categories_id and c.parent_id= '0' and cd.language_id='1' and c.categories_status='1' order by c.sort_order, cd.categories_name
categories_tab(object: queryFactoryResult)
0(array)
sort_order(string) => 0
categories_id(string) => 1
categories_name(string) => Tungsten Fishing Jigs
1(array)
sort_order(string) => 2
categories_id(string) => 7
categories_name(string) => Jigs
2(array)
sort_order(string) => 4
categories_id(string) => 15
categories_name(string) => Wonder Bread Series
3(array)
sort_order(string) => 10
categories_id(string) => 11
categories_name(string) => Jigging Spoons
4(array)
sort_order(string) => 12
categories_id(string) => 13
categories_name(string) => Kits
5(array)
sort_order(string) => 15
categories_id(string) => 8
categories_name(string) => Apparel & Accessories
6(array)
sort_order(string) => 20
categories_id(string) => 12
categories_name(string) => Gift Certificate
new_style(string) => category-top
categories_tab_current(string) => Gift Certificate
manufacturer_sidebox_query(string) => select distinct m.manufacturers_id, m.manufacturers_name
from manufacturers m
left join products p on m.manufacturers_id = p.manufacturers_id
where m.manufacturers_id = p.manufacturers_id and p.products_status= 1
order by manufacturers_name
manufacturer_sidebox(object: queryFactoryResult)
0(array)
manufacturers_id(string) => 1
manufacturers_name(string) => Maynards Tackle
1(array)
manufacturers_id(string) => 2
manufacturers_name(string) => Northwest Metro Tackle
products_description(string) => A unique kahle style hook that sets quick and holds'em. It's deadly on crappie and walleye and is easily seen on electronics. It's avaiable in 5 brilliant colors that attract fish day or night–even in stained or muddy water. Tip with minnow or grub.
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
1(array)
products_image(string) => BE_Yellow.jpg
products_name(string) => BIG EYE EASY-TIE GLOW JIGS
products_quantity(string) => 9866
products_id(string) => 68
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => Big Eye, Easy-Tie UV Glow Jig; there’s no place for ‘em to hide–not even in dark, murky waters. These outweigh anything on the market today: Easy tie means stronger, more resilient knots for better action and fewer snags. Plus, no holes to clean out and now, our UV Glow. Tip with your favorite artificial bait, minnow, leech or crawler.
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
2(array)
products_image(string) => dgj.jpg
products_name(string) => Dakota Gold Jigs
products_quantity(string) => 9889
products_id(string) => 73
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.3000
products_tax_class_id(string) => 1
products_description(string) => With it’s black pupil surrounded by our distintive Neon Lites, glow red eye set on a shimmering, 24 gold plated jig, this proven combination promises to deliver. All you need do is tip with your favorite live or artificial bait and prepare to catch your limit. Available in sizes #4, #6, #8 and #10.
specials_new_products_price(NULL) =>
final_price(string) => 1.3000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
3(array)
products_image(string) => ffglow_blue.jpg
products_name(string) => Fire Fry Glow Jigs
products_quantity(string) => 9927
products_id(string) => 69
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => The Fire Fry jig has a center-balance body for a horizontal presentation. This jig imitates tiny bait fish and dynamite for panfish, crappie and walleye. it's also easily seen on electronics. It's available in 5 brilliant NEON LITES colors and sizes #6, #8 and #10. Attract fish day or night–even in stained or muddy water.
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
4(array)
products_image(string) => FT glow blue.jpg
products_name(string) => Flickertail Glow Jigs
products_quantity(string) => 9903
products_id(string) => 70
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.3000
products_tax_class_id(string) => 1
products_description(string) => The Flickertail Jig is designed with a center-balance jig head for a horizontal presentation. It's painted with brilliant 5 brilliant NEON LITES super glow colors then tied with 'crystal-flash' tinsel that imitates tiny scales from baitfish–and drives fish wild! Available in sizes 1/16oz. #4, 1/32oz. #6 and 1/64oz. #8. For best results use camera flash or LED to excite jig, tip with minnow, waxworm or leech then cast in and around weeds of timber.
products_description(string) => You can bet that this year’s entry is sure to be a favorite, summer or winter. Our most effective glass rattle, combined with our Wonder Bread glow, all on a spoon jig. Along with it’s lifelike holographic feature and it’s ability to flutter, simulating a distressed minnow, make it a game-changer. Add your favorite live or artificial bait for even greater effectiveness.
products_description(string) => You can bet that this year’s entry is sure to be a favorite, summer or winter. Our most effective glass rattle, combined with our NEON LITES glow, all on a spoon jig. Along with it’s lifelike holographic feature and it’s ability to flutter, simulating a distressed minnow, make it a game-changer. Add your favorite live or artificial bait for even greater effectiveness. Available in 10 NEON LITES color combinations, including 24K gold plate in 1/4oz.
specials_new_products_price(NULL) =>
final_price(string) => 4.2000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
7(array)
products_image(string) => RS-chrt-grn.jpg
products_name(string) => Glass Rat'lr Jigs
products_quantity(string) => 884
products_id(string) => 79
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.2000
products_tax_class_id(string) => 1
products_description(string) => The Glass Rat'lr Jig has a extra short shank, wide gap hook that provides a compact natural presentation for a "Deadly" hook set. It also has a venom glass rattle molded into the head which produces a loud enticing rattle "That triggers fish to strike." The Glass Rat'lr Jig is extremely effective in stained and muddy water. For best results, tip with minnow, leech or crawler.
specials_new_products_price(NULL) =>
final_price(string) => 1.2000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
8(array)
products_image(string) => Grubbie glow blue.jpg
products_name(string) => Grubby Glow Jigs
products_quantity(string) => 9886
products_id(string) => 72
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => The Grubby Jig is one of our most popular jigs, It's grub-shaped body resembles larva–and sends fish into a 'feeding frenzy'. Available in 5 brilliant NEON LITES colors in sizes #6, #8 and #10. Attract fish day or night–even in stained or muddy water. For best results use a camera flash to excite jig, then tip with minnow or waxworm.
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
9(array)
products_image(string) => NMT lanyard.jpg
products_name(string) => Lanyard w/Line Nippers
products_quantity(string) => 988
products_id(string) => 85
products_type(string) => 1
master_categories_id(string) => 8
manufacturers_id(string) => 2
products_price(string) => 1.0000
products_tax_class_id(string) => 1
products_description(string) => Northwest Metro Tackle Lanyard with Clippers
Stamped from metal and feature an “poker-eye” that pokes, pops & cleans paint out of jig head eyes and painted hooks
specials_new_products_price(NULL) =>
final_price(string) => 1.0000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
10(array)
products_image(string) => MG_glow blue.jpg
products_name(string) => MAXimum Gap Glow Jigs
products_quantity(string) => 9856
products_id(string) => 75
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.3000
products_tax_class_id(string) => 1
products_description(string) => Since it’s introduction, the MAXimum Gap Glow Jig has become a fisherman’s standard. It’s piercing eyes and 6 brilliant NEO LITES colors in sizes 1/4oz., 1/8oz., 1/16oz. and 1/64oz. makes it a tackle-box favorite. The extra short shank and wide gap RED hook provides a compact, natural presentation for a deadly hook-set. Attract and catch fish day or night–even in stained or muddy water. For best results use a camera flash or LED to excite jig, then tip with a minnow, leech or crawler.
specials_new_products_price(NULL) =>
final_price(string) => 1.3000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
11(array)
products_image(string) => JIG-TICK-4GLW-BLU.jpg
products_name(string) => Neon Ice Tic Glow Jigs
products_quantity(string) => 9918
products_id(string) => 71
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => The Neon Tic Jig was designed to drop fast and catch fish! The slender body of the Neon Tic Jig attracts fish with its gold hook and glow. Available in 5 brilliant NEON LITES colors in sizes #4, #6 and #8. Walleyes, crappies and other panfish can’t resist the action of this jig.
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
12(array)
products_image(string) => NWM_hat2.jpg
products_name(string) => Northwest Metro Cap
products_quantity(string) => 100
products_id(string) => 88
products_type(string) => 1
master_categories_id(string) => 8
manufacturers_id(string) => 2
products_price(string) => 16.9900
products_tax_class_id(string) => 0
products_description(string) => This is an adjustable cap made from the highest quality material. The logo is stitched on the front panel with the American flag on one side and the company name on the other. These caps come in 2 versions. Mesh back and solid back.
specials_new_products_price(NULL) =>
final_price(string) => 16.9900
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
13(array)
products_image(string) => ML_Glow Blue.jpg
products_name(string) => NWM-Moon Glow Jigs
products_quantity(string) => 9751
products_id(string) => 74
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => The Moon Glow Jig is one of our most popular jigs. It's moon shaped body resembles larva–and sends fish into a 'feeding frenzy'. It's available in 5 brilliant NEON LITES colors in sizes #4, #6, #8 and #10. Attract fish day or night–even in stained or muddy water. For best results use a camera flash to excite jig, then tip with minnow or waxworm.
specials_new_products_price(NULL) =>
final_price(string) => 1.1000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
14(array)
products_image(string) => PE-011#6.jpg
products_name(string) => Perch Eye Glow Jigs
products_quantity(string) => 9821
products_id(string) => 77
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => The Perch Eye Jig is becoming a favorite for crappie fishermen. It's also effective on panfish and walleye and it can be easily seen on electronics. Available in 5 brilliant NEON LITES colors in sizes #4, #6, #8 and #10. Attract fish day or night–even in stained or muddy water. For best results use a camera flash to excite jig, then tip with minnow or waxworm.
products_description(string) => Introducing, the Raindrop Jig. Made from tungsten, these jigs are sharper, drop faster and last longer than anything else its size in your tacklebox today. Their bright glow attracts fish and sends them into a ‘feeding frenzy’. Available in 5 brilliant NEON LITES colors in sizes #8, #8LS (Long Shank), #10, #12, #14 and #16. Attract fish day or night–even in stained or muddy water. For best results, use camera flash or LED to excite the jig, then tip with waxworm, minnow or leech.
<p><b>Size #16-1/60oz.
<p>Size #14-1/28oz.
<p>Size #12-1/16oz.
<p>Size #10-1/10oz.
<p>Size #8- 1/6oz.</b></p>
products_description(string) => Tungsten Raindrop Jigs are not only sharper, drop faster and last longer, but now come in an impossible for fish to resist, iridescent finish. These colorful ‘forces of nature’ are tested to attract fish like you’ve come to expect in Neon Lites jigs. We like to call it a ‘feeding frenzy’. These are a BIG punch in a small package. For BEST results, tip with waxworm or minnow.
specials_new_products_price(NULL) =>
final_price(string) => 2.4900
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
17(array)
products_image(string) => rj_ch_bl.jpg
products_name(string) => Rat'lr Glow Jigs
products_quantity(string) => 905
products_id(string) => 80
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.3000
products_tax_class_id(string) => 1
products_description(string) => Combining the bright NEON LITES glow with the effectiveness of the loud rattle. The Rat'lr 'Glow' jig has an extra short shank and wide gap RED hook that provides a compact, natural presentation for a deadly hook-set. It also has a BRASS rattle that produces a loud enticing rattle that triggers fish to strike. Available in 3 brilliant NEON LITES colors in sizes 1/4oz., 1/8oz. and 3/8oz. Extremely effective in stained and muddy water. For best results, tip with a minnow, leach or crawler.
specials_new_products_price(NULL) =>
final_price(string) => 1.3000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
18(array)
products_image(string) => STUPglow blue.jpg
products_name(string) => Stand-Up Glow Jigs
products_quantity(string) => 9892
products_id(string) => 76
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.3000
products_tax_class_id(string) => 1
products_description(string) => Finally, a Stand-Up Jig that actually works! 75% to 100% standup average, compared to others that average 0% to 25%. Having a jig that allows the tail portion of the jig to stand up and not roll onto its side is key to triggering more strikes and having a better hookup percentage. This is the perfect jig for almost every river and lake-bottom jigging application.
Available in 6 brilliant NEON LITES colors in sizes 1/4oz., 1/8oz. and 3/8oz. Attract and catch fish day or night–even in stained or muddy water. Natural sunlight excites the jig, then tip with a minnow, leech or crawler.
specials_new_products_price(NULL) =>
final_price(string) => 1.3000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
19(array)
products_image(string) => NWM_StockingHat.jpg
products_name(string) => Stocking Hat
products_quantity(string) => 93
products_id(string) => 89
products_type(string) => 1
master_categories_id(string) => 8
manufacturers_id(string) => 2
products_price(string) => 10.9900
products_tax_class_id(string) => 0
products_description(string) => Keeps you warm in the coldest temperatures
Neon Lites Logo Sewn Into Front of Hat
One Size Fits All
products_description(string) => Our Sundrop Tungsten Jigs are made with luminous materials which absorb and store light energy from direct sunlight or an artificial light source. Then emit a brilliant glow. This bright glow attracts fish and sends them into a ‘feeding frenzy’. Tungsten jigs are sharper, drop faster and last longer. Available in brilliant colors that attract fish day or night–even in stained or muddy water. Available in 5 brilliant NEON LITES glow colors and 5 UV colors. The Neon Lites UV jigs ‘flash’ even in dark or murky waters. UV jigs attract fish and sends them into a ‘feeding frenzy’. They come in sizes #8, #10, #12 and #14. For BEST results, use camera flash or LED to excite the jig, then tip with your favorite live or artificial bait.
<p><b>Size #14-1/40oz.
<p>Size #12-1/24oz.
<p>Size #10-1/16oz.
<p>Size #8-1/10oz.</b></p>
specials_new_products_price(NULL) =>
final_price(string) => 2.2000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
21(array)
products_image(string) => Walleye Jig-blue.jpg
products_name(string) => Walleye Glow Jigs
products_quantity(string) => 576
products_id(string) => 81
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.3000
products_tax_class_id(string) => 1
products_description(string) => The Walleye Jig is designed with a wedge shape head that has less drag in strong current–excellent for river fishing. It also features a bait-holding collar for soft plastics and live bait. Available in 5 brilliant NEON LITES colors in sizes 1/4oz.,1/16oz., 1/8oz. and 3/8oz. Attract fish day or night–even in stained or muddy water. Tip with minnow, crawler or leech.
specials_new_products_price(NULL) =>
final_price(string) => 1.3000
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
22(array)
products_image(string) => WGGlow Blue.jpg
products_name(string) => Wide Gap Glow Jigs
products_quantity(string) => 9461
products_id(string) => 82
products_type(string) => 1
master_categories_id(string) => 7
manufacturers_id(string) => 2
products_price(string) => 1.1000
products_tax_class_id(string) => 1
products_description(string) => The Wide Gap Jig has a unique kahle style hook that sets quick and holds'em. It's deadly on crappie and walleye and is easily seen on electronics. Available in 5 brilliant NEON LITES colors in sizes #4, #6, and #8. Attract fish day or night–even in stained or muddy water. Tip with minnow or grub.
sql_query(string) => SELECT p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) AS specials_new_products_price, IF(s.status = 1, s.specials_new_products_price, p.products_price) AS final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status FROM products p LEFT JOIN specials s ON s.products_id = p.products_id LEFT JOIN products_description pd ON pd.products_id = p.products_id AND pd.language_id = 1 LEFT JOIN products_to_categories p2c ON p2c.products_id = p.products_id LEFT JOIN manufacturers m ON m.manufacturers_id = p.manufacturers_id WHERE p.products_status = 1 AND m.manufacturers_id = 2 AND p2c.categories_id = p.master_categories_id ORDER BY p.products_sort_order, pd.products_name limit 9
number_of_rows(string) => 23
current_page_number(integer) => 1
number_of_pages(double) => 3
number_of_rows_per_page(integer) => 9
page_name(string) => page
countQuery(string) => SELECT p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) AS specials_new_products_price, IF(s.status = 1, s.specials_new_products_price, p.products_price) AS final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status FROM products p LEFT JOIN specials s ON s.products_id = p.products_id LEFT JOIN products_description pd ON pd.products_id = p.products_id AND pd.language_id = 1 LEFT JOIN products_to_categories p2c ON p2c.products_id = p.products_id LEFT JOIN manufacturers m ON m.manufacturers_id = p.manufacturers_id WHERE p.products_status = 1 AND m.manufacturers_id = 2 AND p2c.categories_id = p.master_categories_id ORDER BY p.products_sort_order, pd.products_name
featured_products_query(string) => SELECT p.products_id, p.products_image, pd.products_name, p.master_categories_id
FROM products p
left join featured f on p.products_id = f.products_id
LEFT JOIN products_description pd ON p.products_id = pd.products_id
AND pd.language_id = 1
WHERE p.products_status = 1
AND f.status = 1
specials_index_query(string) => SELECT p.products_id, p.products_image, pd.products_name, p.master_categories_id
FROM (products p
LEFT JOIN specials s ON p.products_id = s.products_id
LEFT JOIN products_description pd ON p.products_id = pd.products_id )
WHERE p.products_id = s.products_id
AND p.products_id = pd.products_id
AND p.products_status = 1 AND s.status = 1
AND pd.language_id = 1
specials_index(object: queryFactoryResult)
expected_query(string) => SELECT p.products_id, pd.products_name, products_date_available AS date_expected, p.master_categories_id
FROM products p, products_description pd
WHERE p.products_id = pd.products_id
AND p.products_status = 1
AND pd.language_id = 1 and p.products_date_available >20210411235959 ORDER BY date_expected DESC
LIMIT 10
limit_clause(string) => ORDER BY date_expected DESC
LIMIT 10
Tungsten Fishing Jigs
Featured Products ...
Page 2
