Featured Wines and Products

SELECT l.label_id, l.label_name, l.label_text, l.sort_order, l.inactive_flag, l.page_id , s.class_name FROM labels l, style_classes s WHERE l.page_id = 2 AND l.inactive_flag = 0 AND l.class_id = s.class_id ORDER BY l.sort_order

#ReplaceNoCase(getFeatProdLabels.label_text, chr(13) & chr(10), "
", "all")#

SELECT * FROM getFeaturesWeek WHERE featurescat_id = 1

#get1.feature_cat#	Size	Price	Feature
#get1.product#	#get1.size#	#get1.price#	#get1.feature#

SELECT * FROM getFeaturesWeek WHERE featurescat_id = 2

#get2.feature_cat#	Was	Now
#get2.product#	#get2.size#	#get2.price#	#get2.feature#

--->