Peloton - kopp on ees Statistikas

Statistika

Komme kokku	88
Kommitud päevi	4976
Keskmiselt komme päevas	0.018
Tegelikult kommitud päevi	19
Kommivabu päevi	4957
Keskmiselt komme kommitud päevadel	0.018
Erinevaid nimesid kokku	25
Enim komme ühel päeval	35	2023-05-04
Enim komme ühelt nimelt	29	lisa
Enim komme ühelt nimelt päevas	29	lisa, 2023-05-04
Enim erinevaid nimesid päevas	7	2013-07-30
Kõige kõrgemalt hinnatud kommentaator	8	lisa

Aastad

2012	8
2013	16
2015	1
2017	6
2019	7
2020	2
2021	1
2023	38
2024	1
2025	8

Kuud

Jaanuar	7
Veebruar	9
Märts	2
Aprill	9
Mai	40
Juuni	2
Juuli	8
September	8
Detsember	3

Päevad

4	Komme: 41
5	Komme: 2
6	Komme: 2
7	Komme: 1
8	Komme: 1
15	Komme: 5
16	Komme: 2
17	Komme: 2
18	Komme: 9
19	Komme: 1
22	Komme: 2
23	Komme: 1
25	Komme: 2
27	Komme: 7
29	Komme: 1
30	Komme: 9

Tunnid

7	3
8	3
9	5
10	7
11	2
12	7
13	10
14	2
15	39
16	6
18	2
20	2

Edetabel

1	lisa	29
2	test	14
3	Po	10
4	tekamsee	5
5	Potsataja (KMO)	5
6	Pot	3
7	Graveyard Singer	2
8	ddd	2
9	Potsa	2
10	dukqdqoolrbu fzdmsr hvhlalnnuq	1
11	kes	1
12	sql	1
13	fwefa	1
14	Gtlpkwcn Kwiwp	1
15	wxdwwe qvd ophqu nms	1
16	aejvs ryurmctngy wisth wfuhnaogl	1
17	eeeeee	1
18	dddd	1
19	gzehm igdfrvtlcxm	1
20	fgppeojfkm knfvhqpb ytluq ehik	1

(default) 13 queries took 3 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SHOW FULL COLUMNS FROM `books`	3	3	1
2	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';	1	1	1
3	select count(*) cnt, dateDiff( max(aeg), min(aeg) ) paevi, count(distinct date(aeg)) tegpaevi, count(distinct nimi) nimesid from komms as Komm	1	1	0
4	select date(aeg) paev, count(id) cnt from komms as Komm group by paev order by cnt desc limit 1	1	1	0
5	select nimi, count(id) cnt from komms as Komm group by nimi order by cnt desc limit 1	1	1	0
6	select nimi, date(aeg) paev, count(id) cnt from komms as Komm group by nimi, paev order by cnt desc limit 1	1	1	0
7	select date(aeg) paev, count(distinct nimi) cnt from komms as Komm group by paev order by cnt desc limit 1	1	1	0
8	select Komm.nimi nimi, sum(Point.hinne) hinne from komms as Komm, points as Point where Komm.id = Point.komm_id group by Komm.nimi order by hinne desc limit 1	1	1	1
9	select year(aeg) aasta, count(distinct nimi) nimesid, count(distinct id) komme from komms as Komm group by aasta order by aasta	10	10	0
10	select month(aeg) kuu, count(distinct nimi) nimesid, count(distinct id) komme from komms as Komm group by kuu order by kuu	9	9	0
11	select day(aeg) paev, count(distinct nimi) nimesid, count(distinct id) komme from komms as Komm group by paev order by paev	16	16	0
12	select hour(aeg) tund, count(distinct nimi) nimesid, count(distinct id) komme from komms as Komm group by tund order by tund	12	12	0
13	select nimi, count(id) komme from komms as Komm group by nimi order by komme desc limit 20	20	20	0

(default) 13 queries took 3 ms

Query

Error

Affected

Num. rows

Took (ms)

SHOW FULL COLUMNS FROM `books`

SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';

select count(*) cnt, dateDiff( max(aeg), min(aeg) ) paevi, count(distinct date(aeg)) tegpaevi, count(distinct nimi) nimesid from komms as Komm

select date(aeg) paev, count(id) cnt from komms as Komm group by paev order by cnt desc limit 1

select nimi, count(id) cnt from komms as Komm group by nimi order by cnt desc limit 1

select nimi, date(aeg) paev, count(id) cnt from komms as Komm group by nimi, paev order by cnt desc limit 1

select date(aeg) paev, count(distinct nimi) cnt from komms as Komm group by paev order by cnt desc limit 1

select Komm.nimi nimi, sum(Point.hinne) hinne from komms as Komm, points as Point where Komm.id = Point.komm_id group by Komm.nimi order by hinne desc limit 1

select year(aeg) aasta, count(distinct nimi) nimesid, count(distinct id) komme from komms as Komm group by aasta order by aasta

select month(aeg) kuu, count(distinct nimi) nimesid, count(distinct id) komme from komms as Komm group by kuu order by kuu

select day(aeg) paev, count(distinct nimi) nimesid, count(distinct id) komme from komms as Komm group by paev order by paev

select hour(aeg) tund, count(distinct nimi) nimesid, count(distinct id) komme from komms as Komm group by tund order by tund

select nimi, count(id) komme from komms as Komm group by nimi order by komme desc limit 20