#sql @ freenode stats by mapreri

Statistics generated on Tuesday 1 August 2023 - 21:46:09
During this 971-day reporting period, a total of 5654 different nicks were represented on #sql.


Daily activity (last 31 days)
524
27
5
7
8
329
15
4
6
4
481
10
16
8
9
496
10
9
18
6
493
11
18
7
9
761
22
28
11
9
756
19
18
17
14
813
26
7
8
33
354
8
7
7
9
585
17
19
9
7
664
20
27
7
5
632
10
20
18
9
618
18
18
10
11
665
28
11
12
9
377
10
11
6
6
255
6
6
6
3
497
9
24
7
4
648
23
21
11
4
626
27
16
8
4
606
16
16
11
11
1069
36
34
11
17
639
8
22
12
16
265
6
6
6
5
524
17
15
10
5
712
18
25
13
8
931
13
38
23
11
632
9
33
11
5
940
13
29
33
10
298
12
5
5
4
368
10
9
7
6
149
8
5
30 29 28 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0
0-5 = 0-5 6-11 = 6-11 12-17 = 12-17 18-23 = 18-23

Most active times
3.6%
25063
3.2%
22827
3.1%
21671
2.8%
19919
2.7%
18758
2.7%
19120
2.7%
19068
3.0%
21319
3.3%
23280
3.3%
23537
3.3%
23591
3.5%
24354
3.9%
27524
4.7%
33473
5.2%
36982
5.8%
40888
5.8%
40661
5.7%
40494
5.8%
41029
5.8%
40967
5.7%
40268
5.5%
38535
4.5%
31832
4.2%
29967
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
0-5 = 0-5 6-11 = 6-11 12-17 = 12-17 18-23 = 18-23

Most active nicks
 NickNumber of linesWhen?Number of WordsWords per lineChars per lineLast seenRandom quote
1 Xgc4546322870597819 226524546322870597819 33464414.885.6230 days ago"archheretic: SELECT does something entirely different. :)"
2 MatheusOl1038163087034746 161171038163087034746 16456510.256.53 days ago"Gamah: do you have the link?"
3 Gamah72681542268775 1454272681542268775 1154557.943.63 days ago"surely giving it a few gigs is ok"
4 twist208941530103736 9250208941530103736 10617311.567.6111 days ago"date and time functions exist for this purpose."
5 ||cw239724993 904639724993 10687011.864.24 days ago"or not, it's not really clear to me, yet"
6 Xgc_150855430203021 8103150855430203021 12226515.186.6yesterday"RedAero: No. Use IS DISTINCT FROM or an equivalent logic."
7 Entalyan-192092117792223 6843192092117792223 11205316.491.360 days ago"lseactuary: And that was your GROUP BY clause?"
8 pluszak28832980 587228832980 6234810.658.13 days ago"IcyPhoenix: you don't, the query planner does"
9 Azrael_-55385717712628 580955385717712628 7730813.374.7yesterday"using the ssms-wizard but the "last updated"-value didn't change"
10 testtcl3767681471 28041893767681471 4232315.191.8yesterday"lseactuary: So, this is just denormalized, ok."
11 bewbs13721325 27889113721325 198337.137.140 days ago"there's more fields in the table but it breaks on that one"
12 Firien1808925 27551808925 3865114.078.824 days ago"then your FROM is incorrect"
13 incognito9291187 2362170929118776 178177.543.8today"ysch : i represent them like sword falling from sky :)"
14 lseactuary2512271601229 23082512271601229 181547.940.83 days ago"as left join should disclude those"
15 Juggie`1740334 22331740135334 176417.940.63 days ago"you cant ever compare NULL that way"
16 jmer_5381526 2150538152676 2842013.272.53 days ago"It could potentially be solved in the SSAS Tabular model"
17 zaffinge-2734831153 19252734831153 120426.335.0yesterday"I hate the language barrier"
18 hellyeah1040636 17161040636 123127.240.6743 days ago"i think it was kinda of non sense"
19 martin290970379 153597044142379 108947.137.731 days ago"definitely use a transaction"
20 Amoeba243632608 1483243632608 89666.030.4455 days ago"not sure what he expects us to do about it"
21 apothecary_595689 134561595689 1516111.361.4today"incognito: that looks neat"
22 IcyPhoenix_752363 1326752363209 83996.332.95 days ago"I'm saying that I'd rather do a JOIN over a Sub Query IN"
23 cairnz_654348260 1273654348260 1541912.167.118 days ago"isthisajokeORWHA .. did you read what it means?"
24 dadsfas490736 126449073638 80276.433.443 days ago"you can find some alternatives"
25 \mSg_mini710231254 126171023166254 1548812.369.53 days ago"but specifically, the name of the functions, are ETL processes..."


These didn't make it to the top:
NotStooge (1148) ionas_ (1114) GeneralShenaniga (1059) Entalyan (1046) Beeeeeks (953)
guide_X (913) reduce (825) centrx (807) The_Tick (804) plushy (770)
cntrx (755) ekeret01__ (746) Beeks (732) Vady (729) toughtroxs_ (686)
dostoyev1ky (666) lalskdjflasdiiu2 (663) ||cw (647) AnimalFarmPig_ (638) goldfinger (632)
Devastator_ (629) beaky (626) NonSecwitter (623) NullEntity_ (622) b0oing (621)
flyko_ (618) JBlitzen\AG (614) teta (602) BetaFrey1 (562) steveoh (553)

By the way, there were 5599 other nicks.

Most active nicks by hours
  0-5 6-11 12-17 18-23
1 Xgc - 4546 Xgc - 3228 MatheusOl - 8703 Gamah - 8775
2 twist - 2089 pluszak - 2883 Xgc - 7059 Xgc - 7819
3 Entalyan- - 1920 Firien - 1808 Gamah - 4226 ||cw2 - 4993
4 Juggie` - 1740 MatheusOl - 1630 ||cw2 - 3972 MatheusOl - 4746
5 Xgc_ - 1508 hellyeah - 1040 Xgc_ - 3020 twist - 3736

Big numbers
Is testtcl stupid or just asking too many questions? 42.3% lines contained a question!
tarkus didn't know that much either. 42.0% of his/her lines were questions.
The loudest one was no_gravity, who yelled 11.8% of the time!
Another old yeller was wfpkhc, who shouted 10.7% of the time!
It seems that DirtyDeF's shift-key is hanging: 7.8% of the time he/she wrote UPPERCASE.
For example, like this:
     <DirtyDeF> MUSICIAN (MNO, NAME, ADDRESS, PHONE)

notchris just forgot to deactivate his/her Caps-Lock. He/She wrote UPPERCASE 4.1% of the time.
Nobody beat anyone up. Everybody was friendly.
Entalyan- brings happiness to the world. 22.6% lines contained smiling faces. :)
testtcl isn't a sad person either, smiling 21.7% of the time.
wedr seems to be sad at the moment: 5.8% lines contained sad faces. :(
Supertanker is also a sad person, crying 4.3% of the time.
waveform wrote the longest lines, averaging 145.0 letters per line.
#sql average was 64.5 letters per line.
notchris wrote the shortest lines, averaging 26.4 characters per line.
sqln00b was tight-lipped, too, averaging 28.1 characters.
Xgc spoke a total of 334644 words!
Xgc's faithful follower, MatheusOl, didn't speak so much: 164565 words.
jephsf wrote an average of 97.00 words per line.
Channel average was 11.71 words per line.

Users with most nicknames
 Nick Names Used
1 Devastator_ (33 names) VLife7VL, Devastator_n, Devastator_o, Devastator_q, Devastator_y, ...
2 _Tristan-Speccy_ (30 names) Guest6851, Guest51228, Guest18308, Guest82871, Guest63576, ...
3 OverCoder (30 names) ServBottle, Cloak, Internet, BananaPower, c[__], ...
4 t0xic (27 names) Guest74410, t0xic-, squiggle_, Guest48857, Guest84025, ...
5 digifiv5e (27 names) Guest34688, Guest66988, Guest89586, Guest17350, Guest98794, ...

Most active gender
 GenderNumber of linesNick
1 Male 22339 64 mapreri (36), twb (22), mtuts (6)

Most used words
 Word Number of Uses Last Used by
1 table 20486 timothy
2 Select 13523 Azrael_-
3 WHERE 10618 Azrael_-
4 there 10502 garyserj
5 query 10186 MatheusOl
6 would 10036 Azrael_-
7 about 6955 temple48
8 using 6927 roger_padactor_w
9 which 6803 testtcl
10 column 6027 testtcl

Most referenced nicks
 Nick Number of Uses Last Used by
1 SQL 16260 tttb
2 Xgc 4800 Gamah
3 tables 4555 lmoo
4 MatheusOl 2268 Gamah
5 User 2056 walbo

Smileys :-)
 Smiley Number of Uses Last Used by
1 :) 4478 Xgc_
2 ;) 1659 testtcl
3 :p 1489 Stogoe
4 :D 1233 zaffinge-
5 :P 1197 Gamah
6 :( 859 incognito
7 :/ 505 Gamah
8 ): 186 realies
9 :-) 171 NGC3982
10 D: 91 mallu

#sql karma
 Nick Karma Good karma by Bad karma by
1 Xgc 3 tang^_^, anli, MatheusOl
2 Gamah 2 Uranium[oc], MatheusOl
3 boogyman 1 MatheusOl
4 postgresql 1 MatheusOl
5 Entalyan 1 MatheusOl
3 ah -1 teta
2 mssql -1 MatheusOl
1 %3b%20select%20*%20from%20users%3b%20 -1 np

Most referenced URLs
 URL Number of Uses Last Used by
1 http://blog.codinghorror.com/a-visual-explanation-of-sql-joi 41 garyserj
2 http://sqlfiddle.com/ 20 dancrew32
3 http://grimoire.ca/mysql/choose-something-else 16 MatheusOl
4 https://blog.codinghorror.com/a-visual-explanation-of-sql-jo 15 Xgc_
5 http://www.sqlfiddle.com 14 Azrael_-

#sql Music Charts
 Song How Often Played Last Played by
1 Is there a command to check duplicates of existing data in t 1 Dexx1_
2 makes sense. thank you. you've been a great help 1 research4oscar
3 ahoy? Are you a pirate 1 JosefDe
4 DISTINCT ... expression .... there's no required ( )s and 1 Xgc
5 table layout 1 Azrael_-

Other interesting numbers
Nice opers here, no one got kicked!
ChanServ donated 2 ops in the channel...
ChanServ is the channel sheriff with 1 deops.
Strange, no voices were given on #sql!
No voices were taken on #sql!
Gamah always lets us know what he/she's doing: 348 actions!
For example, like this:
     * gamah waves

Also, MatheusOl tells us what's up with 228 actions.
Xgc talks to him/herself a lot. He/She wrote over 5 lines in a row 221 times!
Another lonely one was Gamah, who managed to hit 166 times.
YoutubeAPI couldn't decide whether to stay or go. 3200 joins during this reporting period!
artung has quite a potty mouth. 1.9% words were foul language.
For example, like this:
     <artung> case don't loose time with idiot

techlib also makes sailors blush, 1.9% of the time.

Latest Topics
A topic was never set on this channel.
Total number of lines: 705127.