public static function countVideosHavingComments()
{
$request = "SELECT COUNT(*) AS count FROM (SELECT DISTINCT video_id FROM videos_comments) AS temp";
$pdo = Database::getPDOObject();
$result = $pdo->query($request)->fetch(PDO::FETCH_NAMED)['count'];
return $result;
}
public static function sumViews()
{
return Database::getPDOObject()->query('SELECT SUM(`views`) AS total_views FROM `videos`')->fetchAll()[0]['total_views'];
}
public static function cleanDeleted()
{
Database::getPDOObject()->query("DELETE FROM " . self::table_name() . " WHERE user_id NOT IN (SELECT id FROM users) OR user_channel_id NOT IN (SELECT id FROM users_channels)");
}
