#total_order# total item(s)

select web_desc, brand, description from tb_styles where style_id=#session.itemstyleid[x]#

#get_style_name.web_desc# #get_style_name.description# #get_style_name.brand#	#session.itemq[x]#
Your Shopping is Empty.

select distinct (style_id) as style_id , max(picture_id) , min(min_price) as min_price , max(max_price) as max_price , max(web_style) as web_style , max(web_desc) as web_desc , max(picture_id) as picture_id , max(dept) as dept , max(typ) as typ , max(subtyp_1) as subtyp_1 , max(subtyp_2) as subtyp_2 , max(subtyp_3) as subtyp_3 , max(category_style) as category_style , max(web_url) as web_url , max(sort_position) as sort_position ,max(web_taxonomy_id) as web_taxonomy_id ,max(brand) as brand , MAX(max_sugg_price) AS max_sugg_price from grandgetproducts where of20='FEATURED WEB ITEM' group by Style_id order by picture_id desc

/c/#Getweburl.web_url#/brand/#url.brand#"> image not available

#brand#
/c/#Getweburl.web_url#/brand/#url.brand#" style="font-size: 11px;"> #web_desc#
#dollarformat(min_price)#
#display_percent# % OFF

Enter to Win a $50 gift card!
Ends December 1st^st, 2009