SELECT
userName,
SUM(thanksSent) AS thanksSent,
... |
4 days ago |
SELECT
userName,
COALESCE(thanksSent, 0) AS thanksSent,
... |
4 days ago |
SELECT
COALESCE(receiver.log_title, sent.actor_name) AS userName,
... |
4 days ago |
SELECT
receiver.log_title AS userName,
COALESCE(sent.thanksSent, 0)... |
4 days ago |
SELECT
receiver.log_title AS userName,
COALESCE(sent.thanksSent, 0)... |
4 days ago |
SELECT
log_title AS receiver,
COUNT(*) AS thanksReceived
FROM
... |
4 days ago |
FROM logging_logindex join actor on log_actor = actor_id
WHERE
log_type =... |
4 days ago |
SELECT
a.actor_name AS userName,
COALESCE(sent.thanksSent, 0) AS... |
4 days ago |
SELECT
a.actor_name AS userName,
COALESCE(sent.thanksSent, 0) AS... |
4 days ago |
SELECT
a.actor_name AS userName,
COALESCE(sent.gegeben, 0) AS... |
4 days ago |