Les users sans organization et connection cette année

SELECT
    user_login.id,
    email,
    user_login.created_at
FROM user
JOIN user_login ON user_login.user_id = user.id
WHERE
    user.id NOT IN (
        SELECT user_id
        FROM organization_user_pivot
    )
    AND email NOT LIKE '%@inactive'
    AND user.id NOT IN (
        SELECT user_id
        FROM user_login
        WHERE created_at > '2022-11-24'
    )
GROUP BY user.id

Keywords

user organization user_login organization_user_pivot inactive