#editorial | Logs for 2022-01-18
« return
[15:13:26] <janrinok> =submit https://arstechnica.com
[15:13:31] <systemd> ✓ Sub-ccess! "03Microsoft Set to Purchase Activision Blizzard in $68.7 Billion Deal" (17p) -> https://soylentnews.org
[15:14:05] <janrinok> =submit https://arstechnica.com
[15:14:07] <systemd> ✓ Sub-ccess! "03After Six Decades, Russia Will Build its Final Proton Rocket This Year" (9p) -> https://soylentnews.org
[15:14:43] <janrinok> =submit https://arstechnica.com
[15:14:45] <systemd> ✓ Sub-ccess! "03Microsoft Warns of Destructive Disk Wiper Targeting Ukraine" (18p) -> https://soylentnews.org
[15:24:12] <janrinok> =submit https://www.bbc.com
[15:24:15] <systemd> ✓ Sub-ccess! "035G Phones: How Serious is the Threat to US Flights?" (30p) -> https://soylentnews.org
[15:25:42] <janrinok> =submit https://www.bbc.com
[15:25:44] <systemd> ✓ Sub-ccess! "03Sweden Drones: Sightings Reported Over Nuclear Plants and Palace" (13p) -> https://soylentnews.org
[15:29:00] <janrinok> =submit https://www.cnet.com
[15:29:02] <systemd> ✓ Sub-ccess! "03How Next-gen Satellites are Transforming Our View of Climate Change" (50p) -> https://soylentnews.org
[15:30:09] <janrinok> =submit https://www.reuters.com
[15:30:11] <systemd> ✓ Sub-ccess! "03Exclusive: U.S. Examining Alibaba's Cloud Unit for National Security Risks" (42p) -> https://soylentnews.org
[15:32:27] <janrinok> =submit https://www.techradar.com
[15:32:30] <systemd> ✓ Sub-ccess! "03Intel’s Lowly Celeron G6900 CPU Gets Overclocked to a Staggering 5.3GHz" (19p) -> https://soylentnews.org
[15:33:07] <janrinok> =submit https://www.techradar.com
[15:33:09] <systemd> ✓ Sub-ccess! "03AMD RX 6500 XT Pricing Looks Like Seriously Bad News for a ‘Budget’ GPU" (19p) -> https://soylentnews.org
[15:36:40] <janrinok> =submit https://scitechdaily.com
[15:36:43] <systemd> ✓ Sub-ccess! "03Hormone Therapy Treatments May Increase Survival Rate in Prostate Cancer Patients" (15p) -> https://soylentnews.org
[15:39:20] <janrinok> =submit https://www.zdnet.com
[15:39:22] <systemd> ✓ Sub-ccess! "03Open Invention Network Expands Linux Patent Protection" (8p) -> https://soylentnews.org
[16:14:24] <Bytram> janrinok: thanks for the subs!
[16:14:26] <Bytram> gtg; laters!
[19:48:29] <Bytram> Updating Beg-o-Meter
[19:48:43] <Bytram> mysql> SELECT sum( payment_gross ), sum(payment_net) FROM subscribe_payments WHERE ts > '2021-12-28 13:01:56' AND payment_gross > 0 ;
[19:48:43] <Bytram> +----------------------+------------------+
[19:48:43] <Bytram> | sum( payment_gross ) | sum(payment_net) |
[19:48:43] <Bytram> +----------------------+------------------+
[19:48:43] <Bytram> | 2855.43 | 2744.64 |
[19:48:47] <Bytram> +----------------------+------------------+
[19:48:49] <Bytram> 1 row in set (0.00 sec)
[19:48:51] <Bytram> mysql>
[19:50:13] <Bytram> whoops! Wrong query!
[19:53:20] <Bytram> mysql> SELECT SUM(payment_net) AS Net, 100.0 * SUM(payment_net) / 3500.00 AS GoalPercent, MAX(ts), MAX(spid), NOW() FROM subscribe_payments WHERE ts > '2022-01-01' ;
[19:53:20] <Bytram> +--------+-------------+---------------------+-----------+---------------------+
[19:53:20] <Bytram> | Net | GoalPercent | MAX(ts) | MAX(spid) | NOW() |
[19:53:20] <Bytram> +--------+-------------+---------------------+-----------+---------------------+
[19:53:20] <Bytram> | 764.51 | 21.8431429 | 2022-01-18 12:27:42 | 1757 | 2022-01-18 19:52:40 |
[19:53:22] <Bytram> +--------+-------------+---------------------+-----------+---------------------+
[19:53:24] <Bytram> 1 row in set (0.00 sec)
[19:53:26] <Bytram> mysql>
[19:56:58] <Bytram> hmmmmm...
[20:08:16] <janrinok> time for me to go to bed.... Have a good one!
[20:08:42] <janrinok> story queue is good for 14-16 hours
[20:10:05] <janrinok> Bytram, ^^^
[20:10:34] * Bytram checked... that query *does* include the subscription made on '2022-01-01' (specifically was made at '2022-01-01 06:02:19') and was the only sub made on that day.
[20:10:54] <Bytram> janrinok++ thanks so much! ...
[20:10:54] <Bender> karma - janrinok: 127
[20:11:02] <Bytram> sleep well!
[20:11:24] <Bytram> thanks for ALL you do for the site! =)
[20:12:07] <janrinok> np - cu tomorrow!
[20:12:45] <Bytram> janrinok: ciao for now! =)
[20:13:36] <Bytram> Seems like I *did* have the subscription query correct! YAY!
[20:14:54] <Bytram> mysql> SELECT SUM(payment_net) AS Net, 100.0 * SUM(payment_net) / 3500.00 AS GoalPercent, MAX(ts), MAX(spid), NOW() FROM subscribe_payments WHERE ts > '2022-01-01' ;
[20:14:54] <Bytram> +--------+-------------+---------------------+-----------+---------------------+
[20:14:54] <Bytram> | Net | GoalPercent | MAX(ts) | MAX(spid) | NOW() |
[20:14:54] <Bytram> +--------+-------------+---------------------+-----------+---------------------+
[20:14:54] <Bytram> | 764.51 | 21.8431429 | 2022-01-18 12:27:42 | 1757 | 2022-01-18 20:14:28 |
[20:14:56] <Bytram> +--------+-------------+---------------------+-----------+---------------------+
[20:14:58] <Bytram> 1 row in set (0.00 sec)
[20:15:00] <Bytram> mysql>