SELECT * FROM catalog WHERE STOREID = 1 AND stockquantity > 0 category = '#cat_id#' style = '#style#' medium = '#medium#' AND STOREID = 1 AND stockquantity > 0
<--- QNT=allcat_id=#cat_id#&style=#style#&medium=#medium#">PREVIOUS #attributes.maxrows#      Total Items Found: #SearchResults.recordcount# Now Displaying: #attributes.startrow# - #SearchResults.recordcount# #last_row_in_this_set#      QNT=allcat_id=#cat_id#&style=#style#&medium=#medium#"> LAST #LASTPAGE# NEXT #attributes.maxrows# --->
START A NEW SEARCH...
#searchresults.Item#
SHOW THE COMPLETE DETAILS
#searchresults.ImgAltText# PHOTO NOT YET AVAILABLE
Not For Sale #DollarFormat(RegularPrice)#

<--- QNT=allcat_id=#cat_id#&style=#style#&medium=#medium#">PREVIOUS #attributes.maxrows#      Total Items Found: #SearchResults.recordcount# Now Displaying: #attributes.startrow# - #SearchResults.recordcount# #last_row_in_this_set#      QNT=allcat_id=#cat_id#&style=#style#&medium=#medium#"> LAST #LASTPAGE# NEXT #attributes.maxrows# --->