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
1(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
specials_new_products_price(NULL) =>
final_price(string) => 10.9900
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 = 8
ORDER BY p.products_sort_order, pd.products_name
keywords_string_metatags(string) => Tungsten Fishing Jigs Jigging Spoons Jigs Apparel & Accessories Gift Certificate Kits Wonder Bread Series
keywords_metatags(object: queryFactoryResult)
0(array)
categories_name(string) => Tungsten Fishing Jigs
1(array)
categories_name(string) => Jigging Spoons
2(array)
categories_name(string) => Jigs
3(array)
categories_name(string) => Apparel & Accessories
4(array)
categories_name(string) => Gift Certificate
5(array)
categories_name(string) => Kits
6(array)
categories_name(string) => Wonder Bread Series
category_metatags(object: queryFactoryResult)
0(array)
categories_id(string) => 8
language_id(string) => 1
metatags_title(string) => Fishing Apparel
metatags_keywords(string) => "fishing, tackle, ice, jigs, tungsten, panfish, bass, walleye, trout, northern pike, and muskie,Northwest Metro Tackle, original"
metatags_description(string) => Quality apparel for the avid fisherman. Great-looking and durable shirts, caps, and hoodies that will keep you warm on the water and have you looking smart all day long.
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_name(string) => Black Maynards Fitted Cap
products_quantity(string) => 9
products_id(string) => 48
products_type(string) => 1
master_categories_id(string) => 8
manufacturers_id(string) => 1
products_price(string) => 18.0000
products_tax_class_id(string) => 0
products_description(string) => This is a Flexfit cap made from the highest quality. The logo is stitched on the side panel and is in a black metallic color. These caps come on 2 sizes. S/M and L/XL.
specials_new_products_price(NULL) =>
final_price(string) => 18.0000
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) => dp.jpg
products_name(string) => Depth Finder
products_quantity(string) => 9922
products_id(string) => 56
products_type(string) => 1
master_categories_id(string) => 8
manufacturers_id(string) => 1
products_price(string) => 3.0000
products_tax_class_id(string) => 1
products_description(string) => This Depth Finder is about 1.25 oz. These work great for finding the depth of water quickly without caring around your electronics.
Come in 3 fluorescent colors.
specials_new_products_price(NULL) =>
final_price(string) => 3.0000
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) => hoodie1.jpg
products_name(string) => Hockey Hoodie
products_quantity(string) => 3
products_id(string) => 91
products_type(string) => 1
master_categories_id(string) => 8
manufacturers_id(string) => 1
products_price(string) => 79.9900
products_tax_class_id(string) => 0
products_description(string) => This hoodie just screams quality and warmth. This lace up pullover hoodie is made of a heavy cotton/poly blend.
It feature our embroidered (not silk screened) logos in front (Maynards & Neon Lites) and the back has an embroidered charcoal stitched crappie and walleye.
This hoodie has gray accents around the hood and sleeves with a front pouch pocket.
specials_new_products_price(NULL) =>
final_price(string) => 79.9900
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) => lh.jpg
products_name(string) => Jig Holder
products_quantity(string) => 933
products_id(string) => 46
products_type(string) => 1
master_categories_id(string) => 8
manufacturers_id(string) => 1
products_price(string) => 7.9500
products_tax_class_id(string) => 1
products_description(string) => This Pocket Lure Holder has become extremely poplular with fisherman. It is made from a quality material on the
outside and the inside has 4 foam pages that will last for many years. It also has a pocket on both sides for accessories.
Many fisherman have purchase more than one so they have a lure holder for each species of fish.
specials_new_products_price(NULL) =>
final_price(string) => 7.9500
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) => 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
5(array)
products_image(string) => Benie.jpg
products_name(string) => Maynards Beanie
products_quantity(string) => 0
products_id(string) => 57
products_type(string) => 1
master_categories_id(string) => 8
manufacturers_id(string) => 1
products_price(string) => 12.9500
products_tax_class_id(string) => 0
products_description(string) => The Maynards Beanie is a high quality beanie perfect for keeping you warm in fall and winter conditions. Sizing is one size fits all and features an embroidered Maynards logo.
specials_new_products_price(NULL) =>
final_price(string) => 12.9500
products_sort_order(string) => 0
product_is_call(string) => 0
product_is_always_free_shipping(string) => 0
products_qty_box_status(string) => 1
6(array)
products_image(string) => decal.jpg
products_name(string) => Maynards Decal
products_quantity(string) => 78
products_id(string) => 64
products_type(string) => 1
master_categories_id(string) => 8
manufacturers_id(string) => 1
products_price(string) => 2.0000
products_tax_class_id(string) => 1
products_description(string) => Maynards Tackle decal printed on a clear background. This decal measures about 6" wide X 2 1/2" height.
specials_new_products_price(NULL) =>
final_price(string) => 2.0000
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) => hoodie.jpg
products_name(string) => Maynards Hoodie
products_quantity(string) => 13
products_id(string) => 44
products_type(string) => 1
master_categories_id(string) => 8
manufacturers_id(string) => 1
products_price(string) => 39.9500
products_tax_class_id(string) => 0
products_description(string) => Maynards Hoodie Sweater is of the highest quality in warmth and comfort. Made from 50% cotton and 50% polyester. The "Logo" and "Pro-Staff" is embroidered (not silk screened) for that professional look. Comes with drawstring hood, hand pouch
specials_new_products_price(NULL) =>
final_price(string) => 39.9500
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) => longsleeve_t.jpg
products_name(string) => Maynards Long Sleeve T-Shirt
products_quantity(string) => 2
products_id(string) => 45
products_type(string) => 1
master_categories_id(string) => 8
manufacturers_id(string) => 1
products_price(string) => 18.0000
products_tax_class_id(string) => 0
products_description(string) => This long-sleeve Maynards t-shirt is comfortable in both summer, when arms are at high risk of sunburn, and in the winter for providing a buffer against cold winds on mild days. 100% Cotton Preshrunk. These shirts have an embroidered logo on the front. Not silk screened.
specials_new_products_price(NULL) =>
final_price(string) => 18.0000
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) => 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
10(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
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 = 8 ORDER BY p.products_sort_order, pd.products_name limit 9, 9
number_of_rows(string) => 11
current_page_number(string) => 2
number_of_pages(double) => 2
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 = 8 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 (43, 44, 45, 46, 48, 56, 57, 64, 85, 88, 89, 90, 91)
featured_products(object: queryFactoryResult)
0(array)
products_id(string) => 56
products_image(string) => dp.jpg
products_name(string) => Depth Finder
master_categories_id(string) => 8
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 (43, 44, 45, 46, 48, 56, 57, 64, 85, 88, 89, 90, 91)
specials_index(object: queryFactoryResult)
expected_query(string) =>
limit_clause(string) => ORDER BY date_expected DESC
LIMIT 10
Tungsten Fishing Jigs
Featured Products ...
Page 2
