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
meta_products_name(string) => Plain Ant Plain Ant [Plain Ant] - $1.10 : Fishing Tackle - Lures & Jigs- Maynards Tackle
product_info_metatags(object: queryFactoryResult)
0(array)
products_name(string) => Plain Ant
products_model(string) => Plain Ant
products_price_sorter(string) => 1.1000
products_tax_class_id(string) => 1
metatags_title_status(string) => 1
metatags_products_name_status(string) => 1
metatags_model_status(string) => 1
products_id(string) => 30
metatags_price_status(string) => 1
metatags_title_tagline_status(string) => 1
products_description(string) => The Plain Ant is just a simple jig with two bodies and a double eye on each.
<b>
<p>Plain Ant Size #6-1/28 oz.
<p>Plain Ant Size #8-1/36 oz.
<p>Plain Ant Size #10-1/62 oz.
<p>Plain Ant Size #12-1/80 oz.
</b>
</p>
metatags_description(string) => Maynards Plain Ant is a great fishing lure for Walleye, Crappie, Perch, Sunfish, Bluegill and Northern Pike. It comes in multiple colors and sizes. FREE SHIPPING AVAILABLE!
metatags_description(string) => Maynards Plain Ant is a great fishing lure for Walleye, Crappie, Perch, Sunfish, Bluegill and Northern Pike. It comes in multiple colors and sizes. FREE SHIPPING AVAILABLE!
order_by(string) => order by LPAD(pa.products_options_sort_order,11,"0"), pov.products_options_values_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) => The Plain Ant is just a simple jig with two bodies and a double eye on each.
<b>
<p>Plain Ant Size #6-1/28 oz.
<p>Plain Ant Size #8-1/36 oz.
<p>Plain Ant Size #10-1/62 oz.
<p>Plain Ant Size #12-1/80 oz.
</b>
</p>
reviews_query(string) => select count(*) as count from reviews r, reviews_description rd
where r.products_id = '30'
and r.reviews_id = rd.reviews_id
and rd.languages_id = '1' and r.status = '1'
reviews(object: queryFactoryResult)
0(array)
reviews_id(string) => 29
reviews_text(string) => Super product fish love it and helped us catch more fish per outing.
reviews_rating(string) => 5
date_added(string) => 2010-05-16 13:25:23
customers_name(string) => Justin L.
products_name(string) => Plain Ant
products_model(string) => Plain Ant
products_description(string) => The Plain Ant is just a simple jig with two bodies and a double eye on each.
<b>
<p>Plain Ant Size #6-1/28 oz.
<p>Plain Ant Size #8-1/36 oz.
<p>Plain Ant Size #10-1/62 oz.
<p>Plain Ant Size #12-1/80 oz.
</b>
</p>
reviews_query_raw(string) => select r.reviews_id, left(rd.reviews_text, 1000) as reviews_text,
r.reviews_rating, r.date_added, r.customers_name
from reviews r, reviews_description rd
where r.products_id = '30'
and r.reviews_id = rd.reviews_id
and rd.languages_id = '1' and r.status = '1'
order by r.reviews_id desc
reviews_split(object: splitPageResults)
sql_query(string) => select r.reviews_id, left(rd.reviews_text, 1000) as reviews_text, r.reviews_rating, r.date_added, r.customers_name from reviews r, reviews_description rd where r.products_id = '30' and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and r.status = '1' order by r.reviews_id desc limit 6
number_of_rows(string) => 1
current_page_number(integer) => 1
number_of_pages(double) => 1
number_of_rows_per_page(integer) => 6
page_name(string) => page
countQuery(string) => select r.reviews_id, left(rd.reviews_text, 1000) as reviews_text, r.reviews_rating, r.date_added, r.customers_name from reviews r, reviews_description rd where r.products_id = '30' and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and r.status = '1' order by r.reviews_id desc