#qa | Logs for 2021-01-03
« return
[00:48:51] -!- systemd has quit [Remote host closed the connection]
[00:49:14] -!- systemd [systemd!~systemd@pid1] has joined #qa
[01:58:49] <Bytram> Posting here for later reference:
[01:58:51] <Bytram> select spid, uid, email, ts, payment_gross, payment_net, method, submethod from subscribe_payments where ts >= '2019-12-31' and ts <= '2020-01-05' order by spid ; select max( spid ) from subscribe_payments; select sum( payment_net ), 100 * sum( payment_net ) / 3500 from subscribe_payments where spid >= 1408 ; select sum( payment_net ), 100 * sum( payment_net ) / 7000 from subscribe_payments where ts >= "2020-01-01" ;
[11:56:28] <Bytram> tail -f /srv/soylentnews.org/apache/logs/error_log