An excerpt of a NodeJS API for getting users between two ranks.

Rankings

exports.getRanks = function(rankMin, rankMax, sinceUTC, callback) {
    
    var sql = 'SELECT nickname,shared_identifier,items,experience FROM accounts WHERE ? < date_updated ORDER BY experience DESC LIMIT ?,?';
    var sqlParams = [sinceUTC, rankMin, (rankMax - rankMin) + 1];

    mysql.query(sql, sqlParams, function (err, result) {
        if (err) {
            console.log(err);
            callback(err, null);
        }
        else {
            callback(null, result);
        }
    });
};