#qa | Logs for 2017-01-04
« return
[02:58:36] Bytram is now known as Beetlejuice
[03:00:18] Beetlejuice is now known as Bytram
[03:00:27] Bytram is now known as Bytram|fite
[03:01:10] Bytram|fite is now known as Bytram
[13:26:03] -!- TheMightyBuzzard [TheMightyBuzzard!~TheMighty@Soylent/Staff/Developer/TMB] has joined #qa
[13:36:47] <TheMightyBuzzard> Bytram, select users.nickname, foo.uid, foo.posts from (select uid, count(*) as posts from comments where comments.uid <> 1 group by uid order by posts desc) as foo left join users on foo.uid=users.uid limit 10;
[13:36:59] <TheMightyBuzzard> adjust limit to give you as many as you like
[13:43:32] <TheMightyBuzzard> +--------------------+------+-------+
[13:43:32] <TheMightyBuzzard> | nickname | uid | posts |
[13:43:32] <TheMightyBuzzard> +--------------------+------+-------+
[13:43:32] <TheMightyBuzzard> | frojack | 1554 | 8173 |
[13:43:32] <TheMightyBuzzard> | VLM | 445 | 6167 |
[13:43:33] <TheMightyBuzzard> | Runaway1956 | 2926 | 5626 |
[13:43:37] <TheMightyBuzzard> | khallow | 3766 | 5456 |
[13:43:39] <TheMightyBuzzard> | takyon | 881 | 4897 |
[13:43:41] <TheMightyBuzzard> | c0lo | 156 | 4742 |
[13:43:43] <TheMightyBuzzard> | The Mighty Buzzard | 18 | 3769 |
[13:43:45] <TheMightyBuzzard> | Phoenix666 | 552 | 3752 |
[13:43:47] <TheMightyBuzzard> | aristarchus | 2645 | 3617 |
[13:43:49] <TheMightyBuzzard> | kaszz | 4211 | 3436 |
[13:43:51] <TheMightyBuzzard> +--------------------+------+-------+
[13:48:00] <TheMightyBuzzard> Bytram, my bad, that was for all time
[13:48:17] <TheMightyBuzzard> this is for last year: select users.nickname, foo.uid, foo.posts from (select uid, count(*) as posts from comments where comments.uid <> 1 and date < "2017-01-01 00:00:00" and date > "2015-12-31 23:59:59" group by uid order by posts desc limit 10) as foo left join users on foo.uid=users.uid;
[13:48:33] <TheMightyBuzzard> +--------------------+------+-------+
[13:48:33] <TheMightyBuzzard> | nickname | uid | posts |
[13:48:33] <TheMightyBuzzard> +--------------------+------+-------+
[13:48:33] <TheMightyBuzzard> | Runaway1956 | 2926 | 2815 |
[13:48:33] <TheMightyBuzzard> | takyon | 881 | 2805 |
[13:48:36] <TheMightyBuzzard> | khallow | 3766 | 2620 |
[13:48:38] <TheMightyBuzzard> | frojack | 1554 | 2169 |
[13:48:40] <TheMightyBuzzard> | The Mighty Buzzard | 18 | 1950 |
[13:48:42] <TheMightyBuzzard> | VLM | 445 | 1910 |
[13:48:44] <TheMightyBuzzard> | butthurt | 6141 | 1726 |
[13:48:46] <TheMightyBuzzard> | Phoenix666 | 552 | 1624 |
[13:48:48] <TheMightyBuzzard> | bob_super | 1357 | 1569 |
[13:48:50] <TheMightyBuzzard> | Azuma Hazuki | 5086 | 1558 |
[13:48:52] <TheMightyBuzzard> +--------------------+------+-------+
[13:55:37] <TheMightyBuzzard> select users.nickname, foo.uid, foo.posts from (select uid, count(*) as posts from comments where date < "2017-01-01 00:00:00" and date > "2015-12-31 23:59:59" group by uid order by posts desc limit 11) as foo left join users on foo.uid=users.uid;
[13:55:37] <TheMightyBuzzard> +--------------------+------+-------+
[13:55:37] <TheMightyBuzzard> | nickname | uid | posts |
[13:55:37] <TheMightyBuzzard> +--------------------+------+-------+
[13:55:38] <TheMightyBuzzard> | Anonymous Coward | 1 | 62635 |
[13:55:40] <TheMightyBuzzard> | Runaway1956 | 2926 | 2815 |
[13:55:42] <TheMightyBuzzard> | takyon | 881 | 2805 |
[13:55:44] <TheMightyBuzzard> | khallow | 3766 | 2620 |
[13:55:46] <TheMightyBuzzard> | frojack | 1554 | 2169 |
[13:55:48] <TheMightyBuzzard> | The Mighty Buzzard | 18 | 1950 |
[13:55:50] <TheMightyBuzzard> | VLM | 445 | 1910 |
[13:55:52] <TheMightyBuzzard> | butthurt | 6141 | 1726 |
[13:55:54] <TheMightyBuzzard> | Phoenix666 | 552 | 1624 |
[13:55:56] <TheMightyBuzzard> | bob_super | 1357 | 1569 |
[13:55:58] <TheMightyBuzzard> | Azuma Hazuki | 5086 | 1558 |
[13:56:00] <TheMightyBuzzard> +--------------------+------+-------+
[14:03:00] <Bytram> NICE!!!!!!!!
[14:03:18] <Bytram> I should have done this before... here is what I had so far:
[14:03:18] <Bytram> Journal entries:
[14:03:18] <Bytram> select count(*) from journals where date > '2015-12-31' AND date < '2017-01-01';
[14:03:18] <Bytram> 468
[14:03:18] <Bytram> Users Registered:
[14:03:18] <Bytram> select count(*) from users_info where created_at > '2015-12-31' AND created_at < '2017-01-01' ;
[14:03:19] <Bytram> 442
[14:03:21] <Bytram> Stories Published:
[14:03:25] <Bytram> select count(*) from stories where day_published > '2015-12-31' AND day_published < '2017-01-01' ;
[14:03:25] <Bytram> 5267
[14:03:27] <Bytram> Stories Submitted
[14:03:29] <Bytram> select count(*) from submissions where time > '2015-12-31' AND time < '2017-01-01' ;
[14:03:33] <Bytram> 6361
[14:03:35] <Bytram> Comments Posted
[14:03:37] <Bytram> select count(*) from comments where date > '2015-12-31' AND date < '2017-01-01' ;
[14:03:40] <Bytram> 165203
[14:03:41] <Bytram> _end of paste_
[14:04:17] <TheMightyBuzzard> you know, like 90% of my list could use a good arse kicking. the 10% that couldn't is Phoenix666.