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) => Northwest Metro Cap [NWM cap]
product_info_metatags(object: queryFactoryResult)
0(array)
products_name(string) => Northwest Metro Cap
products_model(string) => NWM cap
products_price_sorter(string) => 16.9900
products_tax_class_id(string) => 0
metatags_title_status(string) => 0
metatags_products_name_status(string) => 0
metatags_model_status(string) => 0
products_id(string) => 88
metatags_price_status(string) => 0
metatags_title_tagline_status(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.
product_is_free(string) => 0
product_is_call(string) => 0
metatags_title(NULL) =>
metatags_keywords(NULL) =>
metatags_description(NULL) =>
meta_products_price(string) => - $16.99
metatags_keywords(NULL) =>
metatags_description(NULL) =>
prod_is_call_and_no_price(boolean) =>
meta_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.
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) => 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.
reviews_query(string) => select count(*) as count from reviews r, reviews_description rd
where r.products_id = '88'
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) => Northwest Metro Cap
products_model(string) => NWM cap
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.
thumb_slashes(string) => <img src="bmz_cache/n/nwm_hat2_02jpg.image.157x150.jpg" alt="Northwest Metro Cap" title=" Northwest Metro Cap " width="157" height="150" style="position:relative;" onmouseover="showtrail(\'images/images/NWM_hat2_02.jpg\',\'Northwest Metro Cap\',157,150,,,this,0,0,157,150);" onmouseout="hidetrail();" />
thumb_regular(string) => <img src="bmz_cache/n/nwm_hat2_02jpg.image.157x150.jpg" alt="Northwest Metro Cap" title=" Northwest Metro Cap " width="157" height="150" style="position:relative;" onmouseover="showtrail('images/images/NWM_hat2_02.jpg','Northwest Metro Cap',157,150,,,this,0,0,157,150);" onmouseout="hidetrail();" />
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 = '88'
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 = '88' 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 = '88' and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and r.status = '1' order by r.reviews_id desc