Jamroom: Search Sort Orders for use with Song searches

The Powerful Social Media Platform

Newsletter

Spotlight

The-Muzic

"In September 2006 we decided to create an MP3 hosting and promotion site to help unsigned artists. Originally this was all done by hand in HTML and CSS - and although it looked OK, the site had very limited features. While trawling the net one day we discovered Jamroom - which took our site from a basic spare time MP3 site to a very advanced music site in a short space of time. The features keep improving and therefore so do the options we can offer our members."

Search Sort Orders for use with Song searches

This document applies to Jamroom 2 only - for current Jamroom 3 Documentation, visit the main Documentation section.

Available SORT Orders for use in Song Search Areas

Column Name	Description
s.song_id	Sort by the Song ID
s.song_time	Sort by the Song Creation Date
s.song_name	Sort by the Song Name
s.song_album	Sort by the Song Album Name
s.song_label	Sort by the Song Label Name
i.band_id	Sort by the Artist ID number
i.band_time	Sort by the Artist Creation Date
i.band_name	Sort by the Artist Name
i.band_location	Sort by the Artist Location
h.hifi_size	Sort by the SIZE (in bytes) of the HIFI Song file
h.hifi_length	Sort by the LENGTH of the HIFI song
l.lofi_size	Sort by the SIZE (in bytes) of the LOFI Song file
l.lofi_length	Sort by the LENGTH of the LOFI song
song_total_count	Sort by the total number of plays (Streams + Downloads) for the song
song_stream_count	Sort by the number of Sreams for the song
song_download_count	Sort by the number of Downloads for the song
g.genre_name	Sort by the Song Genre Name
r.rating_number	Sort by the number of Song Ratings for the song
r.rating_average	Sort by the Song Rating Average for the song

» Login to leave your rating!