[kh99]

I don't have a real database to test this on, and I'm also not an sql expert, but maybe something like:

SELECT username FROM 
   (SELECT user.username, SUM(IF (subscriptionlog.subscriptionid IN (1, 9, 10) AND subscriptionlog.status, 1, 0)) AS status_sum
      FROM user
        LEFT JOIN subscriptionlog ON (user.userid = subscriptionlog.userid)
      WHERE user.usergroupid = 9
      GROUP BY user.userid) AS X 
WHERE status_sum = 0