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 >= '2024' AND FromTime < '2025' ORDER BY FromTime