Untitled query #89517

SQL

SELECT 
    a.actor_name AS userName,
    COALESCE(sent.gegeben, 0) AS gegeben,
    COALESCE(received.bekommen, 0) AS bekommen
FROM 
    actor a
LEFT JOIN (
    SELECT 
        log_actor, 
        COUNT(log_id) AS thanksSent
    FROM 
        logging_logindex
    WHERE 
        log_type = "thanks"
    GROUP BY 
        log_actor
) sent ON a.actor_id = sent.log_actor
LEFT JOIN (
    SELECT 
        log_title, 
        COUNT(log_id) AS bekommen
    FROM 
        logging_logindex
    WHERE 
        log_type = "thanks"
    GROUP BY 
        log_title
) received ON a.actor_name = received.log_title
ORDER BY 
    gegeben DESC, 
    bekommen DESC
LIMIT 50;
SQL

Checking query status...
