SELECT equipment.id, trim(equipment.year) AS myyear, equipment.hz, equipment.description, equipment.status, equipment.availability, equipment.modality, equipment.manufacturer, equipment.model, web_equipment_media.filename, web_equipment_media.mediatype, web_equipment_media.height, web_equipment_media.width, web_equipment_media.mediatype FROM equipment LEFT JOIN web_equipment_media ON equipment.id = web_equipment_media.EquipmentId WHERE ( (equipment.status = 'Available' OR equipment.status = 'Pending Sale') AND (equipment.rental = 'Y' or equipment.rental = 'B') AND (equipment.mobile = 'Y') AND (web_equipment_media.mediatype='thumb' OR web_equipment_media.mediatype IS NULL) AND (#EquipmentCacheNumber# = #EquipmentCacheNumber#) ) SELECT * from equipmentmain#mytype# WHERE (#EquipmentCacheNumber# = #EquipmentCacheNumber#) ORDER BY myyear#finalsort#, id DESC;


%%%subheader%%%

 %%%pagebody%%% #thistitle# Equipment Available

 There is currently no equipment available for this category. Please check back soon.
Displaying Items: #start# - #equipment.recordcount##evaluate('#start#' + '#resultsperpage#' - 1)# of #equipment.recordcount# Result Page:  Previous  #i#,  Next
Sort Results by: IDID, ModalityModality, ModelModel, ManufacturerManufacturer, YearYear
#navigation#

   ID #id#: #myyear# #manufacturer# #model# #modality# #hz# Hz
#trim(shortdescription)#...

   

#navigation#