Lines Matching refs:files
145 …CREATE TABLE files ( idFile integer primary key, idPath integer, strFilename text, playCount integ…
146 …INSERT INTO "files" VALUES(1,2,'The.Big.Bang.Theory.S01E01.WEB-DL.AAC2.0.H264.mkv',NULL,NULL,'2013…
215 CREATE INDEX ix_files ON files ( idPath, strFilename );
231 files.strfilename AS strFileName,
233 files.playcount AS playCount,
234 files.lastplayed AS lastPlayed,
235 files.dateadded AS dateAdded,
245 JOIN files
246 ON files.idfile = episode.idfile
253 ON files.idpath = path.idpath
262 Max(files.lastplayed) AS lastPlayed,
264 Count(files.playcount) AS watchedcount,
273 LEFT JOIN files
274 ON files.idfile = episode.idfile
287 count(files.playCount)
292 JOIN files ON files.idFile = episodeview.idFile