[Solved] I have this query that is driving me crazy [closed]

by


This is not the answer, but the start point for you.

Here is sqlfiddle: http://sqlfiddle.com/#!9/197dd9/1

You should add more data into that fiddle.
After that use my query to see some results and play with that query until you get to the closest result of what you expect to get. And once you get to the point when you can’t get your goal, come back with your fiddle and query prepared and ask community for the help again.

SELECT 
   g.*,
   gua.*
FROM games g
LEFT JOIN game_user_answers gua
ON g.id = gua.id_game
  AND gua.answer_time>g.game_start_time
  AND points>0
WHERE g.id = 1 
  AND g.game_start_time="2016-01-01 00:00:00"

1

solved I have this query that is driving me crazy [closed]