Kelly Goucher Internal
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY film_id' at line 1]
SELECT DISTINCT film_id, SUM(seconds_viewed) AS totalSeconds , SUM(film_viewed) AS totalFilmViews , COUNT(*) AS totalPageViews , COUNT(DISTINCT(browser_user_id)) AS uniqueViewers , MAX(data_viewed) AS lastViewDate FROM fd4Afa56_statistic_films_views WHERE (data_viewed >='2015-01-01' AND data_viewed <='2024-02-24') AND university_id = GROUP BY film_id
|Number of Plays
|Total Seconds Viewed
|Total Minutes Viewed
|NO DATA for this data range
Page Visits counts the frequency of visitors to a film page.
Number of Plays counts the number of times the film was streamed. (IE how many times a viewer pressed “play” on the streaming player).
Total Seconds/Minutes Viewed calculates the total time that a film was streamed by any number of users.
Last View displays the most recent date that the film page was viewed.
Your stats may also include films for which your school does yet have streaming access. Our statistics show anytime a person from your school’s IP address has visited one of our film pages. These statistics will show up as “Page Views” without any seconds or minutes viewed.