Chi ha chiuso il sondaggio?

Se utilizzi l’Esplora Dati, puoi provare con questo (SQL)

SELECT 
    pr.created_at AS "Chiuso il",
    p.topic_id AS "ID Discussione",
    p.post_number AS "Numero Messaggio",
    u.username AS "Chiuso da",
    pr.modifications AS "Modifiche"
FROM post_revisions pr
JOIN posts p ON p.id = pr.post_id
JOIN users u ON u.id = pr.user_id
WHERE pr.modifications LIKE '%status=closed%'
ORDER BY pr.created_at DESC