+ const buildTotalViewersPromise = () => {
+ let totalViewersDateWhere = ''
+
+ if (startDate) totalViewersDateWhere += ' AND "localVideoViewer"."endDate" >= :startDate'
+ if (endDate) totalViewersDateWhere += ' AND "localVideoViewer"."startDate" <= :endDate'
+
+ const totalViewersQuery = `SELECT ` +
+ `COUNT("localVideoViewer"."id") AS "totalViewers" ` +
+ `FROM "localVideoViewer" ` +
+ `WHERE "videoId" = :videoId ${totalViewersDateWhere}`
+
+ return LocalVideoViewerModel.sequelize.query<any>(totalViewersQuery, queryOptions)
+ }
+