Table Definition:
CREATE TABLE Module (
ModuleId INTEGER PRIMARY KEY AUTOINCREMENT ,
Guid VARCHAR,
Type VARCHAR ,
Name VARCHAR ,
GroupName VARCHAR ,
StatusLabel VARCHAR ,
Icon VARCHAR ,
SortOrder INTEGER
);
CREATE TABLE Feed (
FeedId INTEGER PRIMARY KEY AUTOINCREMENT ,
Guid VARCHAR,
ModuleId INTEGER ,
Encoding VARCHAR ,
FavIcon VARCHAR ,
ImageLink VARCHAR,
FeedType VARCHAR ,
Link VARCHAR NOT NULL ,
PubDate BIGINT ,
Title VARCHAR ,
TotalCount INTEGER DEFAULT 0 ,
UnreadCount INTEGER DEFAULT 0 ,
WebLink VARCHAR,
StreamHash VARCHAR,
SyncDate BIGINT,
IsAutoMobilize SMALLINT,
MobilizeProvider VARCHAR,
IsDownloadNewEnclosure SMALLINT,
CacheGuid VARCHAR,
HTTPLastModified VARCHAR,
HTTPETag VARCHAR
);
CREATE TABLE FeedItem (
FeedItemId INTEGER PRIMARY KEY AUTOINCREMENT ,
FeedId INTEGER ,
Author VARCHAR ,
CommentsLink VARCHAR ,
Description VARCHAR ,
EnclosureCurrentPosition INTEGER ,
EnclosureDuration INTEGER ,
EnclosureLength INTEGER ,
EnclosureLink VARCHAR ,
EnclosureType VARCHAR ,
Title VARCHAR ,
Thumbnail VARCHAR ,
Snippet VARCHAR ,
PubDate BIGINT NOT NULL ,
UniqueKey VARCHAR ,
Link VARCHAR ,
IsStar SMALLINT ,
IsRead SMALLINT ,
IsDeleted SMALLINT ,
IsQueued SMALLINT,
QueueOrder INTEGER,
ArticleStatus SMALLINT,
EnclosureStatus SMALLINT,
Article VARCHAR,
CacheGuid VARCHAR,
CreatedDate INTEGER
);
Following is example:
Assuming Feed Guid = cafd5d05542d43a09ade192c2bf5d752
FeedQuery: FeedId IN (SELECT FeedId FROM Feed WHERE GUID = 'cafd5d05542d43a09ade192c2bf5d752')
In your example, would looks like: IsRead=0 AND IsDeleted = 0 AND FeedId IN (SELECT FeedId FROM Feed WHERE GUID = 'cafd5d05542d43a09ade192c2bf5d752')
replace above guid with your module guid