I have a query which should fine players with 0 times playing also count(t.id_user) as loginTimes, should be 0. and max(t.end_time) as lastGameDate should be NULL but no matter what I do with it I can not get it to work and still brings max(t.end_time) as lastGameDate which is not NULL.
Is there anyway that I can fix this to achieve the results and how I can rewrite to to update the u.play_chips to 0 also set uplayed accoutn balances to 0. I really appreciate all the help as I can get because I know I can not get it further than this.
Thanks a LOT
count(t.id_user) as loginTimes,
max(t.end_time) as lastGameDate
from t_user u
left outer join t_login_session_live t on t.id_user = u.id
between '2010-04-01 00:00:00' and '2010-12-29 23:59:59')
group by u.userid