High Quality Hand-Crafted Lures that are Made in Minnesota in a variety of colors.
Discover the incredible selection of ice fishing gear at Maynards Tackle that will have you catching the limit on your next fishing trip.
products_description(string) => The 2 Banger is first on the market to have a rattle built inside the jigging spoon. (not glued on the back) It features a brass rattle with steel balls for that extra loud rattle. Comes with a red treble hook and flipper to improve attracting those reluctant fish.
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) => <span style="color: rgb(255, 0, 0); font-weight: bold;">TUNGSTEN STEEL</span><div><font color="#ff0000"><b><br /></b></font></div><div><i style="color: rgb(255, 0, 0); font-family: impact; font-size: x-large;">HAND-CRAFTED IN MINNESOTA</i><font color="#ff0000"><b><br /></b></font>
<p>The Plow Grub is one of our Tungsten fishing jigs made from Tungsten steel. Featuring our New Natural <b><font color="#00ff00">"Power Glow"</font></b> paint. These Wonder Bread Plow Grub jigs Glow in the Dark very bright.</p>
</div>
<p><b>Plow Grub Size #12-1/28 oz.-4mm
<p>Plow Grub Size #10-1/16 oz.-5mm
<p>Plow Grub Size #8-3/32 oz.-6mm
<p>Plow Grub Size #6-1/10 oz.-6mm</p></b>
specials_new_products_price(NULL) =>
final_price(string) => 2.1900
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 p2c.categories_id = 15
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
current_categories_description(string) => High Quality Hand-Crafted Lures that are Made in Minnesota in a variety of colors.
<br />
Discover the incredible selection of ice fishing gear at Maynards Tackle that will have you catching the limit on your next fishing trip.
current_categories_name(string) => Wonder Bread Series
categories_description(string) => High Quality Hand-Crafted Lures that are Made in Minnesota in a variety of colors.
<br />
Discover the incredible selection of ice fishing gear at Maynards Tackle that will have you catching the limit on your next fishing trip.
products_description(string) => The 2 Banger is first on the market to have a rattle built inside the jigging spoon. (not glued on the back) It features a brass rattle with steel balls for that extra loud rattle. Comes with a red treble hook and flipper to improve attracting those reluctant fish.
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.
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 p2c.categories_id = 15 ORDER BY p.products_sort_order, pd.products_name limit 9
number_of_rows(string) => 3
current_page_number(integer) => 1
number_of_pages(double) => 1
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 p2c.categories_id = 15 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
and p.products_id in (51, 58, 86)
featured_products(object: queryFactoryResult)
zc_show_specials(boolean) =>
specials_index_query(string) => SELECT DISTINCT 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
AND p.products_id in (51, 58, 86)
specials_index(object: queryFactoryResult)
expected_query(string) =>
limit_clause(string) => ORDER BY date_expected DESC
LIMIT 10