+ * Returns the track that contains the derivative with the given ID.
+ *
+ * @param id
+ * The ID of the track derivative
+ * @return The track the derivative belongs to, or {@code null} if there is
+ * no such track
+ * @throws DatabaseException
+ * if a database error occurs
+ */
+ public Track getTrackByDerivativeId(String id) throws DatabaseException {
+ Query query = new Query(Type.SELECT, "TRACKS");
+ query.addField(new Field("TRACKS.*"));
+ query.addJoin(new Join(JoinType.INNER, "TRACK_DERIVATIVES", new Field("TRACK_DERIVATIVES.TRACK"), new Field("TRACKS.ID")));
+ query.addWhereClause(new ValueFieldWhereClause(new ValueField("TRACK_DERIVATIVES.ID", new StringParameter(id))));
+ return loadTrackProperties(database.getSingle(query, trackCreator));
+ }
+
+ /**