SELECT
									S.id, S.title_en as title

							FROM
									odds_sports S LEFT JOIN odds_results M ON M.sport_id = S.id

							WHERE
									(dateindex IN (1180623, 1180622, 1180624)) AND
									1 AND M.date_start >= '2018-06-23 00:00' - interval TIMEZONE_OFFSET minute

							GROUP BY S.id
							
							ORDER BY S.rating_en DESC
						
Unknown column 'TIMEZONE_OFFSET' in 'where clause'
							SELECT
									M.group_id, MA.rating_en as rating

							FROM
									odds_results M LEFT JOIN odds_livescore_groups G ON G.id = M.group_id
									LEFT JOIN odds_matchs MA ON MA.livescore_id = M.id

							WHERE
									(dateindex IN (1180623, 1180622, 1180624)) AND
									M.sport_id = 1
									AND M.date_start >= '2018-06-23 00:00' - interval TIMEZONE_OFFSET minute
						
Unknown column 'TIMEZONE_OFFSET' in 'where clause'
							SELECT
									M.id, M.match_id, UNIX_TIMESTAMP(M.date_start) as date_start, M.team1_id, M.team2_id, M.group_id, M.score,
									M.match_id, MA.rating_en as rating

							FROM
									odds_results M LEFT JOIN odds_livescore_groups G ON G.id = M.group_id
									LEFT JOIN odds_competitions C ON C.id = G.competition_id
									LEFT JOIN odds_matchs MA ON MA.livescore_id = M.id

							WHERE
									(dateindex IN (1180623, 1180622, 1180624)) AND
									M.sport_id = 1 
									AND M.date_start >= '2018-06-23 00:00' - interval TIMEZONE_OFFSET minute

							ORDER BY M.group_id, M.date_start
						
Unknown column 'TIMEZONE_OFFSET' in 'where clause'
Sport Results – ODDS.am
Our website is currently in the final BETA testing phase. If you notice an error or a bug, please do not hesitate to use the bug report form situated on the bottom left of every page or contact us directly using the feedback form.

Results

 

 

 

 

 

 

 
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       

Today

Yesterday