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:083afb35-96e4-47b3-bff5-289158c6fba1 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 91228 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (91228,1,'{"status":"ok","response":{"mid":91228,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Germany won by 4 wickets","day_remaining_over":"","team_batting":"Germany","team_bowling":"Tanzania","live_inning_number":2,"live_score":{"runs":137,"overs":18,"wickets":6,"target":136,"runrate":7.61,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Muslim Yar","batsman_id":95151,"runs":3,"balls_faced":5,"fours":0,"sixes":0,"strike_rate":"60.00"},{"name":"Rohit Singh","batsman_id":102177,"runs":21,"balls_faced":14,"fours":1,"sixes":1,"strike_rate":"150.00"}],"bowlers":[{"name":"Salum Ally Jumbe","bowler_id":61551,"overs":3,"runs_conceded":32,"wickets":0,"maidens":0,"econ":"10.67"},{"name":"Arun Yadav","bowler_id":150316,"overs":2,"runs_conceded":12,"wickets":3,"maidens":0,"econ":"6.00"}],"commentaries":[{"event_id":"12300187","event":"ball","batsman_id":"102177","bowler_id":"101888","over":"13","ball":"6","score":6,"commentary":"Ally Mpeka Kimote to Rohit Singh, Six,","noball_dismissal":false,"text":"","timestamp":1751884346,"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":"overend","over":14,"runs":12,"score":"120\/2","bats":[{"runs":12,"balls_faced":7,"fours":0,"sixes":1,"batsman_id":102177},{"runs":39,"balls_faced":36,"fours":2,"sixes":1,"batsman_id":112008}],"bowls":[{"runs_conceded":23,"maidens":0,"wickets":1,"bowler_id":101888,"overs":3},{"runs_conceded":18,"maidens":0,"wickets":1,"bowler_id":144095,"overs":3}],"commentary":"End of over 14 (12 runs), Germany 120\/2"},{"event_id":"12300202","event":"ball","batsman_id":"112008","bowler_id":"144095","over":"14","ball":"1","score":0,"commentary":"Khalidy Juma to Kyle Klesse, no run,","noball_dismissal":false,"text":"","timestamp":1751884392,"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":"12300206","event":"ball","batsman_id":"112008","bowler_id":"144095","over":"14","ball":"2","score":0,"commentary":"Khalidy Juma to Kyle Klesse, no run,","noball_dismissal":false,"text":"","timestamp":1751884396,"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":"12300207","event":"ball","batsman_id":"112008","bowler_id":"144095","over":"14","ball":"3","score":0,"commentary":"Khalidy Juma to Kyle Klesse, no run,","noball_dismissal":false,"text":"","timestamp":1751884447,"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":"12300215","event":"ball","batsman_id":"112008","bowler_id":"144095","over":"14","ball":"4","score":1,"commentary":"Khalidy Juma to Kyle Klesse, 1 run,","noball_dismissal":false,"text":"","timestamp":1751884497,"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":"12300228","event":"ball","batsman_id":"102177","bowler_id":"144095","over":"14","ball":"5","score":1,"commentary":"Khalidy Juma to Rohit Singh, 1 run,","noball_dismissal":false,"text":"","timestamp":1751884674,"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":"12300255","event":"ball","batsman_id":"112008","bowler_id":"144095","over":"14","ball":"6","score":1,"commentary":"Khalidy Juma to Kyle Klesse, 1 run,","noball_dismissal":false,"text":"","timestamp":1751887466,"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":15,"runs":3,"score":"123\/2","bats":[{"runs":41,"balls_faced":41,"fours":2,"sixes":1,"batsman_id":112008},{"runs":13,"balls_faced":8,"fours":0,"sixes":1,"batsman_id":102177}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":1,"bowler_id":144095,"overs":4},{"runs_conceded":23,"maidens":0,"wickets":1,"bowler_id":101888,"overs":3}],"commentary":"End of over 15 (3 runs), Germany 123\/2"},{"event_id":"12300270","event":"ball","batsman_id":"112008","bowler_id":"101888","over":"15","ball":"1","score":1,"commentary":"Ally Mpeka Kimote to Kyle Klesse, 1 run,","noball_dismissal":false,"text":"","timestamp":1751884768,"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":"12300271","event":"ball","batsman_id":"102177","bowler_id":"101888","over":"15","ball":"2","score":1,"commentary":"Ally Mpeka Kimote to Rohit Singh, 1 run,","noball_dismissal":false,"text":"","timestamp":1751884817,"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":"12300282","event":"wicket","batsman_id":"112008","bowler_id":"101888","over":"15","ball":"3","score":"w","commentary":"Ally Mpeka Kimote to Kyle Klesse, no run, c SA Jumbe b A M Kimote,","noball_dismissal":false,"text":"","timestamp":1751884822,"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,"wicket_batsman_id":"112008","how_out":"c SA Jumbe b A M Kimote","batsman_runs":"42","batsman_balls":"43"},{"event_id":"12300295","event":"ball","batsman_id":"146906","bowler_id":"101888","over":"15","ball":"4","score":1,"commentary":"Ally Mpeka Kimote to Hassan Khan, 1 run,","noball_dismissal":false,"text":"","timestamp":1751884901,"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":"12300296","event":"ball","batsman_id":"102177","bowler_id":"101888","over":"15","ball":"5","score":1,"commentary":"Ally Mpeka Kimote to Rohit Singh, 1 run,","noball_dismissal":false,"text":"","timestamp":1751884930,"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":"12300298","event":"ball","batsman_id":"146906","bowler_id":"101888","over":"15","ball":"6","score":0,"commentary":"Ally Mpeka Kimote to Hassan Khan, no run,","noball_dismissal":false,"text":"","timestamp":1751885024,"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":16,"runs":4,"score":"127\/3","bats":[{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":146906},{"runs":15,"balls_faced":10,"fours":0,"sixes":1,"batsman_id":102177}],"bowls":[{"runs_conceded":27,"maidens":0,"wickets":2,"bowler_id":101888,"overs":4},{"runs_conceded":21,"maidens":0,"wickets":1,"bowler_id":144095,"overs":4}],"commentary":"End of over 16 (4 runs), Germany 127\/3"},{"event_id":"12300303","event":"ball","batsman_id":"102177","bowler_id":"150316","over":"16","ball":"1","score":1,"commentary":"Arun Yadav to Rohit Singh, 1 run,","noball_dismissal":false,"text":"","timestamp":1751885028,"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":"12300311","event":"wicket","batsman_id":"146906","bowler_id":"150316","over":"16","ball":"2","score":"w","commentary":"Arun Yadav to Hassan Khan, no run, b A Yadav,","noball_dismissal":false,"text":"","timestamp":1751885121,"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,"wicket_batsman_id":"146906","how_out":"b A Yadav","batsman_runs":"1","batsman_balls":"3"},{"event_id":"12300331","event":"wicket","batsman_id":"100836","bowler_id":"150316","over":"16","ball":"3","score":"w","commentary":"Arun Yadav to Fayaz Khan, no run, lbw b A Yadav,","noball_dismissal":false,"text":"","timestamp":1751885125,"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,"wicket_batsman_id":"100836","how_out":"lbw b A Yadav","batsman_runs":"0","batsman_balls":"1"},{"event_id":"12300343","event":"wicket","batsman_id":"118590","bowler_id":"150316","over":"16","ball":"4","score":"w","commentary":"Arun Yadav to Jatinder Vashisht, no run, lbw b A Yadav,","noball_dismissal":false,"text":"","timestamp":1751885210,"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,"wicket_batsman_id":"118590","how_out":"lbw b A Yadav","batsman_runs":"0","batsman_balls":"1"},{"event_id":"12300361","event":"ball","batsman_id":"95151","bowler_id":"150316","over":"16","ball":"5","score":0,"commentary":"Arun Yadav to Muslim Yar, no run,","noball_dismissal":false,"text":"","timestamp":1751885318,"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":"12300364","event":"ball","batsman_id":"95151","bowler_id":"150316","over":"16","ball":"6","score":"1wd","commentary":"Arun Yadav to Muslim Yar, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751885356,"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":"12300371","event":"ball","batsman_id":"95151","bowler_id":"150316","over":"16","ball":"6","score":1,"commentary":"Arun Yadav to Muslim Yar, 1 run,","noball_dismissal":false,"text":"","timestamp":1751885407,"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":17,"runs":3,"score":"130\/6","bats":[{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":95151},{"runs":16,"balls_faced":11,"fours":0,"sixes":1,"batsman_id":102177}],"bowls":[{"runs_conceded":12,"maidens":0,"wickets":3,"bowler_id":150316,"overs":2},{"runs_conceded":27,"maidens":0,"wickets":2,"bowler_id":101888,"overs":4}],"commentary":"End of over 17 (3 runs), Germany 130\/6"},{"event_id":"12300376","event":"ball","batsman_id":"95151","bowler_id":"61551","over":"17","ball":"1","score":0,"commentary":"Salum Ally Jumbe to Muslim Yar, no run,","noball_dismissal":false,"text":"","timestamp":1751885415,"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":"12300377","event":"ball","batsman_id":"95151","bowler_id":"61551","over":"17","ball":"2","score":1,"commentary":"Salum Ally Jumbe to Muslim Yar, 1 run,","noball_dismissal":false,"text":"","timestamp":1751885420,"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":"12300380","event":"ball","batsman_id":"102177","bowler_id":"61551","over":"17","ball":"3","score":1,"commentary":"Salum Ally Jumbe to Rohit Singh, 1 run,","noball_dismissal":false,"text":"","timestamp":1751885477,"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":"12300390","event":"ball","batsman_id":"95151","bowler_id":"61551","over":"17","ball":"4","score":1,"commentary":"Salum Ally Jumbe to Muslim Yar, 1 run,","noball_dismissal":false,"text":"","timestamp":1751885547,"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":"12300401","event":"ball","batsman_id":"102177","bowler_id":"61551","over":"17","ball":"5","score":0,"commentary":"Salum Ally Jumbe to Rohit Singh, no run,","noball_dismissal":false,"text":"","timestamp":1751885551,"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":"12300402","event":"ball","batsman_id":"102177","bowler_id":"61551","over":"17","ball":"6","score":4,"commentary":"Salum Ally Jumbe to Rohit Singh, Four,","noball_dismissal":false,"text":"","timestamp":1751885560,"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":18,"runs":7,"score":"137\/6","bats":[{"runs":21,"balls_faced":14,"fours":1,"sixes":1,"batsman_id":102177},{"runs":3,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":95151}],"bowls":[{"runs_conceded":32,"maidens":0,"wickets":0,"bowler_id":61551,"overs":3},{"runs_conceded":12,"maidens":0,"wickets":3,"bowler_id":150316,"overs":2}],"commentary":"End of over 18 (7 runs), Germany 137\/6"}],"day":"0","session":"0","live_inning":{"iid":199251,"number":2,"name":"Germany Inning","short_name":"GER Inning","status":2,"issuperover":"false","result":3,"batting_team_id":41704,"fielding_team_id":10535,"scores":"137\/6","scores_full":"137\/6 (18 ov)","fielder":[{"fielder_id":"133048","fielder_name":"Mukesh Suthar Maker","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"61551","fielder_name":"Salum Ally Jumbe","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"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":"Jatinder Vashisht","batsman_id":"118590","runs":"0","balls":"1","how_out":"lbw b A Yadav","score_at_dismissal":128,"overs_at_dismissal":"16.4","bowler_id":"150316","dismissal":"lbw","number":6},"extra_runs":{"byes":0,"legbyes":3,"wides":4,"noballs":0,"penalty":"0","total":7},"equations":{"runs":137,"wickets":6,"overs":"18","bowlers_used":6,"runrate":"7.61"},"current_partnership":{"runs":9,"balls":8,"overs":1.2,"batsmen":[{"name":"Muslim Yar","batsman_id":95151,"runs":3,"balls":5},{"name":"Rohit Singh","batsman_id":102177,"runs":5,"balls":3}]},"did_not_bat":[{"player_id":"95054","name":"Sajid Liaqat"},{"player_id":"99143","name":"Adil Khan"},{"player_id":"109412","name":"Ghulam Rasul Ahmadi"}],"max_over":"20","target":"136","recent_scores":"4,0,1,1,1,0,1,1,0,w,w,w,1,0,1,1,w,1","last_five_overs":"29\/4 5.61","last_ten_overs":"62\/5 5.90"},"teams":[{"tid":10535,"title":"Tanzania","abbr":"TZN","alt_name":"Tanzania","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Tanzania.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Tanzania.png","country":"tz","sex":"male","team_owner":"","head_coach":"","scores_full":"135\/9 (20 ov)","scores":"135\/9","overs":"20"},{"tid":41704,"title":"Germany","abbr":"GER","alt_name":"Germany","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Germany.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Germany.png","country":"de","sex":"male","team_owner":"","head_coach":"","scores_full":"137\/6 (18 ov)","scores":"137\/6","overs":"18"}],"players":[{"pid":53288,"title":"Musadiq Ahmed","short_name":"Musadiq Ahmed","first_name":"Musadiq Ahmed","last_name":"","middle_name":"","birthdate":"1989-04-25","birthplace":"","country":"pk","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bat","role_str":""},{"pid":57394,"title":"Kassimu Nassoro","short_name":"K Nassoro","first_name":"Kassimu Nassoro","last_name":"","middle_name":"","birthdate":"1988-05-13","birthplace":"","country":"tz","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right 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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"all","role_str":"(C)"},{"pid":61551,"title":"Salum Ally Jumbe","short_name":"SA Jumbe","first_name":"Salum Ally Jumbe","last_name":"","middle_name":"","birthdate":"1997-06-04","birthplace":"","country":"tz","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left 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":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"all","role_str":""},{"pid":95054,"title":"Sajid Liaqat","short_name":"S Liaqat","first_name":"Sajid Liaqat","last_name":"","middle_name":"","birthdate":"1985-08-24","birthplace":"","country":"de","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"bowl","role_str":""},{"pid":95151,"title":"Muslim Yar","short_name":"Muslim Yar","first_name":"Muslim Yar","last_name":"","middle_name":"","birthdate":"1999-05-10","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Germany","role":"bowl","role_str":""},{"pid":99143,"title":"Adil Khan","short_name":"A Khan","first_name":"Adil Khan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"bowl","role_str":""},{"pid":100836,"title":"Fayaz Khan","short_name":"F K Nasseri","first_name":"Fayaz Khan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"all","role_str":""},{"pid":101540,"title":"Abdul Basir Andar","short_name":"A B Andar","first_name":"Abdul Basir Andar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":101855,"title":"Laksh Snehal Bakrania","short_name":"L S Bakrania","first_name":"Laksh Snehal Bakrania","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"tz","primary_team":[],"logo_url":"","playing_role":"bowl","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"bowl","role_str":""},{"pid":101888,"title":"Ally Mpeka Kimote","short_name":"A M Kimote","first_name":"Ally Mpeka Kimote","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"tz","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"all","role_str":""},{"pid":101890,"title":"Raymond Francis","short_name":"R Francis","first_name":"Raymond Francis","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"tz","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"squad","role_str":""},{"pid":102177,"title":"Rohit Singh","short_name":"R Singh","first_name":"Rohit Singh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"bat","role_str":"(C)"},{"pid":107623,"title":"Acrey Pascal","short_name":"A Pascal","first_name":"Acrey Pascal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"tz","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"wk","role_str":"(WK)"},{"pid":108300,"title":"Sachin Mandy","short_name":"S Mandy","first_name":"Sachin Mandy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":109412,"title":"Ghulam Rasul Ahmadi","short_name":"GR Ahmadi","first_name":"Ghulam Rasul Ahmadi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"bowl","role_str":""},{"pid":112008,"title":"Kyle Klesse","short_name":"Kyle Klesse","first_name":"Kyle Klesse","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"za","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"wk","role_str":"(WK)"},{"pid":118590,"title":"Jatinder Vashisht","short_name":"Jatinder Vashisht","first_name":"Jatinder Vashisht","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":119878,"title":"Dhrumit Mehta","short_name":"D Mehta","first_name":"Dhrumit Mehta","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"tz","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"bat","role_str":""},{"pid":124279,"title":"Abdul Shakoor","short_name":"A Shakoor","first_name":"Abdul Shakoor","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bat","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":129367,"title":"Shaikh Basha","short_name":"S Basha","first_name":"Shaikh Basha","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"tz","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"bowl","role_str":""},{"pid":130296,"title":"Shahid Afridi","short_name":"S Afridi","first_name":"Shahid Afridi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"all","role_str":""},{"pid":133048,"title":"Mukesh Suthar Maker","short_name":"MS Maker","first_name":"Mukesh Suthar Maker","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"tz","primary_team":[],"logo_url":"","playing_role":"bat","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"bat","role_str":""},{"pid":133063,"title":"Mohamed Simba","short_name":"M Simba","first_name":"Mohamed Simba","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"tz","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"squad","role_str":""},{"pid":144095,"title":"Khalidy Juma","short_name":"K Juma","first_name":"Khalidy Juma","last_name":"","middle_name":"","birthdate":"2008-12-07","birthplace":"","country":"tz","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"bowl","role_str":""},{"pid":146906,"title":"Hassan Khan","short_name":"H Khan","first_name":"Hassan Khan","last_name":"","middle_name":"","birthdate":"2002-04-21","birthplace":"","country":"af","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"bat","role_str":""},{"pid":150315,"title":"Ajith Kayyalakudy Augastin","short_name":"A Kayyalakudy Augastin","first_name":"Ajith Kayyalakudy Augastin","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"tz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"bat","role_str":""},{"pid":150316,"title":"Arun Yadav","short_name":"A Yadav","first_name":"Arun Yadav","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"tz","primary_team":[],"logo_url":"","playing_role":"all","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"all","role_str":""},{"pid":150317,"title":"Ally Hafidhi","short_name":"A Hafidhi","first_name":"Ally Hafidhi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"tz","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"squad","role_str":""}]},"etag":"9b62d7ac9e3447871784f9d1ebf18934","modified":"2025-07-30 01:37:16","datetime":"2025-07-30 01:37:16","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":91228,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Germany won by 4 wickets","day_remaining_over":"","team_batting":"Germany","team_bowling":"Tanzania","live_inning_number":2,"live_score":{"runs":137,"overs":18,"wickets":6,"target":136,"runrate":7.61,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Muslim Yar","batsman_id":95151,"runs":3,"balls_faced":5,"fours":0,"sixes":0,"strike_rate":"60.00"},{"name":"Rohit Singh","batsman_id":102177,"runs":21,"balls_faced":14,"fours":1,"sixes":1,"strike_rate":"150.00"}],"bowlers":[{"name":"Salum Ally Jumbe","bowler_id":61551,"overs":3,"runs_conceded":32,"wickets":0,"maidens":0,"econ":"10.67"},{"name":"Arun Yadav","bowler_id":150316,"overs":2,"runs_conceded":12,"wickets":3,"maidens":0,"econ":"6.00"}],"commentaries":[{"event_id":"12300187","event":"ball","batsman_id":"102177","bowler_id":"101888","over":"13","ball":"6","score":6,"commentary":"Ally Mpeka Kimote to Rohit Singh, Six,","noball_dismissal":false,"text":"","timestamp":1751884346,"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":"overend","over":14,"runs":12,"score":"120\/2","bats":[{"runs":12,"balls_faced":7,"fours":0,"sixes":1,"batsman_id":102177},{"runs":39,"balls_faced":36,"fours":2,"sixes":1,"batsman_id":112008}],"bowls":[{"runs_conceded":23,"maidens":0,"wickets":1,"bowler_id":101888,"overs":3},{"runs_conceded":18,"maidens":0,"wickets":1,"bowler_id":144095,"overs":3}],"commentary":"End of over 14 (12 runs), Germany 120\/2"},{"event_id":"12300202","event":"ball","batsman_id":"112008","bowler_id":"144095","over":"14","ball":"1","score":0,"commentary":"Khalidy Juma to Kyle Klesse, no run,","noball_dismissal":false,"text":"","timestamp":1751884392,"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":"12300206","event":"ball","batsman_id":"112008","bowler_id":"144095","over":"14","ball":"2","score":0,"commentary":"Khalidy Juma to Kyle Klesse, no run,","noball_dismissal":false,"text":"","timestamp":1751884396,"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":"12300207","event":"ball","batsman_id":"112008","bowler_id":"144095","over":"14","ball":"3","score":0,"commentary":"Khalidy Juma to Kyle Klesse, no run,","noball_dismissal":false,"text":"","timestamp":1751884447,"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":"12300215","event":"ball","batsman_id":"112008","bowler_id":"144095","over":"14","ball":"4","score":1,"commentary":"Khalidy Juma to Kyle Klesse, 1 run,","noball_dismissal":false,"text":"","timestamp":1751884497,"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":"12300228","event":"ball","batsman_id":"102177","bowler_id":"144095","over":"14","ball":"5","score":1,"commentary":"Khalidy Juma to Rohit Singh, 1 run,","noball_dismissal":false,"text":"","timestamp":1751884674,"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":"12300255","event":"ball","batsman_id":"112008","bowler_id":"144095","over":"14","ball":"6","score":1,"commentary":"Khalidy Juma to Kyle Klesse, 1 run,","noball_dismissal":false,"text":"","timestamp":1751887466,"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":15,"runs":3,"score":"123\/2","bats":[{"runs":41,"balls_faced":41,"fours":2,"sixes":1,"batsman_id":112008},{"runs":13,"balls_faced":8,"fours":0,"sixes":1,"batsman_id":102177}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":1,"bowler_id":144095,"overs":4},{"runs_conceded":23,"maidens":0,"wickets":1,"bowler_id":101888,"overs":3}],"commentary":"End of over 15 (3 runs), Germany 123\/2"},{"event_id":"12300270","event":"ball","batsman_id":"112008","bowler_id":"101888","over":"15","ball":"1","score":1,"commentary":"Ally Mpeka Kimote to Kyle Klesse, 1 run,","noball_dismissal":false,"text":"","timestamp":1751884768,"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":"12300271","event":"ball","batsman_id":"102177","bowler_id":"101888","over":"15","ball":"2","score":1,"commentary":"Ally Mpeka Kimote to Rohit Singh, 1 run,","noball_dismissal":false,"text":"","timestamp":1751884817,"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":"12300282","event":"wicket","batsman_id":"112008","bowler_id":"101888","over":"15","ball":"3","score":"w","commentary":"Ally Mpeka Kimote to Kyle Klesse, no run, c SA Jumbe b A M Kimote,","noball_dismissal":false,"text":"","timestamp":1751884822,"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,"wicket_batsman_id":"112008","how_out":"c SA Jumbe b A M Kimote","batsman_runs":"42","batsman_balls":"43"},{"event_id":"12300295","event":"ball","batsman_id":"146906","bowler_id":"101888","over":"15","ball":"4","score":1,"commentary":"Ally Mpeka Kimote to Hassan Khan, 1 run,","noball_dismissal":false,"text":"","timestamp":1751884901,"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":"12300296","event":"ball","batsman_id":"102177","bowler_id":"101888","over":"15","ball":"5","score":1,"commentary":"Ally Mpeka Kimote to Rohit Singh, 1 run,","noball_dismissal":false,"text":"","timestamp":1751884930,"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":"12300298","event":"ball","batsman_id":"146906","bowler_id":"101888","over":"15","ball":"6","score":0,"commentary":"Ally Mpeka Kimote to Hassan Khan, no run,","noball_dismissal":false,"text":"","timestamp":1751885024,"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":16,"runs":4,"score":"127\/3","bats":[{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":146906},{"runs":15,"balls_faced":10,"fours":0,"sixes":1,"batsman_id":102177}],"bowls":[{"runs_conceded":27,"maidens":0,"wickets":2,"bowler_id":101888,"overs":4},{"runs_conceded":21,"maidens":0,"wickets":1,"bowler_id":144095,"overs":4}],"commentary":"End of over 16 (4 runs), Germany 127\/3"},{"event_id":"12300303","event":"ball","batsman_id":"102177","bowler_id":"150316","over":"16","ball":"1","score":1,"commentary":"Arun Yadav to Rohit Singh, 1 run,","noball_dismissal":false,"text":"","timestamp":1751885028,"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":"12300311","event":"wicket","batsman_id":"146906","bowler_id":"150316","over":"16","ball":"2","score":"w","commentary":"Arun Yadav to Hassan Khan, no run, b A Yadav,","noball_dismissal":false,"text":"","timestamp":1751885121,"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,"wicket_batsman_id":"146906","how_out":"b A Yadav","batsman_runs":"1","batsman_balls":"3"},{"event_id":"12300331","event":"wicket","batsman_id":"100836","bowler_id":"150316","over":"16","ball":"3","score":"w","commentary":"Arun Yadav to Fayaz Khan, no run, lbw b A Yadav,","noball_dismissal":false,"text":"","timestamp":1751885125,"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,"wicket_batsman_id":"100836","how_out":"lbw b A Yadav","batsman_runs":"0","batsman_balls":"1"},{"event_id":"12300343","event":"wicket","batsman_id":"118590","bowler_id":"150316","over":"16","ball":"4","score":"w","commentary":"Arun Yadav to Jatinder Vashisht, no run, lbw b A Yadav,","noball_dismissal":false,"text":"","timestamp":1751885210,"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,"wicket_batsman_id":"118590","how_out":"lbw b A Yadav","batsman_runs":"0","batsman_balls":"1"},{"event_id":"12300361","event":"ball","batsman_id":"95151","bowler_id":"150316","over":"16","ball":"5","score":0,"commentary":"Arun Yadav to Muslim Yar, no run,","noball_dismissal":false,"text":"","timestamp":1751885318,"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":"12300364","event":"ball","batsman_id":"95151","bowler_id":"150316","over":"16","ball":"6","score":"1wd","commentary":"Arun Yadav to Muslim Yar, 1 wide,","noball_dismissal":false,"text":"","timestamp":1751885356,"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":"12300371","event":"ball","batsman_id":"95151","bowler_id":"150316","over":"16","ball":"6","score":1,"commentary":"Arun Yadav to Muslim Yar, 1 run,","noball_dismissal":false,"text":"","timestamp":1751885407,"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":17,"runs":3,"score":"130\/6","bats":[{"runs":1,"balls_faced":2,"fours":0,"sixes":0,"batsman_id":95151},{"runs":16,"balls_faced":11,"fours":0,"sixes":1,"batsman_id":102177}],"bowls":[{"runs_conceded":12,"maidens":0,"wickets":3,"bowler_id":150316,"overs":2},{"runs_conceded":27,"maidens":0,"wickets":2,"bowler_id":101888,"overs":4}],"commentary":"End of over 17 (3 runs), Germany 130\/6"},{"event_id":"12300376","event":"ball","batsman_id":"95151","bowler_id":"61551","over":"17","ball":"1","score":0,"commentary":"Salum Ally Jumbe to Muslim Yar, no run,","noball_dismissal":false,"text":"","timestamp":1751885415,"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":"12300377","event":"ball","batsman_id":"95151","bowler_id":"61551","over":"17","ball":"2","score":1,"commentary":"Salum Ally Jumbe to Muslim Yar, 1 run,","noball_dismissal":false,"text":"","timestamp":1751885420,"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":"12300380","event":"ball","batsman_id":"102177","bowler_id":"61551","over":"17","ball":"3","score":1,"commentary":"Salum Ally Jumbe to Rohit Singh, 1 run,","noball_dismissal":false,"text":"","timestamp":1751885477,"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":"12300390","event":"ball","batsman_id":"95151","bowler_id":"61551","over":"17","ball":"4","score":1,"commentary":"Salum Ally Jumbe to Muslim Yar, 1 run,","noball_dismissal":false,"text":"","timestamp":1751885547,"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":"12300401","event":"ball","batsman_id":"102177","bowler_id":"61551","over":"17","ball":"5","score":0,"commentary":"Salum Ally Jumbe to Rohit Singh, no run,","noball_dismissal":false,"text":"","timestamp":1751885551,"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":"12300402","event":"ball","batsman_id":"102177","bowler_id":"61551","over":"17","ball":"6","score":4,"commentary":"Salum Ally Jumbe to Rohit Singh, Four,","noball_dismissal":false,"text":"","timestamp":1751885560,"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":18,"runs":7,"score":"137\/6","bats":[{"runs":21,"balls_faced":14,"fours":1,"sixes":1,"batsman_id":102177},{"runs":3,"balls_faced":5,"fours":0,"sixes":0,"batsman_id":95151}],"bowls":[{"runs_conceded":32,"maidens":0,"wickets":0,"bowler_id":61551,"overs":3},{"runs_conceded":12,"maidens":0,"wickets":3,"bowler_id":150316,"overs":2}],"commentary":"End of over 18 (7 runs), Germany 137\/6"}],"day":"0","session":"0","live_inning":{"iid":199251,"number":2,"name":"Germany Inning","short_name":"GER Inning","status":2,"issuperover":"false","result":3,"batting_team_id":41704,"fielding_team_id":10535,"scores":"137\/6","scores_full":"137\/6 (18 ov)","fielder":[{"fielder_id":"133048","fielder_name":"Mukesh Suthar Maker","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"61551","fielder_name":"Salum Ally Jumbe","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"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":"Jatinder Vashisht","batsman_id":"118590","runs":"0","balls":"1","how_out":"lbw b A Yadav","score_at_dismissal":128,"overs_at_dismissal":"16.4","bowler_id":"150316","dismissal":"lbw","number":6},"extra_runs":{"byes":0,"legbyes":3,"wides":4,"noballs":0,"penalty":"0","total":7},"equations":{"runs":137,"wickets":6,"overs":"18","bowlers_used":6,"runrate":"7.61"},"current_partnership":{"runs":9,"balls":8,"overs":1.2,"batsmen":[{"name":"Muslim Yar","batsman_id":95151,"runs":3,"balls":5},{"name":"Rohit Singh","batsman_id":102177,"runs":5,"balls":3}]},"did_not_bat":[{"player_id":"95054","name":"Sajid Liaqat"},{"player_id":"99143","name":"Adil Khan"},{"player_id":"109412","name":"Ghulam Rasul Ahmadi"}],"max_over":"20","target":"136","recent_scores":"4,0,1,1,1,0,1,1,0,w,w,w,1,0,1,1,w,1","last_five_overs":"29\/4 5.61","last_ten_overs":"62\/5 5.90"},"teams":[{"tid":10535,"title":"Tanzania","abbr":"TZN","alt_name":"Tanzania","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Tanzania.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Tanzania.png","country":"tz","sex":"male","team_owner":"","head_coach":"","scores_full":"135\/9 (20 ov)","scores":"135\/9","overs":"20"},{"tid":41704,"title":"Germany","abbr":"GER","alt_name":"Germany","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Germany.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Germany.png","country":"de","sex":"male","team_owner":"","head_coach":"","scores_full":"137\/6 (18 ov)","scores":"137\/6","overs":"18"}],"players":[{"pid":53288,"title":"Musadiq Ahmed","short_name":"Musadiq Ahmed","first_name":"Musadiq Ahmed","last_name":"","middle_name":"","birthdate":"1989-04-25","birthplace":"","country":"pk","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Pakistan","role":"bat","role_str":""},{"pid":57394,"title":"Kassimu Nassoro","short_name":"K Nassoro","first_name":"Kassimu Nassoro","last_name":"","middle_name":"","birthdate":"1988-05-13","birthplace":"","country":"tz","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right 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":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"all","role_str":"(C)"},{"pid":61551,"title":"Salum Ally Jumbe","short_name":"SA Jumbe","first_name":"Salum Ally Jumbe","last_name":"","middle_name":"","birthdate":"1997-06-04","birthplace":"","country":"tz","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left 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":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"all","role_str":""},{"pid":95054,"title":"Sajid Liaqat","short_name":"S Liaqat","first_name":"Sajid Liaqat","last_name":"","middle_name":"","birthdate":"1985-08-24","birthplace":"","country":"de","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"bowl","role_str":""},{"pid":95151,"title":"Muslim Yar","short_name":"Muslim Yar","first_name":"Muslim Yar","last_name":"","middle_name":"","birthdate":"1999-05-10","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Germany","role":"bowl","role_str":""},{"pid":99143,"title":"Adil Khan","short_name":"A Khan","first_name":"Adil Khan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"bowl","role_str":""},{"pid":100836,"title":"Fayaz Khan","short_name":"F K Nasseri","first_name":"Fayaz Khan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"all","role_str":""},{"pid":101540,"title":"Abdul Basir Andar","short_name":"A B Andar","first_name":"Abdul Basir Andar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":101855,"title":"Laksh Snehal Bakrania","short_name":"L S Bakrania","first_name":"Laksh Snehal Bakrania","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"tz","primary_team":[],"logo_url":"","playing_role":"bowl","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"bowl","role_str":""},{"pid":101888,"title":"Ally Mpeka Kimote","short_name":"A M Kimote","first_name":"Ally Mpeka Kimote","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"tz","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"all","role_str":""},{"pid":101890,"title":"Raymond Francis","short_name":"R Francis","first_name":"Raymond Francis","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"tz","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"squad","role_str":""},{"pid":102177,"title":"Rohit Singh","short_name":"R Singh","first_name":"Rohit Singh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"bat","role_str":"(C)"},{"pid":107623,"title":"Acrey Pascal","short_name":"A Pascal","first_name":"Acrey Pascal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"tz","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"wk","role_str":"(WK)"},{"pid":108300,"title":"Sachin Mandy","short_name":"S Mandy","first_name":"Sachin Mandy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":109412,"title":"Ghulam Rasul Ahmadi","short_name":"GR Ahmadi","first_name":"Ghulam Rasul Ahmadi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"bowl","role_str":""},{"pid":112008,"title":"Kyle Klesse","short_name":"Kyle Klesse","first_name":"Kyle Klesse","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"za","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"South Africa","role":"wk","role_str":"(WK)"},{"pid":118590,"title":"Jatinder Vashisht","short_name":"Jatinder Vashisht","first_name":"Jatinder Vashisht","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":119878,"title":"Dhrumit Mehta","short_name":"D Mehta","first_name":"Dhrumit Mehta","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"tz","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"bat","role_str":""},{"pid":124279,"title":"Abdul Shakoor","short_name":"A Shakoor","first_name":"Abdul Shakoor","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","primary_team":[],"logo_url":"","playing_role":"bat","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"squad","role_str":""},{"pid":129367,"title":"Shaikh Basha","short_name":"S Basha","first_name":"Shaikh Basha","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"tz","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"bowl","role_str":""},{"pid":130296,"title":"Shahid Afridi","short_name":"S Afridi","first_name":"Shahid Afridi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"de","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Germany","role":"all","role_str":""},{"pid":133048,"title":"Mukesh Suthar Maker","short_name":"MS Maker","first_name":"Mukesh Suthar Maker","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"tz","primary_team":[],"logo_url":"","playing_role":"bat","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"bat","role_str":""},{"pid":133063,"title":"Mohamed Simba","short_name":"M Simba","first_name":"Mohamed Simba","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"tz","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"squad","role_str":""},{"pid":144095,"title":"Khalidy Juma","short_name":"K Juma","first_name":"Khalidy Juma","last_name":"","middle_name":"","birthdate":"2008-12-07","birthplace":"","country":"tz","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"bowl","role_str":""},{"pid":146906,"title":"Hassan Khan","short_name":"H Khan","first_name":"Hassan Khan","last_name":"","middle_name":"","birthdate":"2002-04-21","birthplace":"","country":"af","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Afghanistan","role":"bat","role_str":""},{"pid":150315,"title":"Ajith Kayyalakudy Augastin","short_name":"A Kayyalakudy Augastin","first_name":"Ajith Kayyalakudy Augastin","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"tz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"bat","role_str":""},{"pid":150316,"title":"Arun Yadav","short_name":"A Yadav","first_name":"Arun Yadav","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"tz","primary_team":[],"logo_url":"","playing_role":"all","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"all","role_str":""},{"pid":150317,"title":"Ally Hafidhi","short_name":"A Hafidhi","first_name":"Ally Hafidhi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"tz","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Tanzania","role":"squad","role_str":""}]},"etag":"9b62d7ac9e3447871784f9d1ebf18934","modified":"2025-07-30 01:37:16","datetime":"2025-07-30 01:37:16","api_version":"3.0"}', Modified = GetDate() WHERE Id = 91228 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:79fe99ed-f508-463e-85be-cb34a6e9c8d9 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 91228 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (91228,3,'{"status":"ok","response":{"match_id":91228,"title":"Germany vs Tanzania","short_title":"GER vs TZN","subtitle":"Match 4","match_number":"4","format":3,"format_str":"T20I","status":2,"status_str":"Completed","status_note":"Germany won by 4 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129661,"title":"Malawi T20I Quad Series","abbr":"Malawi T20I Quad Series","type":"series","category":"international","match_format":"t20i","season":"2025","status":"result","datestart":"2025-07-05","dateend":"2025-07-13","country":"int","total_matches":"14","total_rounds":"1","total_teams":"4"},"teama":{"team_id":41704,"name":"Germany","short_name":"GER","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Germany.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Germany.png","scores_full":"137\/6 (18 ov)","scores":"137\/6","overs":"18"},"teamb":{"team_id":10535,"name":"Tanzania","short_name":"TZN","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Tanzania.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Tanzania.png","scores_full":"135\/9 (20 ov)","scores":"135\/9","overs":"20"},"date_start":"2025-07-07 07:30:00","date_end":"2025-07-07 17:30:00","timestamp_start":1751873400,"timestamp_end":1751909400,"date_start_ist":"2025-07-07 13:00:00","date_end_ist":"2025-07-07 23:00:00","venue":{"venue_id":"1213720","name":"TCA Oval, Blantyre","location":"Blantyre","country":"Malawi","timezone":""},"umpires":"Osman Mhango (Malawi), Mazizi Gampu (South Africa)","referee":"","equation":"","live":"","result":"GER won by 4 wickets","result_type":1,"win_margin":"4 wickets","winning_team_id":41704,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-05 18:41:27","verify_time":"2025-07-07 17:05:27","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clear","weather_desc":"clear sky","temp":14.16,"humidity":69,"visibility":10000,"wind_speed":0.84,"clouds":0},"pitch":{"pitch_condition":"Spinning Pitch","batting_condition":"Low Scoring","pace_bowling_condition":"Swing Favourable","spine_bowling_condition":"Average"},"toss":{"text":"Tanzania elected to bat","winner":10535,"decision":1}},"etag":"6650f18a6f6e8897657e479ad4dcfea1","modified":"2025-07-30 01:37:17","datetime":"2025-07-30 01:37:17","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":91228,"title":"Germany vs Tanzania","short_title":"GER vs TZN","subtitle":"Match 4","match_number":"4","format":3,"format_str":"T20I","status":2,"status_str":"Completed","status_note":"Germany won by 4 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129661,"title":"Malawi T20I Quad Series","abbr":"Malawi T20I Quad Series","type":"series","category":"international","match_format":"t20i","season":"2025","status":"result","datestart":"2025-07-05","dateend":"2025-07-13","country":"int","total_matches":"14","total_rounds":"1","total_teams":"4"},"teama":{"team_id":41704,"name":"Germany","short_name":"GER","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Germany.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Germany.png","scores_full":"137\/6 (18 ov)","scores":"137\/6","overs":"18"},"teamb":{"team_id":10535,"name":"Tanzania","short_name":"TZN","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Tanzania.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Tanzania.png","scores_full":"135\/9 (20 ov)","scores":"135\/9","overs":"20"},"date_start":"2025-07-07 07:30:00","date_end":"2025-07-07 17:30:00","timestamp_start":1751873400,"timestamp_end":1751909400,"date_start_ist":"2025-07-07 13:00:00","date_end_ist":"2025-07-07 23:00:00","venue":{"venue_id":"1213720","name":"TCA Oval, Blantyre","location":"Blantyre","country":"Malawi","timezone":""},"umpires":"Osman Mhango (Malawi), Mazizi Gampu (South Africa)","referee":"","equation":"","live":"","result":"GER won by 4 wickets","result_type":1,"win_margin":"4 wickets","winning_team_id":41704,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-05 18:41:27","verify_time":"2025-07-07 17:05:27","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clear","weather_desc":"clear sky","temp":14.16,"humidity":69,"visibility":10000,"wind_speed":0.84,"clouds":0},"pitch":{"pitch_condition":"Spinning Pitch","batting_condition":"Low Scoring","pace_bowling_condition":"Swing Favourable","spine_bowling_condition":"Average"},"toss":{"text":"Tanzania elected to bat","winner":10535,"decision":1}},"etag":"6650f18a6f6e8897657e479ad4dcfea1","modified":"2025-07-30 01:37:17","datetime":"2025-07-30 01:37:17","api_version":"3.0"}', Modified = GetDate() WHERE Id = 91228 AND DataTypeId = 3 END
Live Report & Scorecard of Germany vs Tanzania Match 4
CricDirect Cricket News, Results and Stats
 

Germany vs Tanzania, Match 4, Malawi T20I Quad Series

Completed
Malawi T20I Quad Series, Completed
Germany
GER
137/6 (18)
Tanzania
TZN
135/9 (20)
Germany won by 4 wickets
Match Details
Date
2025-07-07 07:30:00
Venue
TCA Oval, Blantyre, Blantyre
Toss
Tanzania elected to bat
Umpires
    Tv Umpires
      Match Referee
        × Close