Slide 13
Slide 13 text
@Query("SELECT e.id, e.start_time, e.end_time, e.room_name, e.slug, et.title,
et.subtitle, e.abstract, e.description"
+ ", GROUP_CONCAT(p.name, ', ') AS persons, e.day_index, d.date AS day_date,
e.track_id, t.name AS track_name, t.type AS track_type"
+ ", b.event_id IS NOT NULL AS is_bookmarked"
+ " FROM events e"
+ " JOIN events_titles et ON e.id = et.`rowid`"
+ " JOIN days d ON e.day_index = d.`index`"
+ " JOIN tracks t ON e.track_id = t.id"
+ " LEFT JOIN events_persons ep ON e.id = ep.event_id"
+ " LEFT JOIN persons p ON ep.person_id = p.`rowid`"
+ " LEFT JOIN bookmarks b ON e.id = b.event_id"
+ " WHERE e.day_index = :day AND e.track_id = :track"
+ " GROUP BY e.id"
+ " ORDER BY e.start_time ASC")
public abstract LiveData> getEvents(Day day, Track track);
ScheduleDao.java