Table 'rating_sandbox.half_games2' doesn't exist
SELECT game_date,
hg.games,
colour,
score,
hg.player_no_submitted,
IFNULL(p_submitted.ECF_code,'not recorded') as ECF_code_submitted,
hg.player_no,
p.ECF_code,
opponent_no,
ratings2.revised_rating AS opponent_rating,
ratings2.revised_category AS opponent_category,
op.full_name AS opponent_full_name,
op.member_class AS opponent_member_class,
op.status AS opponent_status,
op.date_of_birth AS opponent_date_of_birth,
op.gender AS opponent_gender,
op.nation AS opponent_nation,
increment,
player_rating,
event_code,
hg.event_no,
org_no,
org_name,
event_name,
round_no,
section_no,
match_no,
seat_no
FROM half_games2 hg
LEFT JOIN players2 p
ON p.player_no = hg.player_no
LEFT JOIN players2 op
ON op.player_no = hg.opponent_no
LEFT JOIN events2
ON events2.event_no = hg.event_no
LEFT JOIN organisations2 USING (org_no)
LEFT JOIN ratings2
ON ratings2.player_no = hg.opponent_no
AND ratings2.month = 239
AND ratings2.domain = 'R'
LEFT JOIN players2 p_submitted
ON p_submitted.player_no = hg.player_no_submitted
WHERE hg.game_date BETWEEN '2020-06-01' AND LAST_DAY('2020-06-01')
AND hg.domain = 'R'
AND hg.player_no = 314896
ORDER BY game_date DESC,
event_no DESC,
round_no DESC,
section_no DESC,
match_no DESC,
seat_no DESC