I'm not good with advanced mysql queries. What i am looking to do is combine the following two queries, if possible.
Query 2Code:SELECT * FROM game_drawings WHERE game_id = [game_id] GROUP BY drawing_date ORDER BY drawing_date DESC [custom limit]
The common key between tables would be drawing_id.Code:SELECT * FROM game_results WHERE drawing_id = [drawing_id] and game_id = [game_id]
Thanks in advance.