equal
deleted
inserted
replaced
208 |
208 |
209 // existence check |
209 // existence check |
210 _LIT8( KThumbnailSelectAllPaths, "SELECT ThumbnailInfo.RowID,Path FROM ThumbnailInfo " |
210 _LIT8( KThumbnailSelectAllPaths, "SELECT ThumbnailInfo.RowID,Path FROM ThumbnailInfo " |
211 "WHERE NOT EXISTS (SELECT Path FROM ThumbnailDeleted " |
211 "WHERE NOT EXISTS (SELECT Path FROM ThumbnailDeleted " |
212 "WHERE ThumbnailInfo.Path = ThumbnailDeleted.Path) " |
212 "WHERE ThumbnailInfo.Path = ThumbnailDeleted.Path) " |
213 "AND ThumbFromPath = 1 AND ThumbnailInfo.RowID > :RowID ORDER BY ThumbnailInfo.RowID ASC LIMIT :Limit;" ); |
213 "AND ThumbnailInfo.RowID > :RowID ORDER BY ThumbnailInfo.RowID ASC LIMIT :Limit;" ); |
214 |
214 |
215 #endif // THUMBNAILSQL_H |
215 #endif // THUMBNAILSQL_H |