moves_out_1.sql


1
2
3
4
5
6
7
8
9
10
11

SELECT 
	game_log.*, 
	move_log.*
FROM
	game_log INNER JOIN move_log
		ON game_log.game_id = move_log.game_id
WHERE
	move_log.board = :fen_board
	AND game_log.plr_X_name = :plr_name
	AND game_log.plr_X_color_int = :plr_color_int
;