Re: Brouillon

Il faut aussi prendre en compte les comptes qui ont été modérateurs (news.moderator_id) et ceux qui ont modifié des dépêches (news_versions.user_id).

SELECT * FROM users LEFT JOIN accounts ON accounts.user_id=users.id LEFT JOIN comments ON comments.user_id=users.id LEFT JOIN nodes ON nodes.user_id=users.id AND nodes.public=1 LEFT JOIN taggings ON taggings.user_id=users.id LEFT JOIN tags ON tags.id=taggings.user_id AND tags.public=1 LEFT JOIN news ON news.moderator_id=users.id LEFT JOIN news_versions ON news_versions.user_id=users.id WHERE (accounts.id IS NULL OR accounts.role='inactive') AND date(users.created_at) < '2012-03-31' AND comments.id IS NULL AND nodes.id IS NULL AND taggings.id IS NULL AND news.id IS NULL AND news_versions.id IS NULL;