Untitled query #89726

SQL

SELECT
  log_entries.log_id,
  log_entries.log_timestamp,
  giver.actor_name AS thanked_by,
  receiver.actor_name AS thanked_to,
  log_entries.log_page AS revision_id
FROM logging AS log_entries
LEFT JOIN actor AS giver ON log_entries.log_actor = giver.actor_id
LEFT JOIN revision ON log_entries.log_page = revision.rev_id
LEFT JOIN actor AS receiver ON revision.rev_actor = receiver.actor_id
WHERE log_entries.log_type = 'thanks'
  AND (giver.actor_name = 'WikiBayer')
ORDER BY log_entries.log_timestamp DESC;
SQL

Checking query status...
