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) => Sting Ray Sting Ray [Sting Ray] - $1.50 : Fishing Tackle - Lures & Jigs- Maynards Tackle
product_info_metatags(object: queryFactoryResult)
0(array)
products_name(string) => Sting Ray
products_model(string) => Sting Ray
products_price_sorter(string) => 1.5000
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) => 33
metatags_price_status(string) => 1
metatags_title_tagline_status(string) => 1
products_description(string) => The Sting Ray is great for vertical jigging. It falls slowly in a semi-circle motion.
<b>
<p>Sting Ray Size #2-1/4 oz.
<p>Sting Ray Size #4-3/16 oz.
</b>
</p>
metatags_description(string) => Maynards Sting Ray 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 Sting Ray 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 Sting Ray is great for vertical jigging. It falls slowly in a semi-circle motion.
<b>
<p>Sting Ray Size #2-1/4 oz.
<p>Sting Ray Size #4-3/16 oz.
</b>
</p>
reviews_query(string) => select count(*) as count from reviews r, reviews_description rd
where r.products_id = '33'
and r.reviews_id = rd.reviews_id
and rd.languages_id = '1' and r.status = '1'
reviews(object: queryFactoryResult)
0(array)
reviews_id(string) => 28
reviews_text(string) => A must have for any tackle box, super presentation in the water. Fish can't resist this one!!
reviews_rating(string) => 5
date_added(string) => 2010-05-16 13:24:43
customers_name(string) => Justin L.
products_name(string) => Sting Ray
products_model(string) => Sting Ray
products_description(string) => The Sting Ray is great for vertical jigging. It falls slowly in a semi-circle motion.
<b>
<p>Sting Ray Size #2-1/4 oz.
<p>Sting Ray Size #4-3/16 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 = '33'
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 = '33' 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 = '33' and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and r.status = '1' order by r.reviews_id desc