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
product_is_free(string) => 0
product_is_call(string) => 0
metatags_title(NULL) =>
metatags_keywords(NULL) =>
metatags_description(NULL) =>
meta_products_price(string) => - $39.95
metatags_keywords(NULL) =>
metatags_description(NULL) =>
prod_is_call_and_no_price(boolean) =>
meta_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
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) => 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
reviews_query(string) => select count(*) as count from reviews r, reviews_description rd
where r.products_id = '44'
and r.reviews_id = rd.reviews_id
and rd.languages_id = '1' and r.status = '1'
reviews(object: queryFactoryResult)
0(array)
count(string) => 0
products_name(string) => Maynards Hoodie
products_model(string) => Maynards Hoodie
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
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 = '44'
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 = '44' 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) => 0
current_page_number(double) => 0
number_of_pages(double) => 0
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 = '44' and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and r.status = '1' order by r.reviews_id desc