Untitled query #89517

SQL

SELECT 
    userName,
    SUM(thanksSent) AS thanksSent,
    SUM(thanksReceived) AS thanksReceived
FROM (
    SELECT 
        log_title AS userName, 
        0 AS thanksSent,
        COUNT(*) AS thanksReceived
    FROM 
        logging_logindex
    WHERE 
        log_action = 'thank'
        AND log_title IN ('WikiBayer', 'Gardini', 'DerHexer', 'Jack User', 'Itti')
    GROUP BY 
        log_title

    UNION ALL

    SELECT 
        actor.actor_name AS userName, 
        COUNT(*) AS thanksSent,
        0 AS thanksReceived
    FROM 
        logging_logindex
    JOIN 
        actor ON logging_logindex.log_actor = actor.actor_id
    WHERE 
        log_action = 'thank'
        AND actor.actor_name IN ('WikiBayer', 'Gardini', 'DerHexer', 'Jack User', 'Itti')
    GROUP BY 
        actor.actor_name
) combined
GROUP BY 
    userName
ORDER BY 
    userName;
SQL

Checking query status...
