0wrgPBXd

1{"message":"109.239.77.230 - - [31/Aug/2018:17:11:59 +0000] \"GET / HTTP/1.0\" 200 2915 \"-\" \"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:60.0) Gecko/20100101 Firefox/60.0\"\n","level":"info","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:11:59.727Z"}
2{"message":"Executing (default): SELECT \"id\", \"clientId\", \"clientSecret\", \"grants\", \"redirectUris\", \"createdAt\", \"updatedAt\" FROM \"oAuthClient\" AS \"OAuthClientModel\" LIMIT 1;","level":"debug","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:00.467Z"}
3{"message":"109.239.77.230 - - [31/Aug/2018:17:12:00 +0000] \"GET /api/v1/config/ HTTP/1.0\" 200 834 \"https://video.sebesdileni.cz/\" \"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:60.0) Gecko/20100101 Firefox/60.0\"\n","level":"info","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:00.474Z"}
4{"message":"Getting access token (bearerToken: 3c36d54eebe39271c0b6e625120188c96e8a3bea).","level":"debug","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:00.484Z"}
5{"message":"Executing (default): SELECT \"OAuthTokenModel\".\"id\", \"OAuthTokenModel\".\"accessToken\", \"OAuthTokenModel\".\"accessTokenExpiresAt\", \"OAuthTokenModel\".\"refreshToken\", \"OAuthTokenModel\".\"refreshTokenExpiresAt\", \"OAuthTokenModel\".\"userId\", \"OAuthTokenModel\".\"oAuthClientId\", \"OAuthTokenModel\".\"createdAt\", \"OAuthTokenModel\".\"updatedAt\", \"User\".\"id\" AS \"User.id\", \"User\".\"password\" AS \"User.password\", \"User\".\"username\" AS \"User.username\", \"User\".\"email\" AS \"User.email\", \"User\".\"nsfwPolicy\" AS \"User.nsfwPolicy\", \"User\".\"autoPlayVideo\" AS \"User.autoPlayVideo\", \"User\".\"blocked\" AS \"User.blocked\", \"User\".\"blockedReason\" AS \"User.blockedReason\", \"User\".\"role\" AS \"User.role\", \"User\".\"videoQuota\" AS \"User.videoQuota\", \"User\".\"createdAt\" AS \"User.createdAt\", \"User\".\"updatedAt\" AS \"User.updatedAt\", \"User->Account\".\"id\" AS \"User.Account.id\", \"User->Account\".\"name\" AS \"User.Account.name\", \"User->Account\".\"description\" AS \"User.Account.description\", \"User->Account\".\"actorId\" AS \"User.Account.actorId\", \"User->Account\".\"userId\" AS \"User.Account.userId\", \"User->Account\".\"applicationId\" AS \"User.Account.applicationId\", \"User->Account\".\"createdAt\" AS \"User.Account.createdAt\", \"User->Account\".\"updatedAt\" AS \"User.Account.updatedAt\", \"User->Account->Actor\".\"id\" AS \"User.Account.Actor.id\", \"User->Account->Actor\".\"type\" AS \"User.Account.Actor.type\", \"User->Account->Actor\".\"uuid\" AS \"User.Account.Actor.uuid\", \"User->Account->Actor\".\"preferredUsername\" AS \"User.Account.Actor.preferredUsername\", \"User->Account->Actor\".\"url\" AS \"User.Account.Actor.url\", \"User->Account->Actor\".\"publicKey\" AS \"User.Account.Actor.publicKey\", \"User->Account->Actor\".\"privateKey\" AS \"User.Account.Actor.privateKey\", \"User->Account->Actor\".\"followersCount\" AS \"User.Account.Actor.followersCount\", \"User->Account->Actor\".\"followingCount\" AS \"User.Account.Actor.followingCount\", \"User->Account->Actor\".\"inboxUrl\" AS \"User.Account.Actor.inboxUrl\", \"User->Account->Actor\".\"outboxUrl\" AS \"User.Account.Actor.outboxUrl\", \"User->Account->Actor\".\"sharedInboxUrl\" AS \"User.Account.Actor.sharedInboxUrl\", \"User->Account->Actor\".\"followersUrl\" AS \"User.Account.Actor.followersUrl\", \"User->Account->Actor\".\"followingUrl\" AS \"User.Account.Actor.followingUrl\", \"User->Account->Actor\".\"avatarId\" AS \"User.Account.Actor.avatarId\", \"User->Account->Actor\".\"serverId\" AS \"User.Account.Actor.serverId\", \"User->Account->Actor\".\"createdAt\" AS \"User.Account.Actor.createdAt\", \"User->Account->Actor\".\"updatedAt\" AS \"User.Account.Actor.updatedAt\", \"User->Account->Actor->Server\".\"id\" AS \"User.Account.Actor.Server.id\", \"User->Account->Actor->Server\".\"host\" AS \"User.Account.Actor.Server.host\", \"User->Account->Actor->Server\".\"createdAt\" AS \"User.Account.Actor.Server.createdAt\", \"User->Account->Actor->Server\".\"updatedAt\" AS \"User.Account.Actor.Server.updatedAt\", \"User->Account->Actor->Avatar\".\"id\" AS \"User.Account.Actor.Avatar.id\", \"User->Account->Actor->Avatar\".\"filename\" AS \"User.Account.Actor.Avatar.filename\", \"User->Account->Actor->Avatar\".\"createdAt\" AS \"User.Account.Actor.Avatar.createdAt\", \"User->Account->Actor->Avatar\".\"updatedAt\" AS \"User.Account.Actor.Avatar.updatedAt\" FROM \"oAuthToken\" AS \"OAuthTokenModel\" LEFT OUTER JOIN ( \"user\" AS \"User\" INNER JOIN \"account\" AS \"User->Account\" ON \"User\".\"id\" = \"User->Account\".\"userId\" INNER JOIN \"actor\" AS \"User->Account->Actor\" ON \"User->Account\".\"actorId\" = \"User->Account->Actor\".\"id\" LEFT OUTER JOIN \"server\" AS \"User->Account->Actor->Server\" ON \"User->Account->Actor\".\"serverId\" = \"User->Account->Actor->Server\".\"id\" LEFT OUTER JOIN \"avatar\" AS \"User->Account->Actor->Avatar\" ON \"User->Account->Actor\".\"avatarId\" = \"User->Account->Actor->Avatar\".\"id\" ) ON \"OAuthTokenModel\".\"userId\" = \"User\".\"id\" WHERE \"OAuthTokenModel\".\"accessToken\" = '3c36d54eebe39271c0b6e625120188c96e8a3bea' LIMIT 1;","level":"debug","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:00.490Z"}
6{"message":"109.239.77.230 - - [31/Aug/2018:17:12:00 +0000] \"GET /api/v1/oauth-clients/local HTTP/1.0\" 200 99 \"https://video.sebesdileni.cz/\" \"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:60.0) Gecko/20100101 Firefox/60.0\"\n","level":"info","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:00.491Z"}
7{"message":"Executing (default): SELECT \"UserModel\".*, \"Account->VideoChannels\".\"id\" AS \"Account.VideoChannels.id\", \"Account->VideoChannels\".\"name\" AS \"Account.VideoChannels.name\", \"Account->VideoChannels\".\"description\" AS \"Account.VideoChannels.description\", \"Account->VideoChannels\".\"support\" AS \"Account.VideoChannels.support\", \"Account->VideoChannels\".\"actorId\" AS \"Account.VideoChannels.actorId\", \"Account->VideoChannels\".\"accountId\" AS \"Account.VideoChannels.accountId\", \"Account->VideoChannels\".\"createdAt\" AS \"Account.VideoChannels.createdAt\", \"Account->VideoChannels\".\"updatedAt\" AS \"Account.VideoChannels.updatedAt\", \"Account->VideoChannels->Actor\".\"id\" AS \"Account.VideoChannels.Actor.id\", \"Account->VideoChannels->Actor\".\"type\" AS \"Account.VideoChannels.Actor.type\", \"Account->VideoChannels->Actor\".\"uuid\" AS \"Account.VideoChannels.Actor.uuid\", \"Account->VideoChannels->Actor\".\"preferredUsername\" AS \"Account.VideoChannels.Actor.preferredUsername\", \"Account->VideoChannels->Actor\".\"url\" AS \"Account.VideoChannels.Actor.url\", \"Account->VideoChannels->Actor\".\"publicKey\" AS \"Account.VideoChannels.Actor.publicKey\", \"Account->VideoChannels->Actor\".\"privateKey\" AS \"Account.VideoChannels.Actor.privateKey\", \"Account->VideoChannels->Actor\".\"followersCount\" AS \"Account.VideoChannels.Actor.followersCount\", \"Account->VideoChannels->Actor\".\"followingCount\" AS \"Account.VideoChannels.Actor.followingCount\", \"Account->VideoChannels->Actor\".\"inboxUrl\" AS \"Account.VideoChannels.Actor.inboxUrl\", \"Account->VideoChannels->Actor\".\"outboxUrl\" AS \"Account.VideoChannels.Actor.outboxUrl\", \"Account->VideoChannels->Actor\".\"sharedInboxUrl\" AS \"Account.VideoChannels.Actor.sharedInboxUrl\", \"Account->VideoChannels->Actor\".\"followersUrl\" AS \"Account.VideoChannels.Actor.followersUrl\", \"Account->VideoChannels->Actor\".\"followingUrl\" AS \"Account.VideoChannels.Actor.followingUrl\", \"Account->VideoChannels->Actor\".\"avatarId\" AS \"Account.VideoChannels.Actor.avatarId\", \"Account->VideoChannels->Actor\".\"serverId\" AS \"Account.VideoChannels.Actor.serverId\", \"Account->VideoChannels->Actor\".\"createdAt\" AS \"Account.VideoChannels.Actor.createdAt\", \"Account->VideoChannels->Actor\".\"updatedAt\" AS \"Account.VideoChannels.Actor.updatedAt\", \"Account->VideoChannels->Actor->Avatar\".\"id\" AS \"Account.VideoChannels.Actor.Avatar.id\", \"Account->VideoChannels->Actor->Avatar\".\"filename\" AS \"Account.VideoChannels.Actor.Avatar.filename\", \"Account->VideoChannels->Actor->Avatar\".\"createdAt\" AS \"Account.VideoChannels.Actor.Avatar.createdAt\", \"Account->VideoChannels->Actor->Avatar\".\"updatedAt\" AS \"Account.VideoChannels.Actor.Avatar.updatedAt\", \"Account->VideoChannels->Actor->Server\".\"id\" AS \"Account.VideoChannels.Actor.Server.id\", \"Account->VideoChannels->Actor->Server\".\"host\" AS \"Account.VideoChannels.Actor.Server.host\", \"Account->VideoChannels->Actor->Server\".\"createdAt\" AS \"Account.VideoChannels.Actor.Server.createdAt\", \"Account->VideoChannels->Actor->Server\".\"updatedAt\" AS \"Account.VideoChannels.Actor.Server.updatedAt\", \"Account->Actor->Server\".\"id\" AS \"Account.Actor.Server.id\", \"Account->Actor->Server\".\"host\" AS \"Account.Actor.Server.host\", \"Account->Actor->Server\".\"createdAt\" AS \"Account.Actor.Server.createdAt\", \"Account->Actor->Server\".\"updatedAt\" AS \"Account.Actor.Server.updatedAt\", \"Account->Actor->Avatar\".\"id\" AS \"Account.Actor.Avatar.id\", \"Account->Actor->Avatar\".\"filename\" AS \"Account.Actor.Avatar.filename\", \"Account->Actor->Avatar\".\"createdAt\" AS \"Account.Actor.Avatar.createdAt\", \"Account->Actor->Avatar\".\"updatedAt\" AS \"Account.Actor.Avatar.updatedAt\" FROM (SELECT \"UserModel\".\"id\", \"UserModel\".\"password\", \"UserModel\".\"username\", \"UserModel\".\"email\", \"UserModel\".\"nsfwPolicy\", \"UserModel\".\"autoPlayVideo\", \"UserModel\".\"blocked\", \"UserModel\".\"blockedReason\", \"UserModel\".\"role\", \"UserModel\".\"videoQuota\", \"UserModel\".\"createdAt\", \"UserModel\".\"updatedAt\", \"Account\".\"id\" AS \"Account.id\", \"Account\".\"name\" AS \"Account.name\", \"Account\".\"description\" AS \"Account.description\", \"Account\".\"actorId\" AS \"Account.actorId\", \"Account\".\"userId\" AS \"Account.userId\", \"Account\".\"applicationId\" AS \"Account.applicationId\", \"Account\".\"createdAt\" AS \"Account.createdAt\", \"Account\".\"updatedAt\" AS \"Account.updatedAt\", \"Account->Actor\".\"id\" AS \"Account.Actor.id\", \"Account->Actor\".\"type\" AS \"Account.Actor.type\", \"Account->Actor\".\"uuid\" AS \"Account.Actor.uuid\", \"Account->Actor\".\"preferredUsername\" AS \"Account.Actor.preferredUsername\", \"Account->Actor\".\"url\" AS \"Account.Actor.url\", \"Account->Actor\".\"publicKey\" AS \"Account.Actor.publicKey\", \"Account->Actor\".\"privateKey\" AS \"Account.Actor.privateKey\", \"Account->Actor\".\"followersCount\" AS \"Account.Actor.followersCount\", \"Account->Actor\".\"followingCount\" AS \"Account.Actor.followingCount\", \"Account->Actor\".\"inboxUrl\" AS \"Account.Actor.inboxUrl\", \"Account->Actor\".\"outboxUrl\" AS \"Account.Actor.outboxUrl\", \"Account->Actor\".\"sharedInboxUrl\" AS \"Account.Actor.sharedInboxUrl\", \"Account->Actor\".\"followersUrl\" AS \"Account.Actor.followersUrl\", \"Account->Actor\".\"followingUrl\" AS \"Account.Actor.followingUrl\", \"Account->Actor\".\"avatarId\" AS \"Account.Actor.avatarId\", \"Account->Actor\".\"serverId\" AS \"Account.Actor.serverId\", \"Account->Actor\".\"createdAt\" AS \"Account.Actor.createdAt\", \"Account->Actor\".\"updatedAt\" AS \"Account.Actor.updatedAt\" FROM \"user\" AS \"UserModel\" INNER JOIN \"account\" AS \"Account\" ON \"UserModel\".\"id\" = \"Account\".\"userId\" INNER JOIN \"actor\" AS \"Account->Actor\" ON \"Account\".\"actorId\" = \"Account->Actor\".\"id\" WHERE \"UserModel\".\"username\" = 'martin.mojmir' AND ( SELECT \"Account\".\"userId\" FROM \"account\" AS \"Account\" LEFT OUTER JOIN ( \"videoChannel\" AS \"VideoChannels\" INNER JOIN \"actor\" AS \"VideoChannels->Actor\" ON \"VideoChannels\".\"actorId\" = \"VideoChannels->Actor\".\"id\" LEFT OUTER JOIN \"avatar\" AS \"VideoChannels->Actor->Avatar\" ON \"VideoChannels->Actor\".\"avatarId\" = \"VideoChannels->Actor->Avatar\".\"id\" LEFT OUTER JOIN \"server\" AS \"VideoChannels->Actor->Server\" ON \"VideoChannels->Actor\".\"serverId\" = \"VideoChannels->Actor->Server\".\"id\" ) ON \"Account\".\"id\" = \"VideoChannels\".\"accountId\" WHERE (\"Account\".\"userId\" = \"UserModel\".\"id\") LIMIT 1 ) IS NOT NULL LIMIT 1) AS \"UserModel\" LEFT OUTER JOIN ( \"videoChannel\" AS \"Account->VideoChannels\" INNER JOIN \"actor\" AS \"Account->VideoChannels->Actor\" ON \"Account->VideoChannels\".\"actorId\" = \"Account->VideoChannels->Actor\".\"id\" LEFT OUTER JOIN \"avatar\" AS \"Account->VideoChannels->Actor->Avatar\" ON \"Account->VideoChannels->Actor\".\"avatarId\" = \"Account->VideoChannels->Actor->Avatar\".\"id\" LEFT OUTER JOIN \"server\" AS \"Account->VideoChannels->Actor->Server\" ON \"Account->VideoChannels->Actor\".\"serverId\" = \"Account->VideoChannels->Actor->Server\".\"id\" ) ON \"Account.id\" = \"Account->VideoChannels\".\"accountId\" LEFT OUTER JOIN \"server\" AS \"Account->Actor->Server\" ON \"Account.Actor.serverId\" = \"Account->Actor->Server\".\"id\" LEFT OUTER JOIN \"avatar\" AS \"Account->Actor->Avatar\" ON \"Account.Actor.avatarId\" = \"Account->Actor->Avatar\".\"id\";","level":"debug","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:00.524Z"}
8{"message":"109.239.77.230 - - [31/Aug/2018:17:12:00 +0000] \"GET /client/locales/cs-CZ/server.json HTTP/1.0\" 200 6129 \"https://video.sebesdileni.cz/\" \"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:60.0) Gecko/20100101 Firefox/60.0\"\n","level":"info","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:00.526Z"}
9{"message":"109.239.77.230 - - [31/Aug/2018:17:12:00 +0000] \"GET /api/v1/users/me HTTP/1.0\" 200 1133 \"https://video.sebesdileni.cz/\" \"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:60.0) Gecko/20100101 Firefox/60.0\"\n","level":"info","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:00.532Z"}
10{"message":"109.239.77.230 - - [31/Aug/2018:17:12:01 +0000] \"GET /client/cs_CZ/language.e569b5463ef1c0ef2b34.png HTTP/1.0\" 200 10937 \"https://video.sebesdileni.cz/\" \"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:60.0) Gecko/20100101 Firefox/60.0\"\n","level":"info","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:01.128Z"}
11{"parameters":{"start":"0","count":"40","sort":"-views"},"level":"debug","message":"Checking pagination parameters","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:01.144Z"}
12{"parameters":{"start":"0","count":"40","sort":"-views"},"level":"debug","message":"Checking sort parameters","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:01.145Z"}
13{"message":"109.239.77.230 - - [31/Aug/2018:17:12:01 +0000] \"GET /api/v1/videos/categories HTTP/1.0\" 200 263 \"https://video.sebesdileni.cz/\" \"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:60.0) Gecko/20100101 Firefox/60.0\"\n","level":"info","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:01.147Z"}
14{"message":"109.239.77.230 - - [31/Aug/2018:17:12:01 +0000] \"GET /api/v1/videos/languages HTTP/1.0\" 200 3254 \"https://video.sebesdileni.cz/\" \"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:60.0) Gecko/20100101 Firefox/60.0\"\n","level":"info","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:01.149Z"}
15{"message":"109.239.77.230 - - [31/Aug/2018:17:12:01 +0000] \"GET /api/v1/videos/licences HTTP/1.0\" 304 - \"https://video.sebesdileni.cz/\" \"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:60.0) Gecko/20100101 Firefox/60.0\"\n","level":"info","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:01.150Z"}
16{"message":"109.239.77.230 - - [31/Aug/2018:17:12:01 +0000] \"GET /api/v1/videos/privacies HTTP/1.0\" 304 - \"https://video.sebesdileni.cz/\" \"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:60.0) Gecko/20100101 Firefox/60.0\"\n","level":"info","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:01.151Z"}
17{"message":"109.239.77.230 - - [31/Aug/2018:17:12:01 +0000] \"GET /client/assets/images/default-avatar.png HTTP/1.0\" 304 - \"https://video.sebesdileni.cz/\" \"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:60.0) Gecko/20100101 Firefox/60.0\"\n","level":"info","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:01.154Z"}
18{"message":"Getting access token (bearerToken: 3c36d54eebe39271c0b6e625120188c96e8a3bea).","level":"debug","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:01.154Z"}
19{"message":"Executing (default): SELECT \"OAuthTokenModel\".\"id\", \"OAuthTokenModel\".\"accessToken\", \"OAuthTokenModel\".\"accessTokenExpiresAt\", \"OAuthTokenModel\".\"refreshToken\", \"OAuthTokenModel\".\"refreshTokenExpiresAt\", \"OAuthTokenModel\".\"userId\", \"OAuthTokenModel\".\"oAuthClientId\", \"OAuthTokenModel\".\"createdAt\", \"OAuthTokenModel\".\"updatedAt\", \"User\".\"id\" AS \"User.id\", \"User\".\"password\" AS \"User.password\", \"User\".\"username\" AS \"User.username\", \"User\".\"email\" AS \"User.email\", \"User\".\"nsfwPolicy\" AS \"User.nsfwPolicy\", \"User\".\"autoPlayVideo\" AS \"User.autoPlayVideo\", \"User\".\"blocked\" AS \"User.blocked\", \"User\".\"blockedReason\" AS \"User.blockedReason\", \"User\".\"role\" AS \"User.role\", \"User\".\"videoQuota\" AS \"User.videoQuota\", \"User\".\"createdAt\" AS \"User.createdAt\", \"User\".\"updatedAt\" AS \"User.updatedAt\", \"User->Account\".\"id\" AS \"User.Account.id\", \"User->Account\".\"name\" AS \"User.Account.name\", \"User->Account\".\"description\" AS \"User.Account.description\", \"User->Account\".\"actorId\" AS \"User.Account.actorId\", \"User->Account\".\"userId\" AS \"User.Account.userId\", \"User->Account\".\"applicationId\" AS \"User.Account.applicationId\", \"User->Account\".\"createdAt\" AS \"User.Account.createdAt\", \"User->Account\".\"updatedAt\" AS \"User.Account.updatedAt\", \"User->Account->Actor\".\"id\" AS \"User.Account.Actor.id\", \"User->Account->Actor\".\"type\" AS \"User.Account.Actor.type\", \"User->Account->Actor\".\"uuid\" AS \"User.Account.Actor.uuid\", \"User->Account->Actor\".\"preferredUsername\" AS \"User.Account.Actor.preferredUsername\", \"User->Account->Actor\".\"url\" AS \"User.Account.Actor.url\", \"User->Account->Actor\".\"publicKey\" AS \"User.Account.Actor.publicKey\", \"User->Account->Actor\".\"privateKey\" AS \"User.Account.Actor.privateKey\", \"User->Account->Actor\".\"followersCount\" AS \"User.Account.Actor.followersCount\", \"User->Account->Actor\".\"followingCount\" AS \"User.Account.Actor.followingCount\", \"User->Account->Actor\".\"inboxUrl\" AS \"User.Account.Actor.inboxUrl\", \"User->Account->Actor\".\"outboxUrl\" AS \"User.Account.Actor.outboxUrl\", \"User->Account->Actor\".\"sharedInboxUrl\" AS \"User.Account.Actor.sharedInboxUrl\", \"User->Account->Actor\".\"followersUrl\" AS \"User.Account.Actor.followersUrl\", \"User->Account->Actor\".\"followingUrl\" AS \"User.Account.Actor.followingUrl\", \"User->Account->Actor\".\"avatarId\" AS \"User.Account.Actor.avatarId\", \"User->Account->Actor\".\"serverId\" AS \"User.Account.Actor.serverId\", \"User->Account->Actor\".\"createdAt\" AS \"User.Account.Actor.createdAt\", \"User->Account->Actor\".\"updatedAt\" AS \"User.Account.Actor.updatedAt\", \"User->Account->Actor->Server\".\"id\" AS \"User.Account.Actor.Server.id\", \"User->Account->Actor->Server\".\"host\" AS \"User.Account.Actor.Server.host\", \"User->Account->Actor->Server\".\"createdAt\" AS \"User.Account.Actor.Server.createdAt\", \"User->Account->Actor->Server\".\"updatedAt\" AS \"User.Account.Actor.Server.updatedAt\", \"User->Account->Actor->Avatar\".\"id\" AS \"User.Account.Actor.Avatar.id\", \"User->Account->Actor->Avatar\".\"filename\" AS \"User.Account.Actor.Avatar.filename\", \"User->Account->Actor->Avatar\".\"createdAt\" AS \"User.Account.Actor.Avatar.createdAt\", \"User->Account->Actor->Avatar\".\"updatedAt\" AS \"User.Account.Actor.Avatar.updatedAt\" FROM \"oAuthToken\" AS \"OAuthTokenModel\" LEFT OUTER JOIN ( \"user\" AS \"User\" INNER JOIN \"account\" AS \"User->Account\" ON \"User\".\"id\" = \"User->Account\".\"userId\" INNER JOIN \"actor\" AS \"User->Account->Actor\" ON \"User->Account\".\"actorId\" = \"User->Account->Actor\".\"id\" LEFT OUTER JOIN \"server\" AS \"User->Account->Actor->Server\" ON \"User->Account->Actor\".\"serverId\" = \"User->Account->Actor->Server\".\"id\" LEFT OUTER JOIN \"avatar\" AS \"User->Account->Actor->Avatar\" ON \"User->Account->Actor\".\"avatarId\" = \"User->Account->Actor->Avatar\".\"id\" ) ON \"OAuthTokenModel\".\"userId\" = \"User\".\"id\" WHERE \"OAuthTokenModel\".\"accessToken\" = '3c36d54eebe39271c0b6e625120188c96e8a3bea' LIMIT 1;","level":"debug","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:01.160Z"}
20{"parameters":{"start":0,"count":40,"sort":"-views"},"level":"debug","message":"Checking commons video filters query","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:01.165Z"}
21{"message":"Executing (default): SELECT count(*) AS \"count\" FROM \"video\" AS \"VideoModel\" INNER JOIN \"videoChannel\" AS \"VideoChannel\" ON \"VideoModel\".\"channelId\" = \"VideoChannel\".\"id\" INNER JOIN \"actor\" AS \"VideoChannel->Actor\" ON \"VideoChannel\".\"actorId\" = \"VideoChannel->Actor\".\"id\" LEFT OUTER JOIN \"server\" AS \"VideoChannel->Actor->Server\" ON \"VideoChannel->Actor\".\"serverId\" = \"VideoChannel->Actor->Server\".\"id\" LEFT OUTER JOIN \"avatar\" AS \"VideoChannel->Actor->Avatar\" ON \"VideoChannel->Actor\".\"avatarId\" = \"VideoChannel->Actor->Avatar\".\"id\" INNER JOIN \"account\" AS \"VideoChannel->Account\" ON \"VideoChannel\".\"accountId\" = \"VideoChannel->Account\".\"id\" INNER JOIN \"actor\" AS \"VideoChannel->Account->Actor\" ON \"VideoChannel->Account\".\"actorId\" = \"VideoChannel->Account->Actor\".\"id\" LEFT OUTER JOIN \"server\" AS \"VideoChannel->Account->Actor->Server\" ON \"VideoChannel->Account->Actor\".\"serverId\" = \"VideoChannel->Account->Actor->Server\".\"id\" LEFT OUTER JOIN \"avatar\" AS \"VideoChannel->Account->Actor->Avatar\" ON \"VideoChannel->Account->Actor\".\"avatarId\" = \"VideoChannel->Account->Actor->Avatar\".\"id\" WHERE (\"VideoModel\".\"state\" = 1 OR (\"VideoModel\".\"state\" = 2 AND \"VideoModel\".\"waitTranscoding\" = false)) AND (\"VideoModel\".\"id\" NOT IN (SELECT \"videoBlacklist\".\"videoId\" FROM \"videoBlacklist\") AND \"VideoModel\".\"id\" IN (SELECT \"videoShare\".\"videoId\" AS \"id\" FROM \"videoShare\" INNER JOIN \"actorFollow\" ON \"actorFollow\".\"targetActorId\" = \"videoShare\".\"actorId\" WHERE \"actorFollow\".\"actorId\" = 1 UNION SELECT \"video\".\"id\" AS \"id\" FROM \"video\" INNER JOIN \"videoChannel\" ON \"videoChannel\".\"id\" = \"video\".\"channelId\" INNER JOIN \"account\" ON \"account\".\"id\" = \"videoChannel\".\"accountId\" INNER JOIN \"actor\" ON \"account\".\"actorId\" = \"actor\".\"id\" WHERE \"actor\".\"serverId\" IS NULL  UNION ALL SELECT \"video\".\"id\" AS \"id\" FROM \"video\" INNER JOIN \"videoChannel\" ON \"videoChannel\".\"id\" = \"video\".\"channelId\" INNER JOIN \"account\" ON \"account\".\"id\" = \"videoChannel\".\"accountId\" INNER JOIN \"actor\" ON \"account\".\"actorId\" = \"actor\".\"id\" INNER JOIN \"actorFollow\" ON \"actorFollow\".\"targetActorId\" = \"actor\".\"id\" WHERE \"actorFollow\".\"actorId\" = 1)) AND \"VideoModel\".\"privacy\" = 1 AND \"VideoModel\".\"nsfw\" = false;","level":"debug","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:01.180Z"}
22{"message":"Executing (default): SELECT \"VideoModel\".\"id\", \"VideoModel\".\"uuid\", \"VideoModel\".\"name\", \"VideoModel\".\"category\", \"VideoModel\".\"licence\", \"VideoModel\".\"language\", \"VideoModel\".\"privacy\", \"VideoModel\".\"nsfw\", \"VideoModel\".\"description\", \"VideoModel\".\"support\", \"VideoModel\".\"duration\", \"VideoModel\".\"views\", \"VideoModel\".\"likes\", \"VideoModel\".\"dislikes\", \"VideoModel\".\"remote\", \"VideoModel\".\"url\", \"VideoModel\".\"commentsEnabled\", \"VideoModel\".\"waitTranscoding\", \"VideoModel\".\"state\", \"VideoModel\".\"publishedAt\", \"VideoModel\".\"channelId\", \"VideoModel\".\"createdAt\", \"VideoModel\".\"updatedAt\", \"VideoChannel\".\"name\" AS \"VideoChannel.name\", \"VideoChannel\".\"description\" AS \"VideoChannel.description\", \"VideoChannel\".\"id\" AS \"VideoChannel.id\", \"VideoChannel->Actor\".\"id\" AS \"VideoChannel.Actor.id\", \"VideoChannel->Actor\".\"uuid\" AS \"VideoChannel.Actor.uuid\", \"VideoChannel->Actor\".\"preferredUsername\" AS \"VideoChannel.Actor.preferredUsername\", \"VideoChannel->Actor\".\"url\" AS \"VideoChannel.Actor.url\", \"VideoChannel->Actor\".\"serverId\" AS \"VideoChannel.Actor.serverId\", \"VideoChannel->Actor\".\"avatarId\" AS \"VideoChannel.Actor.avatarId\", \"VideoChannel->Actor->Server\".\"id\" AS \"VideoChannel.Actor.Server.id\", \"VideoChannel->Actor->Server\".\"host\" AS \"VideoChannel.Actor.Server.host\", \"VideoChannel->Actor->Avatar\".\"id\" AS \"VideoChannel.Actor.Avatar.id\", \"VideoChannel->Actor->Avatar\".\"filename\" AS \"VideoChannel.Actor.Avatar.filename\", \"VideoChannel->Actor->Avatar\".\"createdAt\" AS \"VideoChannel.Actor.Avatar.createdAt\", \"VideoChannel->Actor->Avatar\".\"updatedAt\" AS \"VideoChannel.Actor.Avatar.updatedAt\", \"VideoChannel->Account\".\"id\" AS \"VideoChannel.Account.id\", \"VideoChannel->Account\".\"name\" AS \"VideoChannel.Account.name\", \"VideoChannel->Account->Actor\".\"id\" AS \"VideoChannel.Account.Actor.id\", \"VideoChannel->Account->Actor\".\"uuid\" AS \"VideoChannel.Account.Actor.uuid\", \"VideoChannel->Account->Actor\".\"preferredUsername\" AS \"VideoChannel.Account.Actor.preferredUsername\", \"VideoChannel->Account->Actor\".\"url\" AS \"VideoChannel.Account.Actor.url\", \"VideoChannel->Account->Actor\".\"serverId\" AS \"VideoChannel.Account.Actor.serverId\", \"VideoChannel->Account->Actor\".\"avatarId\" AS \"VideoChannel.Account.Actor.avatarId\", \"VideoChannel->Account->Actor->Server\".\"id\" AS \"VideoChannel.Account.Actor.Server.id\", \"VideoChannel->Account->Actor->Server\".\"host\" AS \"VideoChannel.Account.Actor.Server.host\", \"VideoChannel->Account->Actor->Avatar\".\"id\" AS \"VideoChannel.Account.Actor.Avatar.id\", \"VideoChannel->Account->Actor->Avatar\".\"filename\" AS \"VideoChannel.Account.Actor.Avatar.filename\", \"VideoChannel->Account->Actor->Avatar\".\"createdAt\" AS \"VideoChannel.Account.Actor.Avatar.createdAt\", \"VideoChannel->Account->Actor->Avatar\".\"updatedAt\" AS \"VideoChannel.Account.Actor.Avatar.updatedAt\" FROM \"video\" AS \"VideoModel\" INNER JOIN \"videoChannel\" AS \"VideoChannel\" ON \"VideoModel\".\"channelId\" = \"VideoChannel\".\"id\" INNER JOIN \"actor\" AS \"VideoChannel->Actor\" ON \"VideoChannel\".\"actorId\" = \"VideoChannel->Actor\".\"id\" LEFT OUTER JOIN \"server\" AS \"VideoChannel->Actor->Server\" ON \"VideoChannel->Actor\".\"serverId\" = \"VideoChannel->Actor->Server\".\"id\" LEFT OUTER JOIN \"avatar\" AS \"VideoChannel->Actor->Avatar\" ON \"VideoChannel->Actor\".\"avatarId\" = \"VideoChannel->Actor->Avatar\".\"id\" INNER JOIN \"account\" AS \"VideoChannel->Account\" ON \"VideoChannel\".\"accountId\" = \"VideoChannel->Account\".\"id\" INNER JOIN \"actor\" AS \"VideoChannel->Account->Actor\" ON \"VideoChannel->Account\".\"actorId\" = \"VideoChannel->Account->Actor\".\"id\" LEFT OUTER JOIN \"server\" AS \"VideoChannel->Account->Actor->Server\" ON \"VideoChannel->Account->Actor\".\"serverId\" = \"VideoChannel->Account->Actor->Server\".\"id\" LEFT OUTER JOIN \"avatar\" AS \"VideoChannel->Account->Actor->Avatar\" ON \"VideoChannel->Account->Actor\".\"avatarId\" = \"VideoChannel->Account->Actor->Avatar\".\"id\" WHERE (\"VideoModel\".\"state\" = 1 OR (\"VideoModel\".\"state\" = 2 AND \"VideoModel\".\"waitTranscoding\" = false)) AND (\"VideoModel\".\"id\" NOT IN (SELECT \"videoBlacklist\".\"videoId\" FROM \"videoBlacklist\") AND \"VideoModel\".\"id\" IN (SELECT \"videoShare\".\"videoId\" AS \"id\" FROM \"videoShare\" INNER JOIN \"actorFollow\" ON \"actorFollow\".\"targetActorId\" = \"videoShare\".\"actorId\" WHERE \"actorFollow\".\"actorId\" = 1 UNION SELECT \"video\".\"id\" AS \"id\" FROM \"video\" INNER JOIN \"videoChannel\" ON \"videoChannel\".\"id\" = \"video\".\"channelId\" INNER JOIN \"account\" ON \"account\".\"id\" = \"videoChannel\".\"accountId\" INNER JOIN \"actor\" ON \"account\".\"actorId\" = \"actor\".\"id\" WHERE \"actor\".\"serverId\" IS NULL  UNION ALL SELECT \"video\".\"id\" AS \"id\" FROM \"video\" INNER JOIN \"videoChannel\" ON \"videoChannel\".\"id\" = \"video\".\"channelId\" INNER JOIN \"account\" ON \"account\".\"id\" = \"videoChannel\".\"accountId\" INNER JOIN \"actor\" ON \"account\".\"actorId\" = \"actor\".\"id\" INNER JOIN \"actorFollow\" ON \"actorFollow\".\"targetActorId\" = \"actor\".\"id\" WHERE \"actorFollow\".\"actorId\" = 1)) AND \"VideoModel\".\"privacy\" = 1 AND \"VideoModel\".\"nsfw\" = false ORDER BY \"VideoModel\".\"views\" DESC, \"VideoModel\".\"id\" ASC LIMIT 40 OFFSET 0;","level":"debug","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:01.186Z"}
23{"message":"109.239.77.230 - - [31/Aug/2018:17:12:01 +0000] \"GET /api/v1/videos/?start=0&count=40&sort=-views HTTP/1.0\" 200 1162 \"https://video.sebesdileni.cz/\" \"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:60.0) Gecko/20100101 Firefox/60.0\"\n","level":"info","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:01.198Z"}
24{"message":"109.239.77.230 - - [31/Aug/2018:17:12:01 +0000] \"GET /client/locales/cs-CZ/server.json HTTP/1.0\" 304 - \"https://video.sebesdileni.cz/\" \"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:60.0) Gecko/20100101 Firefox/60.0\"\n","level":"info","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:01.224Z"}
25{"message":"Getting access token (bearerToken: 3c36d54eebe39271c0b6e625120188c96e8a3bea).","level":"debug","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:07.408Z"}
26{"message":"Executing (default): SELECT \"OAuthTokenModel\".\"id\", \"OAuthTokenModel\".\"accessToken\", \"OAuthTokenModel\".\"accessTokenExpiresAt\", \"OAuthTokenModel\".\"refreshToken\", \"OAuthTokenModel\".\"refreshTokenExpiresAt\", \"OAuthTokenModel\".\"userId\", \"OAuthTokenModel\".\"oAuthClientId\", \"OAuthTokenModel\".\"createdAt\", \"OAuthTokenModel\".\"updatedAt\", \"User\".\"id\" AS \"User.id\", \"User\".\"password\" AS \"User.password\", \"User\".\"username\" AS \"User.username\", \"User\".\"email\" AS \"User.email\", \"User\".\"nsfwPolicy\" AS \"User.nsfwPolicy\", \"User\".\"autoPlayVideo\" AS \"User.autoPlayVideo\", \"User\".\"blocked\" AS \"User.blocked\", \"User\".\"blockedReason\" AS \"User.blockedReason\", \"User\".\"role\" AS \"User.role\", \"User\".\"videoQuota\" AS \"User.videoQuota\", \"User\".\"createdAt\" AS \"User.createdAt\", \"User\".\"updatedAt\" AS \"User.updatedAt\", \"User->Account\".\"id\" AS \"User.Account.id\", \"User->Account\".\"name\" AS \"User.Account.name\", \"User->Account\".\"description\" AS \"User.Account.description\", \"User->Account\".\"actorId\" AS \"User.Account.actorId\", \"User->Account\".\"userId\" AS \"User.Account.userId\", \"User->Account\".\"applicationId\" AS \"User.Account.applicationId\", \"User->Account\".\"createdAt\" AS \"User.Account.createdAt\", \"User->Account\".\"updatedAt\" AS \"User.Account.updatedAt\", \"User->Account->Actor\".\"id\" AS \"User.Account.Actor.id\", \"User->Account->Actor\".\"type\" AS \"User.Account.Actor.type\", \"User->Account->Actor\".\"uuid\" AS \"User.Account.Actor.uuid\", \"User->Account->Actor\".\"preferredUsername\" AS \"User.Account.Actor.preferredUsername\", \"User->Account->Actor\".\"url\" AS \"User.Account.Actor.url\", \"User->Account->Actor\".\"publicKey\" AS \"User.Account.Actor.publicKey\", \"User->Account->Actor\".\"privateKey\" AS \"User.Account.Actor.privateKey\", \"User->Account->Actor\".\"followersCount\" AS \"User.Account.Actor.followersCount\", \"User->Account->Actor\".\"followingCount\" AS \"User.Account.Actor.followingCount\", \"User->Account->Actor\".\"inboxUrl\" AS \"User.Account.Actor.inboxUrl\", \"User->Account->Actor\".\"outboxUrl\" AS \"User.Account.Actor.outboxUrl\", \"User->Account->Actor\".\"sharedInboxUrl\" AS \"User.Account.Actor.sharedInboxUrl\", \"User->Account->Actor\".\"followersUrl\" AS \"User.Account.Actor.followersUrl\", \"User->Account->Actor\".\"followingUrl\" AS \"User.Account.Actor.followingUrl\", \"User->Account->Actor\".\"avatarId\" AS \"User.Account.Actor.avatarId\", \"User->Account->Actor\".\"serverId\" AS \"User.Account.Actor.serverId\", \"User->Account->Actor\".\"createdAt\" AS \"User.Account.Actor.createdAt\", \"User->Account->Actor\".\"updatedAt\" AS \"User.Account.Actor.updatedAt\", \"User->Account->Actor->Server\".\"id\" AS \"User.Account.Actor.Server.id\", \"User->Account->Actor->Server\".\"host\" AS \"User.Account.Actor.Server.host\", \"User->Account->Actor->Server\".\"createdAt\" AS \"User.Account.Actor.Server.createdAt\", \"User->Account->Actor->Server\".\"updatedAt\" AS \"User.Account.Actor.Server.updatedAt\", \"User->Account->Actor->Avatar\".\"id\" AS \"User.Account.Actor.Avatar.id\", \"User->Account->Actor->Avatar\".\"filename\" AS \"User.Account.Actor.Avatar.filename\", \"User->Account->Actor->Avatar\".\"createdAt\" AS \"User.Account.Actor.Avatar.createdAt\", \"User->Account->Actor->Avatar\".\"updatedAt\" AS \"User.Account.Actor.Avatar.updatedAt\" FROM \"oAuthToken\" AS \"OAuthTokenModel\" LEFT OUTER JOIN ( \"user\" AS \"User\" INNER JOIN \"account\" AS \"User->Account\" ON \"User\".\"id\" = \"User->Account\".\"userId\" INNER JOIN \"actor\" AS \"User->Account->Actor\" ON \"User->Account\".\"actorId\" = \"User->Account->Actor\".\"id\" LEFT OUTER JOIN \"server\" AS \"User->Account->Actor->Server\" ON \"User->Account->Actor\".\"serverId\" = \"User->Account->Actor->Server\".\"id\" LEFT OUTER JOIN \"avatar\" AS \"User->Account->Actor->Avatar\" ON \"User->Account->Actor\".\"avatarId\" = \"User->Account->Actor->Avatar\".\"id\" ) ON \"OAuthTokenModel\".\"userId\" = \"User\".\"id\" WHERE \"OAuthTokenModel\".\"accessToken\" = '3c36d54eebe39271c0b6e625120188c96e8a3bea' LIMIT 1;","level":"debug","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:07.414Z"}
27{"message":"Executing (default): SELECT \"UserModel\".*, \"Account->VideoChannels\".\"id\" AS \"Account.VideoChannels.id\", \"Account->VideoChannels\".\"name\" AS \"Account.VideoChannels.name\", \"Account->VideoChannels\".\"description\" AS \"Account.VideoChannels.description\", \"Account->VideoChannels\".\"support\" AS \"Account.VideoChannels.support\", \"Account->VideoChannels\".\"actorId\" AS \"Account.VideoChannels.actorId\", \"Account->VideoChannels\".\"accountId\" AS \"Account.VideoChannels.accountId\", \"Account->VideoChannels\".\"createdAt\" AS \"Account.VideoChannels.createdAt\", \"Account->VideoChannels\".\"updatedAt\" AS \"Account.VideoChannels.updatedAt\", \"Account->VideoChannels->Actor\".\"id\" AS \"Account.VideoChannels.Actor.id\", \"Account->VideoChannels->Actor\".\"type\" AS \"Account.VideoChannels.Actor.type\", \"Account->VideoChannels->Actor\".\"uuid\" AS \"Account.VideoChannels.Actor.uuid\", \"Account->VideoChannels->Actor\".\"preferredUsername\" AS \"Account.VideoChannels.Actor.preferredUsername\", \"Account->VideoChannels->Actor\".\"url\" AS \"Account.VideoChannels.Actor.url\", \"Account->VideoChannels->Actor\".\"publicKey\" AS \"Account.VideoChannels.Actor.publicKey\", \"Account->VideoChannels->Actor\".\"privateKey\" AS \"Account.VideoChannels.Actor.privateKey\", \"Account->VideoChannels->Actor\".\"followersCount\" AS \"Account.VideoChannels.Actor.followersCount\", \"Account->VideoChannels->Actor\".\"followingCount\" AS \"Account.VideoChannels.Actor.followingCount\", \"Account->VideoChannels->Actor\".\"inboxUrl\" AS \"Account.VideoChannels.Actor.inboxUrl\", \"Account->VideoChannels->Actor\".\"outboxUrl\" AS \"Account.VideoChannels.Actor.outboxUrl\", \"Account->VideoChannels->Actor\".\"sharedInboxUrl\" AS \"Account.VideoChannels.Actor.sharedInboxUrl\", \"Account->VideoChannels->Actor\".\"followersUrl\" AS \"Account.VideoChannels.Actor.followersUrl\", \"Account->VideoChannels->Actor\".\"followingUrl\" AS \"Account.VideoChannels.Actor.followingUrl\", \"Account->VideoChannels->Actor\".\"avatarId\" AS \"Account.VideoChannels.Actor.avatarId\", \"Account->VideoChannels->Actor\".\"serverId\" AS \"Account.VideoChannels.Actor.serverId\", \"Account->VideoChannels->Actor\".\"createdAt\" AS \"Account.VideoChannels.Actor.createdAt\", \"Account->VideoChannels->Actor\".\"updatedAt\" AS \"Account.VideoChannels.Actor.updatedAt\", \"Account->VideoChannels->Actor->Avatar\".\"id\" AS \"Account.VideoChannels.Actor.Avatar.id\", \"Account->VideoChannels->Actor->Avatar\".\"filename\" AS \"Account.VideoChannels.Actor.Avatar.filename\", \"Account->VideoChannels->Actor->Avatar\".\"createdAt\" AS \"Account.VideoChannels.Actor.Avatar.createdAt\", \"Account->VideoChannels->Actor->Avatar\".\"updatedAt\" AS \"Account.VideoChannels.Actor.Avatar.updatedAt\", \"Account->VideoChannels->Actor->Server\".\"id\" AS \"Account.VideoChannels.Actor.Server.id\", \"Account->VideoChannels->Actor->Server\".\"host\" AS \"Account.VideoChannels.Actor.Server.host\", \"Account->VideoChannels->Actor->Server\".\"createdAt\" AS \"Account.VideoChannels.Actor.Server.createdAt\", \"Account->VideoChannels->Actor->Server\".\"updatedAt\" AS \"Account.VideoChannels.Actor.Server.updatedAt\", \"Account->Actor->Server\".\"id\" AS \"Account.Actor.Server.id\", \"Account->Actor->Server\".\"host\" AS \"Account.Actor.Server.host\", \"Account->Actor->Server\".\"createdAt\" AS \"Account.Actor.Server.createdAt\", \"Account->Actor->Server\".\"updatedAt\" AS \"Account.Actor.Server.updatedAt\", \"Account->Actor->Avatar\".\"id\" AS \"Account.Actor.Avatar.id\", \"Account->Actor->Avatar\".\"filename\" AS \"Account.Actor.Avatar.filename\", \"Account->Actor->Avatar\".\"createdAt\" AS \"Account.Actor.Avatar.createdAt\", \"Account->Actor->Avatar\".\"updatedAt\" AS \"Account.Actor.Avatar.updatedAt\" FROM (SELECT \"UserModel\".\"id\", \"UserModel\".\"password\", \"UserModel\".\"username\", \"UserModel\".\"email\", \"UserModel\".\"nsfwPolicy\", \"UserModel\".\"autoPlayVideo\", \"UserModel\".\"blocked\", \"UserModel\".\"blockedReason\", \"UserModel\".\"role\", \"UserModel\".\"videoQuota\", \"UserModel\".\"createdAt\", \"UserModel\".\"updatedAt\", \"Account\".\"id\" AS \"Account.id\", \"Account\".\"name\" AS \"Account.name\", \"Account\".\"description\" AS \"Account.description\", \"Account\".\"actorId\" AS \"Account.actorId\", \"Account\".\"userId\" AS \"Account.userId\", \"Account\".\"applicationId\" AS \"Account.applicationId\", \"Account\".\"createdAt\" AS \"Account.createdAt\", \"Account\".\"updatedAt\" AS \"Account.updatedAt\", \"Account->Actor\".\"id\" AS \"Account.Actor.id\", \"Account->Actor\".\"type\" AS \"Account.Actor.type\", \"Account->Actor\".\"uuid\" AS \"Account.Actor.uuid\", \"Account->Actor\".\"preferredUsername\" AS \"Account.Actor.preferredUsername\", \"Account->Actor\".\"url\" AS \"Account.Actor.url\", \"Account->Actor\".\"publicKey\" AS \"Account.Actor.publicKey\", \"Account->Actor\".\"privateKey\" AS \"Account.Actor.privateKey\", \"Account->Actor\".\"followersCount\" AS \"Account.Actor.followersCount\", \"Account->Actor\".\"followingCount\" AS \"Account.Actor.followingCount\", \"Account->Actor\".\"inboxUrl\" AS \"Account.Actor.inboxUrl\", \"Account->Actor\".\"outboxUrl\" AS \"Account.Actor.outboxUrl\", \"Account->Actor\".\"sharedInboxUrl\" AS \"Account.Actor.sharedInboxUrl\", \"Account->Actor\".\"followersUrl\" AS \"Account.Actor.followersUrl\", \"Account->Actor\".\"followingUrl\" AS \"Account.Actor.followingUrl\", \"Account->Actor\".\"avatarId\" AS \"Account.Actor.avatarId\", \"Account->Actor\".\"serverId\" AS \"Account.Actor.serverId\", \"Account->Actor\".\"createdAt\" AS \"Account.Actor.createdAt\", \"Account->Actor\".\"updatedAt\" AS \"Account.Actor.updatedAt\" FROM \"user\" AS \"UserModel\" INNER JOIN \"account\" AS \"Account\" ON \"UserModel\".\"id\" = \"Account\".\"userId\" INNER JOIN \"actor\" AS \"Account->Actor\" ON \"Account\".\"actorId\" = \"Account->Actor\".\"id\" WHERE \"UserModel\".\"username\" = 'martin.mojmir' AND ( SELECT \"Account\".\"userId\" FROM \"account\" AS \"Account\" LEFT OUTER JOIN ( \"videoChannel\" AS \"VideoChannels\" INNER JOIN \"actor\" AS \"VideoChannels->Actor\" ON \"VideoChannels\".\"actorId\" = \"VideoChannels->Actor\".\"id\" LEFT OUTER JOIN \"avatar\" AS \"VideoChannels->Actor->Avatar\" ON \"VideoChannels->Actor\".\"avatarId\" = \"VideoChannels->Actor->Avatar\".\"id\" LEFT OUTER JOIN \"server\" AS \"VideoChannels->Actor->Server\" ON \"VideoChannels->Actor\".\"serverId\" = \"VideoChannels->Actor->Server\".\"id\" ) ON \"Account\".\"id\" = \"VideoChannels\".\"accountId\" WHERE (\"Account\".\"userId\" = \"UserModel\".\"id\") LIMIT 1 ) IS NOT NULL LIMIT 1) AS \"UserModel\" LEFT OUTER JOIN ( \"videoChannel\" AS \"Account->VideoChannels\" INNER JOIN \"actor\" AS \"Account->VideoChannels->Actor\" ON \"Account->VideoChannels\".\"actorId\" = \"Account->VideoChannels->Actor\".\"id\" LEFT OUTER JOIN \"avatar\" AS \"Account->VideoChannels->Actor->Avatar\" ON \"Account->VideoChannels->Actor\".\"avatarId\" = \"Account->VideoChannels->Actor->Avatar\".\"id\" LEFT OUTER JOIN \"server\" AS \"Account->VideoChannels->Actor->Server\" ON \"Account->VideoChannels->Actor\".\"serverId\" = \"Account->VideoChannels->Actor->Server\".\"id\" ) ON \"Account.id\" = \"Account->VideoChannels\".\"accountId\" LEFT OUTER JOIN \"server\" AS \"Account->Actor->Server\" ON \"Account.Actor.serverId\" = \"Account->Actor->Server\".\"id\" LEFT OUTER JOIN \"avatar\" AS \"Account->Actor->Avatar\" ON \"Account.Actor.avatarId\" = \"Account->Actor->Avatar\".\"id\";","level":"debug","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:07.424Z"}
28{"message":"Executing (default): SELECT SUM(\"size\") AS \"total\" FROM (SELECT MAX(\"videoFile\".\"size\") AS \"size\" FROM \"videoFile\" INNER JOIN \"video\" ON \"videoFile\".\"videoId\" = \"video\".\"id\" INNER JOIN \"videoChannel\" ON \"videoChannel\".\"id\" = \"video\".\"channelId\" INNER JOIN \"account\" ON \"videoChannel\".\"accountId\" = \"account\".\"id\" WHERE \"account\".\"userId\" = $1 GROUP BY \"video\".\"id\") t","level":"debug","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:07.432Z"}
29{"message":"109.239.77.230 - - [31/Aug/2018:17:12:07 +0000] \"GET /api/v1/users//me/video-quota-used HTTP/1.0\" 304 - \"https://video.sebesdileni.cz/videos/upload\" \"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:60.0) Gecko/20100101 Firefox/60.0\"\n","level":"info","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:12:07.435Z"}
30{"message":"184.105.139.68 - - [31/Aug/2018:17:15:01 +0000] \"GET / HTTP/1.0\" 200 2915 \"-\" \"-\"\n","level":"info","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:15:01.952Z"}
31{"message":"Checking peers.","level":"debug","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:16:41.683Z"}
32{"message":"Getting access token (bearerToken: 3c36d54eebe39271c0b6e625120188c96e8a3bea).","level":"debug","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:21:29.613Z"}
33{"message":"Executing (default): SELECT \"OAuthTokenModel\".\"id\", \"OAuthTokenModel\".\"accessToken\", \"OAuthTokenModel\".\"accessTokenExpiresAt\", \"OAuthTokenModel\".\"refreshToken\", \"OAuthTokenModel\".\"refreshTokenExpiresAt\", \"OAuthTokenModel\".\"userId\", \"OAuthTokenModel\".\"oAuthClientId\", \"OAuthTokenModel\".\"createdAt\", \"OAuthTokenModel\".\"updatedAt\", \"User\".\"id\" AS \"User.id\", \"User\".\"password\" AS \"User.password\", \"User\".\"username\" AS \"User.username\", \"User\".\"email\" AS \"User.email\", \"User\".\"nsfwPolicy\" AS \"User.nsfwPolicy\", \"User\".\"autoPlayVideo\" AS \"User.autoPlayVideo\", \"User\".\"blocked\" AS \"User.blocked\", \"User\".\"blockedReason\" AS \"User.blockedReason\", \"User\".\"role\" AS \"User.role\", \"User\".\"videoQuota\" AS \"User.videoQuota\", \"User\".\"createdAt\" AS \"User.createdAt\", \"User\".\"updatedAt\" AS \"User.updatedAt\", \"User->Account\".\"id\" AS \"User.Account.id\", \"User->Account\".\"name\" AS \"User.Account.name\", \"User->Account\".\"description\" AS \"User.Account.description\", \"User->Account\".\"actorId\" AS \"User.Account.actorId\", \"User->Account\".\"userId\" AS \"User.Account.userId\", \"User->Account\".\"applicationId\" AS \"User.Account.applicationId\", \"User->Account\".\"createdAt\" AS \"User.Account.createdAt\", \"User->Account\".\"updatedAt\" AS \"User.Account.updatedAt\", \"User->Account->Actor\".\"id\" AS \"User.Account.Actor.id\", \"User->Account->Actor\".\"type\" AS \"User.Account.Actor.type\", \"User->Account->Actor\".\"uuid\" AS \"User.Account.Actor.uuid\", \"User->Account->Actor\".\"preferredUsername\" AS \"User.Account.Actor.preferredUsername\", \"User->Account->Actor\".\"url\" AS \"User.Account.Actor.url\", \"User->Account->Actor\".\"publicKey\" AS \"User.Account.Actor.publicKey\", \"User->Account->Actor\".\"privateKey\" AS \"User.Account.Actor.privateKey\", \"User->Account->Actor\".\"followersCount\" AS \"User.Account.Actor.followersCount\", \"User->Account->Actor\".\"followingCount\" AS \"User.Account.Actor.followingCount\", \"User->Account->Actor\".\"inboxUrl\" AS \"User.Account.Actor.inboxUrl\", \"User->Account->Actor\".\"outboxUrl\" AS \"User.Account.Actor.outboxUrl\", \"User->Account->Actor\".\"sharedInboxUrl\" AS \"User.Account.Actor.sharedInboxUrl\", \"User->Account->Actor\".\"followersUrl\" AS \"User.Account.Actor.followersUrl\", \"User->Account->Actor\".\"followingUrl\" AS \"User.Account.Actor.followingUrl\", \"User->Account->Actor\".\"avatarId\" AS \"User.Account.Actor.avatarId\", \"User->Account->Actor\".\"serverId\" AS \"User.Account.Actor.serverId\", \"User->Account->Actor\".\"createdAt\" AS \"User.Account.Actor.createdAt\", \"User->Account->Actor\".\"updatedAt\" AS \"User.Account.Actor.updatedAt\", \"User->Account->Actor->Server\".\"id\" AS \"User.Account.Actor.Server.id\", \"User->Account->Actor->Server\".\"host\" AS \"User.Account.Actor.Server.host\", \"User->Account->Actor->Server\".\"createdAt\" AS \"User.Account.Actor.Server.createdAt\", \"User->Account->Actor->Server\".\"updatedAt\" AS \"User.Account.Actor.Server.updatedAt\", \"User->Account->Actor->Avatar\".\"id\" AS \"User.Account.Actor.Avatar.id\", \"User->Account->Actor->Avatar\".\"filename\" AS \"User.Account.Actor.Avatar.filename\", \"User->Account->Actor->Avatar\".\"createdAt\" AS \"User.Account.Actor.Avatar.createdAt\", \"User->Account->Actor->Avatar\".\"updatedAt\" AS \"User.Account.Actor.Avatar.updatedAt\" FROM \"oAuthToken\" AS \"OAuthTokenModel\" LEFT OUTER JOIN ( \"user\" AS \"User\" INNER JOIN \"account\" AS \"User->Account\" ON \"User\".\"id\" = \"User->Account\".\"userId\" INNER JOIN \"actor\" AS \"User->Account->Actor\" ON \"User->Account\".\"actorId\" = \"User->Account->Actor\".\"id\" LEFT OUTER JOIN \"server\" AS \"User->Account->Actor->Server\" ON \"User->Account->Actor\".\"serverId\" = \"User->Account->Actor->Server\".\"id\" LEFT OUTER JOIN \"avatar\" AS \"User->Account->Actor->Avatar\" ON \"User->Account->Actor\".\"avatarId\" = \"User->Account->Actor->Avatar\".\"id\" ) ON \"OAuthTokenModel\".\"userId\" = \"User\".\"id\" WHERE \"OAuthTokenModel\".\"accessToken\" = '3c36d54eebe39271c0b6e625120188c96e8a3bea' LIMIT 1;","level":"debug","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:21:29.621Z"}
34{"message":"Checking peers.","level":"debug","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:21:41.684Z"}
35{"message":"109.239.77.230 - - [31/Aug/2018:17:23:58 +0000] \"POST /api/v1/videos/upload HTTP/1.0\" - - \"https://video.sebesdileni.cz/videos/upload\" \"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:60.0) Gecko/20100101 Firefox/60.0\"\n","level":"info","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:23:58.106Z"}
36{"message":"Checking peers.","level":"debug","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:26:41.685Z"}
37{"parameters":{"start":"0","count":"40","sort":"-views"},"level":"debug","message":"Checking pagination parameters","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:30:00.213Z"}
38{"parameters":{"start":"0","count":"40","sort":"-views"},"level":"debug","message":"Checking sort parameters","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:30:00.214Z"}
39{"message":"Getting access token (bearerToken: 3c36d54eebe39271c0b6e625120188c96e8a3bea).","level":"debug","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:30:00.216Z"}
40{"message":"Executing (default): SELECT \"OAuthTokenModel\".\"id\", \"OAuthTokenModel\".\"accessToken\", \"OAuthTokenModel\".\"accessTokenExpiresAt\", \"OAuthTokenModel\".\"refreshToken\", \"OAuthTokenModel\".\"refreshTokenExpiresAt\", \"OAuthTokenModel\".\"userId\", \"OAuthTokenModel\".\"oAuthClientId\", \"OAuthTokenModel\".\"createdAt\", \"OAuthTokenModel\".\"updatedAt\", \"User\".\"id\" AS \"User.id\", \"User\".\"password\" AS \"User.password\", \"User\".\"username\" AS \"User.username\", \"User\".\"email\" AS \"User.email\", \"User\".\"nsfwPolicy\" AS \"User.nsfwPolicy\", \"User\".\"autoPlayVideo\" AS \"User.autoPlayVideo\", \"User\".\"blocked\" AS \"User.blocked\", \"User\".\"blockedReason\" AS \"User.blockedReason\", \"User\".\"role\" AS \"User.role\", \"User\".\"videoQuota\" AS \"User.videoQuota\", \"User\".\"createdAt\" AS \"User.createdAt\", \"User\".\"updatedAt\" AS \"User.updatedAt\", \"User->Account\".\"id\" AS \"User.Account.id\", \"User->Account\".\"name\" AS \"User.Account.name\", \"User->Account\".\"description\" AS \"User.Account.description\", \"User->Account\".\"actorId\" AS \"User.Account.actorId\", \"User->Account\".\"userId\" AS \"User.Account.userId\", \"User->Account\".\"applicationId\" AS \"User.Account.applicationId\", \"User->Account\".\"createdAt\" AS \"User.Account.createdAt\", \"User->Account\".\"updatedAt\" AS \"User.Account.updatedAt\", \"User->Account->Actor\".\"id\" AS \"User.Account.Actor.id\", \"User->Account->Actor\".\"type\" AS \"User.Account.Actor.type\", \"User->Account->Actor\".\"uuid\" AS \"User.Account.Actor.uuid\", \"User->Account->Actor\".\"preferredUsername\" AS \"User.Account.Actor.preferredUsername\", \"User->Account->Actor\".\"url\" AS \"User.Account.Actor.url\", \"User->Account->Actor\".\"publicKey\" AS \"User.Account.Actor.publicKey\", \"User->Account->Actor\".\"privateKey\" AS \"User.Account.Actor.privateKey\", \"User->Account->Actor\".\"followersCount\" AS \"User.Account.Actor.followersCount\", \"User->Account->Actor\".\"followingCount\" AS \"User.Account.Actor.followingCount\", \"User->Account->Actor\".\"inboxUrl\" AS \"User.Account.Actor.inboxUrl\", \"User->Account->Actor\".\"outboxUrl\" AS \"User.Account.Actor.outboxUrl\", \"User->Account->Actor\".\"sharedInboxUrl\" AS \"User.Account.Actor.sharedInboxUrl\", \"User->Account->Actor\".\"followersUrl\" AS \"User.Account.Actor.followersUrl\", \"User->Account->Actor\".\"followingUrl\" AS \"User.Account.Actor.followingUrl\", \"User->Account->Actor\".\"avatarId\" AS \"User.Account.Actor.avatarId\", \"User->Account->Actor\".\"serverId\" AS \"User.Account.Actor.serverId\", \"User->Account->Actor\".\"createdAt\" AS \"User.Account.Actor.createdAt\", \"User->Account->Actor\".\"updatedAt\" AS \"User.Account.Actor.updatedAt\", \"User->Account->Actor->Server\".\"id\" AS \"User.Account.Actor.Server.id\", \"User->Account->Actor->Server\".\"host\" AS \"User.Account.Actor.Server.host\", \"User->Account->Actor->Server\".\"createdAt\" AS \"User.Account.Actor.Server.createdAt\", \"User->Account->Actor->Server\".\"updatedAt\" AS \"User.Account.Actor.Server.updatedAt\", \"User->Account->Actor->Avatar\".\"id\" AS \"User.Account.Actor.Avatar.id\", \"User->Account->Actor->Avatar\".\"filename\" AS \"User.Account.Actor.Avatar.filename\", \"User->Account->Actor->Avatar\".\"createdAt\" AS \"User.Account.Actor.Avatar.createdAt\", \"User->Account->Actor->Avatar\".\"updatedAt\" AS \"User.Account.Actor.Avatar.updatedAt\" FROM \"oAuthToken\" AS \"OAuthTokenModel\" LEFT OUTER JOIN ( \"user\" AS \"User\" INNER JOIN \"account\" AS \"User->Account\" ON \"User\".\"id\" = \"User->Account\".\"userId\" INNER JOIN \"actor\" AS \"User->Account->Actor\" ON \"User->Account\".\"actorId\" = \"User->Account->Actor\".\"id\" LEFT OUTER JOIN \"server\" AS \"User->Account->Actor->Server\" ON \"User->Account->Actor\".\"serverId\" = \"User->Account->Actor->Server\".\"id\" LEFT OUTER JOIN \"avatar\" AS \"User->Account->Actor->Avatar\" ON \"User->Account->Actor\".\"avatarId\" = \"User->Account->Actor->Avatar\".\"id\" ) ON \"OAuthTokenModel\".\"userId\" = \"User\".\"id\" WHERE \"OAuthTokenModel\".\"accessToken\" = '3c36d54eebe39271c0b6e625120188c96e8a3bea' LIMIT 1;","level":"debug","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:30:00.224Z"}
41{"parameters":{"start":0,"count":40,"sort":"-views"},"level":"debug","message":"Checking commons video filters query","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:30:00.234Z"}
42{"message":"Executing (default): SELECT count(*) AS \"count\" FROM \"video\" AS \"VideoModel\" INNER JOIN \"videoChannel\" AS \"VideoChannel\" ON \"VideoModel\".\"channelId\" = \"VideoChannel\".\"id\" INNER JOIN \"actor\" AS \"VideoChannel->Actor\" ON \"VideoChannel\".\"actorId\" = \"VideoChannel->Actor\".\"id\" LEFT OUTER JOIN \"server\" AS \"VideoChannel->Actor->Server\" ON \"VideoChannel->Actor\".\"serverId\" = \"VideoChannel->Actor->Server\".\"id\" LEFT OUTER JOIN \"avatar\" AS \"VideoChannel->Actor->Avatar\" ON \"VideoChannel->Actor\".\"avatarId\" = \"VideoChannel->Actor->Avatar\".\"id\" INNER JOIN \"account\" AS \"VideoChannel->Account\" ON \"VideoChannel\".\"accountId\" = \"VideoChannel->Account\".\"id\" INNER JOIN \"actor\" AS \"VideoChannel->Account->Actor\" ON \"VideoChannel->Account\".\"actorId\" = \"VideoChannel->Account->Actor\".\"id\" LEFT OUTER JOIN \"server\" AS \"VideoChannel->Account->Actor->Server\" ON \"VideoChannel->Account->Actor\".\"serverId\" = \"VideoChannel->Account->Actor->Server\".\"id\" LEFT OUTER JOIN \"avatar\" AS \"VideoChannel->Account->Actor->Avatar\" ON \"VideoChannel->Account->Actor\".\"avatarId\" = \"VideoChannel->Account->Actor->Avatar\".\"id\" WHERE (\"VideoModel\".\"state\" = 1 OR (\"VideoModel\".\"state\" = 2 AND \"VideoModel\".\"waitTranscoding\" = false)) AND (\"VideoModel\".\"id\" NOT IN (SELECT \"videoBlacklist\".\"videoId\" FROM \"videoBlacklist\") AND \"VideoModel\".\"id\" IN (SELECT \"videoShare\".\"videoId\" AS \"id\" FROM \"videoShare\" INNER JOIN \"actorFollow\" ON \"actorFollow\".\"targetActorId\" = \"videoShare\".\"actorId\" WHERE \"actorFollow\".\"actorId\" = 1 UNION SELECT \"video\".\"id\" AS \"id\" FROM \"video\" INNER JOIN \"videoChannel\" ON \"videoChannel\".\"id\" = \"video\".\"channelId\" INNER JOIN \"account\" ON \"account\".\"id\" = \"videoChannel\".\"accountId\" INNER JOIN \"actor\" ON \"account\".\"actorId\" = \"actor\".\"id\" WHERE \"actor\".\"serverId\" IS NULL  UNION ALL SELECT \"video\".\"id\" AS \"id\" FROM \"video\" INNER JOIN \"videoChannel\" ON \"videoChannel\".\"id\" = \"video\".\"channelId\" INNER JOIN \"account\" ON \"account\".\"id\" = \"videoChannel\".\"accountId\" INNER JOIN \"actor\" ON \"account\".\"actorId\" = \"actor\".\"id\" INNER JOIN \"actorFollow\" ON \"actorFollow\".\"targetActorId\" = \"actor\".\"id\" WHERE \"actorFollow\".\"actorId\" = 1)) AND \"VideoModel\".\"privacy\" = 1 AND \"VideoModel\".\"nsfw\" = false;","level":"debug","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:30:00.243Z"}
43{"message":"Executing (default): SELECT \"VideoModel\".\"id\", \"VideoModel\".\"uuid\", \"VideoModel\".\"name\", \"VideoModel\".\"category\", \"VideoModel\".\"licence\", \"VideoModel\".\"language\", \"VideoModel\".\"privacy\", \"VideoModel\".\"nsfw\", \"VideoModel\".\"description\", \"VideoModel\".\"support\", \"VideoModel\".\"duration\", \"VideoModel\".\"views\", \"VideoModel\".\"likes\", \"VideoModel\".\"dislikes\", \"VideoModel\".\"remote\", \"VideoModel\".\"url\", \"VideoModel\".\"commentsEnabled\", \"VideoModel\".\"waitTranscoding\", \"VideoModel\".\"state\", \"VideoModel\".\"publishedAt\", \"VideoModel\".\"channelId\", \"VideoModel\".\"createdAt\", \"VideoModel\".\"updatedAt\", \"VideoChannel\".\"name\" AS \"VideoChannel.name\", \"VideoChannel\".\"description\" AS \"VideoChannel.description\", \"VideoChannel\".\"id\" AS \"VideoChannel.id\", \"VideoChannel->Actor\".\"id\" AS \"VideoChannel.Actor.id\", \"VideoChannel->Actor\".\"uuid\" AS \"VideoChannel.Actor.uuid\", \"VideoChannel->Actor\".\"preferredUsername\" AS \"VideoChannel.Actor.preferredUsername\", \"VideoChannel->Actor\".\"url\" AS \"VideoChannel.Actor.url\", \"VideoChannel->Actor\".\"serverId\" AS \"VideoChannel.Actor.serverId\", \"VideoChannel->Actor\".\"avatarId\" AS \"VideoChannel.Actor.avatarId\", \"VideoChannel->Actor->Server\".\"id\" AS \"VideoChannel.Actor.Server.id\", \"VideoChannel->Actor->Server\".\"host\" AS \"VideoChannel.Actor.Server.host\", \"VideoChannel->Actor->Avatar\".\"id\" AS \"VideoChannel.Actor.Avatar.id\", \"VideoChannel->Actor->Avatar\".\"filename\" AS \"VideoChannel.Actor.Avatar.filename\", \"VideoChannel->Actor->Avatar\".\"createdAt\" AS \"VideoChannel.Actor.Avatar.createdAt\", \"VideoChannel->Actor->Avatar\".\"updatedAt\" AS \"VideoChannel.Actor.Avatar.updatedAt\", \"VideoChannel->Account\".\"id\" AS \"VideoChannel.Account.id\", \"VideoChannel->Account\".\"name\" AS \"VideoChannel.Account.name\", \"VideoChannel->Account->Actor\".\"id\" AS \"VideoChannel.Account.Actor.id\", \"VideoChannel->Account->Actor\".\"uuid\" AS \"VideoChannel.Account.Actor.uuid\", \"VideoChannel->Account->Actor\".\"preferredUsername\" AS \"VideoChannel.Account.Actor.preferredUsername\", \"VideoChannel->Account->Actor\".\"url\" AS \"VideoChannel.Account.Actor.url\", \"VideoChannel->Account->Actor\".\"serverId\" AS \"VideoChannel.Account.Actor.serverId\", \"VideoChannel->Account->Actor\".\"avatarId\" AS \"VideoChannel.Account.Actor.avatarId\", \"VideoChannel->Account->Actor->Server\".\"id\" AS \"VideoChannel.Account.Actor.Server.id\", \"VideoChannel->Account->Actor->Server\".\"host\" AS \"VideoChannel.Account.Actor.Server.host\", \"VideoChannel->Account->Actor->Avatar\".\"id\" AS \"VideoChannel.Account.Actor.Avatar.id\", \"VideoChannel->Account->Actor->Avatar\".\"filename\" AS \"VideoChannel.Account.Actor.Avatar.filename\", \"VideoChannel->Account->Actor->Avatar\".\"createdAt\" AS \"VideoChannel.Account.Actor.Avatar.createdAt\", \"VideoChannel->Account->Actor->Avatar\".\"updatedAt\" AS \"VideoChannel.Account.Actor.Avatar.updatedAt\" FROM \"video\" AS \"VideoModel\" INNER JOIN \"videoChannel\" AS \"VideoChannel\" ON \"VideoModel\".\"channelId\" = \"VideoChannel\".\"id\" INNER JOIN \"actor\" AS \"VideoChannel->Actor\" ON \"VideoChannel\".\"actorId\" = \"VideoChannel->Actor\".\"id\" LEFT OUTER JOIN \"server\" AS \"VideoChannel->Actor->Server\" ON \"VideoChannel->Actor\".\"serverId\" = \"VideoChannel->Actor->Server\".\"id\" LEFT OUTER JOIN \"avatar\" AS \"VideoChannel->Actor->Avatar\" ON \"VideoChannel->Actor\".\"avatarId\" = \"VideoChannel->Actor->Avatar\".\"id\" INNER JOIN \"account\" AS \"VideoChannel->Account\" ON \"VideoChannel\".\"accountId\" = \"VideoChannel->Account\".\"id\" INNER JOIN \"actor\" AS \"VideoChannel->Account->Actor\" ON \"VideoChannel->Account\".\"actorId\" = \"VideoChannel->Account->Actor\".\"id\" LEFT OUTER JOIN \"server\" AS \"VideoChannel->Account->Actor->Server\" ON \"VideoChannel->Account->Actor\".\"serverId\" = \"VideoChannel->Account->Actor->Server\".\"id\" LEFT OUTER JOIN \"avatar\" AS \"VideoChannel->Account->Actor->Avatar\" ON \"VideoChannel->Account->Actor\".\"avatarId\" = \"VideoChannel->Account->Actor->Avatar\".\"id\" WHERE (\"VideoModel\".\"state\" = 1 OR (\"VideoModel\".\"state\" = 2 AND \"VideoModel\".\"waitTranscoding\" = false)) AND (\"VideoModel\".\"id\" NOT IN (SELECT \"videoBlacklist\".\"videoId\" FROM \"videoBlacklist\") AND \"VideoModel\".\"id\" IN (SELECT \"videoShare\".\"videoId\" AS \"id\" FROM \"videoShare\" INNER JOIN \"actorFollow\" ON \"actorFollow\".\"targetActorId\" = \"videoShare\".\"actorId\" WHERE \"actorFollow\".\"actorId\" = 1 UNION SELECT \"video\".\"id\" AS \"id\" FROM \"video\" INNER JOIN \"videoChannel\" ON \"videoChannel\".\"id\" = \"video\".\"channelId\" INNER JOIN \"account\" ON \"account\".\"id\" = \"videoChannel\".\"accountId\" INNER JOIN \"actor\" ON \"account\".\"actorId\" = \"actor\".\"id\" WHERE \"actor\".\"serverId\" IS NULL  UNION ALL SELECT \"video\".\"id\" AS \"id\" FROM \"video\" INNER JOIN \"videoChannel\" ON \"videoChannel\".\"id\" = \"video\".\"channelId\" INNER JOIN \"account\" ON \"account\".\"id\" = \"videoChannel\".\"accountId\" INNER JOIN \"actor\" ON \"account\".\"actorId\" = \"actor\".\"id\" INNER JOIN \"actorFollow\" ON \"actorFollow\".\"targetActorId\" = \"actor\".\"id\" WHERE \"actorFollow\".\"actorId\" = 1)) AND \"VideoModel\".\"privacy\" = 1 AND \"VideoModel\".\"nsfw\" = false ORDER BY \"VideoModel\".\"views\" DESC, \"VideoModel\".\"id\" ASC LIMIT 40 OFFSET 0;","level":"debug","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:30:00.252Z"}
44{"message":"109.239.77.230 - - [31/Aug/2018:17:30:00 +0000] \"GET /api/v1/videos/?start=0&count=40&sort=-views HTTP/1.0\" 304 - \"https://video.sebesdileni.cz/videos/trending\" \"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:60.0) Gecko/20100101 Firefox/60.0\"\n","level":"info","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:30:00.264Z"}
45{"message":"109.239.77.230 - - [31/Aug/2018:17:30:00 +0000] \"GET /client/locales/cs-CZ/server.json HTTP/1.0\" 304 - \"https://video.sebesdileni.cz/videos/trending\" \"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:60.0) Gecko/20100101 Firefox/60.0\"\n","level":"info","label":"video.sebesdileni.cz:443","timestamp":"2018-08-31T17:30:00.283Z"}