Number of movies phixed has logged by year viewed.
SELECT GET_LOCK('d5e0de94fcce5885e57c178bd4de1e84', 300) AS ci_session_lock ?>
SELECT `data` FROM `ml_sessions` WHERE `id` = '36af419eaaa5417a6371ea7bcfa7641eb8cd6c99' AND `ip_address` = '216.73.216.159' ?>
SELECT `username`, `user_id` FROM `ml_users` WHERE `username` = 'phixed' LIMIT 1 ?>
SELECT DATE_FORMAT(date_viewed, "%Y") AS year_viewed, COUNT(date_viewed) AS total FROM `ml_movies` `MV` WHERE `MV`.`user_id` = 82 GROUP BY `year_viewed` ORDER BY `year_viewed` DESC ?>
Array ( )