No tournaments for selected period -- SELECT *, td.TournamentId as tdTournId FROM TournamentDefinitions td LEFT JOIN RankingTournamentDefinitions rtd ON td.TournamentId=rtd.TournamentId AND RankingSystemId=19 WHERE rtd.Circuit='TKO' AND FromTime >= '2022' AND FromTime < '2023' ORDER BY FromTime