Untitled query #89517

SQL

SELECT 
    receiver.log_title AS userName,
    COALESCE(sent.thanksSent, 0) AS thanksSent,
    COALESCE(receiver.thanksReceived, 0) AS thanksReceived
FROM (
    SELECT 
        log_title, 
        COUNT(*) AS thanksReceived
    FROM 
        logging_logindex
    WHERE 
        log_action = 'thank'
        AND log_title = 'WikiBayer'
    GROUP BY 
        log_title
) receiver
LEFT JOIN (
    SELECT 
        actor.actor_name, 
        COUNT(*) AS thanksSent
    FROM 
        logging_logindex
    JOIN 
        actor ON logging_logindex.log_actor = actor.actor_id
    WHERE 
        log_action = 'thank'
        AND actor.actor_name = 'WikiBayer'
    GROUP BY 
        actor.actor_name
) sent ON receiver.log_title = sent.actor_name;
SQL

Checking query status...
