fileName = "cathode.db",
version = DatabaseSchematic.DATABASE_VERSION)
public final class DatabaseSchematic {
private DatabaseSchematic() {
}
<BUG>static final int DATABASE_VERSION = 35;
</BUG>
public interface Joins {
String SHOWS_UNWATCHED = "LEFT OUTER JOIN episodes ON episodes._id=(SELECT episodes._id FROM"
+ " episodes WHERE episodes.watched=0 AND episodes.showId=shows._id AND episodes.season<>0"

fileName = "cathode.db",
version = DatabaseSchematic.DATABASE_VERSION)
public final class DatabaseSchematic {
private DatabaseSchematic() {
}
static final int DATABASE_VERSION = 36;
public interface Joins {
String SHOWS_UNWATCHED = "LEFT OUTER JOIN episodes ON episodes._id=(SELECT episodes._id FROM"
+ " episodes WHERE episodes.watched=0 AND episodes.showId=shows._id AND episodes.season<>0"
