System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'StatusId'.
Invalid column name 'ErrorLog'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Etoz.ConnectData.DataAccess.ExecuteQuery(String query) in c:\inetpub\wwwroot\cricdirect.com\api\v6\App_Code\db\data_access.cs:line 117
ClientConnectionId:6f9f440d-68ff-4c48-afad-c06391391930
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90638 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90638,1,'{"status":"ok","response":{"mid":90638,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Soca Kings won by 7 wickets","day_remaining_over":"","team_batting":"Soca Kings","team_bowling":"Leatherback Strikers","live_inning_number":2,"live_score":{"runs":104,"overs":8.1,"wickets":3,"target":102,"runrate":12.73,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Tion Webster","batsman_id":90945,"runs":41,"balls_faced":19,"fours":5,"sixes":2,"strike_rate":"215.79"},{"name":"Akeel Mohammed","batsman_id":147243,"runs":25,"balls_faced":16,"fours":2,"sixes":2,"strike_rate":"156.25"}],"bowlers":[{"name":"Vishan Jagessar","bowler_id":114084,"overs":0.1,"runs_conceded":4,"wickets":0,"maidens":0,"econ":"24.00"},{"name":"Tevon Jadoo","bowler_id":116231,"overs":2,"runs_conceded":29,"wickets":0,"maidens":0,"econ":"14.50"}],"commentaries":[{"event":"overend","over":4,"runs":5,"score":"49\/3","bats":[{"runs":4,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":90945},{"runs":10,"balls_faced":7,"fours":2,"sixes":0,"batsman_id":147243}],"bowls":[{"runs_conceded":5,"maidens":0,"wickets":1,"bowler_id":93261,"overs":1},{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":114083,"overs":1}],"commentary":"End of over 4 (5 runs), Soca Kings 49\/3"},{"event_id":"12168476","event":"ball","batsman_id":"90945","bowler_id":"116231","over":"4","ball":"1","score":0,"commentary":"Tevon Jadoo to Tion Webster, no run,","noball_dismissal":false,"text":"","timestamp":1750268516,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168484","event":"ball","batsman_id":"90945","bowler_id":"116231","over":"4","ball":"2","score":6,"commentary":"Tevon Jadoo to Tion Webster, Six,","noball_dismissal":false,"text":"","timestamp":1750268518,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12168489","event":"ball","batsman_id":"90945","bowler_id":"116231","over":"4","ball":"3","score":6,"commentary":"Tevon Jadoo to Tion Webster, Six,","noball_dismissal":false,"text":"","timestamp":1750268523,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12168492","event":"ball","batsman_id":"90945","bowler_id":"116231","over":"4","ball":"4","score":1,"commentary":"Tevon Jadoo to Tion Webster, 1 run,","noball_dismissal":false,"text":"","timestamp":1750268535,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168497","event":"ball","batsman_id":"147243","bowler_id":"116231","over":"4","ball":"5","score":0,"commentary":"Tevon Jadoo to Akeel Mohammed, no run,","noball_dismissal":false,"text":"","timestamp":1750268580,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168507","event":"ball","batsman_id":"147243","bowler_id":"116231","over":"4","ball":"6","score":"1wd","commentary":"Tevon Jadoo to Akeel Mohammed, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750268584,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12168508","event":"ball","batsman_id":"147243","bowler_id":"116231","over":"4","ball":"6","score":0,"commentary":"Tevon Jadoo to Akeel Mohammed, no run,","noball_dismissal":false,"text":"","timestamp":1750268592,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":5,"runs":14,"score":"63\/3","bats":[{"runs":10,"balls_faced":9,"fours":2,"sixes":0,"batsman_id":147243},{"runs":17,"balls_faced":7,"fours":0,"sixes":2,"batsman_id":90945}],"bowls":[{"runs_conceded":14,"maidens":0,"wickets":0,"bowler_id":116231,"overs":1},{"runs_conceded":5,"maidens":0,"wickets":1,"bowler_id":93261,"overs":1}],"commentary":"End of over 5 (14 runs), Soca Kings 63\/3"},{"event_id":"12168550","event":"ball","batsman_id":"90945","bowler_id":"93261","over":"5","ball":"1","score":"2lb","commentary":"Uthman Muhammad to Tion Webster, 2 leg bye,","noball_dismissal":false,"text":"","timestamp":1750268802,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"2","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168551","event":"ball","batsman_id":"90945","bowler_id":"93261","over":"5","ball":"2","score":0,"commentary":"Uthman Muhammad to Tion Webster, no run,","noball_dismissal":false,"text":"","timestamp":1750268807,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168552","event":"ball","batsman_id":"90945","bowler_id":"93261","over":"5","ball":"3","score":4,"commentary":"Uthman Muhammad to Tion Webster, Four,","noball_dismissal":false,"text":"","timestamp":1750268809,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12168553","event":"ball","batsman_id":"90945","bowler_id":"93261","over":"5","ball":"4","score":1,"commentary":"Uthman Muhammad to Tion Webster, 1 run,","noball_dismissal":false,"text":"","timestamp":1750268812,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168555","event":"ball","batsman_id":"147243","bowler_id":"93261","over":"5","ball":"5","score":1,"commentary":"Uthman Muhammad to Akeel Mohammed, 1 run,","noball_dismissal":false,"text":"","timestamp":1750268816,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168571","event":"ball","batsman_id":"90945","bowler_id":"93261","over":"5","ball":"6","score":4,"commentary":"Uthman Muhammad to Tion Webster, Four,","noball_dismissal":false,"text":"","timestamp":1750268934,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":6,"runs":12,"score":"75\/3","bats":[{"runs":26,"balls_faced":12,"fours":2,"sixes":2,"batsman_id":90945},{"runs":11,"balls_faced":10,"fours":2,"sixes":0,"batsman_id":147243}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":1,"bowler_id":93261,"overs":2},{"runs_conceded":14,"maidens":0,"wickets":0,"bowler_id":116231,"overs":1}],"commentary":"End of over 6 (12 runs), Soca Kings 75\/3"},{"event_id":"12168577","event":"ball","batsman_id":"147243","bowler_id":"114083","over":"6","ball":"1","score":1,"commentary":"Christopher Vincent to Akeel Mohammed, 1 run,","noball_dismissal":false,"text":"","timestamp":1750268986,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168579","event":"ball","batsman_id":"90945","bowler_id":"114083","over":"6","ball":"2","score":0,"commentary":"Christopher Vincent to Tion Webster, no run,","noball_dismissal":false,"text":"","timestamp":1750268989,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168587","event":"ball","batsman_id":"90945","bowler_id":"114083","over":"6","ball":"3","score":1,"commentary":"Christopher Vincent to Tion Webster, 1 run,","noball_dismissal":false,"text":"","timestamp":1750269016,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168601","event":"ball","batsman_id":"147243","bowler_id":"114083","over":"6","ball":"4","score":6,"commentary":"Christopher Vincent to Akeel Mohammed, Six,","noball_dismissal":false,"text":"","timestamp":1750269737,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12168606","event":"ball","batsman_id":"147243","bowler_id":"114083","over":"6","ball":"5","score":1,"commentary":"Christopher Vincent to Akeel Mohammed, 1 run,","noball_dismissal":false,"text":"","timestamp":1750269741,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168688","event":"ball","batsman_id":"90945","bowler_id":"114083","over":"6","ball":"6","score":1,"commentary":"Christopher Vincent to Tion Webster, 1 run,","noball_dismissal":false,"text":"","timestamp":1750269774,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":7,"runs":10,"score":"85\/3","bats":[{"runs":28,"balls_faced":15,"fours":2,"sixes":2,"batsman_id":90945},{"runs":19,"balls_faced":13,"fours":2,"sixes":1,"batsman_id":147243}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":0,"bowler_id":114083,"overs":2},{"runs_conceded":15,"maidens":0,"wickets":1,"bowler_id":93261,"overs":2}],"commentary":"End of over 7 (10 runs), Soca Kings 85\/3"},{"event_id":"12168692","event":"ball","batsman_id":"90945","bowler_id":"116231","over":"7","ball":"1","score":4,"commentary":"Tevon Jadoo to Tion Webster, Four,","noball_dismissal":false,"text":"","timestamp":1750269778,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12168693","event":"ball","batsman_id":"90945","bowler_id":"116231","over":"7","ball":"2","score":4,"commentary":"Tevon Jadoo to Tion Webster, Four,","noball_dismissal":false,"text":"","timestamp":1750269781,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12168694","event":"ball","batsman_id":"90945","bowler_id":"116231","over":"7","ball":"3","score":1,"commentary":"Tevon Jadoo to Tion Webster, 1 run,","noball_dismissal":false,"text":"","timestamp":1750269784,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168696","event":"ball","batsman_id":"147243","bowler_id":"116231","over":"7","ball":"4","score":6,"commentary":"Tevon Jadoo to Akeel Mohammed, Six,","noball_dismissal":false,"text":"","timestamp":1750269786,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12168697","event":"ball","batsman_id":"147243","bowler_id":"116231","over":"7","ball":"5","score":0,"commentary":"Tevon Jadoo to Akeel Mohammed, no run,","noball_dismissal":false,"text":"","timestamp":1750269791,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168698","event":"ball","batsman_id":"147243","bowler_id":"116231","over":"7","ball":"6","score":0,"commentary":"Tevon Jadoo to Akeel Mohammed, no run,","noball_dismissal":false,"text":"","timestamp":1750269794,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":8,"runs":15,"score":"100\/3","bats":[{"runs":25,"balls_faced":16,"fours":2,"sixes":2,"batsman_id":147243},{"runs":37,"balls_faced":18,"fours":4,"sixes":2,"batsman_id":90945}],"bowls":[{"runs_conceded":29,"maidens":0,"wickets":0,"bowler_id":116231,"overs":2},{"runs_conceded":25,"maidens":0,"wickets":0,"bowler_id":114083,"overs":2}],"commentary":"End of over 8 (15 runs), Soca Kings 100\/3"},{"event_id":"12168700","event":"ball","batsman_id":"90945","bowler_id":"114084","over":"8","ball":"1","score":4,"commentary":"Vishan Jagessar to Tion Webster, Four,","noball_dismissal":false,"text":"","timestamp":1750269797,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false}],"day":"0","session":"0","live_inning":{"iid":198327,"number":2,"name":"Soca Kings Inning","short_name":"SCK Inning","status":2,"issuperover":"false","result":3,"batting_team_id":123301,"fielding_team_id":128980,"scores":"104\/3","scores_full":"104\/3 (8.1 ov)","fielder":[{"fielder_id":"114083","fielder_name":"Christopher Vincent","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"93005","fielder_name":"Ewart Nicholson","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Dejourn Charles","batsman_id":"52292","runs":"16","balls":"8","how_out":"c C Vincent b U Muhammad","score_at_dismissal":44,"overs_at_dismissal":"3.2","bowler_id":"93261","dismissal":"caught","number":3},"extra_runs":{"byes":0,"legbyes":2,"wides":12,"noballs":0,"penalty":"0","total":14},"equations":{"runs":104,"wickets":3,"overs":"8.1","bowlers_used":6,"runrate":"12.73"},"current_partnership":{"runs":60,"balls":29,"overs":4.5,"batsmen":[{"name":"Tion Webster","batsman_id":90945,"runs":41,"balls":19},{"name":"Akeel Mohammed","batsman_id":147243,"runs":16,"balls":10}]},"did_not_bat":[{"player_id":"96611","name":"Joshua James"},{"player_id":"90814","name":"Imran Khan"},{"player_id":"127227","name":"Jon Russ Jagessar"},{"player_id":"114112","name":"Chadeon Raymond"},{"player_id":"43338","name":"Rayad Emrit"},{"player_id":"116243","name":"Aamir Ali"}],"max_over":"10","target":"102","recent_scores":"4,0,0,6,1,4,4,1,1,6,1,0,1,4,1,1,4,0","last_five_overs":"60\/1 11.61","last_ten_overs":"104\/3 11.14"},"teams":[{"tid":123301,"title":"Soca Kings","abbr":"SCK","alt_name":"Soca Kings","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"104\/3 (8.1 ov)","scores":"104\/3","overs":"8.1"},{"tid":128980,"title":"Leatherback Strikers","abbr":"TLS","alt_name":"Leatherback Strikers","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Leatherback-Strikers.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Leatherback-Strikers.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"101\/8 (10 ov)","scores":"101\/8","overs":"10"}],"players":[{"pid":43338,"title":"Rayad Emrit","short_name":"RR Emrit","first_name":"Rayad Emrit","last_name":"","middle_name":"","birthdate":"1981-03-08","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/rayad51","instagram_profile":"https:\/\/www.instagram.com\/rayad51\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":"(C)"},{"pid":50112,"title":"William Perkins","short_name":"WKD Perkins","first_name":"William Perkins","last_name":"","middle_name":"","birthdate":"1986-10-08","birthplace":"Barbados","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":52292,"title":"Dejourn Charles","short_name":"D Charles","first_name":"Dejourn Charles","last_name":"","middle_name":"","birthdate":"1997-10-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":90814,"title":"Imran Khan","short_name":"I Khan","first_name":"Imran Khan","last_name":"","middle_name":"","birthdate":"1984-07-06","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":90945,"title":"Tion Webster","short_name":"T Webster","first_name":"Tion Webster","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":93005,"title":"Ewart Nicholson","short_name":"E Nicholson","first_name":"Ewart Nicholson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":93261,"title":"Uthman Muhammad","short_name":"U Muhammad","first_name":"Uthman Muhammad","last_name":"","middle_name":"","birthdate":"1989-03-01","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":93874,"title":"Terrance Hinds","short_name":"T Hinds","first_name":"Terrance Hinds","last_name":"","middle_name":"","birthdate":"1992-01-23","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/terrohinds64","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":96611,"title":"Joshua James","short_name":"J James","first_name":"Joshua James","last_name":"","middle_name":"","birthdate":"2001-02-21","birthplace":"Trinidad & Tobago","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":109937,"title":"Sion Hackett","short_name":"S Hackett","first_name":"Sion Hackett","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":null,"role":"squad","role_str":""},{"pid":114083,"title":"Christopher Vincent","short_name":"C Vincent","first_name":"Christopher Vincent","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":"(C)"},{"pid":114084,"title":"Vishan Jagessar","short_name":"V Jagessar","first_name":"Vishan Jagessar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":114112,"title":"Chadeon Raymond","short_name":"C Raymond","first_name":"Chadeon Raymond","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":114121,"title":"Shatrughan Rambaran","short_name":"S Rambaran","first_name":"Shatrughan Rambaran","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":115822,"title":"Damion Joachim","short_name":"D Joachim","first_name":"Damion Joachim","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":115835,"title":"Denzil Antoine","short_name":"D Antoine","first_name":"Denzil Antoine","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":115852,"title":"Suraj Seepaul","short_name":"S Seepaul","first_name":"Suraj Seepaul","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":116231,"title":"Tevon Jadoo","short_name":"T Jadoo","first_name":"Tevon Jadoo","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":116243,"title":"Aamir Ali","short_name":"A Ali","first_name":"Aamir Ali","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":127227,"title":"Jon Russ Jagessar","short_name":"Jon Jagessar","first_name":"Jon Russ Jagessar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":139127,"title":"Abdur Rahman Juman","short_name":"A R Juman","first_name":"Abdur Rahman Juman","last_name":"","middle_name":"","birthdate":"2003-11-14","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":140979,"title":"Junior Bailey","short_name":"J Bailey","first_name":"Junior Bailey","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":140982,"title":"Selwin Allert","short_name":"S Allert","first_name":"Selwin Allert","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":145177,"title":"Kevin Ryan Ramasray","short_name":"K R Ramasray","first_name":"Kevin Ryan Ramasray","last_name":"","middle_name":"","birthdate":"1993-05-19","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":147236,"title":"Trevon James","short_name":"T James","first_name":"Trevon James","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"pid":147243,"title":"Akeel Mohammed","short_name":"A Mohammed","first_name":"Akeel Mohammed","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":147342,"title":"Rondel Ramlogan","short_name":"R Ramlogan","first_name":"Rondel Ramlogan","last_name":"","middle_name":"","birthdate":"2004-11-08","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":147508,"title":"Christian Lall","short_name":"C Lall","first_name":"Christian Lall","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":149628,"title":"Nickolas Wellington","short_name":"N Wellington","first_name":"Nickolas Wellington","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":"(WK)"}]},"etag":"1a6029858ca6cb9e33a9fc34b0ccbc17","modified":"2025-07-21 12:16:36","datetime":"2025-07-21 12:16:36","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90638,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Soca Kings won by 7 wickets","day_remaining_over":"","team_batting":"Soca Kings","team_bowling":"Leatherback Strikers","live_inning_number":2,"live_score":{"runs":104,"overs":8.1,"wickets":3,"target":102,"runrate":12.73,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Tion Webster","batsman_id":90945,"runs":41,"balls_faced":19,"fours":5,"sixes":2,"strike_rate":"215.79"},{"name":"Akeel Mohammed","batsman_id":147243,"runs":25,"balls_faced":16,"fours":2,"sixes":2,"strike_rate":"156.25"}],"bowlers":[{"name":"Vishan Jagessar","bowler_id":114084,"overs":0.1,"runs_conceded":4,"wickets":0,"maidens":0,"econ":"24.00"},{"name":"Tevon Jadoo","bowler_id":116231,"overs":2,"runs_conceded":29,"wickets":0,"maidens":0,"econ":"14.50"}],"commentaries":[{"event":"overend","over":4,"runs":5,"score":"49\/3","bats":[{"runs":4,"balls_faced":3,"fours":0,"sixes":0,"batsman_id":90945},{"runs":10,"balls_faced":7,"fours":2,"sixes":0,"batsman_id":147243}],"bowls":[{"runs_conceded":5,"maidens":0,"wickets":1,"bowler_id":93261,"overs":1},{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":114083,"overs":1}],"commentary":"End of over 4 (5 runs), Soca Kings 49\/3"},{"event_id":"12168476","event":"ball","batsman_id":"90945","bowler_id":"116231","over":"4","ball":"1","score":0,"commentary":"Tevon Jadoo to Tion Webster, no run,","noball_dismissal":false,"text":"","timestamp":1750268516,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168484","event":"ball","batsman_id":"90945","bowler_id":"116231","over":"4","ball":"2","score":6,"commentary":"Tevon Jadoo to Tion Webster, Six,","noball_dismissal":false,"text":"","timestamp":1750268518,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12168489","event":"ball","batsman_id":"90945","bowler_id":"116231","over":"4","ball":"3","score":6,"commentary":"Tevon Jadoo to Tion Webster, Six,","noball_dismissal":false,"text":"","timestamp":1750268523,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12168492","event":"ball","batsman_id":"90945","bowler_id":"116231","over":"4","ball":"4","score":1,"commentary":"Tevon Jadoo to Tion Webster, 1 run,","noball_dismissal":false,"text":"","timestamp":1750268535,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168497","event":"ball","batsman_id":"147243","bowler_id":"116231","over":"4","ball":"5","score":0,"commentary":"Tevon Jadoo to Akeel Mohammed, no run,","noball_dismissal":false,"text":"","timestamp":1750268580,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168507","event":"ball","batsman_id":"147243","bowler_id":"116231","over":"4","ball":"6","score":"1wd","commentary":"Tevon Jadoo to Akeel Mohammed, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750268584,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12168508","event":"ball","batsman_id":"147243","bowler_id":"116231","over":"4","ball":"6","score":0,"commentary":"Tevon Jadoo to Akeel Mohammed, no run,","noball_dismissal":false,"text":"","timestamp":1750268592,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":5,"runs":14,"score":"63\/3","bats":[{"runs":10,"balls_faced":9,"fours":2,"sixes":0,"batsman_id":147243},{"runs":17,"balls_faced":7,"fours":0,"sixes":2,"batsman_id":90945}],"bowls":[{"runs_conceded":14,"maidens":0,"wickets":0,"bowler_id":116231,"overs":1},{"runs_conceded":5,"maidens":0,"wickets":1,"bowler_id":93261,"overs":1}],"commentary":"End of over 5 (14 runs), Soca Kings 63\/3"},{"event_id":"12168550","event":"ball","batsman_id":"90945","bowler_id":"93261","over":"5","ball":"1","score":"2lb","commentary":"Uthman Muhammad to Tion Webster, 2 leg bye,","noball_dismissal":false,"text":"","timestamp":1750268802,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"2","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168551","event":"ball","batsman_id":"90945","bowler_id":"93261","over":"5","ball":"2","score":0,"commentary":"Uthman Muhammad to Tion Webster, no run,","noball_dismissal":false,"text":"","timestamp":1750268807,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168552","event":"ball","batsman_id":"90945","bowler_id":"93261","over":"5","ball":"3","score":4,"commentary":"Uthman Muhammad to Tion Webster, Four,","noball_dismissal":false,"text":"","timestamp":1750268809,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12168553","event":"ball","batsman_id":"90945","bowler_id":"93261","over":"5","ball":"4","score":1,"commentary":"Uthman Muhammad to Tion Webster, 1 run,","noball_dismissal":false,"text":"","timestamp":1750268812,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168555","event":"ball","batsman_id":"147243","bowler_id":"93261","over":"5","ball":"5","score":1,"commentary":"Uthman Muhammad to Akeel Mohammed, 1 run,","noball_dismissal":false,"text":"","timestamp":1750268816,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168571","event":"ball","batsman_id":"90945","bowler_id":"93261","over":"5","ball":"6","score":4,"commentary":"Uthman Muhammad to Tion Webster, Four,","noball_dismissal":false,"text":"","timestamp":1750268934,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event":"overend","over":6,"runs":12,"score":"75\/3","bats":[{"runs":26,"balls_faced":12,"fours":2,"sixes":2,"batsman_id":90945},{"runs":11,"balls_faced":10,"fours":2,"sixes":0,"batsman_id":147243}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":1,"bowler_id":93261,"overs":2},{"runs_conceded":14,"maidens":0,"wickets":0,"bowler_id":116231,"overs":1}],"commentary":"End of over 6 (12 runs), Soca Kings 75\/3"},{"event_id":"12168577","event":"ball","batsman_id":"147243","bowler_id":"114083","over":"6","ball":"1","score":1,"commentary":"Christopher Vincent to Akeel Mohammed, 1 run,","noball_dismissal":false,"text":"","timestamp":1750268986,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168579","event":"ball","batsman_id":"90945","bowler_id":"114083","over":"6","ball":"2","score":0,"commentary":"Christopher Vincent to Tion Webster, no run,","noball_dismissal":false,"text":"","timestamp":1750268989,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168587","event":"ball","batsman_id":"90945","bowler_id":"114083","over":"6","ball":"3","score":1,"commentary":"Christopher Vincent to Tion Webster, 1 run,","noball_dismissal":false,"text":"","timestamp":1750269016,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168601","event":"ball","batsman_id":"147243","bowler_id":"114083","over":"6","ball":"4","score":6,"commentary":"Christopher Vincent to Akeel Mohammed, Six,","noball_dismissal":false,"text":"","timestamp":1750269737,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12168606","event":"ball","batsman_id":"147243","bowler_id":"114083","over":"6","ball":"5","score":1,"commentary":"Christopher Vincent to Akeel Mohammed, 1 run,","noball_dismissal":false,"text":"","timestamp":1750269741,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168688","event":"ball","batsman_id":"90945","bowler_id":"114083","over":"6","ball":"6","score":1,"commentary":"Christopher Vincent to Tion Webster, 1 run,","noball_dismissal":false,"text":"","timestamp":1750269774,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":7,"runs":10,"score":"85\/3","bats":[{"runs":28,"balls_faced":15,"fours":2,"sixes":2,"batsman_id":90945},{"runs":19,"balls_faced":13,"fours":2,"sixes":1,"batsman_id":147243}],"bowls":[{"runs_conceded":25,"maidens":0,"wickets":0,"bowler_id":114083,"overs":2},{"runs_conceded":15,"maidens":0,"wickets":1,"bowler_id":93261,"overs":2}],"commentary":"End of over 7 (10 runs), Soca Kings 85\/3"},{"event_id":"12168692","event":"ball","batsman_id":"90945","bowler_id":"116231","over":"7","ball":"1","score":4,"commentary":"Tevon Jadoo to Tion Webster, Four,","noball_dismissal":false,"text":"","timestamp":1750269778,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12168693","event":"ball","batsman_id":"90945","bowler_id":"116231","over":"7","ball":"2","score":4,"commentary":"Tevon Jadoo to Tion Webster, Four,","noball_dismissal":false,"text":"","timestamp":1750269781,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12168694","event":"ball","batsman_id":"90945","bowler_id":"116231","over":"7","ball":"3","score":1,"commentary":"Tevon Jadoo to Tion Webster, 1 run,","noball_dismissal":false,"text":"","timestamp":1750269784,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168696","event":"ball","batsman_id":"147243","bowler_id":"116231","over":"7","ball":"4","score":6,"commentary":"Tevon Jadoo to Akeel Mohammed, Six,","noball_dismissal":false,"text":"","timestamp":1750269786,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12168697","event":"ball","batsman_id":"147243","bowler_id":"116231","over":"7","ball":"5","score":0,"commentary":"Tevon Jadoo to Akeel Mohammed, no run,","noball_dismissal":false,"text":"","timestamp":1750269791,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12168698","event":"ball","batsman_id":"147243","bowler_id":"116231","over":"7","ball":"6","score":0,"commentary":"Tevon Jadoo to Akeel Mohammed, no run,","noball_dismissal":false,"text":"","timestamp":1750269794,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":8,"runs":15,"score":"100\/3","bats":[{"runs":25,"balls_faced":16,"fours":2,"sixes":2,"batsman_id":147243},{"runs":37,"balls_faced":18,"fours":4,"sixes":2,"batsman_id":90945}],"bowls":[{"runs_conceded":29,"maidens":0,"wickets":0,"bowler_id":116231,"overs":2},{"runs_conceded":25,"maidens":0,"wickets":0,"bowler_id":114083,"overs":2}],"commentary":"End of over 8 (15 runs), Soca Kings 100\/3"},{"event_id":"12168700","event":"ball","batsman_id":"90945","bowler_id":"114084","over":"8","ball":"1","score":4,"commentary":"Vishan Jagessar to Tion Webster, Four,","noball_dismissal":false,"text":"","timestamp":1750269797,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false}],"day":"0","session":"0","live_inning":{"iid":198327,"number":2,"name":"Soca Kings Inning","short_name":"SCK Inning","status":2,"issuperover":"false","result":3,"batting_team_id":123301,"fielding_team_id":128980,"scores":"104\/3","scores_full":"104\/3 (8.1 ov)","fielder":[{"fielder_id":"114083","fielder_name":"Christopher Vincent","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"93005","fielder_name":"Ewart Nicholson","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Dejourn Charles","batsman_id":"52292","runs":"16","balls":"8","how_out":"c C Vincent b U Muhammad","score_at_dismissal":44,"overs_at_dismissal":"3.2","bowler_id":"93261","dismissal":"caught","number":3},"extra_runs":{"byes":0,"legbyes":2,"wides":12,"noballs":0,"penalty":"0","total":14},"equations":{"runs":104,"wickets":3,"overs":"8.1","bowlers_used":6,"runrate":"12.73"},"current_partnership":{"runs":60,"balls":29,"overs":4.5,"batsmen":[{"name":"Tion Webster","batsman_id":90945,"runs":41,"balls":19},{"name":"Akeel Mohammed","batsman_id":147243,"runs":16,"balls":10}]},"did_not_bat":[{"player_id":"96611","name":"Joshua James"},{"player_id":"90814","name":"Imran Khan"},{"player_id":"127227","name":"Jon Russ Jagessar"},{"player_id":"114112","name":"Chadeon Raymond"},{"player_id":"43338","name":"Rayad Emrit"},{"player_id":"116243","name":"Aamir Ali"}],"max_over":"10","target":"102","recent_scores":"4,0,0,6,1,4,4,1,1,6,1,0,1,4,1,1,4,0","last_five_overs":"60\/1 11.61","last_ten_overs":"104\/3 11.14"},"teams":[{"tid":123301,"title":"Soca Kings","abbr":"SCK","alt_name":"Soca Kings","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"104\/3 (8.1 ov)","scores":"104\/3","overs":"8.1"},{"tid":128980,"title":"Leatherback Strikers","abbr":"TLS","alt_name":"Leatherback Strikers","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Leatherback-Strikers.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Leatherback-Strikers.png","country":"wi","sex":"male","team_owner":"","head_coach":"","scores_full":"101\/8 (10 ov)","scores":"101\/8","overs":"10"}],"players":[{"pid":43338,"title":"Rayad Emrit","short_name":"RR Emrit","first_name":"Rayad Emrit","last_name":"","middle_name":"","birthdate":"1981-03-08","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/rayad51","instagram_profile":"https:\/\/www.instagram.com\/rayad51\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":"(C)"},{"pid":50112,"title":"William Perkins","short_name":"WKD Perkins","first_name":"William Perkins","last_name":"","middle_name":"","birthdate":"1986-10-08","birthplace":"Barbados","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicketkeeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":52292,"title":"Dejourn Charles","short_name":"D Charles","first_name":"Dejourn Charles","last_name":"","middle_name":"","birthdate":"1997-10-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":90814,"title":"Imran Khan","short_name":"I Khan","first_name":"Imran Khan","last_name":"","middle_name":"","birthdate":"1984-07-06","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":90945,"title":"Tion Webster","short_name":"T Webster","first_name":"Tion Webster","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":93005,"title":"Ewart Nicholson","short_name":"E Nicholson","first_name":"Ewart Nicholson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":93261,"title":"Uthman Muhammad","short_name":"U Muhammad","first_name":"Uthman Muhammad","last_name":"","middle_name":"","birthdate":"1989-03-01","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":93874,"title":"Terrance Hinds","short_name":"T Hinds","first_name":"Terrance Hinds","last_name":"","middle_name":"","birthdate":"1992-01-23","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/terrohinds64","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":96611,"title":"Joshua James","short_name":"J James","first_name":"Joshua James","last_name":"","middle_name":"","birthdate":"2001-02-21","birthplace":"Trinidad & Tobago","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":109937,"title":"Sion Hackett","short_name":"S Hackett","first_name":"Sion Hackett","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":null,"role":"squad","role_str":""},{"pid":114083,"title":"Christopher Vincent","short_name":"C Vincent","first_name":"Christopher Vincent","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":"(C)"},{"pid":114084,"title":"Vishan Jagessar","short_name":"V Jagessar","first_name":"Vishan Jagessar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":114112,"title":"Chadeon Raymond","short_name":"C Raymond","first_name":"Chadeon Raymond","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":114121,"title":"Shatrughan Rambaran","short_name":"S Rambaran","first_name":"Shatrughan Rambaran","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":115822,"title":"Damion Joachim","short_name":"D Joachim","first_name":"Damion Joachim","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"all","role_str":""},{"pid":115835,"title":"Denzil Antoine","short_name":"D Antoine","first_name":"Denzil Antoine","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":115852,"title":"Suraj Seepaul","short_name":"S Seepaul","first_name":"Suraj Seepaul","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":116231,"title":"Tevon Jadoo","short_name":"T Jadoo","first_name":"Tevon Jadoo","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":116243,"title":"Aamir Ali","short_name":"A Ali","first_name":"Aamir Ali","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":127227,"title":"Jon Russ Jagessar","short_name":"Jon Jagessar","first_name":"Jon Russ Jagessar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":139127,"title":"Abdur Rahman Juman","short_name":"A R Juman","first_name":"Abdur Rahman Juman","last_name":"","middle_name":"","birthdate":"2003-11-14","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":140979,"title":"Junior Bailey","short_name":"J Bailey","first_name":"Junior Bailey","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bowl","role_str":""},{"pid":140982,"title":"Selwin Allert","short_name":"S Allert","first_name":"Selwin Allert","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":145177,"title":"Kevin Ryan Ramasray","short_name":"K R Ramasray","first_name":"Kevin Ryan Ramasray","last_name":"","middle_name":"","birthdate":"1993-05-19","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":147236,"title":"Trevon James","short_name":"T James","first_name":"Trevon James","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"wk","role_str":"(WK)"},{"pid":147243,"title":"Akeel Mohammed","short_name":"A Mohammed","first_name":"Akeel Mohammed","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":147342,"title":"Rondel Ramlogan","short_name":"R Ramlogan","first_name":"Rondel Ramlogan","last_name":"","middle_name":"","birthdate":"2004-11-08","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":""},{"pid":147508,"title":"Christian Lall","short_name":"C Lall","first_name":"Christian Lall","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"squad","role_str":""},{"pid":149628,"title":"Nickolas Wellington","short_name":"N Wellington","first_name":"Nickolas Wellington","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"West Indies","role":"bat","role_str":"(WK)"}]},"etag":"1a6029858ca6cb9e33a9fc34b0ccbc17","modified":"2025-07-21 12:16:36","datetime":"2025-07-21 12:16:36","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90638 AND DataTypeId = 1 END
System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'StatusId'.
Invalid column name 'ErrorLog'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Etoz.ConnectData.DataAccess.ExecuteQuery(String query) in c:\inetpub\wwwroot\cricdirect.com\api\v6\App_Code\db\data_access.cs:line 117
ClientConnectionId:6f9f440d-68ff-4c48-afad-c06391391930
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90638 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90638,3,'{"status":"ok","response":{"match_id":90638,"title":"Leatherback Strikers vs Soca Kings","short_title":"TLS vs SCK","subtitle":"Match 22","match_number":"22","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Soca Kings won by 7 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129622,"title":"Trinidad T10 Blast, 7th Edition","abbr":"Trinidad T10","type":"tournament","category":"domestic","match_format":"t10","season":"2025","status":"live","datestart":"2025-06-09","dateend":"2025-06-22","country":"wi","total_matches":"30","total_rounds":"1","total_teams":"6"},"teama":{"team_id":128980,"name":"Leatherback Strikers","short_name":"TLS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Leatherback-Strikers.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Leatherback-Strikers.png","scores_full":"101\/8 (10 ov)","scores":"101\/8","overs":"10"},"teamb":{"team_id":123301,"name":"Soca Kings","short_name":"SCK","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","scores_full":"104\/3 (8.1 ov)","scores":"104\/3","overs":"8.1"},"date_start":"2025-06-18 16:00:00","date_end":"2025-06-19 02:00:00","timestamp_start":1750262400,"timestamp_end":1750298400,"date_start_ist":"2025-06-18 21:30:00","date_end_ist":"2025-06-19 07:30:00","venue":{"venue_id":"204","name":"Brian Lara Stadium","location":"Tarouba","country":"West Indies","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"SCK won by 7 wickets","result_type":2,"win_margin":"7 wickets","winning_team_id":123301,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-17 08:01:05","verify_time":"2025-06-18 23:47:41","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":29.76,"humidity":61,"visibility":10000,"wind_speed":"9.75","clouds":100},"pitch":{"pitch_condition":"","batting_condition":"Average","pace_bowling_condition":"Average","spine_bowling_condition":"Average"},"toss":{"text":"Soca Kings elected to bowl","winner":123301,"decision":2}},"etag":"a7d94281508621deb5ffc6fde6dedd22","modified":"2025-07-21 12:16:37","datetime":"2025-07-21 12:16:37","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90638,"title":"Leatherback Strikers vs Soca Kings","short_title":"TLS vs SCK","subtitle":"Match 22","match_number":"22","format":17,"format_str":"T10","status":2,"status_str":"Completed","status_note":"Soca Kings won by 7 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129622,"title":"Trinidad T10 Blast, 7th Edition","abbr":"Trinidad T10","type":"tournament","category":"domestic","match_format":"t10","season":"2025","status":"live","datestart":"2025-06-09","dateend":"2025-06-22","country":"wi","total_matches":"30","total_rounds":"1","total_teams":"6"},"teama":{"team_id":128980,"name":"Leatherback Strikers","short_name":"TLS","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Leatherback-Strikers.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2025\/06\/Leatherback-Strikers.png","scores_full":"101\/8 (10 ov)","scores":"101\/8","overs":"10"},"teamb":{"team_id":123301,"name":"Soca Kings","short_name":"SCK","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/02\/SCK-CR1@2x.png","scores_full":"104\/3 (8.1 ov)","scores":"104\/3","overs":"8.1"},"date_start":"2025-06-18 16:00:00","date_end":"2025-06-19 02:00:00","timestamp_start":1750262400,"timestamp_end":1750298400,"date_start_ist":"2025-06-18 21:30:00","date_end_ist":"2025-06-19 07:30:00","venue":{"venue_id":"204","name":"Brian Lara Stadium","location":"Tarouba","country":"West Indies","timezone":""},"umpires":"","referee":"","equation":"","live":"","result":"SCK won by 7 wickets","result_type":2,"win_margin":"7 wickets","winning_team_id":123301,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-17 08:01:05","verify_time":"2025-06-18 23:47:41","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":29.76,"humidity":61,"visibility":10000,"wind_speed":"9.75","clouds":100},"pitch":{"pitch_condition":"","batting_condition":"Average","pace_bowling_condition":"Average","spine_bowling_condition":"Average"},"toss":{"text":"Soca Kings elected to bowl","winner":123301,"decision":2}},"etag":"a7d94281508621deb5ffc6fde6dedd22","modified":"2025-07-21 12:16:37","datetime":"2025-07-21 12:16:37","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90638 AND DataTypeId = 3 END Live Report & Scorecard of Leatherback Strikers vs Soca Kings Match 22
Leatherback Strikers vs Soca Kings, Live Cricket Commentary