Mine

          $sql = 'SELECT p.uid, u.name, p.pointsFROM {userpoints} pINNER JOIN {users} u USING (uid)';if ( $delta == 0 ) {$sql .= ' WHERE p.tid = 0 OR p.tid IS NULL ';$result = db_query_range($sql, 0, $num);} else {$delta = 5;$sql .= ' WHERE p.tid = %d';$result = db_query_range($sql, 0, $num, $delta);}