public Collection<Record> getRecordsFeaturingGroop(String groopName, int groopNumber)
         throws SQLException
   {
      List<Record> featuring = new LinkedList<Record>();

      String sql = "SELECT DISTINCT records.recordnumber from records,track,lineupset,lineup WHERE records.recordnumber = track.recordnumber AND track.trackrefnumber = lineupset.tracknumber AND lineupset.lineupnumber = lineup.lineupnumber AND lineup.groopnumber = ?";
      PreparedStatement ps = Connect.getConnection().getPreparedStatement(sql);
      ps.setInt(1, groopNumber);
      ResultSet rs = ps.executeQuery();
      while (rs.next())
      {
         Record rec = getRecord(rs.getInt(1));
         if (!rec.getAuthor().equals(groopName))
            featuring.add(getRecord(rs.getInt(1)));
      }

      return featuring;
   }